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 |

Tutor | Rating |
---|---|

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.. |