Round Tree Manor is a hotel that provides two types of rooms with three rental c
ID: 3204482 • Letter: R
Question
Round Tree Manor is a hotel that provides two types of rooms with three rental classes: Super Saver, Deluxe, and Business. The profit per night for each type of room and rental class is as follows:
Type I rooms do not have wireless Internet access and are not available for the Business rental class. Round Tree's management makes a forecast of the demand by rental class for each night in the future. A linear programming model developed to maximize profit is used to determine how many reservations to accept for each rental class. The demand forecast for a particular night is 150 rentals in the Super Saver class, 55 rentals in the Deluxe class, and 40 rentals in the Business class. Round Tree has 100 Type I rooms and 110 Type II rooms.
Room Type I $35 $40 - Type II $25 $35 $45
Explanation / Answer
Below are the excel solver details
Below are values computed by solver
Reservations accomodated in Super Saver I = 115
Reservations accomodated in Delux = 55
Reservations accomodated in Business = 40
Solver Solution x11 x12 y11 y12 z12 Total Demand Decision Variables 100 15 0 55 40 Rental 35 25 40 35 45 7600 Constraint 1 1 1 0 0 0 115 150 Constraint 2 0 0 1 1 0 55 55 Constraint 3 0 0 0 0 1 40 40 Constraint 4 1 0 1 0 0 100 100 Constraint 5 0 1 0 1 1 110 110Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.