| ← Back to Dashboard |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ABC CLASSIFICATION
ANALYSIS |
|
|
|
|
|
|
|
|
|
Pareto-based
classification by annual usage value (80/95/100 rule) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
SKU ID |
Product Name |
Category |
Unit Cost ($) |
Annual Demand |
Annual Usage
Value ($) |
% of Total
Value |
Cumulative % |
ABC Class |
Service Level |
|
SKU-005 |
Steel Plate 4x8
1/4in |
Raw Materials |
$180.00 |
3,500 |
$630,000 |
11.2% |
11.2% |
A |
99.0% |
|
SKU-002 |
Hydraulic Cylinder
HC-200 |
Hydraulics |
$450.00 |
1,200 |
$540,000 |
9.6% |
20.9% |
A |
99.0% |
|
SKU-004 |
Electric Motor 5HP |
Motors |
$890.00 |
600 |
$534,000 |
9.5% |
30.4% |
A |
99.0% |
|
SKU-012 |
Stainless Pipe 2in
Sch40 |
Raw Materials |
$95.00 |
4,200 |
$399,000 |
7.1% |
37.5% |
A |
99.0% |
|
SKU-013 |
Industrial Gearbox
RV-40 |
Power Trans |
$1,800.00 |
200 |
$360,000 |
6.4% |
43.9% |
A |
99.0% |
|
SKU-008 |
Pneumatic Valve
1/2in |
Pneumatics |
$65.00 |
5,500 |
$357,500 |
6.4% |
50.3% |
A |
99.0% |
|
SKU-006 |
PLC Controller
S7-1500 |
Electronics |
$2,200.00 |
150 |
$330,000 |
5.9% |
56.2% |
A |
99.0% |
|
SKU-007 |
Welding Wire ER70S-6 |
Consumables |
$35.00 |
8,000 |
$280,000 |
5.0% |
61.2% |
A |
99.0% |
|
SKU-007 |
Welding Wire ER70S-6 |
Consumables |
$35.00 |
8,000 |
$280,000 |
5.0% |
66.2% |
A |
99.0% |
|
SKU-016 |
CNC Spindle Motor
15kW |
Motors |
$4,800.00 |
50 |
$240,000 |
4.3% |
70.5% |
A |
99.0% |
|
SKU-003 |
Ball Bearing
6205-2RS |
Bearings |
$12.00 |
18,000 |
$216,000 |
3.9% |
74.3% |
A |
99.0% |
|
SKU-003 |
Ball Bearing
6205-2RS |
Bearings |
$12.00 |
18,000 |
$216,000 |
3.9% |
78.2% |
A |
99.0% |
|
SKU-010 |
Rubber O-Ring Kit |
Seals |
$8.00 |
25,000 |
$200,000 |
3.6% |
81.8% |
B |
95.0% |
|
SKU-017 |
Cable Tray 12x4
(10ft) |
Electrical |
$28.00 |
6,500 |
$182,000 |
3.2% |
85.0% |
B |
95.0% |
|
SKU-020 |
VFD Drive 10HP |
Electronics |
$1,500.00 |
120 |
$180,000 |
3.2% |
88.2% |
B |
95.0% |
|
SKU-014 |
Safety Gloves (pair) |
PPE |
$4.50 |
36,000 |
$162,000 |
2.9% |
91.1% |
B |
95.0% |
|
SKU-015 |
Lubricant ISO VG 68
(20L) |
Consumables |
$55.00 |
2,400 |
$132,000 |
2.4% |
93.5% |
B |
95.0% |
|
SKU-011 |
Conveyor Belt 24in |
Conveyors |
$320.00 |
400 |
$128,000 |
2.3% |
95.7% |
C |
90.0% |
|
SKU-018 |
Thermal Sensor PT100 |
Instrumentation |
$42.00 |
3,000 |
$126,000 |
2.2% |
98.0% |
C |
90.0% |
|
SKU-001 |
Titanium Bolt M8x50 |
Fasteners |
$2.50 |
45,000 |
$112,500 |
2.0% |
100.0% |
C |
90.0% |
|
|
|
|
|
|
|
|
|
|
|
|
ABC CLASSIFICATION
SUMMARY |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Class |
SKU Count |
% of SKUs |
Total Value ($) |
% of Total Value |
Avg Unit Cost ($) |
|
|
|
|
|
A - Critical |
12 |
60.0% |
$4,382,500 |
78.2% |
$65.02 |
|
|
|
|
|
B - Important |
5 |
25.0% |
$856,000 |
15.3% |
$12.23 |
|
|
|
|
|
C - Standard |
3 |
15.0% |
$366,500 |
6.5% |
$7.57 |
|
|
|
|
|
Total |
20 |
100.0% |
$5,605,000 |
100.0% |
$30.16 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Note: ABC thresholds are
configurable in the Assumptions sheet. Items sorted by descending annual
usage value. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|