Scenarios
| Scenario | Price | Variable cost | Volume, units | Fixed costs | Result | Remove row |
|---|---|---|---|---|---|---|
| — | ||||||
| — | ||||||
| — |
Result
Average profit across scenarios
—
Your inputs are stored in this browser, so everything is still here next time. Nothing is sent to a server.
This calculation is for informational purposes only and does not replace advice from a qualified professional. Formulas and rates may not fit your exact situation — double-check the figures before making decisions.
How it is calculated
Profit for each scenario = (price − variable cost) × volume − fixed costs — computed separately for each row with its own figures. Average profit is a simple average of profit across all entered scenarios.
Scenario analysis differs from computing profit sensitivity to one variable in that it lets several parameters change at once and in different directions — for example, a pessimistic scenario can combine a lower price, a higher cost and a smaller sales volume all at once, not just one of those changes.
The spread between minimum and maximum profit across scenarios is a rough measure of result uncertainty: the wider it is relative to the average, the more the final profit depends on the assumptions baked into the scenarios rather than just the base plan.