Inventory health
Inventory value1,157,628
COGS (12 mo)9,854,364
Turnover7.6x
Days of inventory43
Excess (> 6 mo cover)45,007
Aging by days since last issue
| Bucket | SKUs | Value at risk |
|---|---|---|
| 0-90 days | 226 | 1,106,952 |
| 91-180 days | 3 | 7,913 |
| 181-365 days | 2 | 1,089 |
| 365+ days / never | 11 | 41,674 |
Near-expiry stock FEFO: issue earliest expiry first
| SKU | Received | Qty | Expiry | Status |
|---|---|---|---|---|
| CSM-0002 | May 19, 2025 | 9 | Feb. 13, 2026 (-245d) | expired |
| CSM-0006 | Jan. 21, 2026 | 15 | Oct. 18, 2026 (2d) | near expiry - issue first |
| CSM-0007 | Oct. 29, 2025 | 10 | July 26, 2026 (-82d) | expired |
| CSM-0008 | Feb. 21, 2026 | 4 | Nov. 18, 2026 (33d) | near expiry - issue first |
Non-moving stock no issue for 180+ days
| SKU | Name | Qty | Value | Days since issue | Bucket | NRV |
|---|---|---|---|---|---|---|
| FAN-0028 | Ceiling Fan 1200mm Flex | 75 | 17,392 | 503 | 365+ days / never | 118.7034 |
| FAN-0030 | Ceiling Fan 1200mm Prime | 21 | 5,265 | 504 | 365+ days / never | 187.8042 |
| SWT-0002 | Bell Push Plus | 125 | 4,249 | 534 | 365+ days / never | 24.8185 |
| CAB-0028 | Flexible Cable 3 core Flex | 11 | 3,682 | 456 | 365+ days / never | 138.5735 |
| SWT-0020 | Switch Plate 4M Max | 251 | 2,889 | 474 | 365+ days / never | 8.1728 |
| LED-0033 | Downlight 7W Nova | 40 | 2,775 | 535 | 365+ days / never | 48.4656 |
| CON-0013 | PVC Conduit 20mm Max | 69 | 1,840 | 412 | 365+ days / never | 14.7535 |
| CON-0024 | Bend 20mm Classic | 45 | 1,316 | 503 | 365+ days / never | 19.5621 |
| MCB-0019 | MCB 32A TP Lite | 35 | 1,142 | 483 | 365+ days / never | 23.0030 |
| SWT-0025 | Switch Plate 4M Flex | 152 | 744 | 536 | 365+ days / never | 2.5897 |
| IND-0007 | Timer Relay Classic | 1 | 682 | 281 | 181-365 days | |
| CSM-0006 | Cable Lubricant Nova | 15 | 407 | 189 | 181-365 days | |
| LED-0037 | Panel Light 15W Prime | 65 | 379 | 454 | 365+ days / never | 3.2841 |
Excess stock top 25 by value
| SKU | Name | On hand | Monthly demand | Months cover | Excess qty | Excess value |
|---|---|---|---|---|---|---|
| FAN-0028 | Ceiling Fan 1200mm Flex | 75 | 0.0 | - | 75 | 17,392 |
| FAN-0030 | Ceiling Fan 1200mm Prime | 21 | 0.0 | - | 21 | 5,265 |
| SWT-0002 | Bell Push Plus | 125 | 0.0 | - | 125 | 4,249 |
| CAB-0028 | Flexible Cable 3 core Flex | 11 | 0.0 | - | 11 | 3,682 |
| SWT-0020 | Switch Plate 4M Max | 251 | 0.0 | - | 251 | 2,889 |
| LED-0033 | Downlight 7W Nova | 40 | 0.0 | - | 40 | 2,775 |
| CON-0013 | PVC Conduit 20mm Max | 69 | 0.0 | - | 69 | 1,840 |
| IND-0002 | Contactor 25A Eco | 7 | 0.6 | 12.0 | 4 | 1,572 |
| CON-0024 | Bend 20mm Classic | 45 | 0.0 | - | 45 | 1,316 |
| MCB-0019 | MCB 32A TP Lite | 35 | 0.0 | - | 35 | 1,142 |
| IND-0010 | Proximity Sensor Eco | 5 | 0.4 | 12.0 | 2 | 773 |
| SWT-0025 | Switch Plate 4M Flex | 152 | 0.0 | - | 152 | 744 |
| IND-0006 | Timer Relay Plus | 3 | 0.1 | 36.0 | 2 | 399 |
| LED-0037 | Panel Light 15W Prime | 65 | 0.0 | - | 65 | 379 |
| CSM-0004 | Contact Cleaner Spray Prime | 21 | 2.3 | 9.0 | 7 | 248 |
| CSM-0006 | Cable Lubricant Nova | 15 | 1.0 | 15.0 | 9 | 244 |
| CSM-0002 | Contact Cleaner Spray Lite | 9 | 0.5 | 18.0 | 6 | 79 |
| CSM-0007 | Solder Paste Eco | 10 | 1.4 | 7.1 | 2 | 17 |
Stockout days, last 12 months top 25
| SKU | Name | ABC | Days at zero stock |
|---|---|---|---|
| FAN-0020 | Ceiling Fan 1200mm Pro | B | 38 |
| IND-0014 | Proximity Sensor Flex | C | 38 |
| FAN-0016 | Wall Fan 400mm Max | B | 33 |
| FAN-0004 | Table Fan 300mm Nova | A | 31 |
| MCB-0003 | Isolator 63A Eco | A | 29 |
| FAN-0024 | Decorative Ceiling Fan Lite | A | 28 |
| MCB-0017 | Distribution Board 8-way Prime | C | 28 |
| CAB-0027 | FR Wire 4 sqmm Max | A | 27 |
| MCB-0006 | RCCB 40A Elite | B | 27 |
| CAB-0023 | Cat6 Cable Classic | C | 26 |
| FAN-0006 | Decorative Ceiling Fan Pro | B | 25 |
| MCB-0002 | RCCB 40A Elite | B | 25 |
| CAB-0026 | FR Wire 2.5 sqmm Classic | A | 24 |
| CAB-0030 | FR Wire 2.5 sqmm Elite | A | 24 |
| FAN-0009 | Decorative Ceiling Fan Flex | A | 24 |
| CAB-0004 | FR Wire 2.5 sqmm Prime | A | 23 |
| FAN-0002 | Wall Fan 400mm Pro | A | 23 |
| FAN-0005 | Ceiling Fan 1200mm Plus | B | 23 |
| MCB-0014 | MCB 16A DP Flex | C | 23 |
| CAB-0016 | FR Wire 4 sqmm Prime | A | 22 |
| FAN-0010 | Decorative Ceiling Fan Pro | B | 22 |
| FAN-0015 | Ceiling Fan 1400mm Eco | A | 22 |
| IND-0005 | Contactor 25A Elite | B | 22 |
| CAB-0018 | FR Wire 4 sqmm Elite | A | 21 |
| CAB-0029 | FR Wire 2.5 sqmm Plus | B | 21 |