Sales Forecast Formula: Build a Capacity-Checked Small-Business Plan

A practical sales forecast sums expected units multiplied by net selling price for each offer and period. Build the unit assumptions from customer evidence, check delivery capacity, and keep revenue recognition and collection dates separate.

Every amount in the worked case is an original fictional USD planning assumption. It is not an industry benchmark, a customer result or a prediction.

Choose a method that matches the evidence you have

For repeat services, begin with opening customers, expected completed work and known renewals. For a product line, use expected sold units and net unit prices. For a qualified pipeline, sum opportunity value multiplied by a documented close probability for the relevant period. Historical growth can supply a baseline, but unexplained percentage growth is not customer evidence.

Forecast sales = Σ(expected units × net unit price). A weighted pipeline is an expectation across uncertain outcomes, not a promise that a fractional contract will close. Do not add the same sale again when it appears in both a customer schedule and the pipeline.

Build a two-offer month before applying a growth rate

The team has 160 scheduled worker-hours, of which 80% are realistically productive: 128 hours. The base case uses every productive hour. A target of 60 recurring jobs and 12 one-off jobs would need 168 hours, so demand or sales ambition alone cannot support it. Keep worker-hours distinct from elapsed clock hours when several people attend a job.

Use scenarios that change the actual drivers

The upside is a demand case, not an executable delivery forecast. It needs 32 more productive hours, a revised offer mix or rescheduling. If overtime or contractors add cost, update contribution and cash along with sales. If cancellations are already incorporated in completed-job assumptions, do not subtract them a second time.

Separate signed work, delivered revenue and cash received

A signed $3,000 agreement in November might be delivered in December and collected in January. Keep separate columns for signed bookings, the revenue period under the applicable accounting treatment, and the expected receipt date. The illustrative tables use completed service work as the sales basis; they are not tax-method guidance.

Once sales are built, send dated receipts into the cash-flow forecast. Use the rolling forecast guide to update the horizon as actual months close. These are linked tasks, not interchangeable templates.

Measure forecast error and improve the assumptions

Freeze a dated forecast version before the month begins. Compare actual units, net price, mix, cancellations and timing against that version. If actual revenue is $10,200 against $10,800, the dollar error is −$600 and the shortfall versus forecast is 5.56%. This stated denominator is forecast revenue; a metric using actual revenue would produce a different percentage.

Review persistent bias rather than rewriting the old forecast to match actuals. For a new business, replace weak assumptions with paid pilots, signed scope, customer interviews and observed conversion rates as evidence accumulates. Retain the source date and owner of each assumption in the business plan evidence register.

Use the worksheet with your own records

Download the printable, editable HTML worksheet. It contains the completed example and a blank table. Open it in a browser, edit the blank fields, calculate the outputs using the stated method and print to PDF or paper. It does not automatically calculate results or replace your accounting records.

Method references and source notes

The method references below support the definitions. The examples, assumptions and decision checks on this page are independently constructed.

• Salesforce: forecasting methods and review process