Question

While vacationing in England, you decide to take an impromptu trip outside of London to see some of the country. You phone several hotels in the area but are told that all rooms are reserved. You and your friends decide to go anyway, vowing that if worse comes to worse you will all sleep in the car. Having driven the 100 miles from London, you stop at the first hotel you see, Ye Olde Ox and Bow, and are surprised to find that rooms are available. Having settled in, you go down to the Hotel Pub for a drink and strike up a conversation with the Hotel Manager. You inform him of your experience and he points out that it is not uncommon. The problem is that about 20% of the people with reservations either call back and cancel or just don’t show up. He tells you that there is a great deal of uncertainty in how long guests will stay. From experience he has found that about half of the guests who stayed the night will stay for another night irrespective of their original plans. He therefore adds half the number of rooms rented to the number of vacant rooms to come up with his estimate of the number of rooms that will be available (if there are 92 rooms rented, one half is 46 to which he adds the 8 vacant rooms to come up with an estimated 54 vacant rooms the next night). He then will take a maximum of 54 reservations. Of course, many of the reservations become no-shows so that he usually has rooms available.

You point out that airlines regularly overbook flights since they have a similar “no-show” problem. He has never tried this approach and is worried since if a person with a reservation showed up, he would feel compelled to pay for a similar room at a competitor and provide the inconvenienced party with a free dinner and breakfast.

You wake up the next morning to a terribly rainy English day, which ruins all of your plans. Your friends decide to see the sites of the town, which is a Museum dedicated to Quilting. You beg off and find yourself with most of the morning and afternoon free. Your thoughts return to the previous evening’s conversation and you think that you might be able to help the owner make a bit more profit by changing his reservation procedure.

Assignment:

By using simulation techniques compare the current reservation system with an open reservation system where anyone who calls for a reservation is given one. Specifically determine if the open reservation system is more or less profitable than the current system. Your simulation should be no smaller than one year in length.

Facts and Assumptions:

1) The hotel has 100 rentable rooms;

2) Assume that of the n rooms that are occupied on a given night, the number that will vacate the next day follows the Binomial Distribution with parameters n and p = ½;

3) Assume that the number of new reservations follows the Poisson Distribution with mean equal to 60;

4) If m is the number of reservations made, assume that the number of “no-shows” will follow the Binomial Distribution with parameters m and p=.2;

5) The profit break even point is 50 rented rooms;

6) The net profit is \$90 per room for each rented room over 50;

7) If a person with a reservation cannot be accommodated, the cost to put the person up at another hotel plus dinner and breakfast is \$270.

8) In your simulation you may assume that holidays and weekend lodging and reservations are the same as on any other day.

Hints:

a) Assume that the hotel starts off with 92 rented rooms.

b) Use the day as your basic unit, i.e. use the previous day’s occupancy as the starting point from which you will determine vacancies and, in the case of the present reservation system, the number of reservations you will take. Then determine how many reservations in fact show up and compute the final number of rooms rented. In the case of the present reservation system, use this figure as the starting point for the next day.

#### Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
• ### Use Case Modeling APPENDIX-A Online Hotel Reservation System RichOS hotels owner Mr. Tompkins wanted an online...

Use Case Modeling APPENDIX-A Online Hotel Reservation System RichOS hotels owner Mr. Tompkins wanted an online reservation system (HORSE) for his new hotel located in Antalya. The hotel has two types of rooms: regular and suit. In order to make a reservation or cancel any other, the clients (persons or travel agency) must logon the system. The clients should register to the system through their names, e-mail and telephone information. Clients will be able to query the availability of the...

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

• ### Part II: Let Me Inn (20 points) You are the manager of the Let Me Inn....

Part II: Let Me Inn (20 points) You are the manager of the Let Me Inn. A travel agent has sent you a list of reservations that can be accommodated by the hotel. Your primary job is to send him back the total cost of the reservations. To make sure your hotel runs properly, you also will keep track of how much money you have made from each type of room (Normal, Double, King, Suite). Complete the function hotel manager...

• ### Hotel manager Mr. Smith and his resourceful assistant, John, run a 26-room hotel in a little...

Hotel manager Mr. Smith and his resourceful assistant, John, run a 26-room hotel in a little town. A combination of Mr. Smith's friendly attitude and the absence of a respectable hotel in the nearby vicinity imply that Mr. Smith enjoys sufficient demand at his low fare of \$159 per night. John notes that some customers will walk into the hotel requesting a room for that evening and they are willing to pay a high fare of \$325 per night. John...

• ### Objective: To implement the programming languages features discussed in class and to develop a program that...

Objective: To implement the programming languages features discussed in class and to develop a program that uses Graphical User Interfaces (GUI) that provides a friendly environment for users. Project Assignment Design and implement a Hotel Reservation System. The hotel has two types of rooms. One is regular room that has two beds. Another is deluxe room that has two beds and a safe. The regular room price is \$120 per night. The deluxe room is \$130 per night. A safe...

• ### An investor recently bought a hotel for € 700,000 and then spent a further € 800,000...

An investor recently bought a hotel for € 700,000 and then spent a further € 800,000 on renovations, fixtures, fittings and equipment. The hotel has 60 double-bedded rooms, a bar restaurant, and a leisure facility free for hotel guests. The investor estimates the costs of operating the hotel over a year as follows: Business rates € 160,000 € 25,000 € 60,000 Maintenance and repairs Depreciation of fixtures, fittings and equipment Salaries - assistant managers, bar/restaurant and facility managers Wages-full-time staff...

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

• ### There are a sotall of five classes and one enum required for this project. Over the...

There are a sotall of five classes and one enum required for this project. Over the course of the projeet, it is important that you pay attention to how different responsibilities are separaled between the classes and how they work in coejuncticn to handle a probiem A quick list of the necessary items for this peogram are HotelManagement Class This is the driver class foe your peogram It will cntain a methed for setting up an initial hotel and the...

Hospitality Law Please answer all the questions. Answering the questions in paragraph format instead of listing the questions and answers. Use terms and applicable philosophies from the chapter. You will be graded on the quality of your post and on grammar and spelling. WHAT You are the manager of a franchised, 90-room limited WOULD service hotel property located YOU DO? across the highway from 7 Flags, a major amusement park that is extremely busy in the summer. One of the...

• ### Service Quality at the Remington Hotel Day One Madeline Lewis had recently transferred to the Remington...

Service Quality at the Remington Hotel Day One Madeline Lewis had recently transferred to the Remington Hotel to improve the level of service quality. She had been with the company for five years and had been quite successful in improving the level of service quality at the two previous hotels to which she had been assigned. Madeline knew that the Remington was going to be a real challenge. The mix of business was 60 percent individual transient guests and 40...