Inventory Holding Cost and Obsolescence Control Dashboard
Track excess, aging, and slow-moving inventory to reduce holding costs, write-offs, and working capital tied up in stock.
Inactive Inventory Item Count
Counted 1 distinct inactive item_id at the latest inventory snapshot anchored by MAX(last_updated).
Average Inventory Age (Days)
Calculated at the latest inventory snapshot using quantity-weighted inventory_age_days across all items with positive stock on hand.
Items Below Safety Stock Count
Computed from distinct item_id records at the latest snapshot (MAX last_updated), identifying 1 SKU with aggregated quantity_on_hand below its safety_stock threshold.
Active Inventory Item Count
Based on 20 distinct active item_id records at the latest inventory snapshot (MAX last_updated).
Inventory Value by Category
Finished goods hold the highest inventory value at AED 21.97M, representing the largest concentration of tied-up capital.
Spare (AED 14.59M) and Packaging (AED 13.40M) categories together account for over AED 27.9M, exceeding the value of Finished goods alone.
Raw materials inventory is comparatively low at AED 4.30M, suggesting capital exposure is significantly heavier in downstream categories such as Finished and Semi-Finished goods.
Excess Inventory Value by Category
Finished goods contribute the highest excess inventory value at AED 108.07M, representing the largest opportunity to reduce working capital.
Spare (AED 79.71M) and Packaging (AED 69.11M) categories together account for over AED 148.8M in excess stock, exceeding the combined excess of Semi-Finished and Raw categories.
Even Raw materials show AED 13.12M in excess value, indicating overstock risk across the entire supply chain, not just finished goods.
Inventory Age Distribution
Inventory aged 180+ days represents the largest concentration at AED 38.91M, indicating significant capital tied up in slow-moving stock.
Inventory aged 0–30 days totals AED 20.86M, which is substantially lower than the 180+ days bucket, signaling an imbalance toward older inventory.
The absence of material value in the 31–90 days bucket and AED 4.46M in the 91–180 days range suggests inventory is either very new or already aging beyond 90 days, increasing obsolescence risk.