| SKU | Item Description | Category | Warehouse | Min Level | Current Stock | Max Level | % of Min | Status | PO Status | Expected Delivery | Last Issued |
|---|---|---|---|---|---|---|---|---|---|---|---|
| INV-10584 | 3-inch Gate Valve | Valves | North | 25 | 12 | 100 | 48% | Critical | In Transit | Mar 20, 2025 | Mar 15, 2025 |
| INV-10832 | Gasket 4-inch 150# | Gaskets | East | 50 | 26 | 200 | 52% | Warning | PO Issued | Mar 22, 2025 | Mar 14, 2025 |
| INV-11023 | Pressure Gauge 0-100 PSI | Instrumentation | North | 15 | 0 | 50 | 0% | Critical | None | - | Mar 12, 2025 |
| INV-10456 | 1/2-inch Ball Valve | Valves | South | 40 | 18 | 120 | 45% | Critical | PR Pending | - | Mar 10, 2025 |
| INV-10683 | Safety Glasses | PPE | South | 100 | 85 | 500 | 85% | Warning | None | - | Mar 16, 2025 |
| INV-10721 | Hard Hat - Yellow | PPE | North | 50 | 32 | 150 | 64% | Warning | None | - | Mar 14, 2025 |
| INV-10892 | 2-inch Check Valve | Valves | East | 20 | 8 | 60 | 40% | Critical | PO Issued | Mar 25, 2025 | Mar 11, 2025 |
| INV-10945 | Fire Extinguisher - 10lb | Safety | North | 30 | 14 | 60 | 47% | Critical | In Transit | Mar 21, 2025 | Mar 09, 2025 |
| INV-11078 | Hydraulic Oil - 5 Gal | Fluids | South | 25 | 16 | 75 | 64% | Warning | PR Pending | - | Mar 13, 2025 |
| INV-10512 | Welding Gloves | PPE | East | 40 | 28 | 120 | 70% | Warning | None | - | Mar 15, 2025 |
| Category | Total SKUs | Critical Items | Warning Items | Total Below Min | PO Issued | PR Pending | No Action |
|---|---|---|---|---|---|---|---|
| Valves | 125 | 8 | 7 | 15 | 6 | 3 | 6 |
| Gaskets | 85 | 2 | 4 | 6 | 3 | 1 | 2 |
| PPE | 210 | 1 | 9 | 10 | 2 | 0 | 8 |
| Instrumentation | 95 | 2 | 3 | 5 | 2 | 1 | 2 |
| Safety | 75 | 2 | 2 | 4 | 2 | 0 | 2 |
| Fluids | 60 | 0 | 2 | 2 | 0 | 1 | 1 |