7/25/2019 000004349

1/1

0StLoc.

3Yrs

Annual

Cons.

Average

Annual

Cons.

Reorder PointMaximum

LevelSoH

Material # 000004349 Plant 0611

Material Description FUSE,1A,250V,AGC1,GOULD

Unit Price

Planned Delivery Lead

Time

GR Processing

Lead Time

5 3

Annual demand 0

Service Level 90% Service Level 90% Per Order cost Fixed Cost

SL Factor 1.28 Risk of a StockOut 10% Holding Cost /Unit/Year 25 % of the Unit Price

Economic Order Quantity

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

00 0 0

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

0.28CAD

Stock On Hand

0

CAD - CAD - CAD -

IOC

EXISTING MIN

IOC

EXISTING MAX

0 0

Recommended MIN_MAX

Lead Time Ranking

Unit Cost Ranking

S

N

L

NO STOCK SUGGESTED,

EXISTING MIN-MAX RETAINED

CAD - CAD -

Movement Type

Ranking

SKF MIN SKF MAX

0 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%

Percentile

Normal Distribution- Curve

Service Level

90%

Risk of aStockOut 10%

$0.0

0

0.1

0.2

0.3

0.4

0.5

0.6

0.7

0.8

0.9

1

0 50 100 150 200 250 300 350

Cost($)

Order Quantity

EOQ ModelEOQTotal Holding CostTotal Ordering CostTotal Cost

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

1

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00

0.2

0.4

0.6

0.8

1

1.2

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

000004349

68%

95%