Applied experience
From enquiry data to a practical revenue forecast
B2B manufacturing | Commercial forecasting | Data analysis
How historical commercial data helped a UK B2B manufacturer move from management instinct towards a repeatable, evidence-led forecasting approach.
Summary
A UK B2B manufacturer held several years of enquiry, order and turnover data, but forecasting continued to rely heavily on the opening order book, current trading conditions and experienced management judgement.
Those inputs remained important, but the business wanted to understand whether enquiry activity could provide an earlier and more consistent indication of future revenue.
The objective was not to replace commercial judgement with a statistical model. It was to test whether the data contained a useful forward-looking signal and, if so, build it into a practical management forecasting process.
Context
The commercial context
The business operated across several commercially distinct customer, product and market segments.
Some opportunities converted relatively quickly, while others involved larger values, more technical requirements and longer sales cycles. Combining every enquiry into one headline measure risked obscuring the patterns management was trying to identify.
The forecasting process therefore needed to reflect how the business actually traded rather than treating every enquiry as commercially equivalent.
The brief
The question
Could current enquiry activity provide an earlier indication of future turnover?
Answering that question required more than comparing two headline totals. The analysis needed to determine:
- —
whether enquiry activity tended to lead turnover
- —
which business segments showed the clearest relationship
- —
whether slower-converting or technically complex enquiries distorted the signal
- —
how stable the relationship was across the available history
- —
whether the result was strong enough to support a practical forecast
- —
how the model should be combined with wider commercial knowledge and judgement
Inputs
The data reviewed
More than three years of monthly enquiry and turnover history was reviewed. The available information included:
- —
monthly enquiry values
- —
enquiry dates
- —
product and business-stream classifications
- —
customer and sector information
- —
monthly delivered turnover
- —
opening order-book positions
- —
known higher-value and slower-converting opportunities
Before any relationship was tested, the data was cleaned and segmented.
Structurally different business streams were reviewed separately, and selected technical or unusually slow-converting enquiry categories were tested to understand whether they weakened the usefulness of the shorter-term forecast signal.
Method
The analytical approach
Prior-month enquiry activity was compared with the following month’s turnover.
Pearson’s correlation coefficient was used to assess the strength and direction of the relationship. Regression analysis was then applied to determine whether the relationship could support a practical forecasting input rather than simply describe a historic association.
The analysis included:
- —
documented inclusion and exclusion rules
- —
segmentation of commercially different business streams
- —
testing of enquiry value against following-month turnover
- —
review of alternative time lags
- —
comparison of stronger and weaker commercial segments
- —
sensitivity testing around unusually large enquiries
- —
regression analysis
- —
historical backtesting
- —
review alongside the opening order book and current order intake
Result
The finding
Within the selected non-partitioning business stream, the analysis identified a clear positive relationship between enquiry activity and following-month turnover.
The initial analysis produced a Pearson correlation of approximately 0.70, indicating that stronger enquiry months had generally been followed by stronger turnover months within that part of the business.
This did not mean that enquiry value alone determined future sales. Customer mix, opportunity quality, quotation size, timing and conversion behaviour continued to affect the result.
It did, however, provide a sufficiently useful forward-looking signal to strengthen the monthly forecasting process.
Methodology noteCorrelation was treated as evidence of an association, not proof that enquiry activity caused future turnover.
Application
From analysis to application
The tested relationship is now used as part of the business’s monthly revenue forecasting process.
It does not operate as a standalone forecast. It is considered alongside the opening order book, current-month order intake, customer and segment knowledge, known exceptional opportunities, recent conversion behaviour and management judgement.
The combined approach is used to support low, central and high forecast ranges rather than a single fixed outcome.
- —
the opening order book
- —
current-month order intake
- —
customer and segment knowledge
- —
known exceptional opportunities
- —
recent conversion behaviour
- —
management judgement
- —
low, central and high forecast ranges
The resulting process did not rely on one number.
Instead, it combined several commercial indicators into a more structured view of likely turnover.
Forecasting framework
Impact
The outcome
The main outcome was not simply the identification of a statistical relationship. The evidence was converted into a repeatable forecasting input that is now used within the monthly management process.
It has helped management to:
- —
obtain an earlier view of likely revenue direction
- —
challenge forecasts with evidence rather than instinct alone
- —
identify when enquiry activity sits outside its normal range
- —
distinguish genuine commercial signals from short-term noise
- —
improve the structure of monthly forecast discussions
- —
document the assumptions behind the forecast
- —
recognise when management judgement should override or adjust the model
- —
monitor whether the relationship remains stable over time
The model supports management judgement rather than replacing it.
Reflection
The commercial lesson
A statistically valid result is not automatically a commercially useful result. The value of the exercise came from combining five elements:
- 01
understanding how the business actually sells
- 02
separating commercially different types of activity
- 03
testing the evidence with an appropriate method
- 04
documenting the assumptions and limitations
- 05
translating the result into a forecasting process managers could use
“The objective was not to replace commercial judgement. It was to make that judgement better informed.”
Relevance
Why this matters
Many B2B firms already hold years of enquiry, quotation, pipeline and turnover data.
The difficulty is not always a lack of information. It is knowing which parts of that information contain a meaningful signal, which relationships are commercially relevant and how the findings should influence management decisions.
This case demonstrates the Xenon Insight approach:
LimitationsThe relationship identified was specific to the business stream, time period and data analysed. It should not be assumed that the same relationship will exist in every business or commercial environment.
The value of the analysis came from testing the organisation’s own commercial data, documenting the assumptions and interpreting the result within the context of how the business actually sells.
This case study is based on anonymised commercial work undertaken within a live UK B2B manufacturing environment. Business, customer and commercially sensitive details have been removed or generalised.
Related case study
From account chasing to evidence-led opportunity management
Next step
Could your existing commercial data provide an earlier view of future revenue?
The relationship identified in this case study was specific to that business, its market and the data available. The same signal should never be assumed to exist elsewhere without testing.
The Xenon Commercial Predictability Health Check provides a low-risk way to assess whether your own sales, enquiry, quotation or pipeline data contains useful forward-looking signals.
Commercial Predictability Health Check — £495 one-offFounding 10 offer