Unit 4 : IT 528

profileshells0143
ExpectedPayoff.xlsx

Worksheet

Pricing Assumptions Table
Number of Hotel Rooms to Sell
Full Price for a Room
Discount Price for a Room
Expected Payoff Table
Conclusion
Likelihood → 1% 4% 7% 9% 11% 15% 20% 15% 11% 5% 2% Expected Payoff Calculations
Rooms Sold At Full Price → At a Discount ↓ 50 55 60 65 70 75 80 85 90 95 100
0
5
10
15
20
25
30
35
40
45
50
Price of Perfect Information
Oppportunity Loss Table
Rooms Sold At Full Price → At a Discount ↓ 50 55 60 65 70 75 80 85 90 95 100 Expected Opportunity Loss Calculations
0
5
10
15
20
25
30
35
40
45
50

IT528: Quantitative Risk Analysis Expected Payoff Worksheet &P