Create the model spreadsheet

Assignment Help Operation Management

Reference no: EM132112547

The Gambler Hotel in Las Vegas has 300 rooms that each rents for $175 per night. For each reservation accepted, there is a 10% chance that the guest will not arrive. If the guest doesn’t arrive, the hotel will charge $30 for reservation processing fee. If the hotel overbooks, the guests will be upgraded to a luxury suit at their new Grand Tower at no additional charge. This incurs additional $220 cost for Gambler hotel for each reservation that is not honored. The hotel’s fixed cost per night obeys a Normal distribution with the mean of $20,000 and standard deviation of $2,000. The variable cost (per occupied room) is uniformly distributed between $30 to $70.

a. The manger believes that accepting 310 nightly reservations is a policy that the hotel should implement. Use Crystal Ball to estimate the average daily profit using the manager’s policy (1000 replications).

i. Create the model spreadsheet.

ii. Create a report for the results and label the tab.

Reference no: EM132112547

Questions Cloud

Several ways to conduct selection interview. : There are several ways to conduct a selection interview. Explain and illustrate the basic ways in which you can classify selection interviews.

How far does the pike move during the strike : When striking, the pike, a predatory fish, can accelerate from rest to a speed of 3.9m/s in 0.12s. How far does the pike move during this strike?

Economic activity is good thing for society : Clearly at the center of many of our ethical investigations into business is the claim that in and of itself economic activity is a "good" thing for society

Does the blood move during one beat : A somewhat idealized graph of the speed of the blood in the ascending aorta during one beat of the heart appears as in the figure.

Create the model spreadsheet : Create the model spreadsheet. Create a report for the results and label the tab.

Find the quadratic equation for the distance : Find the quadratic equation for the distance, D, in terms of the time, the acceleration due to gravity, and the speed of sound. Arrange the expression.

Design small marketing research experiment : Design a small marketing research experiment. How will you establish that your findings are valid?

What is the stones mass height above the place : Why are there two answers to b? I said because the stone reaches the given hieght two time, on the way up and then again on the way down

Primarily for the halloween season : Pony Express Creations Inc. is a manufacturer of party hats, primarily for the Halloween season.

User Account

All Pages