Please answer the following using excel

This quiz consists of 5 problems including building this model. It is recommended that you solve this problem prior to beginning the quiz.

A hotel has a capacity of 150 rooms and is deciding between two policies for accepting reservations.

Policy 1 accepts reservations for up to 150 rooms. Policy 2 accepts reservations for up to 152 rooms.

• The Revenue per room filled is $1000.
• The Cost (penalty) of denying any guest a room is $2200.
• These is no charge to customers who do not show for their reservation

The following probability distributions represent the number of guests showing up to the hotel:

(Policy 1)

# Who Show	147	148	149	150
Probability	.2	.25	.3	.25

(Policy 2)

# Who Show	149	150	151	152
Probability	.2	.25	.25	.3

(Suggested Template)