Client Overview
The client, a multinational pharmaceutical company headquartered in Asia, produces a broad portfolio of prescription drugs and over-the-counter supplements. Its sourcing heavily depends on global supply chains for:
- Vitamins: A, D3, and B-complex.
- Excipients: Citric acid, starches, and maltodextrin.
Procurement teams were struggling with price opacity, volatile trade tariffs, and supplier concentration risks. The company needed greater transparency in ingredient pricing and a robust forecasting framework to guide long-term sourcing decisions.
Research Objective
The engagement aimed to provide the client with procurement-ready pricing intelligence to:
- Benchmark global prices for vitamins and excipients across key production hubs.
- Assess the impact of tariffs, duties, and non-tariff barriers on landed costs in the USA and EU.
- Develop should-cost ladders to break down supplier quotes into component costs.
- Create a triangulated supplier pricing model to identify fair-value ranges.
- Enable forecast-driven procurement planning to manage exposure from 2026-2030.
Scope of Work
FMI designed a holistic framework to cover:
- Ingredient Pricing Index (IPI): Monthly normalized price series for 30+ pharmaceutical ingredients, differentiated by grade, form (powder, crystalline), Incoterm (FOB, CIF, Ex-Works), and currency.
- Market Pricing Dataset: 2018-2025 history + 2026-2030 forecast, integrated with MoM/YoY change tracking, rolling averages, and volatility measures.
- Trade Flow Dashboard: HS code-level import/export volumes, top partner countries, average unit values, seasonality indices, and tariff notes.
- Price Ladder & Should-Cost: Detailed cost breakdowns including raw material inputs, solvents, utilities, labor, packaging, logistics, duties, and margins.
- Supplier Quote Triangulation: Ranges synthesized from distributor lists, tender portals, and direct qualified supplier quotes, anonymized and timestamped for auditability.
- Audit Trail & Governance: A system of data source tagging, methodology notes, and revision IDs for internal validation and regulatory compliance.
FMI’s Approach & Solution
Step 1 - Global Pricing Index Development
- Normalized monthly series built for vitamins (A, D3, B-complex) and excipients (citric acid, starches, maltodextrin).
- Incoterm differentiation (FOB India, CIF EU, Ex-Works China) allowed procurement to compare apples-to-apples across supplier quotes.
Step 2 - Trade Flow Insights
- Analyzed 7 years of customs data to identify leading exporters:
- Citric Acid - China dominated >65% of global exports.
- Maltodextrin - EU producers (Germany, France) were competitive in quality and stability.
- Built seasonality indices showing procurement risk periods (e.g., Q3 freight congestion in China).
Step 3 - Should-Cost Modeling
- Price ladders revealed that feedstock (corn, citrus peel) accounted for 50-65% of cost base.
- Utilities in Europe (electricity, steam) contributed an additional 15-20% of production costs.
- Sensitivity analysis simulated scenarios such as +10% feedstock, +20% freight, and ±5% duty shifts.
Step 4 - Supplier Triangulation
- Compiled anonymized supplier quotes across Asia, Europe, and North America.
- Built monthly triangulated ranges (min, median, max) for each ingredient.
- Flagged outlier quotes that exceeded median benchmarks by >15%.
Step 5 - Governance & Validation
- Every datapoint tagged with source, timestamp, and methodology note.
- Created an internal audit trail so procurement could present the dataset confidently to finance and leadership.
Outcome & Impact
- Cost Savings: Achieved 8-10% annual savings on excipient contracts through should-cost-backed negotiations.
- Supplier Diversification: Reduced reliance on Chinese suppliers by shifting 25% of volume to EU and India.
- Faster Procurement Cycles: RFQ decision-making time reduced by 30%, as procurement teams no longer needed to debate supplier “fairness” without data.
- Improved Forecasting: Five-year forecasts improved budget planning accuracy and allowed finance to set realistic cost baselines.
- Negotiation Leverage: Procurement successfully challenged inflated quotes by referencing FMI’s triangulated ranges.
Key Recommendations
- Diversify Origins: Maintain at least 2-3 active supplier origins per ingredient to reduce geopolitical and tariff risk.
- Monitor Energy Costs: Track European energy markets closely, as utility costs can significantly impact excipient prices.
- Contract Safeguards: Introduce escalation/de-escalation clauses tied to feedstock and freight indices.
- Quarterly Benchmarking: Refresh pricing datasets every quarter to keep negotiation leverage current.
- Supplier Development: Build strategic partnerships with mid-tier suppliers in India and Southeast Asia to reduce over-reliance on dominant Chinese players.
