Expected payoff table

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

1

2

3

4

5

A

B

Number of Hotel Rooms to Sell

Full Price for a Room

Discount Price for a Room