Data Table
Calculations set to Manual. Press F9 to recalculate.
Day Demand
Today
Revenue
Cost
Next-Day
Revenue
Profit Demand Probability
RN intvl LL Run Profit
130 $3,000.00 $1,500.00 $0.00 $1,500.00 15 0.08 0.00 1 $33,375.00
28 $31,125.00
29 $31,500.00
30 $30,000.00
31 $31,125.00
32 $29,250.00
33 $28,125.00
34 $28,125.00
35 $32,625.00
36 $31,125.00
37 $31,500.00
38 $32,625.00
39 $30,750.00
40 $27,375.00
41 $31,500.00
Demand Distribution
Problem 10-19
60 $31,500.00
61 $31,500.00
62 $34,125.00
63 $28,500.00
74 $31,500.00
75 $30,000.00
76 $32,625.00
77 $31,875.00
78 $27,375.00
89 $32,250.00
90 $31,500.00
91 $28,500.00
92 $28,875.00
93 $31,875.00
104 $29,625.00
105 $30,375.00
106 $30,750.00
107 $31,125.00
108 $32,250.00
119 $33,375.00
120 $31,500.00
121 $28,125.00
122 $31,500.00
123 $29,625.00
134 $30,750.00
135 $29,625.00
136 $31,875.00
137 $26,250.00
138 $30,375.00
149 $31,500.00
150 $31,125.00
151 $32,625.00
152 $30,375.00
153 $29,625.00
164 $28,125.00
165 $30,375.00
166 $29,625.00
167 $30,750.00
168 $30,375.00
179 $29,625.00
180 $32,625.00
181 $31,875.00
182 $31,875.00
183 $33,375.00
194 $28,125.00
195 $27,375.00
196 $28,875.00
197 $30,750.00
198 $30,000.00
Scenario Summary
Current Values: Q25 Q30 Q35 Q40