Report – Cost-to-Serve Analysis for an Australian Distribution Business

Executive Summary

This report presents an activity-based cost-to-serve analysis for Meridian Distribution Pty Ltd (the Company), a hypothetical Australian wholesaler that distributes packaged grocery and household consumables from distribution centres in Sydney and Melbourne to four customer segments: national retail chains, independent retailers, trade and food-service customers, and online direct buyers. The Company earns annual revenue of A$47.0 million and a product gross profit of A$10.23 million (21.8 per cent), but conventional segment reporting stops at gross margin and therefore conceals how much it costs to serve each segment after the sale is made.

Allocating A$7.16 million of order handling, warehousing, freight, and returns cost to segments through activity-based costing produces a very different profit map. Trade and food-service is the strongest segment at a 10.4 per cent net margin after cost-to-serve; national retail is solidly profitable at 6.5 per cent despite carrying the lowest product margin; independent retail is thinner than its 32 per cent product margin implies, at 7.4 per cent; and online direct is loss-making at negative 1.8 per cent even though it carries a healthy 28 per cent product margin. The report recommends retaining and growing the two strong segments, repricing and re-engineering the ordering process for independent retail, and imposing a minimum order value and freight recovery on online direct while selectively exiting its deep-loss micro-orders.

Introduction

Australian distributors operate on thin net margins, and their cost base is dominated by logistics activities whose real cost has risen steadily. The Australian Bureau of Statistics reports sustained growth in road freight activity and cost, and national freight productivity was judged a priority serious enough to warrant a coordinated National Freight and Supply Chain Strategy agreed by all governments (ABS 2023; Commonwealth of Australia 2019). In this environment, a distributor that prices and manages every customer segment from the same average cost assumption will systematically overserve some customers and underserve others.

Traditional profit reporting measures customers only to the gross-margin line, treating warehousing, delivery, and returns as an undifferentiated overhead. Cost-to-serve analysis corrects this by tracing post-sale logistics cost to the customers who cause it, so that true segment profitability becomes visible (Braithwaite and Samakh 1998; Christopher 2016). This report applies cost-to-serve analysis to the Company across the four segments introduced above. Its aim is to quantify the cost of serving each segment, identify which segments create or destroy value once those costs are loaded, and recommend segment-specific pricing and service actions. The scope is one financial year of operating data; capital costs and head-office overhead are excluded so that the analysis isolates controllable service cost. The order-to-delivery process that generates these costs, and the activity pools mapped to it, is shown in Figure 1.

Method: Activity-Based Costing

Activity-based costing (ABC) assigns indirect cost to cost objects in two stages: resource costs are first pooled by activity, then charged to cost objects using a driver that reflects consumption of that activity (Cooper and Kaplan 1991; Drury 2018). Applied to cost-to-serve, the cost objects are customer segments and the activities are the logistics processes that stand between order capture and a completed, retained sale. Four activity pools account for the controllable service cost: order handling (order entry, credit checking, and customer service), warehouse pick and pack, freight and delivery, and returns processing.

The order handling and warehouse pools are labour-intensive, so their rates move directly with award wage outcomes. The relevant instruments, the Storage Services and Wholesale Award and the Road Transport and Distribution Award, are adjusted through the Fair Work Commission Annual Wage Review, so the model is refreshed after each review to keep rates current (Fair Work Commission 2023). Each pool is divided by its total driver volume to give an activity rate, as set out in Table 1; for a high-throughput distributor this can be extended to a time-driven form of ABC that estimates rates from the time each transaction consumes (Kaplan and Anderson 2007). Freight is treated as a set of mode-based rates rather than a single rate, because segments ship through different modes: national retail moves in full pallets, independent and trade orders move as less-than-truckload (LTL) consignments, and online orders move as parcels. This mode split matters, because a single average freight rate would badly misstate the cost of small parcels (Guerreiro et al. 2008).

The three volume-driven rates are calculated by dividing each pool by its driver volume:

• Order handling rate = A$1,320,600 / 74,400 orders = A$17.75 per order.
• Warehouse pick rate = A$2,095,360 / 654,800 order lines = A$3.20 per line.
• Returns handling rate = A$559,104 / 5,824 returns = A$96.00 per return.

The mode-based freight rates applied per consignment are A$135.00 for national retail pallet freight, A$58.00 for independent retail LTL, A$74.00 for trade and food-service LTL, and A$14.50 for online parcels. Although a parcel is the cheapest single consignment, the online segment ships the largest number of consignments, so its freight is far from trivial.

Cost-to-Serve Analysis by Segment

Each segment consumes the four activities in very different proportions, which is what makes average costing so misleading. National retail places few but very large orders (4,800 orders averaging 40 lines and about 850 kilograms), whereas online direct places many tiny orders (38,000 orders averaging three lines and about six kilograms) and returns them at more than four times the rate of any other segment. Multiplying each segment’s driver volumes by the activity rates in Table 1 gives the cost-to-serve build shown in Table 2.

Two segments illustrate both the calculation and the insight. For online direct, the four activity charges are:

• Order handling = 38,000 orders x A$17.75 = A$674,500.
• Warehousing = 114,000 lines x A$3.20 = A$364,800.
• Freight = 38,000 parcels x A$14.50 = A$551,000.
• Returns = 4,560 returns x A$96.00 = A$437,760.
• Total cost-to-serve = A$2,028,060, or A$2,028,060 / 38,000 = A$53.37 per order.

The returns charge alone, driven by a 12 per cent return rate, is A$437,760. That single line is larger than the segment’s entire warehousing cost and accounts for 78 per cent of the Company’s total returns pool. For national retail, by contrast, total cost-to-serve is A$1,356,816, the highest cost per order in the business at A$1,356,816 / 4,800 = A$282.67, yet this represents only 7.5 per cent of its A$3,792 average order value. Online direct records the lowest cost per order but the highest cost relative to order value, at 29.8 per cent of its A$179 average order. This inversion, in which the cheapest orders to pick are the most expensive to serve for the value they carry, is the central finding of the analysis (Niraj et al. 2001).

Segment Profitability

Loading cost-to-serve onto product gross profit converts each segment’s apparent profitability into its real contribution. Product gross margins are 14 per cent for national retail, 32 per cent for independent retail, 22 per cent for trade and food-service, and 28 per cent for online direct, which on the surface ranks online direct as the second most attractive segment. Cost-to-serve reverses this ranking. Online direct absorbs 29.8 per cent of its revenue in service cost and independent retail 24.6 per cent, against only 7.5 per cent for national retail. Net profit after cost-to-serve is calculated for each segment as gross profit less total cost-to-serve; for online direct:

• Gross profit = 28% x A$6,800,000 = A$1,904,000.
• Net profit after cost-to-serve = A$1,904,000 – A$2,028,060 = negative A$124,060, or negative 1.8 per cent of revenue.

The full profitability picture and the recommended action for each segment are summarised in Table 3. National retail, long regarded internally as a low-margin necessity, is in fact the second-largest profit contributor at A$1.19 million, because its bulk pallet orders spread fixed order and freight cost across high order value. Trade and food-service is the most profitable segment at a 10.4 per cent net margin and should be a growth priority. Independent retail remains profitable, but its high per-order handling cost erodes a large product margin, leaving a 7.4 per cent net margin. Online direct destroys value at current volumes and terms, and its position worsens with every additional micro-order.

Segment Action Framework

The analysis supports a serve, fix, or exit decision for each segment rather than a uniform response (Christopher 2016; Chopra and Meindl 2019). Table 3 sets out the recommended verdict, the pricing lever, and the order policy for each segment.

National retail and trade and food-service should be served and grown, since both convert volume into net profit; the priority is to protect them with reliable service and to grow range and share rather than to reprice. Independent retail should be fixed, not fired: the segment is profitable, but its A$427 average order carries the same fixed handling cost as far larger orders, so the levers are a small-order fee below an A$400 threshold and migration of order entry to a self-service online portal, which removes manual order-handling labour from the most frequent, smallest orders. Online direct requires the firmest action: a minimum order value of A$80, a free-freight threshold lifted to A$120, and a lower return rate achieved through better online product information, followed by selective exit from the deep-loss micro-orders that remain unprofitable after repricing.

