Blog · Forecast and pipeline · Sales teams
Separate internal execution changes from external demand assumptions when sales miss the forecast. Build a checked price and volume bridge, then investigate the evidence behind each movement.
Internal and external factors affecting sales forecasting change the units customers buy, the price realized and the period in which sales occur. Separate what changed inside the business from what changed in its market, then measure the forecast miss before assigning an explanation.
The useful output is a checked sales bridge and a short list of assumptions to change. A list of economic conditions alone does not show which product or region needs attention.
Internal factors include account coverage, seller capacity, discount decisions, promotion execution, product availability and delivery performance. External factors include customer spending plans, competing offers, financing conditions, regulations and changes in the market's buying calendar.
The distinction guides the response. A missed launch milestone needs an internal recovery plan. A customer delaying a capital purchase may require a different timing assumption. A stockout can reflect an internal purchasing decision, a supplier disruption or both.
| Factor | Evidence to record | Assumption being tested | Likely review owner |
|---|---|---|---|
| Seller coverage | Assigned accounts and active selling days | Planned accounts can receive attention | Sales operations |
| Price and discounts | Quoted and realized net prices | Planned price will hold | Sales and finance |
| Availability | Orders, stockouts and delivery dates | Supply can fulfill forecast demand | Operations |
| Customer demand | Customer orders and documented budget changes | Buyers will purchase in the period | Account leaders |
| Competition | Dated win/loss evidence | Expected share remains attainable | Commercial leadership |
| Market conditions | Relevant industry series and release dates | External demand assumption remains reasonable | Finance |
Do not turn broad indicators into a company growth assumption automatically. The Census Bureau's retail definitions state that published dollar values are in current dollars and are not adjusted to a constant-dollar series. A rise in market sales dollars can therefore include price changes rather than higher unit demand.
Start with the estimate approved before the sales period. Keep its forecast date and version. Preserve the product, region, period, units and net unit price used to build it, then add the same fields from actual-sales records.
Use consistent units and a common USD basis. If a product changes pack size, convert to comparable units before comparing quantities. Match returns and credits to the sales definition finance approved. Missing prices need investigation; replacing them with zero creates a fictitious price collapse.
Keep a separate assumption register with the factor, expected change, source date, affected products or regions, owner and review date. This separates information available at forecast time from explanations written afterward. Keep forecast categories consistent if the underlying estimate comes from opportunity records.
Consider an illustrative US distributor's September product-region export. Each row represents one comparable product and region, and net unit prices exclude sales taxes.
| Product and region | Forecast units | Forecast price (USD/unit) | Actual units | Actual price (USD/unit) | Forecast sales (USD) | Actual sales (USD) |
|---|---|---|---|---|---|---|
| Filters, East | 1,000 | 100 | 900 | 105 | 100,000 | 94,500 |
| Pumps, West | 600 | 200 | 550 | 190 | 120,000 | 104,500 |
| Valves, Central | 800 | 150 | 880 | 150 | 120,000 | 132,000 |
| Total | 340,000 | 331,000 |
Sales equal units multiplied by net unit price. To explain the difference without double counting, use the following ordering:
Volume effect = (Actual units - Forecast units) × Forecast price
Price effect = Actual units × (Actual price - Forecast price)
Sales variance = Volume effect + Price effect
The price effect uses actual units, so the interaction between changed price and changed volume is included exactly once. These calculations are an arithmetic decomposition, not an estimate of price elasticity.
| Product and region | Volume effect (USD) | Price effect (USD) | Actual minus forecast (USD) |
|---|---|---|---|
| Filters, East | -10,000 | 4,500 | -5,500 |
| Pumps, West | -10,000 | -5,500 | -15,500 |
| Valves, Central | 12,000 | 0 | 12,000 |
| Total | -8,000 | -1,000 | -9,000 |
For filters, the volume effect is (900 - 1,000) × 100 = -$10,000, and the price effect is 900 × (105 - 100) = $4,500. Together they produce the $5,500 shortfall.
The company check is 340,000 - 8,000 - 1,000 = $331,000, matching actual sales. All amounts are exact whole-dollar figures; no rounding is needed. The sales forecast template provides the neighboring baseline and pipeline structure if the forecast still needs assembling.
Suppose the assumption register records an East price change, West delivery constraints and a Central customer promotion. The bridge gives each investigation a location, but it does not prove those events caused the results.
Check the filter price change against invoices and discounts. Check the pump shortfall against customer cancellations, delivery dates and open orders. Check whether Central's stronger volume came from promoted accounts or from unrelated customers. A difference moving into the next month is a timing issue; a canceled order is a different outcome.
The forecasting authors Hyndman and Athanasopoulos distinguish correlation from causation: a variable may help predict another without causing it. Use phrases such as "coincided with" or "is consistent with" until the evidence supports a stronger claim.
The deal-by-deal forecast bridge handles opportunity movements when deal timing is the underlying issue.
Sales operations should coordinate the review, while finance verifies that the total uses the agreed sales measure. The commercial owner decides whether to change customer coverage, discount assumptions or the expected closing period. Operations verifies whether supply constraints persist.
Record the next action beside the assumption: maintain it, replace it with documented evidence, or keep a range because uncertainty remains. Revisit the decision in the next completed period. An explanation is useful when it changes a future assumption or an accountable business action.
Bring your forecast, actual sales and recorded business assumptions as a file or Google Sheet; Covirage maps the columns, and its tools compute and check the figures. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data; account creation takes about a minute.
See forecast analysis for the supporting business context.
Internal factors arise from the company's decisions or execution, such as staffing, discounts and fulfillment capacity. External factors arise outside its control, such as customer budgets and competitor activity. Some outcomes reflect both, so record evidence before assigning responsibility for a miss.
A correlation identifies a relationship worth investigating, but it does not establish cause. A promotion and stronger sales may share a seasonal influence. Compare timing, comparable groups, customer records and other changes before attributing the difference to a particular action.
Sales operations should coordinate the assumption register and forecast snapshot. Sales leaders own execution assumptions, operations owns availability evidence, and finance owns sales definitions and reconciliation. Assign a named owner and review date to each material assumption rather than giving the whole forecast one owner.