Data Table
Calculations set to Manual. Press F9 to recalculate.
Day
Begin
Inv
Units
Rec
Avail
Inv
Dem-
and
Dem-
and
filled
End
Inv
Stock
out
End
Inv +
Order
Place
order?
Lead
time
Inv cost
Stockout
cost
Order
cost
Run Total cost
% stoc-
kout
1300 0300 49 49 251 0251 0 0 0 $125.50 $0 $0 Minimum demand 30 1 $17,537.00
14.38%
2251 0251 35 35 216 0216 0 0 0 $108.00 $0 $0 Maximum demand 60 2 $17,816.00 14.28%
27 154 0154 39 39 115 0115 0 0 0 $57.50 $0 $0 27 $16,264.50 12.25%
28 115 0115 43 43 72 072 1 3 32 $36.00 $0 $100 28 $16,493.50 12.17%
29 72 072 32 32 40 0340 0 0 0 $20.00 $0 $0 29 $16,464.00 12.34%
30 40 040 41 40 0 1 300 0 0 0 $0.00 $20 $0 30 $16,276.50 12.07%
31 0 0 0 41 0 0 41 300 0 0 0 $0.00 $820 $0 31 $17,210.50 13.27%
32 0300 300 32 32 268 0268 0 0 0 $134.00 $0 $0 32 $16,468.00 12.15%
33 268 0268 41 41 227 0227 0 0 0 $113.50 $0 $0 33 $12,175.00 6.30%
34 227 0227 54 54 173 0173 0 0 0 $86.50 $0 $0 34 $15,134.50 10.56%
35 173 0173 37 37 136 0136 0 0 0 $68.00 $0 $0 35 $13,088.00 7.48%
36 136 0136 54 54 82 082 0 0 0 $41.00 $0 $0 36 $18,777.00 14.83%
37 82 082 59 59 23 023 1 3 41 $11.50 $0 $100 37 $14,328.50 9.68%
63 40 040 53 40 013 300 0 0 0 $0.00 $260 $0 63 $14,865.00 9.80%
64 0 0 0 57 0 0 57 300 0 0 0 $0.00 $1,140 $0 64 $15,173.00 10.62%
65 0 0 0 58 0 0 58 300 0 0 0 $0.00 $1,160 $0 65 $16,309.00 11.92%
66 0300 300 38 38 262 0262 0 0 0 $131.00 $0 $0 66 $13,365.50 8.67%
67 262 0262 35 35 227 0227 0 0 0 $113.50 $0 $0 67 $15,604.00 11.50%
68 227 0227 45 45 182 0182 0 0 0 $91.00 $0 $0 68 $14,252.50 9.04%
69 182 0182 52 52 130 0130 0 0 0 $65.00 $0 $0 69 $13,655.00 8.20%
70 130 0130 33 33 97 097 0 0 0 $48.50 $0 $0 70 $16,359.00 12.07%
Problem 10-27
83 214 0214 40 40 174 0174 0 0 0 $87.00 $0 $0 83 $15,329.50 10.85%
84 174 0174 45 45 129 0129 0 0 0 $64.50 $0 $0 84 $12,271.50 6.78%
85 129 0129 33 33 96 096 0 0 0 $48.00 $0 $0 85 $13,076.00 7.94%
97 $12,081.50 6.14%
98 $12,499.50 7.21%
99 $14,706.00 10.02%
100 $14,623.50 10.08%
101 $13,136.50 8.16%
102 $15,626.00 10.96%
103 $14,636.00 9.72%
104 $11,935.00 6.37%
105 $14,973.50 10.19%
106 $14,770.50 10.25%
107 $14,143.00 9.30%
108 $13,693.50 8.77%
109 $13,218.50 7.99%
110 $13,549.50 8.69%
111 $14,857.00 9.69%
112 $17,394.00 13.19%
113 $13,676.00 8.19%
114 $11,868.50 6.13%
115 $13,984.50 8.31%
116 $13,563.50 8.30%
117 $12,480.00 6.60%
118 $17,121.50 12.48%
140 $13,440.50 7.73%
141 $16,780.00 12.52%
142 $14,201.50 9.24%
143 $14,565.00 9.73%
144 $14,856.00 10.43%
145 $15,968.00 11.48%
146 $15,240.50 10.89%
147 $13,779.50 8.40%
148 $15,727.00 10.83%
149 $12,959.50 8.00%
150 $11,927.00 6.20%
151 $14,245.50 9.13%
152 $13,862.50 9.27%
153 $14,575.00 9.15%
154 $13,997.50 8.93%
155 $15,775.00 11.19%
156 $13,800.00 8.46%
157 $14,697.00 10.07%
158 $20,203.50 17.12%
159 $15,544.50 11.05%
160 $15,295.00 11.01%
171 $15,874.50 11.47%
172 $13,220.00 7.57%
173 $17,499.50 13.72%
182 $14,355.50 9.29%
183 $16,198.00 11.99%
184 $16,193.00 12.11%
185 $15,194.50 10.93%
186 $14,375.00 9.44%
187 $14,419.50 9.86%
188 $15,925.50 11.34%
189 $16,576.00 12.82%
190 $16,173.50 11.63%