Account Price Dispersion Test

Test how realized prices vary across comparable B2B accounts and where the entered contribution exposure is concentrated.

About this analysis

Enter comparable account volumes, realized prices, variable costs, and account reference prices. The calculation weights price dispersion by account volume, ranks price-gap exposure, and tests how much of the entered reference gap would need to be recovered to reach a contribution target. Reference prices are entered by the user and are not treated as forecast outcomes. For more information, visit our B2B pricing consultants page.

Weighted realized price $108.38 Volume-weighted across entered accounts
Weighted price dispersion 3.49% Weighted standard deviation divided by weighted realized price
Volume below reference 87.9% Share of entered units priced below account reference
Contribution exposure $271K Entered reference gap multiplied by account volume
Accounts driving 80% 3 Minimum ranked accounts required to reach at least 80% of exposure

Account dispersion

The blue marker is realized price. The white marker is the entered account reference price.

Account A
$108.00 Realized
$112.00 Reference
Account B
$104.00 Realized
$112.00 Reference
Account C
$116.00 Realized
$112.00 Reference
Account D
$109.00 Realized
$112.00 Reference
Account E
$111.00 Realized
$112.00 Reference

Account economics

Accounts are ranked by entered price-gap exposure so the largest economic differences appear first.

Account Units Realized price Reference price Price gap Unit contribution Exposure
Account B 21,000 $104.00 $112.00 $8.00 $44.00 $168K
Account A 12,000 $108.00 $112.00 $4.00 $47.00 $48K
Account D 15,000 $109.00 $112.00 $3.00 $50.00 $45K
Account E 10,000 $111.00 $112.00 $1.00 $49.00 $10K
Account C 8,000 $116.00 $112.00 $0.00 $53.00 $0

Exposure concentration

Exposure is ranked from largest to smallest using only positive gaps between entered reference price and realized price.

Largest account exposure 62.0% Account B represents $168,000 of entered exposure
Top three exposure share 96.3% Share of exposure represented by the three largest account gaps
Accounts driving 80% 3 Minimum ranked accounts required to reach at least 80% of total exposure
Account B
62.0%
$168K
Account A
79.7%
$48K
Account D
96.3%
$45K
Account E
100.0%
$10K

Price recovery sensitivity

Recovery share applies only to the entered positive account price gaps. It does not assume the entered reference prices can be achieved.

Reference gap recovered 50.0% Entered sensitivity applied to total account price-gap exposure
Contribution recovery $135.5K Contribution represented by the entered recovery sensitivity
Required recovery rate 36.9% Share of entered exposure required to reach the $100,000 contribution target

What the interactive shows

Entered price differences are concentrated rather than evenly distributed. Account B alone represents 62.0% of the $271,000 contribution exposure.

Three accounts represent 96.3% of total exposure, while 87.9% of entered volume is priced below its account reference. Recovering 36.9% of the total entered price gap would equal the $100,000 contribution target.

City Shift Finance

Create your account

Continue your analyses, email calculation records, and return to your work from one account.

Have an account?

Contact us

Contact us

Contact

Topics of Interest:

Sign up to download