Nuts and Bolts - Measuring Price Effect

    Ever wonder how pricing decisions actually impact your bottom line? Let’s pull back the curtain and look at the math that makes it all tick. Just like we discussed last week, it all starts with two key time periods: the base and the current.

The base period is your foundation — the sum of all revenue during that time. It’s what we measure against. The current period is where we’ve landed. Everything in between tells the story of what changed and why.

By focusing on both price changes and purchase volumes data, we can calculate what occurred. It’s a bit like Moneyball — one of my favorite books. In Moneyball, baseball stats are treated like financial derivatives — small slices of performance that help predict outcomes. When a player hits a ball to a specific spot with a certain speed, analysts can forecast the expected result. Similarly, in pricing, we can measure the expected impact of a change and compare it to what materialized.

Once we’ve defined our time periods, the next step is to break down the formula. We usually start by aggregating data at the customer-part level — or sometimes the customer-contract level, depending on your business. The idea is to pair each customer with the smallest unit of measure relevant to your pricing.

From there, we calculate the average selling price (ASP). The best way I’ve found is to sum all revenue and divide it by total quantity sold. This gives you a weighted ASP, which accounts for different price points across volumes.

You’ll do this for both the base and current periods. Then, compare the two ASPs:

This tells you how much revenue was gained (or lost) due to price changes. Notice if a customer did not make a purchase in the current or base period then we cannot measure the price changes.

Here’s a quick example to bring it to life:

  • Base Period: Customer 1 buys 100 units of Widget A at $10 → $1,000 revenue → ASP = $10
  • Current Period: Customer 1 buys 110 units at $11 → $1,210 revenue → ASP = $11
  • Price Effect: ($11 - $10) × 110 = $110 uplift

Generated Image

This is just the first piece of the puzzle, but it’s a powerful one. This is just the beginning. In future posts, we’ll explore how volume and mix play into the story — and how you can use these insights to sharpen your pricing strategy.

Comments

Post a Comment

Popular posts from this blog

Intro

     After three years working in pricing—alongside a background in natural resource economics and a master’s in applied econometrics—I’ve come to see pricing as one of the most fascinating areas in business. It’s not just about supply and demand curves or profit maximization. In practice, pricing is messy, nuanced, and deeply human. That complexity is what makes it so compelling. I’ve wanted to document my journey and growth in this field, especially the patterns I’ve observed. As "pricers", we often focus on the exciting parts: choosing between value-based, cost-plus, or competitive models (and interesting variations such as good, better, best). Or speculating on how AI might transform pricing strategy, execution and analytics. But we also dig into the gritty details—the DNA of our systems—where real change happens. Early on, I felt lost. I didn’t know how to measure whether our pricing was working. That’s when I discovered revenue bridges and the power of using them fo...
Read more

Assessing Averages

Image
     I really love statistics. They’re all over the place business, economics, the grocery store — average cost per ounce, sale prices, distribution. But here’s the funny thing about some of the averages: the “ASP,” or Average Sale Price, is just that — an average. And if you’re not careful, you can end up averaging the averages. Think about it. Instead of saying, we did half a million dollars in revenue, sold 50,000 units, which equates to $10 per unit , what often happens is someone takes the, say 8 thousand transactions that the revenue happened over — a spread of prices — and averages those transaction-level averages. Suddenly, you’re looking at $9 or $12.50 instead of the true $10. That’s not just sloppy math; it’s misleading. Even weighted ASPs—which I recommend using in pricing—while technically correct, can still hide the real story. Dan Heath talks about this idea of untangling averages in his book “Reset”. His example comes from the military’s attempt to des...
Read more

Revenue Bridge?

Image
       Revenue bridges might not be carved from granite — but they’re just as solid when built on comparison. They’re built on the comparison of prices, volume, product mix. We compare constantly — especially in sports. Yankees vs. Dodgers. Jordan or LeBron. Scheffler vs. Tiger (too soon?) In the 1500s, Pope Leo X had a beloved white elephant named Hanno, living in luxury at the Vatican. Then came Ganda — a rhinoceros, the first seen in Europe in over a thousand years. Naturally, the Pope staged a showdown to answer the question of which animal was superior. Ganda charged. Hanno fled. The Pope laughed and after calling the rhino ‘a beast of Satan,’ was shipped off (but sadly didn’t survive the journey). Ganda lived on; however, in Albrecht Dürer’s famous woodcut — armor-plated and horned, despite the artist never seeing a rhino. Hanno remained the Pope's prized animal.  In business, we’re lucky to have more reliable comparisons than an elephant to a rhino. Rev...
Read more