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
Purchase decision
- Suggested order
- Order value
- Short during lead time
Demand outlook
View sales history
Compare scenarios
| Demand | Order units | Order value | Short during lead time |
|---|
View the eight-week plan
| Week | Demand | Existing receipt | New receipt | With order | Without 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