Test whether a price increase still protects gross profit after realization, rollout timing, demand response, and input-cost inflation move at different rates.
About this interactive
The analysis starts with the current revenue and cost base, then separates the financial effect of realized pricing, the share of revenue actually repriced during the period, volume movement on repriced business, and inflation on the exposed cost base. It calculates the list-price increase required to hold gross-profit dollars, the increase required to preserve the starting gross-margin rate, and the volume break point at which the entered pricing plan stops protecting gross-profit dollars. For more information, visit Pricing and Revenue Management.
Management assumptions
No elasticity or pricing benchmark is imposed. Realization, rollout, demand response, and cost exposure are entered management assumptions.
Baseline revenue and variable cost establish the gross-profit position before the entered price and cost movements.
Rollout, demand, and cost exposure determine how much of the nominal price action reaches the period economics.
Realized price change
6.80%
on repriced business
Gross-profit impact
+$102,641
annualized vs baseline
Gross-margin rate
45.82%
45.00% baseline
Volume break point
−8.49%
GP dollars equal baseline
Gross-profit bridge
The three effects add exactly to the change in gross-profit dollars from the baseline under the entered assumptions.
Decision thresholds
Thresholds incorporate the entered realization, rollout coverage, volume response, and cost exposure rather than assuming a fully realized price increase at flat volume.
At the entered assumptions, the pricing action clears both thresholds and can absorb a larger volume decline before gross-profit dollars fall below baseline.
What the interactive shows
At 85% realization and 75% rollout, the 8% list increase produces a 6.8% realized increase on repriced business. After a 3% volume decline and 5% inflation on 70% of the variable cost base, annual gross profit is $102,641 above baseline.
Gross-profit dollars return to baseline at an 8.49% decline in repriced volume, leaving 5.49 percentage points of demand cushion under the entered case.
PRICE INCREASE MARGIN RECOVERY ANALYZER — ILLUSTRATIVE DEFAULT RECORD INPUTS Annual baseline revenue: $5,000,000 Variable cost share: 55.00% List price increase: 8.00% Expected price realization: 85.00% Revenue repriced in period: 75.00% Volume change on repriced business: -3.00% Cost base affected by inflation: 70.00% Input cost increase: 5.00% COMPUTED POSITION Baseline gross profit: $2,250,000 Baseline gross-margin rate: 45.00% Realized price change on repriced business: 6.80% Projected revenue: $5,134,850 Projected variable cost: $2,782,209 Projected gross profit: $2,352,641 Projected gross-margin rate: 45.82% GROSS-PROFIT BRIDGE Price realization / rollout effect: +$255,000 Volume response effect: -$58,275 Input-cost inflation effect: -$94,084 Net gross-profit change: +$102,641 DECISION THRESHOLDS Minimum list increase to hold gross-profit dollars: 4.68% Minimum list increase to preserve gross-margin rate: 5.53% Volume break point for gross-profit dollars: -8.49% Demand cushion vs entered volume response: 5.49 percentage points FINDING At 85% realization and 75% rollout, the 8% list increase produces a 6.8% realized increase on repriced business. After a 3% volume decline and 5% inflation on 70% of the variable cost base, annual gross profit is $102,641 above baseline. Gross-profit dollars return to baseline at an 8.49% decline in repriced volume, leaving 5.49 percentage points of demand cushion under the entered case. METHOD STATUS Management-entered assumptions. Exact gross-profit bridge using realized pricing, rollout coverage, volume response, and affected-cost inflation. Thresholds solve the same entered-case equations for the list-price increase or volume change that returns gross-profit dollars or gross-margin rate to baseline. No external benchmark is used.
Continue your analyses, email calculation records, and return to your work from one account.
By creating an account, you agree to the Terms of Use and acknowledge the Privacy Policy.
Enter the 6-digit code sent to .
