On this page
A price increase improves contribution per sale when unit costs stay fixed, but it may also change the number of sales. A price-volume sensitivity table keeps those two assumptions visible. It does not predict customer behavior. Each cell asks what the operating result would be if a particular price and volume combination occurred.
Modeled operating profit = units sold × (price − variable cost per unit) − fixed costs
Build the grid from one consistent cost model
Assume a hypothetical product has $24 of variable cost per unit and $6,000 of fixed monthly costs. Test prices of $40, $44, and $48 against monthly volumes of 300, 400, and 500 units. At $44 and 400 units, contribution is $20 per unit and operating profit is 400 × $20 − $6,000 = $2,000.
| Monthly units | Profit at $40 | Profit at $44 | Profit at $48 |
|---|---|---|---|
| 300 | −$1,200 | $0 | $1,200 |
| 400 | $400 | $2,000 | $3,600 |
| 500 | $2,000 | $4,000 | $6,000 |
The $40-to-$44 change is a 10% price increase measured against the original $40 price. Contribution per unit rises from $16 to $20, a 25% increase measured against the original $16 contribution. Those percentages differ because they have different denominators. Neither is a margin or markup percentage.
Find the volume that preserves contribution
At the original $40 price and 400 units, total contribution is $6,400. At $44, the same contribution requires $6,400 divided by $20, or 320 units. That is 20% fewer units than 400. This is a mathematical threshold under unchanged unit costs and fixed costs, not a prediction that customers will accept the higher price or that a 20% decline is acceptable for other reasons.
If percentage-based payment fees change with price, include them in the unit contribution formula rather than holding the entire variable cost flat. If higher volume triggers a new shift or warehouse charge, the fixed-cost assumption must also change in the affected cells. A clean grid should not hide those step changes.
Choose scenarios with evidence
Use actual quote outcomes, conversion records, order histories, or a defined test to select plausible volume ranges. Do not label an invented demand response as a market elasticity. Separate customer segments when a price change may affect them differently, especially if their variable costs and order sizes also differ.
Preserve negative results and identify combinations outside available capacity. A profitable cell that requires 500 units cannot be treated as feasible if only 350 can be delivered. The table estimates operating profit for the stated period; it does not establish cash timing, long-term demand, or guaranteed earnings. Connect the selected scenario to a capacity plan and collection schedule before using it operationally.
Method references: OpenStax: Break-Even Sensitivity Analysis. Accessed October 22, 2026. All dollar figures are hypothetical worked examples.
Related calculators & guides
- Cost Inflation Scenarios by Cost Component
- Build Base, Downside and Upside Scenarios
- Price and Volume Variance: Reconcile Revenue
- Break-Even Sensitivity and Impossible Results
- Cash Stress Testing: Shift Dates and Amounts
- Scenario Probabilities and Expected Profit
- Forecast vs Budget: Explain the Difference
- Capacity Constraints in Profit Scenarios
- Set Decision Triggers from Scenario Assumptions
- Profit Scenario Calculator
- Cash Stress Calculator
- Price and Volume Profit Scenario Grid
- Cash Flow and Scenario Planning
Report an error
Thank you! Your feedback helps us make this page better.
Could not send. Please try again.