Skip to content

Annual Production Plan: A Year by Month, With Stock

An annual production plan for a small maker: a year's forecast by month, what to make each month, stock at month end, capacity, and a free spreadsheet.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 21, 2026 · 6 min read

An annual production plan is twelve rows: one for each month, with what you expect to sell, what you plan to make, and the stock that leaves at the month's end. It exists because sales and production rarely have the same shape. A maker with a holiday peak can't make December's orders in December if the kitchen tops out below them. The plan shows that in January, when there's still time to do something about it, and it shows what the answer costs: jars sitting on shelves through the summer. Below is a year for a made-up jam maker, the three ways to shape a plan, how to read the stock column, and the file.

The short version

  • Twelve rows: forecast sales, planned production, stock at month end.
  • Stock at month end = last month's stock + made − sold.
  • Check every month's production against what you can make.
  • If a month's sales are above capacity, the difference has to be made earlier.
  • The highest stock number is the storage and cash the plan needs.
  • Redo the plan every quarter with real sales.
  • TaroStack's planning does this from your recipes and stock, on Growth. More below.

An example year

This maker can make 2,000 jars a month and starts the year with 1,800 on the shelf.

Month Forecast sales Planned production Stock at month end Capacity used
January 900 1,200 2,100 60%
February 800 1,200 2,500 60%
March 900 1,400 3,000 70%
April 1,100 1,600 3,500 80%
May 1,400 1,800 3,900 90%
June 1,600 2,000 4,300 100%
July 1,500 2,000 4,800 100%
August 1,400 2,000 5,400 100%
September 1,600 2,000 5,800 100%
October 2,200 2,000 5,600 100%
November 3,400 2,000 4,200 100%
December 3,800 1,400 1,800 70%

The year sells 20,600 jars and makes 20,600, so it ends where it started, with 1,800.

The problem the plan solves is in the last two rows. November and December sell 7,200 jars between them. Flat out, the kitchen makes 4,000 in two months. The other 3,200 have to exist already on November 1, and they do: October closes with 5,600.

What that costs is the September line. At its peak the plan holds 5,800 jars. They need shelves, and the fruit, sugar, jars and labor in them have been paid for months before they're sold.

Three ways to shape a plan

What it does What it costs
Level Make the same every month The most stock, the steadiest work
Chase Make what each month sells Little stock, but needs capacity for the peak
Mixed Build ahead of the peak, ease off after Some of each

A chase plan isn't open to this maker: November needs 3,400 and the kitchen makes 2,000. A level plan would be about 1,717 jars every month. The plan above is mixed. It runs light in winter, when fruit is expensive and there's no rush, and flat out from June, when fruit is in season and the peak is coming.

Whichever you choose, shelf life sets a limit. Stock made in June for December has to still be good in December, with the shelf life your stores ask for on top. This maker's jam keeps long enough for that. A product with a short shelf life can't be built ahead this way, and for it the answer is more capacity, not more stock.

Reading the stock column

  • A negative number means the plan runs out. Make more earlier, or accept selling less.
  • The highest number is the most you'll ever store. If it won't fit, the plan doesn't work.
  • The lowest number is your cushion against a forecast that was too low. This plan never drops below 1,800, about two months of winter sales. How much cushion to keep is in safety stock formula.
  • The last number is next year's opening stock.

Where the numbers come from

The forecast is last year's sales by month, adjusted for what you know: a new store, a dropped product, a price change. One way to build it is in sales forecast template.

Capacity is batches a day × jars a batch × working days, less what always goes wrong. The sum is in how to calculate production capacity.

The year is the outline. Each month then gets a weekly plan by product: see master production schedule template. What to buy for it is in MRP spreadsheet template.

Get the plan

Download the annual production plan. One sheet and a read-me: type your opening stock, each month's forecast and what you plan to make, and it works out the stock at each month's end and the capacity used, and marks a month that runs short or over capacity. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.

Where this stops working

The plan is in jars. The kitchen makes strawberry, raspberry and apricot in two sizes, and a year that balances in total can still run out of strawberry in November with apricot to the ceiling. Doing it by product is six sheets. And the plan is right on the day it's made: by April real sales have drifted from the forecast, and the stock column is describing a year that isn't happening.

How TaroStack does it

TaroStack plans from what's actually on the shelf and in the recipes.

Planning, on Growth, says what to make and what to buy, and when. It knows your capacity, and every suggestion is a draft you approve.

It's shelf-life aware: stock that will expire before it's sold isn't counted on.

Exceptions in plain words: what will run short, arrive too late, or expire before it's used.

Stock is current, by product and lot, because batches and sales orders keep it so. Stock value by month shows what the build-up is costing.

The question Spreadsheet In TaroStack
Will strawberry run out in November A sheet for each product Named as an exception
What's on the shelf today The last count Kept current, by lot
What the stock build costs Jars × a guess Stock value by month
Will June's jam still be good in December Check by hand Planning counts shelf life

Planning is on Growth at $39 a month (50 recipes) and above. Recipes, batches and stock are on every plan, from $9.99 a month (5 recipes). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.

Questions people also ask

What is an annual production plan?

A plan of what to make in each month of the year, set against forecast sales, with the stock that results at each month's end. It shows early whether capacity and storage are enough.

How do you make a production plan for one year?

List twelve months of forecast sales. Enter planned production for each month, no more than you can make. Work out stock at each month's end, and adjust production until no month runs out and the peak stock fits.

What is the difference between a level and a chase plan?

A level plan makes the same amount every month and lets stock rise and fall. A chase plan makes what each month sells and holds little stock, which needs enough capacity for the busiest month.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.