Pricing Scenario Comparison
Use a unit price, a period units, b unit price, b period units, variable cost per unit to prepare the pricing scenario comparison record. The worksheet applies the displayed arithmetic to your supplied values; it does not retrieve account data.
Use a unit price, a period units, b unit price, b period units, variable cost per unit to prepare the pricing scenario comparison 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 pricing scenario comparison 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
Contribution change: B minus A = ([B unit price] − [Variable cost per unit]) × [B period units] − ([A unit price] − [Variable cost per unit]) × [A period units]
Inputs
| Field | Example | Definition |
|---|---|---|
| A unit price | 100 | Use a 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. |
| A period units | 100 | Use the source quantity represented by a period units. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| B unit price | 110 | Use b 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. |
| B period units | 95 | Use the source quantity represented by b period units. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Variable cost per unit | 50 | Use variable cost per unit 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. |
Step-by-step guide
Prepare the source
Supply A unit price, A period units, B unit price. Keep the original material so the output can be compared with it.
Build output
Check A unit price, A period units, then select Generate output.
Use the result
Compare the pricing scenario comparison result with the unchanged source before copying or downloading it.
When to use it
Contribution change: B minus A = ([B unit price] − [Variable cost per unit]) × [B period units] − ([A unit price] − [Variable cost per unit]) × [A 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: A unit price: 100; A period units: 100; B unit price: 110; B period units: 95; Variable cost per unit: 50.
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
Contribution change: B minus A: 700 Assumptions: price_a: 100 units_a: 100 price_b: 110 units_b: 95 unit_cost: 50
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, Cost Plus Pricing Calculator, Tiered Pricing 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