| A manufacturing facility for Company XYZ that produces doors and windows utilizes three manufacturing processes: cutting, sanding and finishing. There are limited resources for each of these processes. Assume that the decision variables are defined to represent the number of doors produced per week and the number of windows produced per week. Assume that the objective function is a profit maximization objective with unit profit for doors being $500 and unit profit for windows being $400. |
| Assume that you are given the Answer report and Sensitivity report in TAB Q2S and Q2A. Answer parts (a)-( e) below. |
| Microsoft Excel 16.0 Sensitivity Report |
| Worksheet: |
| Variable Cells |
| | | | Final | Reduced | Objective | Allowable | Allowable |
| | Cell | Name | Value | Cost | Coefficient | Increase | Decrease |
| | $B$3 | Variables Qty Doors | 20 | 0 | 500 | 300 | 233.3333333333 |
| | $C$3 | Variables Qty Windows | 40 | 0 | 400 | 350 | 150 |
| Constraints |
| | | | Final | Shadow | Constraint | Allowable | Allowable |
| | Cell | Name | Value | Price | R.H. Side | Increase | Decrease |
| | $D$7 | Cutting Used | 40 | 350 | 40 | 40 | 13.3333333333 |
| | $D$8 | Sanding Used | 40 | 300 | 40 | 6.6666666667 | 20 |
| | $D$9 | Finishing Used | 50 | 0 | 60 | 1E+30 | 10 |
| Question part a) | | If the unit profit on doors increased to $700 would the optimal solution change? Why or why not? |
| Answer part a) | >>>>>> |
| Question part b) | | If the unit profit on doors increased to $700 what is the maximum profit? |
| Answer part b) | >>>> |
| Question part c) | | If the unit profit on windows decreased to $200 would the optimal solution change? Why or why not? |
| Answer part c) | >>>>> |
| Question part d) | | If 20 additional hours of cutting capacity became available in a given week, how much additional profit could the company earn? |
| Answer part d) | >>>> |
| Question part e) | | Suppose another company wanted to use 15 hours of XYZ's sanding capacity in a week and was willing to pay $400 per hour to acquire it. Should Company XYZ agree to this? Why or why not? |
| Answer part e) | >>>> |
| | | | | | | | | |
MathematicsExpert
Problem.xlsx
