PlanAI · Lumora Consumer ProductsDemo Data

Surfactant Base

SURF · Raw Material · Surfactants

Shortage
Supplier
Apex Specialty Chemicals
Alternate
Meridian Surfactants
Lead time
42d
MOQ
104.0 MT
Safety stock
120.8 MT
Inventory
761.7 MT
Open PO
1417.0 MT
4 POs
Demand (13 wks)
2243.9 MT

Projected stock

RowW1W2W3W4W5W6W7W8W9W10W11W12W13
Gross requirement164.3 MT166.1 MT167.5 MT167.7 MT182.5 MT183.4 MT185.2 MT175.2 MT169.9 MT170.7 MT170.9 MT170.3 MT170.2 MT
Scheduled receipts0.0 MT0.0 MT0.0 MT0.0 MT0.0 MT277.0 MT380.0 MT0.0 MT380.0 MT0.0 MT380.0 MT0.0 MT0.0 MT
Planned receipts0.0 MT0.0 MT0.0 MT0.0 MT0.0 MT0.0 MT0.0 MT104.0 MT0.0 MT0.0 MT0.0 MT0.0 MT0.0 MT
Projected available597.4 MT431.4 MT263.9 MT96.2 MT0.0 MT93.6 MT288.4 MT217.1 MT427.2 MT256.5 MT465.6 MT295.3 MT125.1 MT
Net requirement0.0 MT0.0 MT0.0 MT24.6 MT207.1 MT27.2 MT0.0 MT7.7 MT0.0 MT0.0 MT0.0 MT0.0 MT0.0 MT
Shortage0.0 MT0.0 MT0.0 MT0.0 MT86.3 MT0.0 MT0.0 MT0.0 MT0.0 MT0.0 MT0.0 MT0.0 MT0.0 MT
Planned release0.0 MT104.0 MT0.0 MT0.0 MT0.0 MT0.0 MT0.0 MT0.0 MT0.0 MT0.0 MT0.0 MT0.0 MT0.0 MT

Affected SKUs (41)

SKUUsage / unit13-wk req.
Lumora Silk Shampoo 180ml0.0863 kg118.5 MT
Lumora Silk Shampoo 360ml0.1726 kg255.1 MT
Lumora Silk Shampoo 650ml0.3117 kg136.2 MT
Lumora Silk Shampoo 90ml Travel0.0432 kg13.0 MT
Lumora Silk Shampoo 360ml Twin Pack0.3452 kg84.9 MT
Lumora Silk Shampoo 1L Refill Pouch0.4795 kg79.0 MT
Lumora Fresh Shampoo 180ml0.0863 kg85.6 MT
Lumora Fresh Shampoo 360ml0.1726 kg175.7 MT
Lumora Fresh Shampoo 650ml0.3117 kg99.3 MT
Lumora Fresh Shampoo 90ml Travel0.0432 kg9.4 MT
Lumora Fresh Shampoo 360ml Twin Pack0.3452 kg61.8 MT
Lumora Fresh Shampoo 1L Refill Pouch0.4795 kg57.1 MT
Lumora Repair Shampoo 180ml0.0863 kg62.5 MT
Lumora Repair Shampoo 360ml0.1726 kg127.1 MT
Lumora Repair Shampoo 650ml0.3117 kg72.1 MT
Lumora Repair Shampoo 90ml Travel0.0432 kg6.9 MT
Lumora Repair Shampoo 360ml Twin Pack0.3452 kg44.9 MT
Lumora Repair Shampoo 1L Refill Pouch0.4795 kg41.8 MT
Lumora Smooth Conditioner 180ml0.0863 kg55.2 MT
Lumora Smooth Conditioner 360ml0.1726 kg112.8 MT
Lumora Smooth Conditioner 650ml0.3117 kg63.9 MT
Lumora Smooth Conditioner 90ml Travel0.0432 kg6.1 MT
Lumora Smooth Conditioner 360ml Twin Pack0.3452 kg39.9 MT
Lumora Smooth Conditioner 1L Refill Pouch0.4795 kg36.8 MT
PureGlow Body Wash 250ml0.0938 kg64.1 MT
PureGlow Body Wash 500ml0.1876 kg57.7 MT
PureGlow Body Wash 100ml Travel0.0375 kg5.1 MT
PureGlow Body Wash 250ml Twin Pack0.1876 kg20.6 MT
PureGlow Body Wash 750ml Pump0.2814 kg38.4 MT
PureGlow Body Wash 1L Refill Pouch0.3752 kg25.7 MT
TinyBloom Baby Wash 250ml0.0782 kg32.1 MT
TinyBloom Baby Wash 500ml0.1563 kg28.9 MT
TinyBloom Baby Wash 100ml Travel0.0313 kg2.6 MT
TinyBloom Baby Wash 250ml Twin Pack0.1563 kg10.3 MT
TinyBloom Baby Wash 750ml Pump0.2345 kg19.3 MT
TinyBloom Baby Wash 1L Refill Pouch0.3127 kg12.9 MT
TinyBloom Baby Shampoo 250ml0.0782 kg27.9 MT
TinyBloom Baby Shampoo 500ml0.1563 kg25.0 MT
TinyBloom Baby Shampoo 100ml Travel0.0313 kg2.2 MT
TinyBloom Baby Shampoo 250ml Twin Pack0.1563 kg8.9 MT
TinyBloom Baby Shampoo 750ml Pump0.2345 kg16.7 MT

Open purchase orders

POWeekQtyStatus
PO-48281W5277.0 MTDelayed
PO-48100W7380.0 MTConfirmed
PO-48101W9380.0 MTOpen
PO-48102W11380.0 MTConfirmed