Question

Problem 11-5 Round Tree Manor is a hotel that provides two types of rooms with three...

Problem 11-5

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 $30 $35 -
Type II $15 $25 $35

Type I rooms do not have high-speed 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 130 rentals in the Super Saver class, 65 in the Deluxe class, and 45 in the Business class. Round Tree has 90 Type I rooms and 130 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.
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 -DeluxeSuper SaverBusinessItem 9 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 IType IIItem 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 -YesNoItem 14
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.
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Data Tools Forecast Outline Analyze Set Objective: SMS191 1 BUCT(M12:012, M10:010) To: O Max 0 O Value Ot: O Min K L M N P 0

Solution:

Type Room Type 11 No of rooms Type 1 Variable for decision No of rooms Type 2 Sum of rooms Rental Class Super Deluxe Business

a. 90

20

0

65

45

b.

110

65

45

Super saver

C.

Shadow (dual) price of type I = 35   (Dual price of Row 5 in the LINDO Solution report)

Shadow (dual) price of type II = 25   (Dual price of Row 6 in the LINDO Solution report)

Convert an unused office area to Type I room.

Shadow price of type I is higher. Therefore, it will give higher profit

(d) Yes

Information about demand forecast for the next night would be needed

Add a comment
Know the answer?
Add Answer to:
Problem 11-5 Round Tree Manor is a hotel that provides two types of rooms with three...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 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 (Mountain View) $35 $40 - Room 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...

  • eBook Problem 8-21 (Algorithmic) Round Tree Manor is a hotel that provides two types of rooms...

    eBook 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 Super Saver $32 $17 Deluxe $43 $35 Business Type I Room Type II $39 Type I rooms do not have wireless Internet access and are not available for the Business rental dass. Round Tree's management makes a forecast...

  • 41. Rou Round Tree Manor is a hotel that provides two types of rooms with three...

    41. Rou 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: Business Rental Class Super Saver Deluxe $30 $35 $20 $30 Room Type I Type II $40 Type I rooms do not have high-speed Internet access and are not available for the Business rental class. Round Tree's management makes a forecast of the...

  • 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:...

    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 hote th provides two types of room with three retai dames:...

    Round Tree Manor is a hote th provides two types of room with three retai dames: Super Savec Deluxe, and Business. The profit per night for each type of room and rental cass is as Super Saver Dele Business Type 1 (Mountain View) $30 Type II (Street View) Round Tree's management makes a forecast of the demand by rental dlass for each night in the ture A linear programming model developed tomieois used to determine how many reservations to accept...

  • Problem 9-15 (Algorithmic) Bay Oil produces two types of fuels (regular and super) by mixing three...

    Problem 9-15 (Algorithmic) Bay Oil produces two types of fuels (regular and super) by mixing three ingredients. The major distinguishing feature of the two products is the octane level required. Regular fuel must have a minimum octane level of 92 while super must have a level of at least 100. The cost per barrel, octane levels, and available amounts (in barrels) for the upcoming two-week period are shown in the following table. Likewise, the maximum demand for each end product...

  • Problem 9-15 (Algorithmic) Bay Oil produces two types of fuels (regular and super) by mixing three ingredients. The ma...

    Problem 9-15 (Algorithmic) Bay Oil produces two types of fuels (regular and super) by mixing three ingredients. The major distinguishing feature of the two products is the octane level required. Regular fuel must have a minimum octane level of 92 while super must have a level of at least 100. The cost per barrel, octane levels, and available amounts (in barrels) for the upcoming two-week period are shown in the following table. Likewise, the maximum demand for each end product...

  • need help with answer for question 3 and 4 please no define the word I need...

    need help with answer for question 3 and 4 please no define the word I need straight to the point answers ill will like the answer Chapter Case: Hudson Kayak Adventures Hudson Kayak Adventures (HKA) offers ecotours and kayak rentals along the Hudson River. Background Steve and Linda Lane are avid kayakers and amateur naturalists who spent many weekends exploring the Hudson River's numerous creeks and tributaries. Steve was a sales representative and Linda worked as a freelance Web designer....

  • Adirondack Savings Bank (ASB) has $1 million in new funds that must be allocated to home loans, personal loans, and automobile loans. The annual rates of return for the three types of loans are 5% for...

    Adirondack Savings Bank (ASB) has $1 million in new funds that must be allocated to home loans, personal loans, and automobile loans. The annual rates of return for the three types of loans are 5% for home loans, 13% for personal loans, and 8% for automobile loans. The bank’s planning committee has decided that at least 40% of the new funds must be allocated to home loans. In addition, the planning committee has specified that the amount allocated to personal...

  • BBA 442 BUSINESS RESEARCH... QUESTION THREE The weekly Hotel bill (HB) per traveller for COVID-19 mandatory...

    BBA 442 BUSINESS RESEARCH... QUESTION THREE The weekly Hotel bill (HB) per traveller for COVID-19 mandatory quarantine accommodation and centres are in high demand in Accra due to the limited accommodation facilities for these persons. Government may withdraw from taking care of the costs as expert say that the COVID- 19 has come to stay with us similar to other diseases. For this reason, it has become imperative for travellers to carefully plan for their accommodation. Information has been gathered...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT