Complete sample planning cycle

The fictional account

Northstar Skin

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

What the planner needs.

The complete pilot accepts CSV exports or a connected Shopify store. Supplier constraints and known events turn a sales forecast into an operational recommendation.

sales.csv ↓inventory.csv ↓suppliers.csv ↓inbound.csv ↓promotions.csv ↓stockouts.csv ↓

SKU	Product	Supplier	On hand	Allocated	Unit cost
SERUM-30	Vitamin C Serum	Lab North	96	18	$7
WASH-01	Daily Face Wash	Coastal Labs	185	20	$5
MASK-05	Recovery Mask	Lab North	62	8	$5
OIL-02	Night Facial Oil	Botanical Works	148	5	$9
POUCH-02	Travel Pouch	Packworks	310	12	$2
BRUSH-01	Cleansing Brush	Packworks	80	0	$3

02 · Planning output

Weekly purchase brief

Cycle date Jul 28, 2026 · Recommendations remain subject to customer approval.

Managed SKUs

Units proposed

988

Purchase value

$6,497

Stockout risks

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	63.3	78 (1.2 wks)	100% 2,000 scenarios / 42 days	Jul 28, 2026	768	$4,992	high weighted average
Reorder soon	Recovery Mask MASK-05	Lab North	19	102 (5.4 wks)	71% 2,000 scenarios / 35 days	Jul 28, 2026	120	$630	high recent average
Reorder soon	Night Facial Oil OIL-02	Botanical Works	17	143 (8.4 wks)	0% 2,000 scenarios / 45 days	Jul 28, 2026	100	$875	high linear trend
Reorder soon	Daily Face Wash WASH-01	Coastal Labs	31	237 (7.6 wks)	0% 2,000 scenarios / 28 days	Aug 8, 2026	0	$0	high recent average
Excess	Cleansing Brush BRUSH-01	Packworks	1	80 (80 wks)	0% 2,000 scenarios / 45 days	Dec 7, 2027	0	$0	low recent average
Excess	Travel Pouch POUCH-02	Packworks	3	298 (99.3 wks)	0% 2,000 scenarios / 60 days	Apr 8, 2028	0	$0	medium recent average

03 · Management exceptions

Review before approval.

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.

SERUM-30 · Vitamin C Serum

Stockout risk

— 63.3 units/week based on the latest 12 weeks
— 78 units available after allocations and near-term inbound
— 42-day lead time plus 21 safety-stock days
— Rounded to case pack 24 and MOQ 200
— 100% of 2,000 simulated demand paths stock out within the 42-day lead-time window

MASK-05 · Recovery Mask

Reorder soon

— 19 units/week based on the latest 12 weeks
— 102 units available after allocations and near-term inbound
— 35-day lead time plus 14 safety-stock days
— Rounded to case pack 12 and MOQ 120
— 71% of 2,000 simulated demand paths stock out within the 35-day lead-time window

OIL-02 · Night Facial Oil

Reorder soon

— 17 units/week based on the latest 12 weeks
— 143 units available after allocations and near-term inbound
— 45-day lead time plus 21 safety-stock days
— Rounded to case pack 20 and MOQ 100
— 0% of 2,000 simulated demand paths stock out within the 45-day lead-time window

warning

BRUSH-01: Forecast confidence is low (52 usable history weeks). Review before approval.

04 · 13-week cash schedule

When cash is required.