PlanAI · Lumora Consumer ProductsDemo Data

Lumora Fresh Shampoo 180ml

Lumora · Hair Care · 180ml

Service W4–8 92.1%
Demand (13 wks)
992K
Forecast W1
74.3K
Inventory
6.6K
Production (13 wks)
954K
Plant / Line
Filling Line 2 · WP
Price / Margin
$3.9 · 44%
Shelf life
730d
Constraint
Material: Surfactant Base

BOM

Multi-level — level 1 shown, bulk exploded below

MaterialQuantityUnitYield lossScrap %Lead timeSupplierCriticality
Bulk — Lumora Fresh Shampoo0.18kg1.5%0.8%MakeIn-house—
↳ Surfactant Base0.0828kg2.6%1.5%42dApex Specialty ChemicalsA
↳ Sodium Laureth Sulfate0.0144kg2.5%1.6%35dMeridian SurfactantsA
↳ Cocamidopropyl Betaine0.0090kg2.9%0.5%35dCorvane ChemicalsB
↳ Fragrance Compound — Lumora Fresh0.0020kg2.9%0.7%42dAurelia AromaticsA
↳ Preservative0.0011kg2.7%0.7%28dRidgeway PreservativesB
↳ Colorant0.0002kg2.6%0.7%21dCobalt PigmentsC
↳ Citric Acid0.0004kg1.9%0.6%14dRidgeway PreservativesB
↳ Sodium Chloride0.0018kg2.8%1.6%7dLumex MineralsC
↳ Cooling Fragrance Premix0.0011kg1.0%0.5%MakeIn-house—
180ml PET Bottle1ea1.0%1.4%21dPolyform ContainersA
Bottle Cap 24mm1ea1.0%1.4%14dTessel ClosuresA
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
Demand74.3K73.7K76.3K76.2K78.9K78.2K80.5K73.7K75.2K76.7K77.2K75.1K75.6K
Production74.3K73.7K76.3K76.2K41.6K78.2K80.5K73.7K75.2K76.7K77.2K75.1K75.6K
Shipped74.3K73.7K76.3K76.2K48.2K78.2K80.5K73.7K75.2K76.7K77.2K75.1K75.6K
Inventory6.6K6.6K6.6K6.6K000000000
Lost000037.3K00000000

Exceptions

Excess Inventory · W5 · Reduce production / reallocate
Demand Spike · W9 · Review consensus forecast