( REPL ) Inventory Ageing Dashboard

Stock ageing & blocked-capital overview · source: Inventory Ageing Summary

44 SKUs · Healthy stock ₹3.12 L
Total inventory value
₹31.53 L
₹31,53,274
Blocked capital >60d
₹28.41 L
₹28,40,836
Inventory risk
90.1%
Share of value in >60-day stock
Units blocked >60d
440
₹3.12 L also in 31–60d bucket

Blocked capital by risk tier

>60-day value
  • Critical(2 SKU)₹9.46 L 33.3%
  • High(1 SKU)₹82.1 K 2.9%
  • Medium(12 SKU)₹3.21 L 11.3%
  • Low(26 SKU)₹71.2 K 2.5%
  • Healthy(3 SKU)₹14.20 L 50.0%

Blocked capital by line of business

>60-day value

Ageing buckets by line of business

31–60d vs >60d

Cost of holding

Interest @ 18% p.a.
Accumulated to date
₹1.35 L
₹1,34,867
Monthly drain
₹47.3 K
₹47,299 / month
Annualised drain
₹5.68 L
₹5,67,589

SKU detail

44 of 44 SKUs · sorted by Blocked >60d (desc)

ItemLOBQty >60dBlocked >60dHolding costRiskAction
GRAND TOTAL
Rate ₹0
nan220₹14,20,418₹67,434HealthyKeep
Microsoft Surface 7th Edition Copilot+ PC for Business - 13.8" Touchscreen - Intel Core Ultra 5 - 32 GB RAM - 512 GB SSD Black
Rate ₹1.80 L
Laptop5₹8,45,000₹38,025CriticalLiquidate
Samsung Portable SSD T7 1TB
Rate ₹7.9 K
Accessories6₹1,01,400₹4,563CriticalLiquidate
13-inch MacBook Air: Apple M3 chip with 8-core CPU and 10-core GPU, 16GB, 512GB SSD - Midnight
Rate ₹1.16 L
Mac1₹82,146₹3,697HighLiquidate
Neopack Defender Case for iPad 6th gen - Black
Rate ₹1
Cover49₹48,020₹2,161MediumBundle
Dell 24 Inch IPS / FHD / HDMI / DP / VGA / Monitor.
Rate ₹1
Display4₹40,800₹1,836MediumLiquidate
11-inch iPad Wi-Fi + Cellular 128GB - Pink
Rate ₹38.5 K
iPad1₹38,482₹1,732MediumReturn to Supplier
10.2-inch iPad Wi-Fi 256GB - Space Grey
Rate ₹37.7 K
iPad1₹36,940₹1,662MediumReturn to Supplier
Alogic Universal Triple 4K Docking Station With 100W Power Delivery -Prime DX3 Dock
Rate ₹19.1 K
Accessories2₹30,000₹1,350MediumReturn to Supplier
2TB HDD WD USB PASSPORT 2.5
Rate ₹6.5 K
Other4₹28,400₹1,278MediumDiscount
10.9-inch iPad Wi-Fi 64GB - Blue
Rate ₹34.6 K
iPad1₹23,058₹1,038MediumDiscount
AirPods Pro 3
Rate ₹20.8 K
Apple Accessories1₹19,407₹873MediumDiscount
STM DUX PLUS DUO 7-9 GEN
Rate ₹1.4 K
Cover14₹18,900₹851MediumBundle
Lenovo Tab K11 27.94cms (11) 8GB 128GB - Luna Grey
Rate ₹16.8 K
Tablet1₹14,195₹639MediumDiscount
LAPTOP STAND
Rate ₹230
Other50₹11,500₹518MediumBundle
HP CHROMEBOOK MT 7D2W1PC 8183/4GB/32GB/11"
Rate ₹11.0 K
Laptop1₹11,000₹495MediumDiscount
Apple 12W USB Power Adapter N
Rate ₹1.1 K
Apple Accessories7₹8,735₹393LowDiscount
Lenovo Tab M8 (4th Gen) 20.32cms (8) 4GB 64GB - Arctic Grey
Rate ₹8.8 K
Tablet1₹7,415₹334LowDiscount
Cover - Black
Rate ₹375
Cover19₹7,125₹321LowBundle
Lightning to 3.5 mm Headphone Jack Adapter
Rate ₹591
Apple Accessories9₹5,320₹239LowDiscount
Cadyce USB-CTM to USB 3.0 Hub, Gigabit Ethernet, HDMI (4k) & VGA Adapter with PD Charging (100W)
Rate ₹1
Accessories1₹4,350₹196LowKeep
LOGITECH Full HD 1080p webcam with auto-light balance, integrated privacy shutter, and built-in mic.
Rate ₹1
Unclassified2₹4,300₹194LowKeep
EarPods with 3.5.mm Headphone Plug
Rate ₹1.6 K
Apple Accessories2₹3,242₹146LowKeep
Neopack Bumper Sleeve for Macbook Air 13.3" - Midnight
Rate ₹1.5 K
Sleeve2₹3,041₹137LowKeep
Neopack C2C Cable 60W 1.5M - Space Grey
Rate ₹339
Accessories8₹2,708₹122LowDiscount
STM Dux Plus Duo for iPad 10.2 inch Black
Rate ₹1.5 K
Cover2₹2,700₹122LowKeep
Neopack Swivo Rotaty Case for iPad 10.2" - 7th/8th & 9th Gen
Rate ₹1.3 K
Cover2₹2,541₹114LowKeep
Neopack Cube 25W Type C Adapter - White
Rate ₹350
Accessories6₹2,540₹114LowDiscount
Honeywell Type C Gigabit Ethernet Adapter HC000006/ADP/BLK Laptop Accessory, USB Cable, USB Hub (Black)
Rate ₹1.5 K
Other2₹2,500₹113LowKeep
External MicroSD card price class 10 128GB
Rate ₹780
Other3₹2,340₹105LowKeep
Neopack Bumper Sleeve for Macbook Air 13.3" - Stone Grey
Rate ₹1.5 K
Sleeve1₹1,520₹68LowKeep
Neopack iShield Hard Shell Case for Macbook Air 13.3" (MQD32HN/A) - Crystal Clear
Rate ₹1.5 K
Cover1₹1,520₹68LowKeep
Lenovo Essential Wireless Combo Keyboard & Mouse Gen2 Black USEnglish 103P
Rate ₹1.4 K
Accessories1₹1,400₹63LowKeep
Neopack ishield Matt Edition Hard Shell Case for Macbook Pro 13" (M1 & M2 SERIES )
Rate ₹1.3 K
Cover1₹1,267₹57LowKeep
Neopack Svelte Sleeve - 4GY13_Grey
Rate ₹1.2 K
Sleeve1₹1,186₹53LowKeep
STM GAMECHANGE BRIEF BLACK
Rate ₹1.2 K
BAG1₹1,161₹52LowKeep
60W USB-C Charge Cable (1m)
Rate ₹1.6 K
Apple Accessories1₹1,059₹48LowKeep
USB-C® Male to USB 3.0 A Type Female Adapter
Rate ₹500
Accessories2₹1,000₹45LowKeep
Neopack Defender Case V2 for iPad A16- Bright Blue
Rate ₹1.3 K
Cover1₹950₹43LowKeep
TABLET COVER IP 10.2
Rate ₹500
Cover1₹500₹23LowKeep
CADYCE USB C 3.0 A TYPE FEMALE CABLE
Rate ₹400
Accessories1₹400₹18LowKeep
Ipad Cover
Rate ₹1
Cover1₹350₹16LowKeep
iPhone 17 256GB White
Rate ₹65.3 K
iPhone0₹0₹2,988HealthyKeep
Magic Keyboard for iPad Pro 11‑inch (M4) - US English - Black
Rate ₹23.1 K
Apple Accessories0₹0₹527HealthyKeep

Management insights

Diagnosis & corrective plan
  • Capital lock-up is severe

    ₹28.41 L (90.1% of total inventory) is held in stock older than 60 days across 440 units.

  • nan drives the largest ageing pocket

    ₹14.20 L blocked in 1 SKUs — 50% of all ageing value. Prioritise this category for clearance.

  • Premium Mac configs dominate risk

    Top-4 SKUs (16" and 14" MacBook Pro Max configurations) account for the bulk of >60-day blockage. Liquidate via channel partners or B2B bundles.

  • Holding cost is bleeding the P&L

    ₹1.35 L carrying cost accumulated · ₹47.3 K/month ongoing drain (₹5.68 L annualised at 18% p.a.).

  • Tighten future procurement

    Cap premium-config Mac purchases until existing stock clears. Move accessories to demand-led replenishment instead of bulk orders.