Monthly Revenue Planning: From the Annual Target to Weekly Activity

Why the annual target divided by twelve does not work

The simplest monthly plan divides the annual target by twelve. At 600,000 euros, that is 50,000 euros a month. In February the business then appears to be behind, in October far ahead, and neither says much. February has always been quiet, and October lives on quotes written in July. If you try to correct course in February, you are steering against the season. If you are satisfied in October, you notice too late that too few quotes went out in summer.

This piece asks: How does a small business spread its annual revenue target across months and weeks so that every week shows what needs to be done? To answer it, we first clarify the terms, introduce backward planning as a mental model, then spread the target with a seasonal index, factor in the lead time, and finally come to the monthly review.

October’s revenue is sold in July. A monthly plan that does not show this describes the past.

Terms: monthly target, seasonal index, lead time

• Monthly target: The revenue to be invoiced in a particular month. It is an outcome target and also depends on the customer.
• Seasonal index: Relates the value of a month to the average of all months. An index of 115 means the month is 15 percent above average. For a reliable index, at least two, preferably three years should be analyzed.
• Lead time: The time between a sales activity and the revenue it triggers. It consists of the time from quote to order and the time from order to invoice.
• Activity target: What the business does to get there, such as holding conversations and writing quotes. It is within your own control and can be checked off every week.

How the annual target becomes a number of orders, quotes, and conversations in the first place is described in the guide Planning sales targets with the target staircase. This guide starts there and adds two things an annual calculation does not show: the season and time.

The mental model: plan backward instead of hoping forward

People regularly underestimate how long a task will take them. Buehler, Griffin, and Ross (1994) described this planning fallacy in a widely cited paper. Wiese, Buehler, and Griffin (2016) explain one reason: when making a prediction, people usually imagine a plan running from the start to success. This mental scenario is simplified, focuses on a few central steps, and leaves out obstacles, interruptions, and competing tasks.

As a remedy, the authors tested backward planning: you start at the end goal and work through the required steps in reverse order. In four experiments, participants who planned backward predicted longer completion times than those who planned forward or without instruction, and in the fourth experiment their estimates were closer to reality. Backward planning drew attention to obstacles and delays and produced new insights into the process. The experiments concerned individual tasks by students and adults, not sales planning. The mechanism, however, can be transferred.

For revenue planning, this means: do not start in January and ask what is possible this year. Start with the revenue of a particular month and ask when the order for it must be in, when the quote must be written, and when the first meeting must have taken place. Each stage moves the activity forward by its lead time.

Step 1: spread the annual target by season

We take the worked example from the guide Planning sales targets: an annual target of 600,000 euros, of which 240,000 euros come from existing business and 360,000 euros from new business, an average order value of 12,000 euros, and a 30 percent win rate. What is new is the seasonal index, which the business has derived from its invoices over the last three years.

The calculation is simple: new business per quarter = 360,000 euros × index sum ÷ 1,200. Orders = new business ÷ 12,000 euros. Quotes = orders ÷ 0.3. Over the year, as in the target staircase, this gives 30 orders and 100 quotes. They are just distributed differently. How to derive the seasonal index from inquiries, hours, and incoming payments is described in the guide Planning for seasonal sales.

Step 2: factor in the lead time

Up to this point, the plan shows when revenue is due. It does not yet show when the work for it arises. In the example, it takes two months on average from quote to order and another month from order to invoice. The lead time is therefore three months, one quarter. The quotes for Q4 revenue must be written in Q3.

The result contradicts the intuition of many owners. Most quotes have to be produced in Q3, in the months with vacations and the weakest revenue. If you let prospecting rest in summer because things are quiet, that is exactly how you create the gap in the fall. The guide on seasonality states a rule for this: prospecting for a period starts two to three months beforehand.

How many open quotes must constantly be on the list for this can be estimated with a rule from queuing theory, Little’s law (Little 1961): the average inventory in a system equals the arrival rate times the average time spent in it. Applied here: open quotes = new quotes per month × months until decision.

