A furniture supplier, Acme Chairs, Inc., manufactures a Basicoffice chair and a Deluxe office chair. Each Basic chair costs$25.00 to manufacture, and each Deluxe office chair costs $40.00 tomanufacture. Acme Chairs wishes to determine the optimal productionquantities per day for each chair model in order to minimizeoverall total cost.
The production of each chair requires three types of materials:Wood, Primer, and Paint. The amount of material available per dayto manufacture the chairs is as follows:
30 units of wood.
600 oz. of primer.
750 oz. of paint.
Each chair requires the materials as shown below:
| Wood (units) | 1.25 | 2.50 |
Primer (oz.) | 3.00 | 7.50 |
Paint (oz.) | 6.00 | 10.00 |
| | |
A. State the Objective function mathematically.
B State the constraints mathematically.
C. Instead, create an Excel Model for this Example.(please givestep by step excel instructions)
Use Solver to determine the optimized solution. (Do not solvethe problem graphically)
