FP&A and Management Reporting

How to Forecast Gross Margin by Product, Customer or Business Unit

How to Forecast Gross Margin by Product, Customer or Business Unit becomes relevant when management needs a decision-grade view of revenue mix, direct costs and contribution economics rather than another accounting output.

For companies with multiple products, the finance question in gross margin forecasting is whether the current process produces enough visibility to act before cash, margin or financing constraints become visible in the historical accounts.

Financely's fractional CFO services work can address gross margin forecasting by connecting reporting, forecasting and capital decisions to the operating requirements behind gross margin by segment.

Where the issue sits in the operating model in gross margin forecasting

Gross margin forecasting sits inside a broader operating model, so the analysis should begin by mapping the handoffs that create or consume the relevant financial information.

For companies with multiple products, the important question is where revenue mix, direct costs and contribution economics enters the workflow and who has authority to change it within the gross margin forecasting operating model.

The evidence needed before changing the process for gross margin forecasting

Before redesigning gross margin forecasting, collect enough historical evidence to distinguish a recurring pattern from an isolated event. Three clean periods are often more informative than one highly detailed month in a gross margin forecasting implementation.

The history should reconcile to gross margin by segment so the redesign starts from measurable behavior rather than anecdotes in a gross margin forecasting implementation.

Primary management metricgross margin by segmentOperating focusrevenue mix, direct costs and contribution economicsControl riskforecasting one blended margin across dissimilar revenue streams

Build a base case that reconciles to actuals when assessing gross margin forecasting

The base case for gross margin forecasting should reproduce recent actual performance before it is allowed to forecast the future. A model that cannot explain the recent past has little credibility in a downside scenario during the gross margin forecasting review.

Once reconciled, the model can test how forecasting one blended margin across dissimilar revenue streams changes the result and how quickly management would see the effect during the gross margin forecasting review.

Add the downside case management will actually face behind gross margin forecasting

The downside case for gross margin forecasting should be operationally plausible, not an arbitrary percentage reduction. The stress needs to describe what changes in volumes, timing, collections, conversion or cost for management of gross margin forecasting.

That makes the impact on gross margin by segment useful for management planning and lender or board discussions for management of gross margin forecasting.

Control note for gross margin forecasting

The working file for gross margin forecasting should preserve definitions, source references and decision assumptions so another reviewer can reproduce the conclusion without oral context.

Monitor the variables with the highest cash impact before implementing gross margin forecasting

Monitoring should concentrate on the two or three variables with the highest cash or conversion sensitivity in the gross margin forecasting analysis. A large dashboard can obscure the signal that actually matters in the gross margin forecasting analysis.

For gross margin forecasting, the monitoring design should flag the early conditions that precede forecasting one blended margin across dissimilar revenue streams rather than waiting for the final outcome.

Close the loop through reporting during execution of gross margin forecasting

The reporting loop should close with an owner and an action when reviewing gross margin forecasting. If a variance in gross margin by segment has no consequence, management will quickly stop treating the report as a decision tool when reviewing gross margin forecasting.

Financely's article on KPI design provides related operating context, and fractional CFO support for capital raising is available for implementation support when reviewing gross margin forecasting.

• Assign an accountable owner for the operating inputs used in gross margin forecasting under review cycle 4.
• Reconcile the gross margin forecasting analysis to source financial or operational records before circulation under review cycle 4.
• Define a management threshold for gross margin by segment that triggers a specific response under review cycle 4.
• Document how forecasting one blended margin across dissimilar revenue streams changes the downside case for gross margin forecasting under review cycle 4.

What good execution looks like after 90 days after gross margin forecasting is in place

Ninety days after implementing gross margin forecasting, management should be able to compare forecast, actual result and corrective action in one review. That is the point at which the process becomes accountable for the gross margin forecasting decision.

For companies with multiple products, repeatability matters more than producing a sophisticated one-time analysis for the gross margin forecasting decision.

Apply the analysis to gross margin forecasting

If gross margin forecasting is becoming a management bottleneck, Financely can build the finance process, reporting and decision framework around the operating requirements of the business.

Discuss Fractional CFO Support