FP Consultancy · INSIGHTS
Forecasting with scenarios
Use a base case and alternative scenarios to see which assumptions matter most to your financial outlook.
What does the forecast assume?
A forecast describes how you expect the business to perform given what you know today. Show the assumptions so readers can explore the uncertainty. Build alternatives around sales volume, price or capacity. Applying an arbitrary percentage to profit gives little indication of what would have to change.
Three possible outcomes
A business charges DKK 1,000 per service, incurs DKK 400 in variable costs per unit and has monthly fixed operating costs of DKK 100,000. Figures exclude VAT, interest and tax.
At 200 units, revenue is DKK 200,000 and variable costs are DKK 80,000, leaving operating profit of DKK 20,000. At 170 units, revenue falls to DKK 170,000 and variable costs to DKK 68,000. Profit falls to DKK 2,000.
At 230 units, revenue reaches DKK 230,000 and variable costs reach DKK 92,000. Profit rises to DKK 38,000, provided existing capacity can handle every order.
Test the assumptions
Only volume changes in this example. Holding prices and unit costs constant isolates the effect of demand. If higher volume requires extra staff, include the cost in the high case. If weaker demand means offering discounts, change the price in the low case.
Decide when to act
Agree when the order book warrants a capacity review or falling demand warrants a cost review. A lost order, a new supplier price or a revised delivery date can all justify updating the forecast before the next scheduled review.
Explain the outlook
Show the expected profit alongside its drivers. Scenarios carry no inherent probabilities, and their average need not represent the most likely outcome. FP Consultancy helps businesses explain the choices, constraints and consequences behind their forecasts.