Needs attention
4
2 critical · 2 warning
Open Backorders
3
33 units awaiting stock
Below Bench Level
6
of 643 SKUs
Incoming POs
4
1 overdue
Open Sales Orders
5
across 5 customers
Exceptions
What needs attention
Critical2" 150# 316SS Flange below Bench Level
Available 3 against Bench Level 15. Backorder BO-0087 awaiting PO-2024-089, expected Aug 18.
WarningPO-2024-087 overdue — Pacific Fittings Supply
3" 90° 316SS Elbow (20 units) expected Aug 4. Supplier delay reported, new ETA not confirmed.
Warning2"×1.5" 316SS Reducer out of stock
On Hand 0 with 8 units backordered on SO-2024-0141. Incoming 15 on PO-2024-090, expected Aug 26.
Warning1" 316SS Hex Nipple critically low
Available 5 against Bench Level 40. Incoming 50 on PO-2024-090, expected Aug 26.
Inventory at risk
Available below Bench Level
| SKU / Product | On Hand | Allocated | Available | Bench | Incoming | Status |
|---|---|---|---|---|---|---|
| SS-2RED-C316 2"×1.5" 316SS Reducer | 0 | 0 | 0 | 10 | +15 | Out of Stock |
| SS-1HEX-N316 1" 316SS Hex Nipple | 5 | 0 | 5 | 40 | +50 | Critical |
| SS-2FLG-L150 2" 150# 316SS Flange | 8 | 5 | 3 | 15 | +25 | Critical |
| SS-3FLG-L300 3" 300# 316SS Flange | 7 | 2 | 5 | 8 | — | Low Stock |
| SS-3ELB-90316 3" 90° 316SS Elbow | 12 | 0 | 12 | 15 | +20 | Low Stock |
| SS-4ELB-45316 4" 45° 316SS Elbow | 22 | 8 | 14 | 15 | — | Low Stock |
Incoming
Purchase Orders
PO-2024-087Overdue
Pacific Fittings Supply · 3" 90° 316SS Elbow · 20 units
Expected Aug 3, 2026 · new ETA pending
PO-2024-089In Transit
Pacific Fittings Supply · 2" 150# 316SS Flange · 25 units
Expected Aug 18, 2026
PO-2024-090Confirmed
Gulf Alloy Partners · 3 SKUs · 73 units
Expected Aug 26, 2026
PO-2024-091Confirmed
Northline Copper Co. · 1/2" 90° Sweat Elbow · 200 units
Expected Sep 2, 2026
PO-2024-092Confirmed
Pacific Fittings Supply · 4" NPT 316SS Coupling · 25 units
Expected Feb 15, 2027
Unfulfillable demand
Open Backorders
Central Technical Supply8 short
Expected Aug 24, 2026 · PO-2024-090
Harbor Industries LLC15 short
Expected Aug 26, 2026 · PO-2024-090
Customer demand
Open Sales Orders
| Order | Customer | Required | Value | Status |
|---|---|---|---|---|
| SO-2024-0142 | Midwest Mechanical | Aug 19, 2026 | $1,580.00 | Partial |
| SO-2024-0141 | Central Technical Supply | Aug 24, 2026 | $248.00 | Partial |
| SO-2024-0140 | Apex Mechanical Contractors | Aug 21, 2026 | $3,420.00 | Allocated |
| SO-2024-0139 | Harbor Industries LLC | Aug 27, 2026 | $962.00 | Partial |
| SO-2024-0138 | Tri-State Piping Co. | Sep 1, 2026 | $5,110.00 | Allocated |