Learn · Calculators
Benefit cost calculator
A benefit cost calculator works out the cost to your business of delivering one loyalty benefit. Add the direct cost of the reward, the fulfilment cost per redemption, and any allocated variable cost. Divide the total by redemptions to get a cost per benefit. Use purchase records, fulfilment invoices, and platform fee schedules for inputs.
How it works
A benefit cost calculator works out the cost to the business of delivering one reward or privilege to a loyalty member. It uses a simple formula: benefit cost equals direct reward cost plus fulfilment cost plus allocated variable cost. Direct reward cost is what you pay for the item or service before any markup. Fulfilment cost is the cost to pack, ship, or otherwise deliver the benefit. Allocated variable cost is the portion of labour, packaging, or platform fees that increases with each redemption. You get these inputs from your purchase ledger, fulfilment invoices, and activity based cost records. If you want a per member figure, divide total benefit cost by the number of members who received the benefit.
Worked example
The following numbers are illustrative arithmetic only. Suppose a free dessert costs the business GBP 1.50 to buy from the supplier. Each redemption also costs GBP 0.40 in packaging and counter service time. The allocated variable platform fee is GBP 0.10 per redemption. The total benefit cost per redemption is therefore GBP 1.50 plus GBP 0.40 plus GBP 0.10, which equals GBP 2.00. If 750 members redeem the dessert in a month, the total monthly benefit cost is GBP 2.00 times 750, which equals GBP 1,500. You can enter these figures in a spreadsheet as three input cells and one formula cell.
What to do
First choose one benefit and one forecast period, for example one month. Put the supplier price in cell A1, the fulfilment cost per redemption in A2, and the allocated platform fee per redemption in A3. In cell A4 type =SUM(A1:A3) to get cost per redemption. In cell B1 put the forecast number of redemptions for the month. In cell B4 type =A4*B1 to get total benefit cost for that benefit. Copy the row for each benefit you want to compare. Update A1, A2 and A3 when supplier, fulfilment, or platform contracts change.
Common mistakes
- Using the retail price instead of your own cost of goods makes the benefit look more expensive than it is and can lead to cutting a good offer.
- Forgetting fulfilment costs such as postage, packaging or third party handling fees understates the true cost per redemption.
- Including fixed overheads that do not change with redemptions distorts the benefit cost and hides which benefits are genuinely cheaper to run.
- Mixing unit costs for different benefit tiers in one average gives a misleading figure when tier benefits have different redemption patterns.