| ← Back to Dashboard |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
SAFETY STOCK &
REORDER POINT ANALYSIS |
|
|
|
|
|
|
|
|
|
|
|
|
SS = Z × √(LT ×
σd² + d² × σLT²) | ROP = (d × LT) + SS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
SKU ID |
Product Name |
ABC Class |
Avg Daily
Demand |
Demand Std Dev |
Lead Time (days) |
LT Std Dev
(days) |
Z-Score |
Safety Stock
(units) |
Reorder Point
(units) |
Current Stock |
Stock Status |
Days of Supply |
SS Value ($) |
|
SKU-001 |
Titanium Bolt M8x50 |
C |
178.6 |
26.8 |
5 |
1 |
1.28 |
242 |
1,135 |
8,500 |
OK |
47.6 |
$605 |
|
SKU-002 |
Hydraulic Cylinder
HC-200 |
A |
4.8 |
0.7 |
14 |
3 |
2.33 |
34 |
101 |
85 |
LOW |
17.9 |
$15,300 |
|
SKU-003 |
Ball Bearing
6205-2RS |
A |
71.4 |
10.7 |
7 |
2 |
2.33 |
340 |
840 |
3,200 |
OK |
44.8 |
$4,080 |
|
SKU-004 |
Electric Motor 5HP |
A |
2.4 |
0.4 |
21 |
5 |
2.33 |
28 |
78 |
42 |
LOW |
17.6 |
$24,920 |
|
SKU-005 |
Steel Plate 4x8
1/4in |
A |
13.9 |
2.1 |
10 |
3 |
2.33 |
99 |
238 |
280 |
LOW |
20.2 |
$17,820 |
|
SKU-006 |
PLC Controller
S7-1500 |
A |
0.6 |
0.1 |
28 |
7 |
2.33 |
10 |
27 |
12 |
LOW |
20.2 |
$22,000 |
|
SKU-007 |
Welding Wire ER70S-6 |
A |
31.7 |
4.8 |
5 |
1 |
2.33 |
79 |
238 |
1,800 |
OK |
56.7 |
$2,765 |
|
SKU-008 |
Pneumatic Valve
1/2in |
A |
21.8 |
3.3 |
10 |
2 |
2.33 |
105 |
324 |
920 |
OK |
42.2 |
$6,825 |
|
SKU-009 |
Servo Drive ACS580 |
C |
0.3 |
0.0 |
35 |
8 |
1.28 |
4 |
16 |
6 |
LOW |
18.9 |
$14,000 |
|
SKU-010 |
Rubber O-Ring Kit |
B |
99.2 |
14.9 |
5 |
1 |
1.65 |
173 |
670 |
5,500 |
OK |
55.4 |
$1,384 |
|
SKU-011 |
Conveyor Belt 24in |
C |
1.6 |
0.2 |
18 |
4 |
1.28 |
9 |
38 |
35 |
LOW |
22.1 |
$2,880 |
|
SKU-012 |
Stainless Pipe 2in
Sch40 |
A |
16.7 |
2.5 |
7 |
2 |
2.33 |
80 |
197 |
650 |
OK |
39.0 |
$7,600 |
|
SKU-013 |
Industrial Gearbox
RV-40 |
A |
0.8 |
0.1 |
25 |
6 |
2.33 |
12 |
32 |
15 |
LOW |
18.9 |
$21,600 |
|
SKU-014 |
Safety Gloves (pair) |
B |
142.9 |
21.4 |
5 |
1 |
1.65 |
249 |
964 |
7,200 |
OK |
50.4 |
$1,121 |
|
SKU-015 |
Lubricant ISO VG 68
(20L) |
B |
9.5 |
1.4 |
7 |
2 |
1.65 |
33 |
100 |
380 |
OK |
39.9 |
$1,815 |
|
SKU-016 |
CNC Spindle Motor
15kW |
A |
0.2 |
0.0 |
42 |
10 |
2.33 |
5 |
14 |
4 |
REORDER NOW |
20.2 |
$24,000 |
|
SKU-017 |
Cable Tray 12x4
(10ft) |
B |
25.8 |
3.9 |
7 |
2 |
1.65 |
87 |
268 |
1,100 |
OK |
42.6 |
$2,436 |
|
SKU-018 |
Thermal Sensor PT100 |
C |
11.9 |
1.8 |
10 |
3 |
1.28 |
47 |
167 |
480 |
OK |
40.3 |
$1,974 |
|
SKU-019 |
Air Filter Element
AF-250 |
C |
47.6 |
7.1 |
7 |
2 |
1.28 |
125 |
459 |
2,400 |
OK |
50.4 |
$2,250 |
|
SKU-020 |
VFD Drive 10HP |
B |
0.5 |
0.1 |
21 |
5 |
1.65 |
4 |
14 |
9 |
LOW |
18.9 |
$6,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
TOTALS / AVERAGES |
|
|
|
|
|
|
|
1,765 |
5,920 |
32,618 |
|
34.2 |
$181,375 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
KEY METRICS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Items Requiring Reorder: |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
Items with Low Stock: |
8 |
|
|
|
|
|
|
|
|
|
|
|
|
Items OK: |
|
11 |
|
|
|
|
|
|
|
|
|
|
|
|
Total Safety Stock
Investment: |
$181,375 |
|
|
|
|
|
|
|
|
|
|
|
|
Average Days of Supply: |
34.2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Note: Safety stock uses
combined demand and lead time variability. Status flags trigger at reorder
point and 120% of ROP. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|