Tools
Tier threshold benchmarker
Find the qualifying spend a tier needs to pay for itself. Enter the annual cost of the tier benefits per member, your gross margin and the contribution buffer you want. The tool returns the break even spend and the threshold that leaves the margin you asked for.
The tool
The formula, in words
Break even spend equals the annual benefit cost divided by your gross margin. Your qualifying threshold equals that break even figure increased by the buffer you choose. The margin left over equals threshold spend multiplied by gross margin, minus the benefit cost.
Set thresholds on margin, not revenue
A threshold expressed in revenue ignores what you keep. Two members spending the same amount on different baskets deliver different margin, and a tier funded from margin has to be qualified on margin. That is why the tool asks for a margin percentage rather than accepting a revenue target.
Treat a new benefit as a threshold increase
Benefit creep is how tiers inflate: a perk gets added, the qualifying spend stays where it was, and the tier quietly stops paying for itself. Every time you add something to a tier, run this again with the new cost and move the threshold, or decide openly that you are funding the difference.
Where it misleads
The tool assumes members at the threshold behave like members at the threshold, and it takes no account of the spend a member would have made anyway. It also treats benefit cost as fixed per member, which understates tiers whose heaviest users cost far more than the average.