Answer as much as possible please

Question 1 You have been offered a job of Operations Manager at a local hotel in Al-Khoud and you are given the following problem with some questions. Your task is to find the answers to those questions to help the hotel management to make informed decisions and maximize total profit. Problem: A hotel in Al-Khoud provides two types of rooms with three rental classes: Budget, Budget-Plus, and Deluxe. The profit (in RO) per night for each type of room and rental room class is shown as follows: Rental Room Class Room Type Budget Budget-Plus Deluxe Type 1 30 40 Type 2 25 35 45 The above table shows that Type 1 rooms are not available for the Deluxe rental room class due to lack of some facilities. Since you took an optional course "Forecasting Methods as a part of your degree plan, you decided to conduct a demand forecast by rental class for each night in future. The demand forecast for a particular night found is 125 rentals in the Budget class, 55 rentals in the Budget-Plus, and 45 rentals in the Deluxe class. Currently the hotel has 95 Type 1 rooms and 115 Type 2 rooms. You decided to develop a linear programing based Excel model to help you to determine how many reservations to accept in each rental class and how the reservations should be allocated to room types to maximize profit. You then solved the model using Solver tool and created following Sensitivity analysis Table 1. Table 1: Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$10 Solution: Budget Type 1 40 0 30 0 30 $C$10 Solution: Budget Type 2 70 25 20 0 $D$10 Solution: Budget-Plus Type 1 55 0 40 1E+30 0 $E$10 Solution: Budget-Plus Type 2 0 0 35 0 1E+30 $F$10 Solution: Deluxe 45 0 45 1E+30 20 Constraints Cell Name $G$5 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 15 40 115 25 115 15 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. {4} Answer: (b) Write down how many bookings the hotel should accept in each rental class? {3} 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. {4} Answer: (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: (f) 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? {4}