Interactive planning demo · Fictional retail data

Inventory planning under changing demand

A retailer needs to decide what to order this week. Use its sales history, supplier lead time, and incoming stock to compare three demand scenarios and see where a purchase order still leaves a gap.

Planning assumptions

Demand scenario

Available stock is net of existing commitments.

Existing orders arrive at the start of the inbound week.

The review window is how long the new order should cover after delivery.

Purchase decision

Suggested order
Order value
Short during lead time

Projected stock after weekly demand
Suggested order No new order

Demand outlook

Units sold and forecast per week
Sales history Selected forecast

View sales history

Compare scenarios

Orders by demand scenario
DemandOrder unitsOrder valueShort during lead time

View the eight-week plan

Weekly inventory plan for the selected demand scenario
WeekDemandExisting receiptNew receiptWith orderWithout order

How the plan is calculated

The base forecast projects the recent sales trend from the midpoint of the latest four weeks. The weekly trend is the difference between the last two four-week averages divided by four, capped at 5% of the recent average. Lower demand uses a 20% reduction and higher demand uses a 30% increase. These changes are assumptions for comparison, not probability estimates.

The order covers demand during lead time and the review window, plus the buffer. It subtracts available stock and receipts due within that window, then rounds up to full cases. The new order arrives at the start of the first week after lead time. Negative projected stock represents backorders carried into the next week.

Discuss an inventory planning project