Project #161513 - Excel Help (6 Problems)

Computer Tutors

Subject Computer
Due By (Pacific Time) 12/21/2016 12:00 am

6-34

A plumbing manufacturer makes two lines of bathtubs, model A and model B. Every tub requires blending a certain amount of steel and zinc; the company has available a total of 24,500 pounds of steel and 6,000 pounds of zinc. Each model A bathtub requires a mixture of 120 pounds of steel and 20 pounds of zinc, and each yields a profit of $90. Each model B tub produced can be sold for a profit of $70; it requires 100 pounds of steel and 30 pounds of zinc. To maintain an adequate supply of both models, the manufacturer would like the number of model A tubs made to be no more than 5 times the number of model B tubs. Find the best product mix of bathtubs.

 

Also need 

7-6 (see attachment)

 

7-10 (see attachement)

 

7-14 (see attachment)

 

7-20 (see attachments (2 screen shots)) 

 

7-24 (see attachment)

 

NEED each problem DONE IN EXCEL WORKBOOK WITH BOTH the LP MODEL AND SOLVER MODEL Methods shown.

 

New Workbook File for each Problem (6 in Total)

TutorRating
pallavi

out of 1971 reviews
amosmm

out of 766 reviews
PhyzKyd

out of 1164 reviews
rajdeep77

out of 721 reviews
sctys

out of 1600 reviews
sharadgreen

out of 770 reviews
topnotcher

out of 766 reviews
XXXIAO

out of 680 reviews