Spare Part Inventory Analysis Report: Normal Distribution-Curve EOQ Model
Spare Part Inventory Analysis Report: Normal Distribution-Curve EOQ Model
Spare Part Inventory Analysis Report: Normal Distribution-Curve EOQ Model
3Yrs
Annual
Cons.
StLoc.
2
Material #
000300388
Material Description
WASHER,FLAT,01643-32060,KOMATSU
Unit Price
CAD
Plant
0611
Average
Annual Reorder Point
Cons.
Maximum
SoH
Level
CR-MINE
16
CR-SA
999
333
200
105
1.42
GR Processing
Lead Time
250
200
196
200
200
200
135
120
150
100
65
48
32
50
0 0 2 0 0 0 0 0 0 0 0 0 0 0 1 0
0
2015-12
2015-09
2015-06
2015-03
2014-12
2014-09
0 0
2014-06
2014-03
0 0
2013-12
0 0
2013-09
16
0 0 0
2013-06
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
2013-03
2012-12
2012-09
2012-06
2012-03
Annual demand
2011-09
70%
CAD
SL Factor
0.52
CAD
EOQ Model
7000
EOQ
Total Holding Cost
Total Ordering Cost
Total Cost
95%
Service Level
70%
6000
Risk of a
StockOut 30%
2011-03
68%
2011-06
339
Service Level
2011-12
0 0 0 0 0 0
5000
Cost ($)
4000
3000
2000
$209.0
1000
0
0.1%
0.6%
2.3%
6.7%
15.9%
30.9%
50.0%
69.1%
84.1%
93.3%
97.7%
99.4%
99.9%
50
100
Percentile
150
200
250
300
350
Order Quantity
17
25
259
Recommended MIN_MAX
IOC
EXISTING MAX
SKF MIN
SKF MAX
200
25
284
CAD
284.00 CAD
35.50 CAD
403.28
SKF Remarks