- A furniture company manufactures desks and chairs. Each desk requires 29 hours to manufacture and contributes $400 to profit, and each chair requires 19 hours to manufacture and contributes $250 to profit. Due to marketing restrictions, a total of 2000 hours are available.
a. Use Solver to maximize the company’s profit.
b. What is the maximum profit?
c. How many desks and chairs should the company manufacture?
d. Of the 2000 available hours, how many hours will be used?
- The Marriott Tub Company manufactures two lines of bathtubs, called model A and model B. Every tub requires blending a certain amount of steel and zinc; the company has available a total of 25,000 pounds of steel and 6,000 pounds of zinc. Each model A bathtub requires a mixture of 125 pounds of steel and 20 pounds of zinc, and each yields a profit to the firm of $90. Each model B tub produced can be sold for a profit of $70; it in turn requires 100 pounds of steel and 30 pounds of zinc. Given information can be set up as shown below:
Using Solver, find the optimal production mix of bathtubs to maximize the Contribution (Profit).