Price Increase Scenario
Use current unit price, price increase (%), current period units, expected unit decline (%) to prepare the price increase scenario record. The worksheet applies the displayed arithmetic to your supplied values; it does not retrieve account data.
Use current unit price, price increase (%), current period units, expected unit decline (%) to prepare the price increase scenario record. The worksheet applies the displayed arithmetic to your supplied values; it does not retrieve account data.
Protecting contribution before accepting a price
This worksheet calculates the displayed relationship from the supplied quantities. Its label and period conventions determine how the amount should be interpreted. A quote can meet a revenue target and still leave too little to cover delivery. Separate the selling-price denominator from the cost denominator: margin and markup answer different questions. A discount changes contribution even when the supplier cost stays fixed.
Scope of this operation
The figure includes only the listed inputs. It does not add unlisted tax, overhead, provider charges or conversion losses. Negative results can represent a shortfall or the signed difference between options. The example output for price increase scenario is shown below so the supplied source can be checked against the actual format. It is not evidence that the operation has run against your own file or account.
How it works
Revenue change = [Current unit price] × (1 + [Price increase (%)] ÷ 100) × [Current period units] × (1 − [Expected unit decline (%)] ÷ 100) − [Current unit price] × [Current period units]
Inputs
| Field | Example | Definition |
|---|---|---|
| Current unit price | 100 | Use current unit price on the currency and period basis shown by the formula. Keep gross amounts, net amounts and unit amounts distinct; the page does not fetch a price or exchange rate. |
| Price increase (%) | 10 | Enter price increase (%) on the percentage scale used in the formula (20 means 20%, not 0.20). Keep its base and reporting period consistent with the other inputs. |
| Current period units | 100 | Use the source quantity represented by current period units. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Expected unit decline (%) | 5 | Enter expected unit decline (%) on the percentage scale used in the formula (20 means 20%, not 0.20). Keep its base and reporting period consistent with the other inputs. |
Step-by-step guide
Prepare the source
Supply Current unit price, Price increase (%), Current period units. Keep the original material so the output can be compared with it.
Build output
Check Current unit price, Price increase (%), then select Generate output.
Use the result
Compare the price increase scenario result with the unchanged source before copying or downloading it.
When to use it
Revenue change = [Current unit price] × (1 + [Price increase (%)] ÷ 100) × [Current period units] × (1 − [Expected unit decline (%)] ÷ 100) − [Current unit price] × [Current period units] The figure includes only the listed inputs. It does not add unlisted tax, overhead, provider charges or conversion losses. Negative results can represent a shortfall or the signed difference between options.
Example and scope
Example inputs: Current unit price: 100; Price increase (%): 10; Current period units: 100; Expected unit decline (%): 5.
The figure includes only the listed inputs. It does not add unlisted tax, overhead, provider charges or conversion losses. Negative results can represent a shortfall or the signed difference between options.
Worked output
Revenue change: 450 Assumptions: price: 100 increase: 10 units: 100 volume_loss: 5
Related tool family
This focused tool is associated with Target Margin Pricing Calculator. Use it when you need to isolate a specific part of that wider workflow.
Several parent models may support the same step. Keep the business question visible and choose the version that best matches the process you actually need to manage.
Related parent models
Target Margin Pricing Calculator, Target Contribution Margin Calculator, Price Increase Revenue Impact Calculator, Minimum Selling Price Calculator, Quote Profitability Calculator, Minimum Order Value Calculator
Keep the displayed formula, input units and model scope with the result. Corrections or questions can be sent through the request section on this page.
Content updated: October 11, 2026