Table 1: Variable Cells Final Reduced Objective Allowable Allowable Celt Name Value Cost Coefficient Increase Decrease $8$10 Solution: Budget Type 1 40 0 30 0 30 $C$10 Solution: Budget Type 2 70 0 25 20 0 SD$10 Solution: Budget-Plus Type 1 55 0 40 1E+30 0 $E$10 Solution: Budget Plus Type 2 0 0 0 1E+30 $F$10 Solution: Deluxe 45 0 45 1E30 20 35 Constraints Cell Name $G$5 Budget $G$6 Budget Plus $G$7 Deluxe $G$8 Type 1 SG$9 Type 2 Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 110 0 125 1E-30 15 55 10 55 40 15 45 20 45 70 15 95 30 95 15 40 115 25 115 15 70 (d) The management realized that an unused office room could be converted to a rental room with a little work, and the conversion cost is the same for both types of rooms. By looking at the model output in the table above would you recommend the management to convert the office to a Type 1 or Type 2 room? Provide brief reasoning to your answers. (3) Answer: (e) The management is considering to increase the rental profit for Type 2 room for Budget class to RO 30 per night, and asking you to find out if the optimal solution would change? Provide brief calculations {4} Answer: I (6) Now the management asking you to modify the model to plan for the allocation of rental demand for the following night. What information you would need for this purpose and how would you change the model