PlanAI · Lumora Consumer ProductsDemo Data

Lumora Fresh Shampoo 1L Refill Pouch

Lumora · Hair Care · 1L Refill Pouch

Service W4–8 92.0%
Demand (13 wks)
119K
Forecast W1
8.8K
Inventory
698
Production (13 wks)
115K
Plant / Line
Filling Line 2 · WP
Price / Margin
$17.16 · 39%
Shelf life
730d
Constraint
Material: Surfactant Base

BOM

Multi-level — level 1 shown, bulk exploded below

MaterialQuantityUnitYield lossScrap %Lead timeSupplierCriticality
Bulk — Lumora Fresh Shampoo1kg1.5%0.8%MakeIn-house—
↳ Surfactant Base0.4600kg2.6%1.5%42dApex Specialty ChemicalsA
↳ Sodium Laureth Sulfate0.0800kg2.5%1.6%35dMeridian SurfactantsA
↳ Cocamidopropyl Betaine0.0500kg2.9%0.5%35dCorvane ChemicalsB
↳ Fragrance Compound — Lumora Fresh0.0110kg2.9%0.7%42dAurelia AromaticsA
↳ Preservative0.0060kg2.7%0.7%28dRidgeway PreservativesB
↳ Colorant0.0010kg2.6%0.7%21dCobalt PigmentsC
↳ Citric Acid0.0020kg1.9%0.6%14dRidgeway PreservativesB
↳ Sodium Chloride0.0100kg2.8%1.6%7dLumex MineralsC
↳ Cooling Fragrance Premix0.0060kg1.0%0.5%MakeIn-house—
1L Refill Pouch1ea0.8%1.6%28dWestlake FlexiblesB
Label — Lumora Fresh Shampoo1ea1.1%1.2%14dVantage LabelsB
Carton — Lumora Fresh Shampoo0.0833ea0.9%0.6%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
Demand8.8K9.0K9.1K9.2K9.3K9.4K9.5K9.0K9.3K9.0K9.3K9.2K9.1K
Production8.8K9.0K9.1K9.2K4.9K9.4K9.5K9.0K9.3K9.0K9.3K9.2K9.1K
Shipped8.8K9.0K9.1K9.2K5.6K9.4K9.5K9.0K9.3K9.0K9.3K9.2K9.1K
Inventory698698698698000000000
Lost00004.4K00000000

Exceptions

Excess Inventory · W8 · Reduce production / reallocate