3 Comments

Hey there,

You are right. To calculate price we use the change in price times current volume (aka column E).

I can see how the phrase "flexes for the unit change" can be confusing, we'll take at the wording.

Thanks for the comment and interest in the topic!

Drew

Expand full comment

Simple yet strong analysis 💪 It really does feel like in FP&A 50% is explaining what happened and 50% is the “so what?” that the CEO and other leaders care about.

Expand full comment

Hi there, can you check this statement: Price compares the price paid for each product in the current year vs the prior year and flexes for the unit change in each product.

You are saying: flexes for the unit change in each product

However, you are using column E, current year volume

Thanks!

Expand full comment