05PlanAI · Lumora Consumer ProductsDemo Data

Inventory Intelligence

Balance service, working capital and shelf life across raw, packaging and finished goods.

Intelli AI Inventory Summary

PureGlow Fresh Soap wrapper inventory is projected 42% above 13-week requirement following artwork transition. PureGlow Soap 100g carries ~31 days excess cover.

Liquid SKUs dependent on Surfactant Base hold only 6 days network cover — buffers deplete in W5–6 without action.

Inventory health matrix

X: days of cover · Y: demand velocity · bubble: inventory value

Shortage RiskHealthyExcessSlow MovingObsolete Risk

Excess & obsolescence

AI-identified

Superseded Packaging
PureGlow Fresh Soap wrapper +42% vs 13-wk requirement
$118K
Potential Excess
PureGlow Soap 100g — 31 days excess
$410K
Slow Moving
Veluna Hand Cream 50ml Tube
$64K
Expiry Risk
12 FG batches < 20% shelf life
$92K
Launch Write-Off Risk
Lumora Botanical labels pre-printed
$38K

Inventory projection — Lumora Silk Shampoo 360ml

13-week finished goods projection from the live plan

LineW1W2W3W4W5W6W7W8W9W10W11W12W13
Opening Inventory2.0K2.0K2.0K2.0K2.0K00000000
Receipts / Production102K101K101K104K64.5K124K132K125K112K112K113K114K115K
Demand102K101K101K104K122K124K132K125K112K112K113K114K115K
Transfers0000000000000
Closing Inventory2.0K2.0K2.0K2.0K000000000
Safety Stock40.8K40.8K40.8K40.8K40.8K40.8K40.8K40.8K40.8K40.8K40.8K40.8K40.8K
Shipped102K101K101K104K66.6K124K132K125K112K112K113K114K115K
Projected Cover (days)0.10.10.10.10.00.00.00.00.00.00.00.00.0
Fill rate100%100%100%100%54%100%100%100%100%100%100%100%100%

Shelf-life management

Finished goods batches with < 20% remaining shelf life

BatchSKUDCMfg dateExpiryRemainingQtyMarket req.RiskRecommendation
L731400TinyBloom Baby Wash 750ml PumpCentral DCD-640730d90d111.3KMediumConsume First
L791100TinyBloom Baby Shampoo 750ml PumpCentral DCD-640730d90d171.1KMediumTransfer
L180100Lumora Smooth Conditioner 180mlWest DCD-639730d91d1919.5KMediumReallocate
L190400Lumora Smooth Conditioner 360mlWest DCD-639730d91d1569.7KMediumReduce Production
L211500Lumora Smooth Conditioner 90ml TravelCentral DCD-639730d91d402.1KMediumPromotion
L413100PureGlow Body Wash 250mlSouth DCD-639730d91d649.8KMediumConsume First
L562400Veluna Hand Cream 50ml TubeNorth DCD-639730d91d251.6KMediumTransfer
L516000Lumora Silk Shampoo 1L Refill PouchCentral DCD-638730d92d502.3KMediumReallocate
L730200TinyBloom Baby Wash 750ml PumpWest DCD-638730d92d171.3KMediumReduce Production
L135000Lumora Silk Shampoo 360mlSouth DCD-637730d93d5520.4KMediumPromotion
L542100Veluna Hand Cream 400ml PumpNorth DCD-637730d93d542.8KMediumConsume First
L543600Veluna Hand Cream 400ml PumpSouth DCD-637730d93d552.8KMediumTransfer