If there are significantly fewer open quotes on the list, revenue will be missing in two to three months, even if the current month looks good. How to keep this list clean and weighted is shown in the guide Pipeline management for SMEs.

Step 3: turn the quarter into the week

The quarter is still too coarse for steering. For the weekly figure, divide a quarter’s activities by the working weeks actually available. In the summer quarter, that is often only ten instead of thirteen weeks because of vacations.

1. Choose the revenue month

   Start with the month whose revenue you are planning and take the new business from the seasonal distribution.

2. Calculate backward

   Divide by order value and win rate and move the result forward by the lead time. Now you know in which month how many quotes must be written.

3. Derive conversations

   Divide the quotes by the share of conversations that lead to a quote, and move forward once more by the time between conversation and quote.

4. Spread across weeks

   Divide by the available working weeks of the month. Subtract vacations, public holidays, and trade fairs that tie up sales.

5. Check feasibility

   Put the weekly figure next to the calendar. If it does not fit, prospecting must start earlier or the target must come down.

In the example, 28 quotes in Q3 with ten working weeks come to almost three quotes a week, more than the two to three on annual average. That is information an even weekly figure would have hidden.

Two views: simple plan or precise plan

The first view prefers the simple plan. One twelfth per month and a fixed weekly figure are immediately understandable, and everyone on the team can recalculate them. Every additional assumption, such as a seasonal index or a lead time, can be wrong. Research on sales forecasts urges caution: Fildes, Goodwin, and De Baets (2023) found that manual adjustments improved accuracy for only about half of the items. More detail is therefore not automatically more truth.

The second view considers the simple plan convenient but misleading. Season and lead time are not guesses but patterns that can be read from the business’s own figures of recent years. If you leave them out, you plan with an assumption you know to be false, namely that every month is the same and quotes turn into revenue immediately.

I consider the precise plan right as long as it meets two conditions: every assumption comes from your own data or is marked as an estimate, and the plan fits on one page. The seasonal index and a single value for the lead time are enough. Further breakdown, for example by service and customer group, only pays off once these two values are stable after a year. Why bottom-up targets are more reliable than wished-for numbers is discussed in the essay Realistic growth targets.

The monthly review: rolling the plan forward

A monthly plan only becomes a steering tool through the review. Once a month, three figures are placed side by side: planned and actual revenue for the previous month, quotes written compared with the plan, and the number of open quotes compared with Little’s rule. The third figure is the most important because it anticipates the revenue of the coming months.

Afterward, the plan is extended by one month so that twelve months are always visible. This rolling forecast does not replace the annual target but complements it. Bhimani and colleagues (2024) found among 380 companies in the UK and Australia that almost a third used such rolling planning in addition to the annual budget. How target, forecast, and budget are separated is described in the guide Annual planning for a small business.

• The seasonal index is calculated from at least two years of your own figures.
• The lead time from quote to invoice is measured or marked as an estimate.
• For each month, it is clear how many quotes must be written.
• The weekly figure is adjusted for vacations and public holidays.
• Once a month, revenue, quotes, and open quotes are compared with the plan.
• The plan is rolled forward by one month every month.

Conclusion and what you can do this week

How does a small business spread its annual revenue target across months and weeks so that every week shows what needs to be done? It spreads new business across the months with a seasonal index from its own figures, calculates backward from each revenue month to orders, quotes, and conversations, and moves these forward by the lead time. This produces a weekly figure that differs by quarter. Research on the planning fallacy explains why the backward direction helps: it makes visible what lies between activity and revenue. The monthly review of open quotes reveals gaps before they show up in revenue.

1. This week: Export your invoices for the last two to three years by month and calculate the seasonal index.
2. Next week: For the last twenty orders, measure the time from quote to invoice.
3. In a month: Calculate the quotes per quarter backward, put the weekly figure next to the calendar, and set a monthly review date.

A good monthly plan says in summer that the fall is at risk, not in the fall that the summer was slept through.