In the R03_ROOM_MIX worksheet, setup placeholder cells for the Rental Quantities of all room types. These cells will act as the changing cells in the Solver tool.

Helios Hotels offers several room types, including Standard, Deluxe, Junior Suite, Corner Suite and Executive Suites. Room types differ based on the available amenities (such as in-suite coffee machines and cable television), while the more premium room types have entirely different room sizes (usually larger), locations (top-floor, corner room), and bathroom configurations (jet tubs). Management performed a study of their existing hotel locations and determined the maximum number of rooms of each type. Each room type requires a specific number of hotel staff for effective operations including Housekeeping, Maintenance Staffs, Servers, Security Personnel, Service Staffs and Bell Boys. Given the staff requirements for operating each room, the revenue from each room, and the staff and room availability constraints, your task is to determine the optimal mix of rooms that Helios Hotel should configure. Tasks 1. In the R03_ROOM_MIX worksheet, setup placeholder cells for the Rental Quantities of all room types. These cells will act as the changing cells in the Solver tool. 2. Using the placeholder cells and the revenue values of each room, designate and formulate a cell that holds the total revenue from the rental of all rooms. This cell will act as the target cell (objective function) in the Solver tool. 3. Using the placeholder cells for the rental quantities, designate and formulate cells that contain the total number of staff required for Housekeeping, Maintenance Staffs, Servers, Security, Service and Bell operations. These cells will act as the comparison cells for the staff availability constraints identified in the spreadsheet. 4. Open the solver tool and specify the target cell, changing cells, and constraints along with other parameters for obtaining a linear programming solution to this optimization problem.