Reconsider the Wyndor Glass Co. case study introduced in Section 2.1/ in class. Suppose that the estimates
Fantastic news! We've Found the answer you've been seeking!
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 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 ofDdoors andWwindows:
- Marketing cost for doors = $25D2
- Marketing costs for windows = $66W2
Hours Used Per Unit Produced : | |||
Doors | Windows | Available hours for each plant | |
Plant 1 | 1 | 0 | 4 |
Plant 2 | 0 | 2 | 12 |
Plant 3 | 3 | 2 | 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 the solver to solve it.
*The number of the products is required to be integer.
Posted Date: