Learn · Calculators

Programme budget calculator

A programme budget calculator estimates the full cost of running a loyalty programme over a chosen period. It sums setup, recurring software fees, and expected reward liability, then shows cost per member and cost per point. This gives a first time operator a realistic spending limit before launch instead of discovering costs after members join.

How it works

A programme budget calculator splits loyalty cost into setup, ongoing operations, and reward liability. Setup covers one time items such as card design and staff training. Ongoing operations include monthly platform fees and support hours. Reward liability is the number of points expected to be issued multiplied by the cash value of one point. The calculator also needs two volume figures: how many members will join and how much each member will spend. With those inputs it returns three outputs: total budget, cost per member, and reward cost as a share of total cost.

Worked example

This worked example is illustrative and uses round numbers. A salon plans a twelve month programme for 1,500 members. Fixed setup costs are 6,000 dollars, platform fees are 250 dollars per month, and each member earns an average of 600 points per year. One point is valued at 0.01 dollars when redeemed. Total reward liability is 1,500 members times 600 points times 0.01 dollars, which equals 9,000 dollars. Platform fees are 250 dollars times 12 months, which equals 3,000 dollars. Total budget is 6,000 plus 3,000 plus 9,000, which equals 18,000 dollars. Cost per member is 18,000 divided by 1,500, which equals 12.00 dollars. Reward cost as a percentage of total budget is 9,000 divided by 18,000, which equals 50 percent.

What to do

Open a blank spreadsheet and label three columns: Item, Monthly amount, One time amount. Enter member count in a separate cell, for example 1,200. List each licence fee, card print run, and training session under one time amount. List every platform subscription, email service, and support retainer under monthly amount. Set a cell for points earned per dollar spent, such as 5. Set a cell for redemption value in dollars per point, such as 0.01. Add a formula for expected reward cash: member count times average annual spend times points per dollar times redemption value. Add monthly amounts times 12 to one time amounts and reward cash. Divide the grand total by member count to get cost per member.

Common mistakes

  • Budgeting only the software subscription and forgetting reward liability, which is often the largest line.
  • Treating unclaimed points as zero cost instead of estimating a redemption rate and holding a reserve.
  • Using one member count without testing lower and higher scenarios, so the budget breaks at launch.
  • Setting an earning rate that gives away more margin than the programme can recover from extra visits.

Related