Free 13 Week Supply Planning Template

A free Excel supply plan that rolls stock forward week by week, shows days cover and flags shortages before they happen.
Free 13 Week Supply Planning Template

A simple Excel supply plan that rolls your stock forward week by week, shows days cover for every item, and flags where you will run short before it happens.

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 supply planning for each item: sales forecast, production orders, projected stock on hand and days cover
  • Days cover that looks forward, based on the next four weeks of forecast, and handles the end of the horizon and items with no demand without errors
  • Green and amber flags so you can see at a glance which weeks need more production
  • Red stock figures for demand you cannot supply, so shortages are hard to miss
  • Ten worked examples: lumpy batches, an uncovered promotion, an item that is overstocked now but runs out later, and a discontinued line run down to zero
  • A Read Me tab with instructions, definitions and every assumption in plain English

Who it's for

Supply planners, production planners, demand planners 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 multiple sites, it will show you the method but you'll outgrow it quickly.

How to use it in five steps

  1. Set the current week commencing date (a Monday) in the yellow cell at the top
  2. Type each item's stock on hand today in the Initial column
  3. Paste 13 weeks of forecast into each Sales Forecast row. If you use the free demand planning template with the same start week, its Demand Plan row pastes straight in
  4. Enter planned production or purchase receipts in the week the stock becomes available to sell
  5. Read the plan: green is fine, amber means you need more production in or before that week

What it deliberately doesn't do

This is the free version, so it shows the gap but doesn't close it for you. There's no capacity check, no lead times, no minimum order quantities and no safety stock target.

That's a deliberate choice. It's enough to build a sound habit: see the shortage coming, then decide what to do about it.

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, inventory and production data, 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