Capgemini / Around 2006
From ad hoc pricing to automated global rate cards
An automated global BPO rate-card tool replaced manual, judgment-led pricing with a consistent model that could be tailored deal by deal.
Global consistency. Deal-by-deal flexibility.
- Location costsLabor · Infrastructure · Telephony
- Deal assumptionsStaffing ratios · Target margin
- Global rate-card toolExcel + Visual Basic
- Tailored pricingLocation & deal scenarios
- Commercial reviewDiscounts & RFPs
Costs covered India, Guatemala, Poland and the United States.
Read the complete architecture & boundaries
Simplified model inputs and outputs. The illustration is not the original tool or an exact reconstruction of its formulas.
- Build the cost base. Costs covered India, Guatemala, Poland and the United States.
- Customize the deal. Leaders could vary agent-to-supervisor and agent-to-QA ratios and target margins.
- Automate the rate card. The tool calculated pricing and supported discount and RFP scenarios.
THE PROBLEM
What needed to change.
Rate cards were assembled manually and pricing relied heavily on judgment. Leaders needed a polished, consistent global tool that still allowed each deal’s economics to be modeled.
MY CONTRIBUTION
Where I came in.
I gathered labor, infrastructure, telephony and other operating costs and built a location-specific rate-card tool with a Visual Basic module.
The tool supported leaders assessing pricing and RFP scenarios across India, Guatemala, Poland and the United States.
THE APPROACH
How it came together.
- Assemble operating costs for each delivery location.
- Let leaders vary agent-to-supervisor and agent-to-QA ratios.
- Use target margins to calculate pricing and assess discount scenarios.
THE OUTCOME
What the work made possible.
The tool brought structure and automation to global rate-card pricing while allowing leaders to customize assumptions for individual deals. Broader adoption and measured impact remain unquantified.
Technical & implementation detail
Technologies described in this account: Excel, Visual Basic.
The Excel-based tool incorporated a Visual Basic module. Inputs included location-specific labor, infrastructure, telephony and other costs, agent-to-supervisor and agent-to-QA ratios, and target margins. The source does not yet distinguish VBA from a separate Visual Basic implementation.
The accompanying visual is a simplified explanation. It is not a production screenshot or a complete implementation specification.