Case 045Budgeting, variance and reportingCore
Tejomaya Technologies has 1,000 staff, a mid-year hike, 18% attrition backfilled after two months, and 150 net new hires. Build the year's staff cost budget month by month.
1The situation
Tejomaya Technologies runs a 1,000-person engineering centre. Average cost to company is Rs 15 lakh a year. The financial year runs April to March, and a 10% hike applies to everyone on the rolls from 1 July; later joiners come in at the hiked pay scale. Attrition runs at 18% a year, spread evenly, with leavers going on the first of the month and each vacancy backfilled two months later at 5% below the leaver's cost. The business also plans 150 net new hires, spread evenly through the year and joining on the first of each month.
The finance lead's first draft was 1,150 heads at the hiked rate for twelve months. The CFO sent it back.
2Your task
Build the monthly staff cost, the annual total, and the bridge from the 1,000-head base to it, and say why the first draft was wrong.
Quick check
The first draft costed 1,150 heads at Rs 16.5 lakh for the full year. Is that too high or too low?
Worked solution
Try it on paper, then open one step at a time.
30-second answerThe answer to give first
The year costs about Rs 169.3 crore, not the Rs 189.8 crore of the first draft. Build it monthly: the original roster shrinks by 15 heads a month, backfills arrive two months later at 95%, new hires add 12.5 a month, and the rate steps from Rs 15 lakh to Rs 16.5 lakh in July. Monthly cost runs from Rs 12.47 crore in April to Rs 15.30 crore in March. The bridge from the Rs 150 crore base is the hike, less vacancy savings, plus new hires, each a timing question.
Step 1Why is a people budget a roll-forward and not a multiplication?
A household that hires a cook in October does not budget twelve months of her salary; a family whose rent rises in July pays the old rent for three months. Staff cost is headcount times rate, month by month, and both move during the year, so the annual number is the sum of twelve different months. Tejomaya has three moving parts: the rate steps up in July, leavers thin the original roster every month, and two kinds of joiners add to it on their own schedules. Multiply year-end heads by the year-end rate and all three timing effects are lost.
Step 2How do you build each month?
Three head counts, one rate. The original roster loses 15 people on the first of each month, so in month m it has 1,000 less 15m. Backfills for those leavers arrive two months later at 95% of cost, so in month m there are 15 times (m minus 2) of them. New hires add 12.5 a month, so 12.5m. Each count is multiplied by the going rate over twelve: Rs 15 lakh until June and Rs 16.5 lakh from July, with backfills at 95% of it. April is 985 originals and 12.5 new hires at Rs 15 lakh, Rs 12.47 crore; March is 820 originals, 150 backfills and 150 new hires at the hiked rate, Rs 15.30 crore.
| Month | Original | Backfills | New hires | Rate, Rs lakh | Cost, Rs crore |
|---|---|---|---|---|---|
| Apr | 985 | 0 | 12.5 | 15.0 | 12.47 |
| May | 970 | 0 | 25.0 | 15.0 | 12.44 |
| Jun | 955 | 15 | 37.5 | 15.0 | 12.58 |
| Jul | 940 | 30 | 50.0 | 16.5 | 14.00 |
| Aug | 925 | 45 | 62.5 | 16.5 | 14.17 |
| Sep | 910 | 60 | 75.0 | 16.5 | 14.33 |
| Oct | 895 | 75 | 87.5 | 16.5 | 14.49 |
| Nov | 880 | 90 | 100.0 | 16.5 | 14.65 |
| Dec | 865 | 105 | 112.5 | 16.5 | 14.81 |
| Jan | 850 | 120 | 125.0 | 16.5 | 14.97 |
| Feb | 835 | 135 | 137.5 | 16.5 | 15.14 |
| Mar | 820 | 150 | 150.0 | 16.5 | 15.30 |
| Year | 169.35 |
Step 3What is the bridge from the base, and why was the draft wrong?
Start at 1,000 heads for a year at Rs 15 lakh, Rs 150 crore. The hike adds Rs 11.25 crore, nine months of 10% on the base; vacancies save Rs 5.22 crore, because each of 180 leavers leaves a seat empty for two months and the replacement costs 5% less; and the new hires add Rs 13.31 crore, which is far less than 150 times Rs 16.5 lakh because the average new hire is on the rolls for only half the year. That sums to Rs 169.3 crore. The draft's Rs 189.8 crore applied the year-end headcount and the year-end rate to all twelve months, which overstates by about Rs 20 crore, enough to misprice every project the centre bills.
Say what the model does not know. Attrition is rarely even; it spikes after bonuses and hikes, which pulls leavers forward and raises the vacancy saving while hurting delivery. Backfill at two months is an average that hides long searches for senior roles. And joiners' cost to company is an assumption until the offers are signed. The finance lead should hold the roll-forward and reforecast it quarterly against actual joiners and leavers, not defend one annual figure.
Where candidates lose it
The common loss is the first draft itself: year-end heads at the year-end rate for twelve months. Hikes, exits and hires all have dates, and the dates are the budget.
The second is forgetting the vacancy. A leaver who is replaced two months later is a saving in the year, not a cost, and a budget that misses it will show a favourable variance nobody earned.
What the interviewer asks next
- Attrition jumps to 24% in the two months after the hike and falls afterwards. How does the annual cost change?
- How would you add a variable bonus of 10% of CTC paid in October on the previous year's rolls?
- What monthly report would you build so the budget can be reforecast against actual joiners and leavers?
Company names and figures are illustrative.
