Global Consumer Health Company
Mastering Supply Chain Cost Visibility with End-to-End Cost to Serve
A leading Global Consumer Health Company lacked visibility on end-to-end supply chain costs. Profitable product lines were assessed using manufacturing costs from ERP compared with net trade sales — an approach that missed a significant proportion of total costs, skewing decision-making and leaving opportunities for cost reduction on the table.
Download case studyThe Challenge
Data required to build a Cost to Serve model was fragmented across many disparate systems — including 3rd-party providers — resulting in an incomplete, inconsistent, and unstandardised data landscape. The absence of a unified view made it impossible to compare cost structures by SKU, market, customer, or region.
What We Did
- Led global leadership alignment on which cost components and features to include in the Cost to Serve model.
- Conducted a Region-by-Region landscape assessment, capturing system and data requirements across North America, Latin America, Europe, Middle East, Africa, and Asia Pacific.
- Created an integrated, incremental delivery plan for the Cost to Serve tool, releasing features by region.
- Identified and onboarded new data sources — including Warehouse and Transportation data — from 5 ERP systems and 9 TMS/WMS providers.
- Wrote Jira User Stories to specify transformation logic converting raw data into activity-based costs at SKU level.
- Managed scrum teams through development, systems integration testing, business simulation testing, and User Acceptance Testing.
- Delivered unified Power BI dashboards with extensive filter options, refreshed daily with automated quality health checks.
