PlanAI · Lumora Consumer ProductsDemo Data
Lumora Silk Shampoo 180ml
Lumora · Hair Care · 180ml
Service W4–8 92.0%
Demand (13 wks)
1.4M
Forecast W1
99.5K
Inventory
10.7K
Production (13 wks)
1.3M
Plant / Line
Filling Line 2 · WP
Price / Margin
$4.2 · 44%
Shelf life
730d
Constraint
Material: Surfactant Base
BOM
Multi-level — level 1 shown, bulk exploded below
| Material | Quantity | Unit | Yield loss | Scrap % | Lead time | Supplier | Criticality |
|---|---|---|---|---|---|---|---|
| Bulk — Lumora Silk Shampoo | 0.18 | kg | 1.5% | 0.8% | Make | In-house | — |
| ↳ Surfactant Base | 0.0828 | kg | 2.6% | 1.5% | 42d | Apex Specialty Chemicals | A |
| ↳ Sodium Laureth Sulfate | 0.0144 | kg | 2.5% | 1.6% | 35d | Meridian Surfactants | A |
| ↳ Cocamidopropyl Betaine | 0.0090 | kg | 2.9% | 0.5% | 35d | Corvane Chemicals | B |
| ↳ Fragrance Compound — Lumora Silk | 0.0020 | kg | 2.5% | 1.3% | 42d | Halden Fragrance House | A |
| ↳ Preservative | 0.0011 | kg | 2.7% | 0.7% | 28d | Ridgeway Preservatives | B |
| ↳ Colorant | 0.0002 | kg | 2.6% | 0.7% | 21d | Cobalt Pigments | C |
| ↳ Citric Acid | 0.0004 | kg | 1.9% | 0.6% | 14d | Ridgeway Preservatives | B |
| ↳ Sodium Chloride | 0.0018 | kg | 2.8% | 1.6% | 7d | Lumex Minerals | C |
| ↳ Conditioning Premix | 0.0061 | kg | 1.0% | 0.5% | Make | In-house | — |
| 180ml PET Bottle | 1 | ea | 1.0% | 1.4% | 21d | Polyform Containers | A |
| Bottle Cap 24mm | 1 | ea | 1.0% | 1.4% | 14d | Tessel Closures | A |
| Label — Lumora Silk Shampoo | 1 | ea | 0.7% | 1.4% | 14d | Vantage Labels | B |
| Carton — Lumora Silk Shampoo | 0.0833 | ea | 1.3% | 1.2% | 21d | Kestrel Cartonboard | B |
| Master Case | 0.0208 | ea | 1.5% | 1% | 14d | Kestrel Cartonboard | B |
| Tamper Seal | 1 | ea | 1.5% | 1.4% | 14d | Orbis Films | C |
| Pallet | 0.001 | ea | 1.3% | 1.1% | 7d | Northwind Pallets | C |
Plan
| Row | W1 | W2 | W3 | W4 | W5 | W6 | W7 | W8 | W9 | W10 | W11 | W12 | W13 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Demand | 99.5K | 101K | 98.3K | 99.5K | 119K | 120K | 117K | 113K | 102K | 102K | 101K | 99.2K | 102K |
| Production | 99.5K | 101K | 98.3K | 99.5K | 62.8K | 120K | 117K | 113K | 102K | 102K | 101K | 99.2K | 102K |
| Shipped | 99.5K | 101K | 98.3K | 99.5K | 73.5K | 120K | 117K | 113K | 102K | 102K | 101K | 99.2K | 102K |
| Inventory | 10.7K | 10.7K | 10.7K | 10.7K | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Lost | 0 | 0 | 0 | 0 | 56.3K | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Exceptions
Shelf-Life Risk · W5 · Review consensus forecast
Forecast Change · W7 · Review consensus forecast