Define the commercial decision
Cost-to-serve analysis can inform pricing, service terms, customer segmentation or the design of a distribution channel. Choose the decision before allocating costs. A review of delivery charges needs transaction and logistics detail; a decision about retaining a channel also needs the capacity and costs that would remain if its volume disappeared. An account-level report should make those different purposes clear.
Agree the population and period covered, then reconcile sales and the relevant cost pools to management accounts. Retain customer, product, channel and order identifiers where available. Separate gross margin on the product from the cost of the activities needed to sell and fulfill it. A customer buying a high-margin item may still require substantial delivery, support or returns handling.
Identify the activities that consume resources
Map the work associated with an order and an ongoing customer relationship. Depending on the business, this may include quotations, order entry, picking, packing, delivery, installation, technical support and credit management. Use operational records to identify the frequency and characteristics of those activities. Shipment counts, support tickets and order-line counts can be more informative than revenue when explaining a resource requirement.
Choose allocation drivers that reasonably reflect the work. A large delivery may use more vehicle capacity but require fewer handling events than several small deliveries. A technical-support cost may depend on product complexity and service commitments. Discuss the proposed drivers with the people performing the activity and check a sample of transactions. Document where the available data requires an estimate.
Avoid distributing every overhead cost to accounts merely because it appears in the ledger. Some costs support the business as a whole and will remain when a particular customer leaves. Show directly attributable costs and allocated shared costs separately. The calculation should let a reader distinguish the contribution earned on current volume from the cash and capacity consequences of a proposed commercial change.
Investigate the customers behind the averages
Compare customers with similar products and service requirements before interpreting a profitability difference. Review contract terms, minimum orders, delivery frequency, returns and support obligations. Sales and operations may be able to explain a result that looks unusual in the data. An expensive delivery pattern might be a temporary arrangement, while a low service cost might reflect a duty carried by a distributor rather than the supplier.
Check how costs change if the business accepts more volume or reduces a service. Existing capacity may accommodate additional orders until another shift, vehicle or specialist is required. A flat cost per order will not represent that threshold well. Model the operational response where it matters to the decision, and retain assumptions about demand and capacity alongside the financial result.
Use the analysis to revise the offer
Possible changes include minimum order quantities, delivery schedules, paid service options or revised channel responsibilities. Assess each proposal against the contract and the likely customer response. Some customers may accept a different service arrangement; others may reduce their purchases or leave. Estimate the contribution and resource effect under those outcomes before adding a forecast benefit to the budget.
Assign the agreed changes to commercial and operational owners, with finance responsible for the method of tracking the effect. Compare subsequent transactions with the baseline and update the activity data when service patterns change. Keep the allocation assumptions available to account managers. They need to understand which actions affect the cost rather than receive a profitability score they cannot explain to a customer or use in a negotiation.