Question

In: Operations Management

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 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 140 rentals in the Super Saver class, 60 rentals in the Deluxe class, and 40 rentals in the Business class. Round Tree has 125 Type I rooms and 135 Type II rooms.

  1. Use linear programming to determine how many reservations to accept in each rental class and how the reservations should be allocated to room types.
    Variable # of reservations
    SuperSaver rentals allocated to room type I
    SuperSaver 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
  2. How many reservations can be accommodated in each rental class?
    Rental Class # of reservations
    SuperSaver
    Deluxe
    Business

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 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...
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 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...
Problem 11-21 (Algorithmic) Agan Interior Design provides home and office decorating assistance to its customers. In...
Problem 11-21 (Algorithmic) Agan Interior Design provides home and office decorating assistance to its customers. In normal operation, an average of 2.7 customers arrive each hour. One design consultant is available to answer customer questions and make product recommendations. Agan's management would like to evaluate two alternatives: Use one consultant with an average service time of 8 minutes per customer. Expand to two consultants, each of whom has an average service time of 10 minutes per customer. If the consultants...
Please use Visual Basic Hotel Occupancy The Hotel has 8 Floors and 30 rooms on each...
Please use Visual Basic Hotel Occupancy The Hotel has 8 Floors and 30 rooms on each floor. Create an application that calculates the occupancy rate for each floor, and the overall occupancy rate for the hotel. The occupancy rate is the percentage of rooms occupied, and may be calculated by dividing the number of rooms occupied by the number of rooms. For example, if 18 rooms on the 1st floor are occupied, the Occupancy Rate is as follows: 18/30=0.6 or...
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?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT