This question has an excel sheet that I am looking for help to populate. Unfortunately I could not attach it here.

A hotel is determining how many reservations to accept for an event in Indianapolis.

Download the template file above to see the details of the problem. Establish the probability for each number of customers that show up and the expected cost as a result. Then calculate the total expected cost.

Use a data table to evaluate different numbers of rooms to sell.

Based on your data table for the previous problem, what is the optimal number of rooms to sell to minimize the amount of expected cost?

Enter your answer as a whole number.

This is a partial template...additional modification may be required. Number of rooms sold = Number of Rooms Available = Expected cost = P(show up) = Cost to reaccomodate = Cost of an empty room =

No. Show up Probability Cost Prob*Cost 1 2 3 4