Please answer part e of this question.

(22 points) You must show your detailed work to get credit in this question via Excel Model development. The solution must be submitted as EXCEL XLSX file to get any credit. The Inn at Penn hotel has 300 rooms with standard queen-size beds and two rates: a full price of $380 and a discount price of $180. To receive the discount price, a customer must purchase the room at least two weeks in advance (this helps to distinguish between leisure travelers, who tend to book early, and business travelers, who value the flexibility of booking late). For a particular Tuesday night, the hotel estimates that the demand from leisure travelers could fill the whole hotel while the demand from business travelers is distributed normally with a mean of 200 rooms and a standard deviation of 100. a. Suppose the Inn chose a protection level of 150 for the full-price rooms. What is the expected number of business travelers who will be lost? b. Continue assuming a protection level of 150 for the full-price rooms. What number of rooms (on average) remains unfilled? c. Compute the expected total revenue for The Inn at Penn with 150 rooms protected at the full-price. d. Find the optimal protection level for full-price rooms; the number of rooms to be protected from sale at a discount price. e. Due to customer no-shows, The Inn at Penn hotel is considering implementing overbooking. The forecast of no-shows is expressed by the discrete probability distribution below. F(Y) represents the cumulative probability distribution of no-shows. The Inn is sensitive about the quality of service it provides alumni, so it estimates the cost of failing to honor a reservation is $400 in lost goodwill and explicit expenses. If The Inn accepts 315 reservations, what is the probability The Inn will not be able to honor a reservation? + Y Y 0 6 Y 12 13 1 7 2 FY) 0.01 0.05 0.09 0.15 0.20 0.22 8 F(Y) 0.24 0.28 0.30 0.40 0.50 0.53 14 FY) 0.67 0.72 0.80 0.88 0.95 1.00 3 9 15 4 10 16 5 11 17 (22 points) You must show your detailed work to get credit in this question via Excel Model development. The solution must be submitted as EXCEL XLSX file to get any credit. The Inn at Penn hotel has 300 rooms with standard queen-size beds and two rates: a full price of $380 and a discount price of $180. To receive the discount price, a customer must purchase the room at least two weeks in advance (this helps to distinguish between leisure travelers, who tend to book early, and business travelers, who value the flexibility of booking late). For a particular Tuesday night, the hotel estimates that the demand from leisure travelers could fill the whole hotel while the demand from business travelers is distributed normally with a mean of 200 rooms and a standard deviation of 100. a. Suppose the Inn chose a protection level of 150 for the full-price rooms. What is the expected number of business travelers who will be lost? b. Continue assuming a protection level of 150 for the full-price rooms. What number of rooms (on average) remains unfilled? c. Compute the expected total revenue for The Inn at Penn with 150 rooms protected at the full-price. d. Find the optimal protection level for full-price rooms; the number of rooms to be protected from sale at a discount price. e. Due to customer no-shows, The Inn at Penn hotel is considering implementing overbooking. The forecast of no-shows is expressed by the discrete probability distribution below. F(Y) represents the cumulative probability distribution of no-shows. The Inn is sensitive about the quality of service it provides alumni, so it estimates the cost of failing to honor a reservation is $400 in lost goodwill and explicit expenses. If The Inn accepts 315 reservations, what is the probability The Inn will not be able to honor a reservation? + Y Y 0 6 Y 12 13 1 7 2 FY) 0.01 0.05 0.09 0.15 0.20 0.22 8 F(Y) 0.24 0.28 0.30 0.40 0.50 0.53 14 FY) 0.67 0.72 0.80 0.88 0.95 1.00 3 9 15 4 10 16 5 11 17