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)**

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

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 |