Problem 4. Refer to "The Wyndor Glass Co" case study on page 35 of the textbook that was discussed in class last week where a weekly profit of $3,600 from the utilization of limited hours in the three plants was determined. Now, assuming that Wyndor would like to give priority to the production of the new Doors and Windows without restricting the weekly available hours on the three plants. Based on the market demand, Wyndor should also consider limiting the total weekly production of the doors and windows together to not more than 100 units, such that the weekly production of new windows should be at least twice the weekly production of new doors. In addition, your modified model should also consider the following restrictions on the raw materials. - Each door requires 48 ft2 of Aluminum and 24 ft2 glass - Each window requires 20 ft2 of Wood and 12 ft2 glass - The materials weekly availability is: 800 ft2 of wood, and 1000 ft2 of aluminum and 1200 ft2 of glass, - Based on the market demand, the number of windows to produce per week should be at least twice the number of doors produced. (a) Modify the original algebraic model for Wyndor Glass case to include the revisions indicated above. (b) Formulate and solve the above revised resource allocation case using the graphical approach. (c) Formulate and solve the above revised resource allocation case using the spreadsheet approach. (d) Comment on your Solver solution with a recommendation on (1) the optimal product mix that Wyndor should produce in order to maximize the profit while meeting all the new conditions and (ii) the required number of hours that should be allocated in each plant to produce the recommended optimal mix. (e) Describe the status of the available raw material on a weekly basis based on the optimal solution