Free 13 Week Demand Planning Template

A free Excel demand plan with a statistical baseline, adjustment row and built-in WAPE and bias tracking.
Free 13 Week Demand Planning Template

A simple Excel demand plan that builds a statistical baseline from your recent sales, lets you layer on what the model can't see, and tells you how accurate it has been.

No macros, no add-ins, no consultant-speak. Just a workbook you can open, overwrite with your own numbers, and use this week.

What's inside

  • 13 weeks of history and 13 weeks forward for each item, so you can see the run rate and the plan side by side
  • A statistical baseline using a moving average, where you choose how many weeks to average
  • A separate adjustment row for promotions, new listings, price changes and lost customers, so you can always see how much of your plan is statistics and how much is judgement
  • WAPE and bias tracking, per item and in total, flagged green or amber against targets you set
  • A flag for lazy forecasts: if your Demand Plan drifts far from the baseline, the cell turns amber until you can explain why
  • A Read Me tab with instructions, definitions and every assumption in plain English

Who it's for

Demand planners, supply planners, analysts and operations managers who want a clean starting point, and anyone learning planning who wants something more realistic than a textbook example.

It's built for a few dozen items. If you're planning hundreds of SKUs across customers and channels, it will show you the method but you'll outgrow it quickly.

How to use it in five steps

  1. Set the inputs at the top: the current week, how many weeks to average, and your accuracy targets
  2. Paste your last 13 weeks of actual sales into the yellow cells
  3. Add adjustments for anything you know is coming that the history can't show
  4. Read the Demand Plan row. That's the number you hand to Supply
  5. Check WAPE and bias. If bias is consistently positive or negative, the baseline has a problem worth fixing

What it deliberately doesn't do

This is the free version, so it uses one method only. A moving average will lag a trend and ignore seasonality, and the template says so. It also works at item level, with no customer splits, promotion calendar or scenarios.

That's a deliberate choice. It's enough to build a sound habit: baseline first, judgement second, measure everything.

Why 13 weeks?

Thirteen weeks is a quarter. It is long enough to cover most supplier and production lead times, so supply can act on the plan, and short enough that the numbers are still worth arguing about. It also lines up with how finance and sales already talk about the year, which makes the plan easier to bring into an S&OP meeting.

Frequently asked questions

Is the demand planning template really free?
Yes. Subscribe with your email and the download appears at the bottom of this page. There is no paid tier hiding behind it.

Does it work in Google Sheets?
It is built in Excel, but it uses standard formulas only, so it opens in Google Sheets and LibreOffice. Conditional formatting may need a quick check after you upload it.

What forecasting method does it use?
A moving average over the number of weeks you choose. It is the simplest honest baseline. If your products are seasonal, pair it with the seasonal forecast method.

How do I measure whether my forecast is any good?
The template tracks WAPE and bias automatically. WAPE tells you how big your errors are, bias tells you whether you lean consistently high or low. Here is how both work.

Can I use it for monthly buckets instead of weeks?
Yes. Treat each column as a month instead of a week. Just keep the averaging period sensible, three to six months rather than thirteen.

Want to practise first?

The sample numbers in the workbook are invented for illustration. If you'd like a larger, realistic dataset to try it on, the Nerd Foods dataset has 104 weeks of demand across six customers, free to download.

New to the thinking behind it?

Get the template

Subscribe to see the workbook. I'll also send you new articles and tools as they're published. Unsubscribe any time.

This post is for subscribers only