Question: Reconsider the Wyndor Glass Co. case study introduced in Section 2.1/ in class. Suppose that the estimates of the unit profits for the two new

Reconsider the Wyndor Glass Co. case study introduced in Section 2.1/ in class. Suppose that the estimates of the unit profits for the two new products now have been revised to $500 for the doors and $350 for the windows. A curve-fitting procedure was used to estimate the weekly marketing costs required to sustain a production rate of D doors and W windows: . Marketing cost for doors = $2502 . Marketing costs for windows = $66W2 Hours Used Per Unit Produced : Available Doors Windows hours for each plant Plant 1 O 4 Plant 2 0 NN 12 Plant 3 3 18 Questions: a. Formulate the model algebraically. (Please clearly define all the decision variables, clearly write down the objective function and each constraints) b. Formulate and solve the model for this problem on a spreadsheet and use solver to solve it. (The number of the products are NOT required to be integer.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
