A Real Roll-Forward
Opening plus received less shipped equals closing, and next week's opening is this week's closing as a formula. Change one PO arrival and every week after it moves with you.
Download the template that projects stock week by week and tells you which SKU runs out and which one is quietly tying up your cash.






Each tab in the template handles one slice of the operating model — drop in your numbers and the rest updates itself.
Opening plus received less shipped equals closing, and next week's opening is this week's closing as a formula. Change one PO arrival and every week after it moves with you.
Cover is measured against forward velocity rather than a trailing average, so seasonality cannot hide a stockout. The shrinking window at the right edge is handled properly.
The trigger is lead time plus safety stock, not zero units. A reorder calendar gives you the week to buy and the quantity that returns each SKU to target cover.
Anchored to the same thirteen weeks as the 13-Week Cash Flow Template, so a container you add here is the same week whose payment you can see there.
Take a self-guided tour, or get a walkthrough tailored to your brand.