Revenue Target Gap
Use period revenue target, forecast period revenue to prepare the revenue target gap record. The worksheet applies the displayed arithmetic to your supplied values; it does not retrieve account data.
Use period revenue target, forecast period revenue to prepare the revenue target gap record. The worksheet applies the displayed arithmetic to your supplied values; it does not retrieve account data.
Turning the revenue target into a measurable sales workload
This worksheet calculates the displayed relationship from the supplied quantities. Its label and period conventions determine how the amount should be interpreted. Pipeline planning joins deal value, conversion and time. The model should use opportunities that meet a defined qualification stage, rather than every contact in the CRM. Deal concentration matters when a few large accounts dominate an average.
Scope of this operation
The figure includes only the listed inputs. It does not add unlisted tax, overhead, provider charges or conversion losses. Negative results can represent a shortfall or the signed difference between options. The example output for revenue target gap is shown below so the supplied source can be checked against the actual format. It is not evidence that the operation has run against your own file or account.
How it works
Revenue gap = [Period revenue target] − [Forecast period revenue]
Inputs
| Field | Example | Definition |
|---|---|---|
| Period revenue target | 100000 | Use period revenue target on the currency and period basis shown by the formula. Keep gross amounts, net amounts and unit amounts distinct; the page does not fetch a price or exchange rate. |
| Forecast period revenue | 75000 | Use forecast period revenue on the currency and period basis shown by the formula. Keep gross amounts, net amounts and unit amounts distinct; the page does not fetch a price or exchange rate. |
Step-by-step guide
Prepare the source
Supply Period revenue target, Forecast period revenue. Keep the original material so the output can be compared with it.
Build output
Check Period revenue target, Forecast period revenue, then select Generate output.
Use the result
Compare the revenue target gap result with the unchanged source before copying or downloading it.
When to use it
Revenue gap = [Period revenue target] − [Forecast period revenue] The figure includes only the listed inputs. It does not add unlisted tax, overhead, provider charges or conversion losses. Negative results can represent a shortfall or the signed difference between options.
Example and scope
Example inputs: Period revenue target: 100000; Forecast period revenue: 75000.
The figure includes only the listed inputs. It does not add unlisted tax, overhead, provider charges or conversion losses. Negative results can represent a shortfall or the signed difference between options.
Worked output
Revenue gap: 25000 Assumptions: target: 100000 forecast: 75000
Related tool family
This focused tool is associated with Required Pipeline Calculator. Use it when you need to isolate a specific part of that wider workflow.
Several parent models may support the same step. Keep the business question visible and choose the version that best matches the process you actually need to manage.
Related parent models
Required Pipeline Calculator, Lead to Opportunity Conversion Calculator, Opportunity Win Rate Calculator, Average Deal Size Calculator, Sales Cycle Calculator, Revenue per Sales Rep Calculator, Sales Capacity Calculator
Keep the displayed formula, input units and model scope with the result. Corrections or questions can be sent through the request section on this page.