Question

In: Statistics and Probability

Round Tree Manor is a hotel that provides two types of rooms with three rental classes:...

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:

Rental Class
Super Saver Deluxe Business

Room
Type I (Mountain View) $35 $40 -
Type II (Street View) $25 $35 $45

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 in the Deluxe class, and 40 in the Business class. Since these are the forecasted demands, Round Tree will take no more than these amounts of each reservation for each rental class. Round Tree has a limited number of each type of room. There are 100 Type I rooms and 110 Type II rooms.

(a) Formulate and solve a linear program to determine how many reservations to accept in each rental class and how the reservations should be allocated to room types. If an amount is zero, enter “0”.
Rental Class with room type No of Reservations
Super Saver rentals allocated to room type I
Super Saver rentals allocated to room type II
Deluxe rentals allocated to room type I
Deluxe rentals allocated to room type II
Business rentals allocated to room type II
(b) For the solution in part (a), how many reservations can be accommodated in each rental class?
Rental Class No of Reservations
Super Saver I
Deluxe
Business
Demand for - Select your answer -Deluxe / Super Saver / Business rental class was not satisfied.
(c) With a little work, an unused office area could be converted to a rental room. If the conversion cost is the same for both types of rooms, would you recommend converting the office to a Type I or a Type II room?
Type I Type II
Shadow Price $ $
Convert an unused office area to - Select your answer -Type I / Type II 12 room.
Explain.
The input in the box below will not be graded, but may be reviewed and considered by your instructor.
(d) Could the linear programming model be modified to plan for the allocation of rental demand for the next night?
- Select your answer -Yes/No
What information would be needed and how would the model change? Explain.
The input in the box below will not be graded, but may be reviewed and considered by your instructor.

Solutions

Expert Solution


Related Solutions

Round Tree Manor is a hotel that provides two types of rooms with three rental classes:...
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: Rental Class Room Super Saver Deluxe Business Type I $36 $38 — Type II $15 $26 $38 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...
Round Tree Manor is a hotel that provides two types of rooms with three rental classes:...
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: Rental Class Super Saver Deluxe Business Type I $30 $35 -- Room Type II $20 $30 $40 Type I rooms do not have Internet access and are not available for the Business rental class. Round Tree’s management makes a forecast of the demand by...
Round Tree Manor is a hotel that provides two types of rooms with three rental classes:...
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: Rental Class Super Saver Deluxe Business Type I $30 $35 -- Room Type II $20 $30 $40 Type I rooms do not have Internet access and are not available for the Business rental class. Round Tree’s management makes a forecast of the demand by...
Round Tree Manor is a hotel that provides two types of rooms with three rental classes:...
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: Rental Class Room Super Saver Deluxe    Business Type I    $32 $43    — Type II $17 $35 $39 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...
Round Tree Manor is a hotel that provides two types of rooms with three rental classes:...
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: Rental Class Room Super Saver Deluxe Business Type I $38 $43 — Type II $16 $28 $45 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...
Problem 8-21 (Algorithmic) Round Tree Manor is a hotel that provides two types of rooms with...
Problem 8-21 (Algorithmic) 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: Rental Class Room Super Saver Deluxe Business Type I $36 $38 — Type II $15 $26 $38 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...
1-If you were the manager of a luxury hotel with 300 rooms and different types of...
1-If you were the manager of a luxury hotel with 300 rooms and different types of restaurants, what functionalities would you want from the PMS? Give examples for the integration between the PMS and three other IT systems. 2-Give examples of other channels that you will use to sell the hotel and how the PMS will help you to manage those channels?
Ada Hotel sells two room tpes: standard rooms and deluxe rooms. Average daily rate (ADR) and...
Ada Hotel sells two room tpes: standard rooms and deluxe rooms. Average daily rate (ADR) and variable costs (VC) of the two room types are provided in the table below: (Hint: Treat two room types as two different products.)                                                 ADR ($)   Variable Cost ($)               Standard rooms    394.50   256.43               Deluxe rooms   631.20   366.10                                     ...
Problem 2. Ada Hotel sells two room tpes: standard rooms and deluxe rooms.  Average daily rate (ADR)...
Problem 2. Ada Hotel sells two room tpes: standard rooms and deluxe rooms.  Average daily rate (ADR) and variable costs (VC) of the two room types are provided in the table below: (Hint: Treat two room types as two different products.) ADR ($) Variable Cost ($) Standard rooms 461.20 299.78 Deluxe rooms 737.92 427.99 The Mock Hotel's fixed costs for a month is =          = 295168 Sales mix (contribution of each room type to total room revenue) of the hotel is: Deluxe...
2. Demand for hotel rooms in Tallahassee takes two possible values: on game days, demand is...
2. Demand for hotel rooms in Tallahassee takes two possible values: on game days, demand is described by the demand curve q = 100−p, while on non-game-days demand is described by the demand curve q = 60 − 2p. (a) Suppose that the hotel price on game days is ph = 80. What quantity is demanded at this price? (b) Find the inverse demand curve on non-game-days. Assuming that the price on game days is ph = 80 as above,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT