Reference no: EM132116228

Refer to “The Wyndor Glass Co” case study on page 22 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, (a) Provide the algebraic, graphical, and spreadsheet models for the above resource allocation case. Solve your model then comment on the obtained results including a recommendation about (i) the optimal product mix that Wyndor should produce in order to maximize the profit while meeting all the new conditions in the case and (ii) the required number of hours that should be allocated in each plant to produce the recommended optimal mix. (b) Describe the status of the available raw material on a weekly basis based on the optimal solution.