Retail & e-commerce
Pricing ROI Calculator
The expected net return of a pricing programme, and the point where it pays back.
The problem
In front of an investment committee, a pricing programme is usually defended with a headline benefit, without the reasoning that produced it. The margin effect of a realignment computes easily and reads well; the volume effect that offsets it needs an elasticity assumption nobody wants to own. The case goes through on margin alone, and the shortfall turns up at the first review.
Full cost is the second blind spot. The budget presented covers tooling and external support but leaves out the months during which internal teams do nothing else, and the ramp where rules are live but not yet producing an effect. Break-even slips several quarters on that alone. The calculation puts margin effect, volume effect and full cost on the same page.
Pricing ROI Calculator
How to read the result
Input
- Revenue and gross margin rate (margin on selling price) of the scope addressed
- Price realignment considered, in margin points, at constant purchase cost
- Share of revenue and price elasticity assumed for each of the four product families
- Implementation cost, deployment timeline and ramp-up
How to read the result
- Net benefit is what remains of the margin effect once the volume effect is deducted
- Break-even locates the month in which cumulative benefit catches up with cumulative cost
- The robustness test reruns the calculation with elasticity halved, then increased by half: between two equally plausible assumptions, a break-even that doubles is no longer one
- Left to settle: size the investment, or tighten the first wave
Limits
- The elasticity entered is an assumption. Borrowed from another market, another retailer or another season, it does not transfer.
- The model holds it constant across the whole realignment. It bends at psychological price points and beyond roughly ten points of movement.
- No competitive response enters the calculation. A fast match by the main competitor removes the volume effect and leaves every committed cost in place.
- Costs cover the project, not the steady state. Rule maintenance, competitor price feed upkeep and recurring arbitration run every year once the programme is live.
The calculation supports an internal investment decision; it travels with its elasticity assumptions left visible. An unreadable entry leaves the last valid value in place with a message, and any value brought back to a limit is flagged. Numbers are read according to the language of the page: comma or point in French, point in English, comma in German and Spanish.
In the glossary
A first thirty-minute conversation
The tool gives the order of magnitude. The decision that follows can be discussed in thirty minutes.