P10-33
Data Table
Calculations set to Manual. Press F9 to recalculate.
Month
Begin
Inv
Units
Rec
Avail
Inv
Demand
Demand
Filled
End
Inv
Stock
out
End Inv
+ Order
Lead
time
Arrive
on day
Inv cost
Stockout
cost
Order cost Value
Proba-
bility
RN intvl
LL
Run
Avg
stockout
Cost per
month
114 014 9 9 5 0 5 1 1 3 $2,000 $0 $1,000 1 3.38 $26,504
2 5 0 5 8 5 0 3 14 0 0 0 $0 $22,500 $0 2 3.33 $26,125
3 0 14 14 9 9 5 0 5 1 2 6 $2,000 $0 $1,000 6 0.0833 0.0000 3 3.75 $29,133
4 5 0 5 9 5 0 4 14 0 0 0 $0 $30,000 $0 7 0.1111 0.0833 4 3.92 $30,375
Avg stockout = 3.38 Total = $19,600 $607,500 $9,000 25 4.79 $36,796
32 3.08 $24,375
87 4.50 $34,750
Sales Distribution
Problem 10-33
Page 1
120 3.88 $30,254
121 3.58 $28,050
132 3.54 $27,738
133 3.71 $28,988
144 4.38 $33,713
145 3.21 $25,363
158 4.08 $31,675
159 3.92 $30,483
178 4.00 $31,092
179 3.50 $27,458
Page 2
P10-33
185 4.04 $31,279
186 3.46 $27,104
193 3.33 $26,325
194 3.83 $29,850
199 3.67 $28,608
200 3.21 $25,321
Page 3
Scenario Summary
Current Values: 12 16 18 20