Case 025Costing, pricing and unit economicsHard
Three customers look equally profitable when overhead is spread by revenue. Re-cost them by the deliveries and returns they cause.
1The situation
Vahanika Logistics runs last-mile delivery for three retail customers. Each pays Rs 10 crore a year and each earns Rs 3 crore before overheads, which are Rs 6 crore and are allocated by revenue, Rs 2 crore each. On that basis every customer makes Rs 1 crore, and the sales team wants to sign more like C, the fastest growing.
Finance has activity data. Deliveries: A 2,000, B 5,000, C 13,000, and the delivery cost pool is Rs 4 crore. Returns: A 100, B 300, C 600, and the returns pool is Rs 2 crore.
2Your task
Re-cost each customer on activity, explain why the answer changes, and say what Vahanika should do about C.
Quick check
Overhead is traced to deliveries and returns instead of revenue. What happens to customer C, who orders 13,000 small drops?
Worked solution
Try it on paper, then open one step at a time.
30-second answerThe answer to give first
On activity, A earns Rs 2.4 crore, B Rs 1.4 crore and C loses Rs 0.8 crore; the total is still Rs 3 crore, but the revenue allocation hid which customer was eating it. A delivery costs Rs 2,000 and a return Rs 20,000. C buys Rs 10 crore in 13,000 drops of Rs 7,692 each, so it consumes Rs 3.8 crore of the Rs 6 crore of overhead. The fix is to price C for the work it causes: a delivery charge of about Rs 615 a drop, a minimum drop size, or an 8% rate rise at renewal.
Step 1What does each customer actually cost to serve?
Find the rate for each activity. Rs 4 crore of delivery cost over 20,000 deliveries is Rs 2,000 a delivery; Rs 2 crore of returns cost over 1,000 returns is Rs 20,000 a return. Then charge each customer for what it used. A used 2,000 deliveries and 100 returns, Rs 0.4 crore plus Rs 0.2 crore; C used 13,000 and 600, Rs 2.6 crore plus Rs 1.2 crore, nearly twice what it was allocated. Three friends split a restaurant bill equally; one of them ordered three courses and the others had soup. The bill is right and the split is wrong, and the soup drinkers are paying for the third friend's dessert. Activity based costingTracing overhead to the activities that cause it, such as deliveries, orders or returns, and charging each product or customer for the activities it consumes, rather than spreading overhead by revenue or volume. is the itemised bill.
| Customer | Revenue | Before overhead | Overhead by revenue | Profit, revenue basis | Delivery cost | Returns cost | Profit, activity basis |
|---|---|---|---|---|---|---|---|
| Customer A | 10.0 | 3.0 | 2.0 | 1.0 | 0.4 | 0.2 | +2.4 |
| Customer B | 10.0 | 3.0 | 2.0 | 1.0 | 1.0 | 0.6 | +1.4 |
| Customer C | 10.0 | 3.0 | 2.0 | 1.0 | 2.6 | 1.2 | -0.8 |
| Total | 30.0 | 9.0 | 6.0 | 3.0 | 4.0 | 2.0 | +3.0 |
Step 2Why does revenue allocation get this so wrong?
Because revenue is not what causes overhead. The three customers pay the same Rs 10 crore but buy it in very different shapes: A in 2,000 drops worth Rs 50,000 each, C in 13,000 drops worth Rs 7,692 each. A delivery van does not care about the invoice value; it costs Rs 2,000 to make a drop whether the parcel is worth Rs 500 or Rs 50,000, so the customer with small frequent orders consumes 65% of the delivery pool while paying a third of the bill. The error is not small. A's true margin is 24%, C's is -8%, and a sales team paid on revenue will keep bringing in C-shaped customers because every one of them looks like a Rs 1 crore account on the management pack.
Step 3What should Vahanika do about C?
Not drop it, at least not first. C's revenue is a third of the business and some of the Rs 6 crore of overhead is fixed: lose C and the vans and the returns desk do not shrink by Rs 3.8 crore overnight, so the loss would partly land on A and B. Price the behaviour instead: a delivery charge of about Rs 615 a drop, or a minimum drop value, takes C to breakeven while leaving C the choice to consolidate orders; C breaks even at about 9,000 deliveries with returns unchanged, and at A's drop size it would need only 2,000. The returns deserve the same treatment, since each one costs Rs 20,000 and C's 600 cost more than B's whole overhead bill. Then change what sales is paid on, from revenue to activity-costed margin, or the next C arrives next quarter.
Say the limitation. Two pools and two drivers is a model, not the truth: the delivery pool probably has a fixed element that should not be charged per drop, and some returns are Vahanika's own fault. The rates are averages, so a customer in a dense city is cheaper per drop than one in the hills. Activity costing is for the decision in front of you, pricing and customer mix, and it should be rebuilt when the mix changes, not run as a monthly ritual.
Where candidates lose it
Candidates compute the activity rates correctly and then recommend firing C. Most of the overhead does not leave with the customer, so the loss moves to A and B. The answer is to price C's behaviour, not to lose C's revenue.
The other miss is forgetting to check the total. Activity costing redistributes the same Rs 6 crore; if your three profits do not add back to Rs 3 crore, a rate or a driver count is wrong.
What the interviewer asks next
- If Rs 1.5 crore of the delivery pool is fixed depot cost, how does that change C's loss and your recommendation?
- How would you set a delivery charge that makes C indifferent between many small drops and fewer large ones?
- What does this analysis say about how the sales team should be paid?
- A fourth customer pays Rs 10 crore with 500 deliveries and no returns. What is its margin, and what does that tell you?
Company names and figures are illustrative.
