PlanAI · Lumora Consumer ProductsDemo Data

PureGlow Body Wash 250ml Twin Pack

PureGlow · Personal Wash · 250ml Twin Pack

Service W4–8 93.5%
Demand (13 wks)
110K
Forecast W1
7.9K
Inventory
1.2K
Production (13 wks)
106K
Plant / Line
Filling Line 3 · SB
Price / Margin
$9.12 · 44%
Shelf life
730d
Constraint
Material: Surfactant Base

BOM

Multi-level — level 1 shown, bulk exploded below

MaterialQuantityUnitYield lossScrap %Lead timeSupplierCriticality
Bulk — PureGlow Body Wash0.5kg1.5%0.8%MakeIn-house—
↳ Surfactant Base0.1800kg2.6%1.5%42dApex Specialty ChemicalsA
↳ Sodium Laureth Sulfate0.0300kg2.5%1.6%35dMeridian SurfactantsA
↳ Glycerin0.0150kg1.3%0.4%21dPinecrest GlycerinB
↳ Fragrance Compound — PureGlow Body0.0045kg1.4%0.9%42dAurelia AromaticsB
↳ Preservative0.0030kg2.7%0.7%28dRidgeway PreservativesB
↳ Pearlizing Agent0.0050kg2.6%0.8%28dEmulsia IngredientsB
↳ pH Adjuster0.0010kg2.9%1.3%14dRidgeway PreservativesC
250ml HDPE Bottle2ea0.8%1.7%21dBrightline PackagingA
Flip Cap 28mm2ea1.4%0.8%14dTessel ClosuresB
Label — PureGlow Body Wash2ea1.0%1%14dVantage LabelsB
Carton — PureGlow Body Wash0.0833ea0.6%0.4%21dKestrel CartonboardB
Master Case0.0208ea1.5%1%14dKestrel CartonboardB
Tamper Seal2ea1.5%1.4%14dOrbis FilmsC
Promo Neck Tag — PureGlow Body Wash1ea1.5%0.6%14dVantage LabelsC
Shrink Film1ea1.2%1.2%14dOrbis FilmsC
Pallet0.001ea1.3%1.1%7dNorthwind PalletsC

Plan

RowW1W2W3W4W5W6W7W8W9W10W11W12W13
Demand7.9K8.1K8.5K8.6K8.4K8.5K8.6K8.6K8.4K8.5K8.5K8.4K8.6K
Production7.9K8.1K8.5K8.6K4.4K8.5K8.6K8.6K8.4K8.5K8.5K8.4K8.6K
Shipped7.9K8.1K8.5K8.6K5.6K8.5K8.6K8.6K8.4K8.5K8.5K8.4K8.6K
Inventory1.2K1.2K1.2K1.2K000000000
Lost00004.0K00000000

Exceptions

Excess Inventory · W6 · Reduce production / reallocate