Cost-to-Serve Analysis

CONTEXT:
Most companies discover that 20-30% of their customers are unprofitable when true cost-to-serve is calculated, yet only 15% of organizations have the analytical capability to measure customer-level profitability accurately. The difference between the most and least expensive customers to serve can vary by a factor of 10 or more within the same revenue tier. Cost-to-serve analysis enables strategic decisions about pricing, service levels, and customer segmentation that directly improve operating margins by 3-8%.

ROLE:
Act as a supply chain finance analyst with 12 years of experience conducting cost-to-serve studies for consumer products companies, industrial distributors, and B2B manufacturers to optimize profitability across customer segments and product portfolios.

RESPONSE GUIDELINES:
- Capture all cost elements from order receipt through delivery including warehousing, transportation, handling, and administrative costs
- Allocate shared costs using activity-based costing principles rather than simple revenue-proportional allocation
- Connect cost-to-serve insights to actionable commercial and operational strategies
- Present findings in ways that enable cross-functional decision-making between finance, sales, and operations
- Do NOT use oversimplified cost allocation methods that spread costs evenly and mask true profitability differences
- Do NOT present cost-to-serve findings without recommended actions for each customer or channel segment

TASK CRITERIA:
**1. Define the cost-to-serve model scope including all supply chain cost elements: order processing, warehousing, picking, packing, transportation, returns, and customer service for [INSERT BUSINESS TYPE].**
**2. Identify cost drivers for each supply chain activity and map them to measurable allocation bases such as order frequency, line items per order, cube shipped, and delivery complexity.**
**3. Collect and validate cost data from financial systems, operational databases, and activity logs for the analysis period of [INSERT TIME PERIOD].**
**4. Calculate cost-to-serve by customer segment, channel, product category, and geographic region revealing the true profitability landscape.**
**5. Perform a customer profitability analysis plotting customers on a revenue vs. cost-to-serve matrix to identify profit leaders, profit drains, and opportunity accounts.**
**6. Develop a channel profitability comparison analyzing cost-to-serve differences between direct-to-consumer, wholesale, marketplace, and retail distribution channels.**
**7. Create pricing and surcharge recommendations for high-cost service elements including small orders, expedited shipping, special handling, and high-return customers.**
**8. Design service level tiering that aligns delivery speed, order flexibility, and support levels with customer profitability and strategic importance.**
**9. Build a recurring cost-to-serve reporting framework with automated data feeds, dashboard visualizations, and quarterly review cadence.**

INFORMATION ABOUT ME:
- My business type: [INSERT BUSINESS TYPE]
- My number of customers to analyze: [INSERT CUSTOMER COUNT]
- My analysis time period: [INSERT TIME PERIOD]
- My sales channels: [INSERT CHANNELS - DTC/WHOLESALE/MARKETPLACE]
- My annual revenue: [INSERT ANNUAL REVENUE]
- My current gross margin: [INSERT GROSS MARGIN PERCENTAGE]

RESPONSE FORMAT:
- Structure as a cost-to-serve analysis report with methodology, findings, and strategic recommendations sections
- Present customer profitability in a quadrant matrix with clear segment labels and action strategies for each quadrant
- Include cost driver analysis tables showing allocation bases and rates for each supply chain activity
- Provide a pricing recommendation framework with specific surcharge calculations for high-cost service elements
- Use executive summary dashboards showing the total margin improvement opportunity and top ten action items