INVENTORY STATUS REPORT

Report Date: March 19, 2025
Generated By: John Doe
Report ID: INV-RPT-2025-0319
Warehouses: All
Categories: All
Status: Below Minimum

Critical Items

15
Items at or below 50% of min level

Warning Items

27
Items between 51-99% of min level

Total Below Min

42
Total items below minimum level

Above Maximum

29
Items exceeding maximum level
Items Below Minimum Level
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 Summary
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