The Wyndor Glass Co estimates of the unit profits for the two new products are $600 for the Doors and $300 for the Windows. Formulate and solve the linear programming model for this problem on a spreadsheet.

Plant	Doors	Windows	Available per Week
1	1 hour	0	4 hours
2	0	2 hours	12 hours
3	3 hours	2 hours	18 hours
Unit Profit	$600	$300

1. a. Formulate and solve the linear programming model for this problem on spreadsheet - show formulas.

b. Color the cells properly, use range name, and sumproduct function.

c. What is the optimal solution? What is the optimal total profit?

d. In the optimal solution, what is the unused capacity at each of the Plants 1, 2, 3?

2. e. . Formulate this same model algebraically

f. In the algebraic model, identify the decision variables, constraints and objective function.

3. g. Use the graphical method to solve this model

h. Draw graph on the tab. Identify the feasible region. Identify the optimal point. Solve the simultaneous equations to obtain the optimal solution.

4.

I. The VP for manufacturing has managed to find one additional hour per week for Plant 1 (from 4 hours to 5 hours/week). Use the graphical method to find the new optimal solution and optimal total profit. (Hint: copy solution from question c and revise it.) How much more profit has it generated?

D E F G A B 1 Wyndor Glass co. Product-Mix Problem Doors Windows Unit Profit $600 $300 Hours Hours Used per Unit Produced Used Plant 1 Plant 2 0 Plant 3 Hours Available BELOWN 18 18 oors Windows Doors Unit Produced Total Profit $3,300 4 13 REVISED for Question 4 Plant Doors Windows Available per Week 1 hour 5 hours 4 hours 12 hours 18 hours 2 hours 2 hours $300 3 hours $600 Unit Profit D E F G A B 1 Wyndor Glass co. Product-Mix Problem Doors Windows Unit Profit $600 $300 Hours Hours Used per Unit Produced Used Plant 1 Plant 2 0 Plant 3 Hours Available BELOWN 18 18 oors Windows Doors Unit Produced Total Profit $3,300 4 13 REVISED for Question 4 Plant Doors Windows Available per Week 1 hour 5 hours 4 hours 12 hours 18 hours 2 hours 2 hours $300 3 hours $600 Unit Profit