Data Table
Calculations set to Manual. Press F9 to recalculate.
Week Demand Profit Run Avg profit
Prob >=
200
130 $1,500.00 Profit $50.00 1$1,747.12 19.23%
12 26 $1,300.00 12 $1,733.65 17.31%
13 34 $1,700.00 13 $1,683.65 17.31%
14 45 $2,250.00 14 $1,771.15 19.23%
15 34 $1,700.00 15 $1,741.35 21.15%
16 27 $1,350.00 16 $1,826.92 25.00%
17 34 $1,700.00 17 $1,769.23 26.92%
18 33 $1,650.00 18 $1,680.77 17.31%
19 37 $1,850.00 19 $1,744.23 19.23%
28 37 $1,850.00 28 $1,783.65 28.85%
29 39 $1,950.00 29 $1,781.73 25.00%
30 32 $1,600.00 30 $1,761.54 23.08%
31 38 $1,900.00 31 $1,820.19 19.23%
32 39 $1,950.00 32 $1,783.65 17.31%
33 38 $1,900.00 33 $1,760.58 26.92%
Problem 10-14
41 37 $1,850.00 41 $1,803.85 19.23%
51 29 $1,450.00 51 $1,808.65 26.92%
52 41 $2,050.00 52 $1,660.58 7.69%
53 $1,760.58 19.23%
54 $1,782.69 19.23%
55 $1,724.04 17.31%
56 $1,754.81 15.38%
57 $1,694.23 13.46%
58 $1,784.62 23.08%
69 $1,759.62 17.31%
70 $1,817.31 30.77%
71 $1,798.08 25.00%
72 $1,735.58 21.15%
73 $1,706.73 5.77%
74 $1,681.73 15.38%
85 $1,693.27 19.23%
86 $1,676.92 15.38%
87 $1,745.19 23.08%
88 $1,711.54 9.62%
89 $1,698.08 13.46%
100 $1,759.62 21.15%
101 $1,764.42 19.23%
102 $1,768.27 23.08%
103 $1,762.50 15.38%
104 $1,762.50 13.46%
115 $1,730.77 13.46%
116 $1,719.23 11.54%
117 $1,700.00 15.38%
118 $1,764.42 15.38%
119 $1,727.88 21.15%
130 $1,730.77 17.31%
131 $1,683.65 11.54%
132 $1,817.31 17.31%
133 $1,796.15 19.23%
134 $1,757.69 15.38%
145 $1,730.77 19.23%
146 $1,710.58 21.15%
147 $1,785.58 26.92%
148 $1,712.50 7.69%
149 $1,753.85 15.38%
160 $1,693.27 11.54%
161 $1,723.08 15.38%
162 $1,715.38 15.38%
163 $1,726.92 17.31%
164 $1,784.62 17.31%
175 $1,769.23 17.31%
176 $1,703.85 9.62%
177 $1,789.42 23.08%
178 $1,789.42 19.23%
179 $1,746.15 9.62%
190 $1,716.35 9.62%
191 $1,788.46 28.85%
192 $1,729.81 13.46%
193 $1,804.81 25.00%
194 $1,746.15 7.69%