Variable Cels Final Reduced Objective Allowable Allowable Cell Name Value Cost Coeffident Increase Decrease $B$10 Solution: Budget Type 1 40 0 30 0 30 $C$ 10 Solution Budget Type 2 70 O 25 20 0 $D$ 10 Solution: Budget-Plus Type 1 O 40 1E+30 0 $E$10 Solution Budget Plus Type 2 O O 0 1E30 $F$10 Solution: Deluxe 45 o 45 1E+30 20 Constraints Name $G$S Budget $G$6 Budget-Plus $G$7 Deluxe $G$8 Type 1 $G$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 40 25 115 70 Now using the information in Table 1 above answer the following questions from a-f. (a) Looking at the Sensitivity table above explain briefly by answering if the demand by any of these the classes is not satisfied. Answer: (b) Write down how many bookings the hotel should accept in each rental class? Answer: (c) The management has asked you to find out if they could consider offering a free breakfast to anyone upgrading from a Budget class to Budget-Plus class The management calculated the cost of the breakfast to the hotel is RO 5. By looking at the model output in the table above, should the management offer this incentive to the customers? Provide a brief explanation, Answer Variable Cels Final Reduced Objective Allowable Allowable Cell Name Value Cost Coeffident Increase Decrease $B$10 Solution: Budget Type 1 40 0 30 0 30 $C$ 10 Solution Budget Type 2 70 O 25 20 0 $D$ 10 Solution: Budget-Plus Type 1 O 40 1E+30 0 $E$10 Solution Budget Plus Type 2 O O 0 1E30 $F$10 Solution: Deluxe 45 o 45 1E+30 20 Constraints Name $G$S Budget $G$6 Budget-Plus $G$7 Deluxe $G$8 Type 1 $G$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 40 25 115 70 Now using the information in Table 1 above answer the following questions from a-f. (a) Looking at the Sensitivity table above explain briefly by answering if the demand by any of these the classes is not satisfied. Answer: (b) Write down how many bookings the hotel should accept in each rental class? Answer: (c) The management has asked you to find out if they could consider offering a free breakfast to anyone upgrading from a Budget class to Budget-Plus class The management calculated the cost of the breakfast to the hotel is RO 5. By looking at the model output in the table above, should the management offer this incentive to the customers? Provide a brief explanation