Data Table
Calculations set to Manual. Press F9 to recalculate.
Day Rain? Demand Seated Profit Run Profit
1 Dry 251 251 $238.75 Number of seats available 300 1 $8,117.50
2 Dry 318 300 $300.00 Profit per seat sold $1.00 2 $7,911.25
17 Dry 267 267 $258.75 17 $7,551.25
18 Dry 325 300 $300.00 18 $7,237.50
19 Dry 271 271 $263.75 19 $7,213.75
20 Dry 297 297 $296.25 20 $7,792.50
21 Rain 238 238 $222.50 21 $7,905.00
22 Dry 316 300 $300.00 22 $7,727.50
23 Dry 317 300 $300.00 23 $7,435.00
24 Dry 260 260 $250.00 24 $7,152.50
39 $6,800.00
40 $7,110.00
41 $6,921.25
42 $7,820.00
43 $6,998.75
44 $7,156.25
Problem 10-35
51 $7,076.25
52 $7,300.00
53 $7,182.50
65 $7,041.25
66 $7,773.75
67 $7,545.00
68 $7,046.25
69 $7,247.50
70 $7,318.75
71 $7,836.25
72 $6,991.25
73 $7,205.00
74 $7,997.50
75 $7,305.00
76 $7,838.75
77 $7,083.75
78 $6,913.75
79 $7,247.50
80 $7,525.00
89 $7,916.25
90 $7,373.75
91 $7,360.00
92 $7,633.75
93 $7,527.50
94 $7,838.75
95 $7,037.50
96 $7,358.75
97 $7,103.75
98 $6,993.75
104 $7,303.75
105 $6,980.00
106 $7,636.25
107 $7,661.25
108 $7,332.50
109 $7,291.25
110 $7,657.50
116 $7,655.00
117 $7,357.50
118 $7,052.50
119 $7,728.75
120 $7,750.00
121 $6,971.25
122 $7,085.00
123 $7,367.50
124 $7,547.50
138 $7,611.25
139 $7,127.50
140 $7,211.25
141 $7,007.50
142 $7,187.50
143 $7,390.00
144 $7,257.50
145 $7,405.00
146 $7,085.00
147 $7,578.75
148 $7,118.75
149 $7,035.00
150 $7,305.00
168 $7,241.25
169 $6,320.00
170 $6,885.00
171 $7,146.25
172 $7,360.00
173 $7,165.00
174 $7,270.00
175 $7,140.00
176 $7,205.00
177 $7,130.00
189 $7,466.25
190 $7,288.75
191 $7,572.50
192 $7,275.00
193 $7,160.00
194 $7,166.25
195 $7,212.50
196 $7,392.50
197 $7,227.50
198 $7,295.00
199 $7,317.50
200 $7,246.25