Complete planning cycle
The fictional account
A growing direct-to-consumer skincare brand with three suppliers, six managed SKUs, seasonal promotions, inbound inventory, and an $8,500 purchasing ceiling.
Illustrative data only. This is a worked product demonstration, not a customer result or performance claim.
Sales history
312 weekly SKU observations
Inventory
6 managed SKUs, on-hand and allocated
Supply rules
Lead time, safety stock, MOQ and case packs
Known events
2 promotions, 1 stockout period, 1 supplier blackout
Inbound
2 open purchase-order lines
Purchasing limit
$8,500
01 · Inputs received
The complete pilot accepts CSV exports or a connected Shopify store. Supplier constraints and known events turn a sales forecast into an operational recommendation.
| SKU | Product | Supplier | On hand | Allocated | Unit cost |
|---|---|---|---|---|---|
| SERUM-30 | Vitamin C Serum | Lab North | 96 | 18 | $6.50 |
| WASH-01 | Daily Face Wash | Coastal Labs | 185 | 20 | $4.50 |
| MASK-05 | Recovery Mask | Lab North | 62 | 8 | $5.25 |
| OIL-02 | Night Facial Oil | Botanical Works | 148 | 5 | $8.75 |
| POUCH-02 | Travel Pouch | Packworks | 310 | 12 | $2.10 |
| BRUSH-01 | Cleansing Brush | Packworks | 80 | 0 | $3.25 |
02 · Planning output
Cycle date Jul 28, 2026 · Recommendations remain subject to customer approval.
Managed SKUs
6
Units proposed
964
Purchase value
$6,341
Stockout risks
1
| Priority | SKU / item | Supplier | Demand / wk | Inventory position | Stockout chance | Order by | Order qty | PO value | Confidence |
|---|---|---|---|---|---|---|---|---|---|
| Stockout risk | Vitamin C Serum SERUM-30 | Lab North | 62.5 | 78 (1.2 wks) | 100% 2,000 scenarios / 42 days | Jul 28, 2026 | 744 | $4,836 | high Last observed week |
| Reorder soon | Recovery Mask MASK-05 | Lab North | 17 | 102 (6 wks) | 29% 2,000 scenarios / 35 days | Jul 28, 2026 | 120 | $630 | high Last observed week |
| Reorder soon | Night Facial Oil OIL-02 | Botanical Works | 16 | 143 (8.9 wks) | 0% 2,000 scenarios / 45 days | Jul 28, 2026 | 100 | $875 | high Last observed week |
| Reorder soon | Daily Face Wash WASH-01 | Coastal Labs | 30 | 237 (7.9 wks) | 0% 2,000 scenarios / 28 days | Aug 10, 2026 | 0 | $0 | high Last observed week |
| Excess | Travel Pouch POUCH-02 | Packworks | 2 | 298 (149 wks) | 0% 2,000 scenarios / 60 days | Mar 20, 2029 | 0 | $0 | medium Last observed week |
| No demand | Cleansing Brush BRUSH-01 | Packworks | 0 | 80 (— wks) | 0% 2,000 scenarios / 45 days | No order | 0 | $0 | low Last observed week |
03 · Management exceptions
Stockout chance is the share of 2,000 seeded demand scenarios that exhaust available inventory before the SKU's replenishment lead time ends. It is a modeled risk—not a guarantee—and includes scheduled inbound receipts.
BRUSH-01: Low forecast confidence: 250% average forecast error on backtests despite 52 weeks of history — demand looks intermittent or highly volatile. Review current demand and inventory before approval.
04 · 13-week cash schedule
The remaining 12 of 13 weeks have no purchasing due — recommendations are recalculated each planning cycle.
Ready to use your own numbers?