PlanAI · Lumora Consumer ProductsDemo Data

Lumora Silk Shampoo 650ml

Lumora · Hair Care · 650ml

Service W4–8 92.8%
Demand (13 wks)
437K
Forecast W1
31.0K
Inventory
5.1K
Production (13 wks)
419K
Plant / Line
Filling Line 2 · WP
Price / Margin
$12.18 · 42%
Shelf life
730d
Constraint
Material: Surfactant Base

BOM

Multi-level — level 1 shown, bulk exploded below

MaterialQuantityUnitYield lossScrap %Lead timeSupplierCriticality
Bulk — Lumora Silk Shampoo0.65kg1.5%0.8%MakeIn-house—
↳ Surfactant Base0.2990kg2.6%1.5%42dApex Specialty ChemicalsA
↳ Sodium Laureth Sulfate0.0520kg2.5%1.6%35dMeridian SurfactantsA
↳ Cocamidopropyl Betaine0.0325kg2.9%0.5%35dCorvane ChemicalsB
↳ Fragrance Compound — Lumora Silk0.0072kg2.5%1.3%42dHalden Fragrance HouseA
↳ Preservative0.0039kg2.7%0.7%28dRidgeway PreservativesB
↳ Colorant0.0007kg2.6%0.7%21dCobalt PigmentsC
↳ Citric Acid0.0013kg1.9%0.6%14dRidgeway PreservativesB
↳ Sodium Chloride0.0065kg2.8%1.6%7dLumex MineralsC
↳ Conditioning Premix0.0221kg1.0%0.5%MakeIn-house—
650ml PET Bottle1ea0.7%1.6%28dClearwave PETB
Pump Dispenser1ea0.7%0.9%35dSummit DispensingA
Label — Lumora Silk Shampoo1ea0.7%1.4%14dVantage LabelsB
Carton — Lumora Silk Shampoo0.0833ea1.3%1.2%21dKestrel CartonboardB
Master Case0.0208ea1.5%1%14dKestrel CartonboardB
Tamper Seal1ea1.5%1.4%14dOrbis FilmsC
Pallet0.001ea1.3%1.1%7dNorthwind PalletsC

Plan

RowW1W2W3W4W5W6W7W8W9W10W11W12W13
Demand31.0K31.6K32.0K32.2K38.5K37.8K38.1K35.3K31.9K32.4K32.1K31.7K32.6K
Production31.0K31.6K32.0K32.2K20.3K37.8K38.1K35.3K31.9K32.4K32.1K31.7K32.6K
Shipped31.0K31.6K32.0K32.2K25.4K37.8K38.1K35.3K31.9K32.4K32.1K31.7K32.6K
Inventory5.1K5.1K5.1K5.1K000000000
Lost000018.2K00000000

Exceptions

Excess Inventory · W7 · Reduce production / reallocate