Skip to content
woodfrog
← Advanced analytics
What ifFMCG, retail and distributionUse case, not a client result

What happens to margin if we change price?

The decision it informs

Whether to change price or pack size, by how much, and on which products and channels.

A dashboard versus an investigation
A dashboard showsLast year's price and volume.
An investigation tells youHow volume responds to price, and the profit at each price.
What would come out
How the driver ranking readsSchematic, no values
01
An elasticity tableFor each product and channel, how sensitive volume is, and how sure we are.
02
A price mapWhere there is room to raise price, and where it would cost volume faster than it adds margin.
03
An interactive scenario modelYours to keep and run, with the assumptions in plain view.
Scenarios you could then run
  • What if price rises 3% on the top ten products?
  • What if promotion depth is cut by a quarter?
  • What if input costs rise and we hold price?
Try the what-if playground →
How we would get there
Method 1Price elasticity modelHow much volume moves for each 1% move in price, by product and channel, with a range.
Method 2Price, volume and mix bridgeHow much of past margin movement came from each.
Method 3Scenario modelChange price, cost and promotion together and see profit, margin and volume.
Data we would look at
Sales by SKU, channel and monthPrice lists and discount historyPromotion calendarUnit costsMarket or competitor price points where available
First week: the questions we ask
Which price changes in the last few years can we learn from?What else changed at the same time: promotions, competitors, distribution?Which products and channels matter most?What is the limit you would not cross, on volume or share?
More investigations

Is this your question?

Build your own brief