Problem 10-30 Data Table
(Calculations set to Manual. Press F9 to recalculate).
Maximum res accepted = 9
RN intvl LL Value Probability Run Profit
Demand = 7 1 $174
Actual res accepted = 7
2$24
Number no shows = 0 0.00 5 0.05 3 $582
18 $582
19 $324
Cost of overbooking $150 20 $453
Fare $129 21 $840
32 $195
33 $282
34 $132
35 $324
36 $432
Demand Distribution
Cost Data
12 $711
47 $582
48 $453
49 $711
50 $153
51 $690
62 $303
63 $453
64 $195
65 $432
66 $453
77 $3
78 $453
79 $324
80 $432
81 $561
92 $453
93 $561
94 $411
95 $24
96 $195
107 $453
108 $153
109 $1,098
110 $453
111 $690
122 $690
123 $453
124 $969
125 $324
126 -$126
137 $324
138 $969
139 $840
140 $174
141 $582
152 $840
153 $282
154 $3
155 $174
156 $153
167 $432
168 $582
169 $582
170 $561
171 $840
182 $582
183 $324
184 $582
185 $582
186 $453
197 $1,098
198 $711
199 $453
Scenario Summary
Current Values: 0 1 2 4 5
Changing Cells:
Result Cells: