Consider the following Linear Programming problem, in which X and Y denote the number of units of products X and Y to be produced, respectively, and Z denotes the overall resulting profit Objective Function Maximize Z = $4X + $5Y Subject to X + 2Y 310 (labor available, in hours) 6X + 6Y 36 (material available in pounds) 8X + 4Y S 40 (storage available, in square feet) XY20 The Excel Sensitivity Report for this problem is given below. Answer the following questions and provide calculations of your answers. Each question is independent of the others. Adjustable Cells Final Reduced Objective Allowable Allowable 7: Cell Name ValueCost Coefficientincrease Decrease 15:55 X 2 0 4 1 1.5 SDS5 Y 4 4 10 5 3 1 e 9: Constraints Page 10 Final Shadow Constraint Allowable Allowable 10 Cell Name Value Price RH. Side Increase Decrease Page 11 11 SES7 Labor 10 1 10 2 2 Parte 2 SES Material 36 0.5 34 -1 12 SES9. Storage 32 0 4d 15:30 8 Pau 15 Al How much excess labor there is in the optimal solution? in the following field provide your answer in numerical diuits only. Do not enter units. Aproximate to two decimal digits if needed Page 1 Es Labor De 15 By How much tog ty there in the optimal solution in the following provide you awarin malinis onlyDo not to SE$9 Storage 32 0 40 1E+30 8 5 (A) How much excess labor there is in the optimal solution? In the following ticld, provide your answer in numerical digits only. Do not enter units. Approximate to two decimal digits it needed. Excess Labor se 7: (B) How much excess storage capacity there are in the optimal solution? te: In the following field, provide your answer in numerical digits only. Do not enter units. Approximate to two decimal digits it needed. 8 Excess Stora Page 9 9 (C) How does the total profit change it you give up 1 hour of labor and get additional 15 pounds of material? Page 10 10 Total protit will insert Increase or Decrease in the field) A Page 11 11 by an amount of center only digits. Do not enter units. Approximate to two digits if nicoded Page 12 D) How does the total protit change it you decided to introduce a new product that has a profit contribution of $2 per unit given that cach unit of this product will use 1 hour of labor 1 pound at material, and 2 square feet of storage? Page 13 12 Total protit will Insert Increase or Decrease in the fielel Page 14 14 by an amount of enter only capits. Do not enter units. Approximate to two digits it needed Pate 55 15 Page 13 of 60