Data Table
Calculations set to Manual. Press F9 to recalculate.
Week Demand Revenue Cost Profit Run Profit
1150 $300.0 $200.0 $100.0 Demand Probability RN intvl LL 1$4,638
2100 $300.0 $200.0 $100.0 50 0.05 0.00 2$4,863
20 100 $300.0 $200.0 $100.0 20 $4,525
21 175 $300.0 $200.0 $100.0 21 $4,638
22 100 $300.0 $200.0 $100.0 22 $4,525
23 125 $300.0 $200.0 $100.0 23 $4,806
24 75 $243.8 $200.0 $43.8 24 $4,919
25 175 $300.0 $200.0 $100.0 25 $4,750
26 100 $300.0 $200.0 $100.0 26 $4,750
27 150 $300.0 $200.0 $100.0 27 $4,525
28 125 $300.0 $200.0 $100.0 28 $4,694
Demand Distribution
Problem 10-18
44 75 $243.8 $200.0 $43.8 44 $4,638
45 125 $300.0 $200.0 $100.0 45 $4,300
46 100 $300.0 $200.0 $100.0 46 $4,581
47 175 $300.0 $200.0 $100.0 47 $4,413
58 $4,469
59 $4,356
60 $4,806
61 $4,300
62 $4,694
73 $4,525
74 $4,806
75 $4,525
76 $4,638
77 $4,750
88 $4,188
89 $4,638
90 $4,694
91 $4,919
92 $4,581
103 $4,525
104 $4,525
105 $4,581
106 $4,131
107 $4,806
118 $4,525
119 $4,863
120 $4,469
121 $4,581
122 $4,863
133 $4,694
134 $4,806
135 $4,919
136 $4,581
137 $4,694
148 $4,694
149 $4,469
150 $5,144
151 $4,638
152 $4,413
163 $4,919
164 $4,413
165 $4,694
166 $4,581
167 $4,469
178 $4,863
179 $4,469
180 $4,806
181 $4,694
182 $4,638
193 $4,638
194 $4,975
195 $4,469
196 $4,581
197 $4,863
Scenario Summary
Current Values: 50 150 175
Changing Cells:
Result Cells: