7/25/2019 000134889

1/1

2StLoc.

3Yrs

Annual

Cons.

Average

Annual

Cons.

Reorder PointMaximum

LevelSoH

Material # 000134889 Plant 0611 CR-MINE 55 19 0 0 0

Material Description ASSEMBLY,HOLD-DOWN-STRETCH,SPA-099451 CR-SH 73 25 6 8 8

Unit Price

Planned Delivery Lead

Time

GR Processing

Lead Time

28 3

Annual demand 44

Service Level 75% Service Level 75% Per Order cost 35.00CAD Fixed Cost

SL Factor 0.67 Risk of a StockOut 25% Holding Cost /Unit/Year 1.27CAD 25 % of the Unit Price

Economic Order Quantity 49

EOQ = Economic order quantity

Co = Cost of procurement

S = Annual usage

Cm = Annual carrying costs

U = Cost of the item. DDL = Demand during Lead Time or working stock.

S = Annual usage of the item (demand)

LT = Lead time i n days.

SS = Safety stock. SKF Remarks SD= Standard deviation of monthly demand.

SL= Standard deviation of Lead-time.

SLFactor = The normal distribution value which yields the desired service level factor

Spare Part Inventory Analysis Report

494 4 8

Demand During Lead Time Reorder Point (RoP) Economic Order Qty (EoQ)

Material Consumption for Past 5 Years or 60 Months

Safety Stock (SS)

Lead Time in Days

5.09CAD

Stock On Hand

8

CAD 40.72 CAD 30.54 CAD 40.72

IOC

EXISTING MIN

IOC

EXISTING MAX

6 8

Recommended MIN_MAX

Lead Time Ranking

Unit Cost Ranking

F

M

L

Min= ROP and Max = ROP +

EOQ

CAD 40.72 CAD 290.13

Movement Type

Ranking

SKF MIN SKF MAX

8 57

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%

Percentile

Normal Distribution- Curve

Service Level

75%

Risk of aStockOut 25%

$63.0

0

100

200

300

400

500

600

700

800

900

0 50 100 150 200 250 300 350

Cost($)

Order Quantity

EOQ ModelEOQTotal Holding CostTotal Ordering CostTotal Cost

0 0 0 0

8 8

0 0 0 0

16

8

16

0

11

0 0 0 0 0

5

14

0

10

56

0 0

-2

0

64

10 0

4

0 0

16

0 0 0 02

11

20 0 0

5

20 0

3

0

-1

0 0

5

0

-5

0

5

10

15

20

2 015 -1 2 2 01 5-0 9 2 01 5-06 20 15 -0 3 2 014 -1 2 2 01 4-09 20 14 -06 20 14 -0 3 2 01 3-1 2 2 01 3-09 20 13 -06 20 13 -0 3 2 01 2-1 2 2 01 2-09 20 12 -06 2 012 -0 3 2 01 1-1 2 2 01 1-09 20 11 -0 6 2 011 -0 3

000134889

68%

95%