PlanAI · Lumora Consumer ProductsDemo Data

Lumora Repair Shampoo 90ml Travel

Lumora · Hair Care · 90ml Travel

Service W4–8 92.4%
Demand (13 wks)
159K
Forecast W1
11.9K
Inventory
1.4K
Production (13 wks)
153K
Plant / Line
Filling Line 1 · WP
Price / Margin
$2.76 · 48%
Shelf life
730d
Constraint
Material: Surfactant Base

BOM

Multi-level — level 1 shown, bulk exploded below

MaterialQuantityUnitYield lossScrap %Lead timeSupplierCriticality
Bulk — Lumora Repair Shampoo0.09kg1.5%0.8%MakeIn-house—
↳ Surfactant Base0.0414kg2.6%1.5%42dApex Specialty ChemicalsA
↳ Sodium Laureth Sulfate0.0072kg2.5%1.6%35dMeridian SurfactantsA
↳ Cocamidopropyl Betaine0.0045kg2.9%0.5%35dCorvane ChemicalsB
↳ Fragrance Compound — Lumora Repair0.0010kg1.8%1.2%42dHalden Fragrance HouseA
↳ Preservative0.0005kg2.7%0.7%28dRidgeway PreservativesB
↳ Colorant0.0001kg2.6%0.7%21dCobalt PigmentsC
↳ Citric Acid0.0002kg1.9%0.6%14dRidgeway PreservativesB
↳ Sodium Chloride0.0009kg2.8%1.6%7dLumex MineralsC
↳ Conditioning Premix0.0031kg1.0%0.5%MakeIn-house—
↳ Hydrolyzed Keratin0.0004kg3.2%0.8%56dTerraform BioC
↳ Panthenol0.0003kg2.5%1.6%35dTerraform BioB
90ml PET Travel Bottle1ea0.7%0.8%21dClearwave PETC
Flip Cap 28mm1ea1.4%0.8%14dTessel ClosuresB
Label — Lumora Repair Shampoo1ea1.2%1.5%14dVantage LabelsB
Carton — Lumora Repair Shampoo0.0833ea1.0%1.5%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
Demand11.9K11.9K11.8K12.1K12.9K12.8K12.8K12.2K12.1K12.3K12.0K12.0K12.1K
Production11.9K11.9K11.8K12.1K6.8K12.8K12.8K12.2K12.1K12.3K12.0K12.0K12.1K
Shipped11.9K11.9K11.8K12.1K8.2K12.8K12.8K12.2K12.1K12.3K12.0K12.0K12.1K
Inventory1.4K1.4K1.4K1.4K000000000
Lost00006.1K00000000

Exceptions

Excess Inventory · W6 · Reduce production / reallocate