Project #161513 - Excel Help (6 Problems)

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)

Subject Computer
Due By (Pacific Time) 12/21/2016 12:00 am
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy