Spare Parts & MRO Inventory Readiness

Titan Steel Rolling · 3 Mills · 1,800 Active MRO SKUs

Parts Availability

88%

-3% vs target

Critical Spare Coverage

91%

-4% vs 95% goal

Stockout Rate

↑ vs 5% target

Emergency POs/mo

-12% MoM

Mean Parts Delay

5.2h

per delayed WO

Downtime Cost

$94K

parts shortage MTD

SKU Readiness by Site (Critical A-Class Parts)

Mill 1

Mill 2

Mill 3

Hydraulic Pumps

98%

74%

92%

Bearing Sets

91%

85%

96%

Motor Starters

100%

94%

Seal Kits

93%

79%

88%

Sensors/Switches

86%

90%

92%

Belts & Couplings

97%

91%

95%

Mill 2 hydraulic pump seal kit stockout drove 52h cumulative delay

Stockout Rate by ABC Classification

Emergency Purchase Orders (12 weeks)

Top 10 SKUs Causing Work Order Delays

SKU	Description	Class	Site	Stockouts (90d)	Cumulative Delay (h)	Cost Impact
HYD-2847	Hydraulic Pump Seal Kit	A	Mill 2	4	52	$28,600
BRG-1923	Rolling Mill Bearing Set	A	Mill 1	3	38	$19,400
MTR-5501	AC Motor Starter 480V	B	Mill 3	5	29	$14,200
SNS-3342	Proximity Sensor 24VDC	B	Mill 2	6	24	$11,800
HYD-4712	Hydraulic Hose Assembly	A	Mill 1	2	22	$10,500
BLT-8834	V-Belt Drive Set	C	Mill 3	7	18	$6,300
FLT-2291	Oil Filter Element	B	Mill 2	4	16	$5,900
VLV-6623	Pneumatic Control Valve	A	Mill 1	2	14	$5,400
CPL-9012	Shaft Coupling Assembly	B	Mill 3	3	12	$4,200
SWT-7745	Limit Switch DPDT	C	Mill 2	5	10	$3,100

Forecast Accuracy vs Stockout Rate

Each point = one SKU category; size = total usage volume

Inventory Carrying Cost Distribution

Obsolete stock post-retrofit: $340K

Supplier Lead-Time Adherence (12 weeks)

Week 6 bearing supplier delay: +8 days vs committed lead time