Case 031Budgeting, variance and reportingWarm up
A back office processed 1,20,000 transactions with more hours and a higher hourly rate than standard. Split the labour overrun into rate and efficiency variances, and say which matters more.
1The situation
Karyasiddhi Business Services runs invoice processing for clients. Its standard is 0.5 hours of staff time per transaction at a standard rate of Rs 450 an hour.
Last quarter it processed 1,20,000 transactions. Staff logged 66,000 hours, and the actual average cost was Rs 470 an hour. The operations head wants to know why labour cost came in over budget, and what to fix first.
2Your task
Compute the labour rate variance and the labour efficiency variance, and say which one deserves the manager's attention.
Quick check
Which variance is bigger?
Worked solution
Try it on paper, then open one step at a time.
30-second answerThe answer to give first
The overrun is Rs 40.2 lakh: Rs 13.2 lakh adverse on rate and Rs 27.0 lakh adverse on efficiency. Standard hours for 1,20,000 transactions are 60,000, so staff used 6,000 hours, 10%, more than they should. Paying Rs 20 more on 66,000 hours adds the rest. Efficiency matters more: it is twice the size, and how long work takes is more within the manager's control than the market wage.
Step 1What is the first number to work out?
The standard hours for the output actually produced. Variances compare actual cost with what the actual volume should have cost, not with the original budget: 1,20,000 transactions at 0.5 hours is 60,000 standard hours, Rs 270 lakh at Rs 450. Actual cost was 66,000 hours at Rs 470, Rs 310.2 lakh. The gap of Rs 40.2 lakh is what you now split, like a grocery bill that is higher because you bought more and because prices rose.
Step 2How do you split the gap?
Change one thing at a time. The rate varianceThe part of a cost overrun caused by paying a different price per unit of input than standard, measured on the inputs actually used. prices the actual hours at the difference in rate; the efficiency variance prices the extra hours at the standard rate. (470 less 450) times 66,000 is Rs 13.2 lakh. (66,000 less 60,000) times 450 is Rs 27.0 lakh. The two add back to Rs 40.2 lakh exactly, which is the check that you used the right hours in each formula.
| Line | Hours | Rate, Rs | Cost, Rs lakh |
|---|---|---|---|
| Standard cost of actual output | 60,000 | 450 | 270.0 |
| Actual hours at standard rate | 66,000 | 450 | 297.0 |
| Actual cost | 66,000 | 470 | 310.2 |
| Efficiency variance, adverse | 27.0 | ||
| Rate variance, adverse | 13.2 |
Step 3Which one should the manager chase?
Efficiency, for two reasons. It is the larger number, and it is the more controllable one: hours per transaction depend on process, training, system downtime and rework, all things an operations head can act on, while the hourly rate is largely set by the labour market and the annual increment. A 10% efficiency slip on a process that should be stable is a signal; a 4.4% rate rise may simply mean the standard is out of date.
Then check whether the two are linked. If the extra hours were worked as overtime at a premium, part of the rate variance is a consequence of the efficiency problem, not a separate one. Note too that the rate variance on actual hours contains a small joint piece: Rs 20 on the 6,000 extra hours, Rs 1.2 lakh, which some teams report on its own. Say which convention you used. The judgement to close on: fix the hours first, and ask whether the Rs 450 standard should be reset before calling the rate a failure.
Where candidates lose it
The usual slip is computing the efficiency variance at the actual rate, Rs 470, which gives Rs 28.2 lakh and double counts part of the rate effect. Efficiency uses the standard rate; rate uses the actual hours.
The second is comparing with the original budget volume rather than the standard hours for actual output. If volume changed, that mixes a volume effect into the labour variance and points the manager at the wrong problem.
What the interviewer asks next
- If 4,000 of the 66,000 hours were overtime paid at Rs 600, how would you restate the two variances?
- Should the standard of 0.5 hours be changed after one bad quarter?
- How would you present these variances to a client who is billed per transaction?
Company names and figures are illustrative.
