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.
