Data Table
(Calculations set to Manual. Press F9 to recalculate).
Day Demand Revenue Cost Profit
Run Profit
129 $435.00 $120.00 $315.00 Mean = 30 1 $7,515.00
34 $7,545.00
35 $7,635.00
36 $7,080.00
37 $7,350.00
38 $7,455.00
39 $7,080.00
40 $7,380.00
41 $7,185.00
42 $7,275.00
Demand Distribution
Problem 10-20
51 $7,575.00
52 $7,065.00
53 $6,975.00
54 $7,875.00
65 $7,080.00
66 $7,110.00
67 $6,630.00
68 $7,155.00
69 $7,455.00
80 $7,245.00
81 $7,200.00
82 $7,440.00
83 $7,380.00
84 $7,575.00
95 $7,020.00
96 $7,290.00
97 $7,440.00
98 $7,440.00
99 $7,215.00
110 $7,530.00
111 $6,600.00
112 $7,350.00
113 $7,650.00
114 $7,320.00
125 $7,530.00
126 $7,200.00
127 $7,245.00
128 $7,095.00
129 $7,860.00
140 $7,275.00
141 $6,990.00
142 $7,260.00
143 $7,380.00
144 $7,275.00
155 $7,350.00
156 $7,200.00
157 $7,425.00
158 $7,095.00
159 $6,915.00
170 $7,575.00
171 $7,395.00
172 $7,245.00
173 $7,080.00
174 $7,050.00
185 $7,380.00
186 $6,900.00
187 $7,380.00
188 $6,870.00
189 $7,140.00
200 $7,320.00
Scenario Summary
Current Values: Q25 Q35 Q40
Changing Cells:
Result Cells: