Sales forecast and resource planning in a financial model: steps 5–9

A sales forecast in a financial model is built from three things: what you sell (the range), how much (volumes in units, kilos or customers) and at what price — by month, with seasonality.

But a forecast is only worth something if it is tied to the project roadmap and to the resources without which those sales are impossible: marketing, people, storage and capacity.

This is the second article in our financial model series, steps 5–9 of 20.

In the first article, Financial model: what it is, what it consists of and how to build one, we covered steps 1–4: why you need a model, the main mistakes and where to start.

If you have not read it, start there so you do not miss important details. Here are the stages that decide how realistic and useful your model will be.

No theory for its own sake — only approaches proven in practice, examples and clear recommendations, so the model becomes a working decision tool rather than a formality.

Step 5. Roadmap: the key time points

The financial model must be synchronised with the project roadmap.

Skip this step and the calculations will contain wrong timings, flawed assumptions and errors in the cash flow forecast. Pin down:

• When will production actually start?
• When do sales start?
• When does hiring begin — and therefore when do payroll costs rise?
• When are the major payments: new premises, raw materials, investment?

The roadmap’s role in the model

A roadmap is not just a project schedule but a dynamic tool that drives the whole model: it spreads both costs and revenues over time. A proper roadmap lets you:

• Forecast the timing of costs and receipts. If the sales start slips by three months, you immediately see the effect on cash flow and payback.
• Assess how timing changes affect results. In a good model the roadmap is a separate sheet of dates linked to the rest of the calculations. Change a start or end date and the model recalculates the final figures by itself.
• Check against reality. Sometimes the model assumes optimistic launch or scaling dates while the roadmap shows it will take longer in practice. This is exactly where the mismatch shows up.

A model is not a static calculation but a living tool.

If the roadmap is flexibly integrated, any timing change immediately shows what happens to profitability, funding needs and payback.

If changing the timing does not affect the final numbers, that is a warning sign: the model is too static or key relationships are missing.

Step 6. Success markers: linking to the project concept

The model must reflect the business’s key goals — that is, be linked to the success markers in the project concept or business plan. Typical markers:

• reaching a sales volume by a given date — for example, 5,000 units a month six months after launch;
• a target market share — for example, 10% within three years;
• launching a new production site or expanding capacity — a second workshop or store.

Why it matters

• Markers are benchmarks for realism. If the business plan sets ambitious goals but the model shows they would need an unrealistic marketing budget or headcount, something does not add up.
• The model shows how achievable the goals are and what they require. If fast sales growth is claimed but production and staff costs do not rise, something has been missed.
• Without markers the model’s value is doubtful. The model must help decide. If break-even moves six months later, you need to know in advance what reserves will carry you through.

How to build markers into the model

• Show them as reporting metrics — for example, on a separate KPI forecast sheet.
• Test how achievable the goals are in different scenarios — optimistic, realistic, pessimistic.
• See clearly what resources and investment each marker needs.

A model without success markers is just a table of numbers. It must show what will be achieved, when and how.

Step 7. Sales plan: realism instead of illusions

The sales plan is the foundation of the model: sales determine future cash flow and profitability.

An error here can be fatal, especially if an inflated forecast drives management decisions. A sales plan must include:

• the range — which products or services, and each segment’s share of sales;
• volumes in physical units — pieces, kilos, square metres, customers; ideally by month, with seasonality and demand cycles;
• prices — not only today’s, but how they will change: inflation, discounts, promotions, market conditions.

What a sales plan looks like: an illustrative example

A café on the Spanish coast with one product, the average ticket. Rows are tickets per day, trading days and average ticket; revenue is their product. Seasonality is obvious straight away:

The figures are illustrative; the logic is what matters. Revenue is not typed in as a lump sum but calculated from drivers — traffic, conversion, ticket.

Revenue in the model excludes VAT: the tax on sales belongs to the tax office, not the business.

If the summer peak is three times the winter, purchasing, staff and cash in the low season have to be planned separately.

Typical sales planning mistakes

• Optimism without facts. The model assumes linear growth or hitting targets within a few months of launch. That rarely happens. A new product may take a long time to build demand. Sales depend on seasonality, marketing and competitors. If sharp growth is assumed with no explanation of what will drive it, that is a red flag.
• Ignoring demand drivers. In a seasonal business, account for low-season dips and do not forecast from peak values. In a competitive market, allow for price adjustments, or the planned margin will be unrealistic.
• Ignoring production or logistics limits. Sales growth without more capacity or purchasing is impossible. If delivery takes months and the model assumes instant supply, that is not a business plan but a fantasy.

How to make a sales plan realistic

• Use real data. If the business is running, use its history and trends. If not, use market analytics, competitor analysis and industry research.
• Build scenarios. Optimistic, realistic and pessimistic, to see the range of outcomes.
• Link sales to marketing. High sales need a clear customer acquisition strategy. Without marketing spend and brand awareness a sudden jump in sales is rare.

The model should reflect not the sales you want but those that are actually possible in the market. If the numbers look too good to be true, they probably are. Unit economics helps check the economics of every sale.

Step 8. Resources needed to deliver the plans

The model must show not only forecast sales and production but the resources needed to deliver them.

Many models draw beautiful growth without answering: who will make these sales, and is there enough capacity to fulfil the orders?

Resources for the sales plan

Sales growth requires investment:

• Marketing — which channels, how effective, what share of budget goes to advertising, PR and discounts. Sales rise while the marketing budget stays flat — an error.
• Staff — how many people for customer service, sales and logistics, when to hire them, what salaries, taxes and bonuses cost. In Spain, employer social security contributions come on top of salaries.
• Storage and logistics — additional space, transport, staff to process orders.

Typical mistakes:

• “Thin-air sales” — growth with no increase in advertising, staff or storage costs.
• Seasonality smoothed out evenly across months when in reality there are peaks and troughs.
• Underestimating marketing — without more spend on acquisition, a multiple increase in sales is unlikely.

Resources for the production plan

If the business has its own production, the model must reflect capacity and limits:

• Premises — is current space enough, is renting or building needed.
• Equipment — buying new or upgrading, depreciation, maintenance plan.
• Staff — how many workers to raise output, rates, shifts, taxes.

Typical mistakes:

• A gap between production and sales — capacity cannot meet the sales plan or, conversely, more is produced than can be sold.
• Scaling costs left out — equipment, staff, rent, logistics.
• Unrealistic timing — a new line takes 6 months to launch, but the model assumes higher output in 3.

How to link resources to the model

• Sales are linked to resources: volume up — staff, marketing and logistics up.
• Production capacity matches the sales plan: the model shows how fast output can grow and what it takes.
• Constraints are reflected: if expansion needs investment, it is in the model.

If the model shows sales growth without the resources to deliver it, it does not work.

Step 9. Business units and a modular approach

A model is far more accurate and easier to use when it is built from modules rather than one block of calculations.

Splitting the business into units helps control cash flows, assess individual lines and adapt the model flexibly.

What a business unit is

A self-contained accounting unit in the model — by product, line of business, region or process. For example:

• in manufacturing — workshops or product lines;
• in retail — individual stores or regions;
• in an IT startup — subscription plans or product lines;
• in logistics — warehouses, routes or individual services.

Splitting into units lets you:

• analyse the profitability of each line separately;
• see the strong and weak areas of the business;
• manage scaling more easily and reallocate resources;
• model launching new lines and closing unprofitable ones.

How to structure a model with units

1. Pick the units that drive results. If a company has 50 stores and 10 of them bring 80% of revenue, there is no point modelling each one — group them into typical segments.
2. Give each unit its own inputs — sales volume, cost structure, utilisation, marketing budget.
3. Build a modular structure so units can be switched on and off, scaled and their impact on the total seen.
4. Keep unit calculations independent so a new region or product can be modelled without touching the whole model.

Typical mistakes

• Too much detail — too many units make the model unwieldy.
• No links between units — growth in one line is not reflected in the resources of others.
• Rigid structure — units hard-wired into the model are difficult to change and scale.

Units for strategic management

• Profitability by unit — you quickly see which lines make money and which drag the business down.
• Resource optimisation — reallocating marketing, production and investment spend.
• Scaling — a new product, branch or region is added and its effect on the total is visible immediately.

As the business grows and becomes more complex, the model must grow with it, and for that it must be structured and modular.

From practice: in the model for the ImSkipper marketplace, the sales plan and resources were built for scaling the platform, and that link is what made the model useful in investor conversations.

Frequently asked questions

How do you forecast sales for a new business with no history?

Build it from drivers: target market size, traffic, conversion, average ticket, purchase frequency. Take the values from market analytics, competitor data and industry research, and always model several scenarios.

Should sales be planned by month or by year?

The first year by month, to see seasonality and cash gaps; after that by quarter or year. An annual plan hides the months when money runs short.

Should VAT be included in revenue in a financial model?

No. Revenue is shown excluding VAT, and the tax itself as a separate line in the cash flow: it is collected from customers and paid to the tax office, usually quarterly.

Why link the sales plan to marketing costs?

Because sales do not grow on their own. If sales rise in the model while the acquisition budget does not, the forecast is unrealistic and the model understates how much money you need.

Key points about the sales forecast

• Roadmap and success markers first, then sales: time and goals set the frame.
• Sales are calculated from drivers — range, volumes, prices — by month and with seasonality.
• Every increase in sales is backed by resources: marketing, people, storage, capacity.
• A modular structure by business unit keeps the model manageable as you grow.
• Next: calculations, scenarios and assumptions, steps 10–14.

All 20 steps in one file — the guide “Financial Model: 20 Practical Steps” (PDF). The café example is illustrative.