This is everything, complete question
Answer part c} Question part d) Answer part d) Question part e} Answer part e) >>>>> >>>> >>>> If 20 additional hours of cutting capacity became available in a given week, how much additional prot could the company earn? Suppose another company wanted to use 15 hours ofXYZ's sanding capacity in a week and was willing to pay $400 per hour to acquire it. Should Company XYZ agreeto this? Why or why not? 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 Obje Your recent changes were saved. Do you want Cell Name Value Cost Coeff to continue working where you left off? $B$3 Variables Qty Doors 20 0 500 300 233.3333333 $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.33333333 $D$8 Sanding Used 40 300 40 6.666666667 20 $DS 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