Because independent retailers are served under standard-form contracts, any new small-order fee or change to minimum order quantities must be introduced with reasonable notice and must comply with the unfair contract terms protections for small business administered by the ACCC (ACCC 2023). Repricing that is commercially sound can still be legally void if it is imposed through an unfair standard-form term, so the legal review must run alongside the commercial one.

Recommendations

1. Retain and grow national retail and trade and food-service, which together generate A$2.50 million of net profit after cost-to-serve; compete on service reliability and range rather than on price.
2. Introduce a self-service ordering portal for independent retailers, together with a small-order handling fee below A$400, to recover the fixed cost of small, frequent orders (Cooper and Kaplan 1991).
3. Reprice online direct with an A$80 minimum order value and an A$120 free-freight threshold, recovering the parcel freight that a single average rate had hidden.
4. Reduce the online direct return rate from 12 per cent through clearer product information, sizing, and imagery, targeting the A$437,760 returns cost that makes the segment unprofitable.
5. Selectively exit online direct micro-orders that remain loss-making after repricing, redirecting that demand to the portal or to minimum-order terms.
6. Introduce all pricing and minimum-order changes to standard-form contracts with adequate notice and in line with ACCC unfair contract terms guidance (ACCC 2023).
7. Refresh the activity rates after each Fair Work Commission Annual Wage Review and each freight-rate movement, so that segment decisions always rest on current cost (Fair Work Commission 2023; ABS 2023).

Conclusion

Cost-to-serve analysis materially changes the Company’s view of where it makes and loses money. On gross margin, online direct and independent retail look most attractive and national retail least; once A$7.16 million of order handling, warehousing, freight, and returns cost is traced to the segments that cause it, national retail and trade and food-service emerge as the profit engines and online direct is shown to be loss-making. The corrective actions, repricing and re-engineering the ordering process for the small-order segments while protecting the profitable high-volume ones, would move online direct back above break-even and lift group net margin without chasing revenue that does not pay for the cost of serving it. Embedding activity-based cost-to-serve as a standing management report, refreshed for award and freight cost movements, would let the Company price and serve each segment on evidence rather than on average cost.

References

Australian Bureau of Statistics 2023, Survey of Motor Vehicle Use, Australia, ABS, Canberra.

Australian Competition and Consumer Commission 2023, Unfair contract terms, ACCC, Canberra.

Braithwaite, A and Samakh, E 1998, ‘The cost-to-serve method’, International Journal of Logistics Management, vol. 9, no. 1, pp. 69-84.

Chopra, S and Meindl, P 2019, Supply chain management: strategy, planning, and operation, 7th edn, Pearson, Harlow.

Christopher, M 2016, Logistics and supply chain management, 5th edn, Pearson, Harlow.

Commonwealth of Australia 2019, National Freight and Supply Chain Strategy, Department of Infrastructure, Transport, Cities and Regional Development, Canberra.

Cooper, R and Kaplan, RS 1991, ‘Profit priorities from activity-based costing’, Harvard Business Review, vol. 69, no. 3, pp. 130-135.

Drury, C 2018, Management and cost accounting, 10th edn, Cengage Learning, Andover.

Fair Work Commission 2023, Annual Wage Review 2022-23 decision, Fair Work Commission, Melbourne.

Guerreiro, R, Bio, SR and Merschmann, EVV 2008, ‘Cost-to-serve measurement and customer profitability analysis’, International Journal of Logistics Management, vol. 19, no. 3, pp. 389-407.

Kaplan, RS and Anderson, SR 2007, Time-driven activity-based costing, Harvard Business School Press, Boston.

Niraj, R, Gupta, M and Narasimhan, C 2001, ‘Customer profitability in a supply chain’, Journal of Marketing, vol. 65, no. 3, pp. 1-16.