How Perfect Distributor Coordination Drives Distribution Growth

FMCG Route Economics: How to Measure Route Efficiency and Cost Per Call in Excel

Track route productivity, strike rate, sales per productive call, and cost-to-serve using practical FMCG metrics and Excel.

In FMCG sales, a route can look busy without being productive. A salesperson may complete many outlet visits, but if only a small percentage of those calls generate orders, the route may be consuming time and cost without producing enough commercial output.

This is why route analysis should not depend on one number. Sales teams need a practical view of calls, productive calls, strike rate, sales per productive call, route cost, and cost per productive call.

Field Principle: A high cost per call or cost per productive call is an investigation signal—not an automatic reason to cancel, redesign, or label a route as poor. The result should always be reviewed alongside outlet potential, order value, stock availability, customer buying patterns, journey design, and seasonality.

Why Route Economics Matters in FMCG

Route economics connects field activity with measurable commercial output. Instead of looking only at total sales, a sales manager can ask how efficiently the team is using its available calls and route resources.

A practical route review can help answer questions such as:

  • How many outlets were actually visited?
  • How many visits generated orders?
  • What percentage of calls became productive?
  • How much sales value was generated per productive call?
  • How much route cost was incurred per call?
  • How much route cost was incurred for each productive call?
  • Are low results caused by poor execution, stock availability, outlet potential, or route design?

The Core Route Economics Metrics

Metric Formula What It Shows
Total Calls Number of outlet visits Field activity level
Productive Calls Calls resulting in an order, according to company definition Commercially productive visits
Strike Rate Productive Calls ÷ Total Calls Call-to-order conversion
Sales / Productive Call Sales ÷ Productive Calls Average sales value generated by each productive call
Cost Per Call (CPC) Route Cost ÷ Total Calls Average route cost per visit
Cost Per Productive Call (CPPC) Route Cost ÷ Productive Calls Average route cost associated with each productive call

1. What Is Cost Per Call?

Cost Per Call (CPC) measures the average route cost associated with each completed call.

Cost Per Call = Total Route Cost ÷ Total Calls

For example, if a route costs Rs. 1,800 and the salesperson completes 40 calls:

CPC = Rs. 1,800 ÷ 40 = Rs. 45 per call

CPC is useful for understanding route execution cost, but it should not be treated as a direct profitability measure. A route with a higher CPC may still be commercially important if it serves high-potential outlets or generates valuable sales and contribution.

2. Strike Rate: Are Calls Turning Into Orders?

Strike Rate shows the percentage of total calls that become productive calls.

Strike Rate = Productive Calls ÷ Total Calls × 100

Suppose a salesperson makes 40 calls and receives orders from 16 outlets:

Strike Rate = 16 ÷ 40 × 100 = 40%

A low strike rate does not automatically mean poor selling. The manager should investigate whether the reason is stock availability, outlet buying cycle, pricing, assortment, credit limits, outlet potential, competitor activity, or call execution.

3. Sales Per Productive Call

Strike rate tells us how often calls become productive. The next question is: how much sales value is generated when a call is productive?

Sales Per Productive Call = Sales ÷ Productive Calls

If sales are Rs. 35,000 from 16 productive calls:

Rs. 35,000 ÷ 16 = Rs. 2,187.50 per productive call

This metric helps managers understand order productivity, especially when comparing routes with similar call volumes.

4. Cost Per Productive Call (CPPC)

Cost Per Productive Call (CPPC) connects route cost with productive calls rather than all visits.

CPPC = Total Route Cost ÷ Productive Calls

For a route with Rs. 1,800 cost and 16 productive calls:

CPPC = Rs. 1,800 ÷ 16 = Rs. 112.50

CPPC can be particularly useful when a route has a reasonable number of calls but a low strike rate. It highlights how much route cost is associated with generating each productive call.

Important: CPPC should not be interpreted as the profit or loss generated by a route. It is an efficiency metric. Profitability requires reliable contribution or margin data and a consistent definition of attributable costs.

5. Real FMCG Field Scenario: Why One Metric Is Not Enough

Consider two routes with the same number of total calls and the same route cost:

Route Calls Productive Route Cost Gross Sales Strike Rate CPC CPPC Sales / Productive Call
Route A 40 30 Rs. 1,800 Rs. 95,000 75.0% Rs. 45 Rs. 60 Rs. 3,166.67
Route B 40 16 Rs. 1,800 Rs. 35,000 40.0% Rs. 45 Rs. 112.50 Rs. 2,187.50

The CPC is identical because both routes have 40 calls and Rs. 1,800 of route cost. However, the productive-call metrics are different because Route B converts fewer calls into orders.

This is exactly why route analysis should combine multiple metrics rather than relying on CPC alone.

6. What Should a Sales Manager Ask?

When a route shows a high CPPC or low strike rate, the next step should be diagnosis rather than an immediate decision.

  • Are the right outlets included in the journey plan?
  • Is the route serving enough high-potential outlets?
  • Were key SKUs available during the visits?
  • Are credit restrictions limiting orders?
  • Is the salesperson reaching outlets at the right buying time?
  • Are order values too small even when calls are productive?
  • Is the journey sequence creating unnecessary travel?
  • Are some outlets being visited too frequently or too infrequently?
  • Are seasonality or market conditions affecting ordering patterns?

7. Build a Practical FMCG Route Tracker in Excel

A simple Excel tracker can turn daily field activity into a management view.

Route Calls Productive Calls Route Cost Gross Sales Strike Rate CPC CPPC Sales / Productive Call
Wholesale Hub 40 30 1800 95000 75.0% 45 60 3166.67
Suburban GT 35 14 2100 28000 40.0% 60 150 2000

Recommended raw-data columns: Date, Territory, Route, Salesperson, Outlet Code, Outlet Name, Outlet Type, Calls, Productive Calls, Route Cost, Gross Sales, and Remarks.

Keeping the raw data structured makes it easier to use Excel Tables, PivotTables, PivotCharts, filters, and slicers later.

8. Practical Excel Formulas

Assume the tracker uses these columns:

  • B: Calls
  • C: Productive Calls
  • D: Route Cost
  • E: Gross Sales
  • F: Strike Rate
  • G: CPC
  • H: CPPC
  • I: Sales / Productive Call

Use these error-safe formulas:

Strike Rate: =IFERROR(C2/B2,0)
CPC: =IFERROR(D2/B2,0)
CPPC: =IFERROR(D2/C2,0)
Sales / Productive Call: =IFERROR(E2/C2,0)

Using IFERROR prevents unnecessary division errors when calls or productive calls are zero.

9. Use an Excel Table for Automatic Expansion

For a growing route dataset, convert the range into an Excel Table using Ctrl + T. This helps formulas and PivotTable source ranges expand more reliably as new records are added.

A structured dataset also makes filtering by salesperson, territory, route, outlet type, or date much easier.

10. Build a Route Economics Dashboard

A useful dashboard should make the important questions visible quickly rather than simply displaying decorative charts.

Useful KPI cards can include:

  • Total Calls
  • Productive Calls
  • Strike Rate
  • Total Sales
  • Route Cost
  • CPC
  • CPPC
  • Sales Per Productive Call

Recommended dashboard visuals include:

  • Route-wise sales comparison
  • Strike rate by route
  • CPPC by route
  • Sales per productive call
  • Territory-wise route performance
  • Monthly trend of calls and productive calls

Adding Slicers for Territory, Salesperson, Route, and Month can make the dashboard much more useful for field reviews.

11. Advanced Analysis with PivotTables

Once the route data is stored in a clean Excel Table, PivotTables can summarize large datasets without manually calculating every route.

For example, a manager can build a PivotTable with:

  • Rows: Route
  • Values: Calls, Productive Calls, Route Cost, Gross Sales
  • Filters/Slicers: Territory, Salesperson, Month

Calculated metrics such as strike rate, CPC, CPPC, and sales per productive call can then be presented alongside the summarized data using appropriate Excel calculations.

12. Why Can CPPC Be High?

A high CPPC can come from several operational conditions. It should be investigated in context rather than treated as proof that the route is commercially weak.

  • Low strike rate: Many visits but relatively few orders.
  • Low outlet density: More travel between productive opportunities.
  • Low outlet potential: The route may contain outlets with limited purchasing capacity.
  • Stock availability issues: Customers may be willing to buy but cannot order unavailable SKUs.
  • Small order values: Calls may be productive but generate limited sales value.
  • Journey sequencing: Poor route order can increase travel time and cost.
  • Buying frequency: Some outlets naturally order less frequently than others.
  • Seasonality: Demand can vary by month, weather, holidays, or local market conditions.

13. Sales Are Not the Same as Profit

This distinction is important when discussing route economics.

Gross sales show sales value, but they do not automatically represent profit. Discounts, trade schemes, returns, damages, claims, freight, product mix, and other commercial costs can affect contribution.

If reliable contribution data is available, a company can build a more complete route contribution analysis:

Route Contribution = Relevant Contribution − Attributable Route Costs

The exact cost components should follow the company's accounting and commercial policy. There is no universal FMCG margin percentage that should be assumed for every route.

14. Common Route Analysis Mistakes

Mistake Better Approach
Looking only at total sales Review sales with calls, strike rate, order productivity, and route cost.
Using CPC as a profitability measure Treat CPC as a route-efficiency metric and use contribution data for profitability.
Ignoring stock availability Check whether lost orders were caused by availability or assortment issues.
Judging a route from one period Compare consistent periods and consider seasonality and market conditions.
Using formulas without error handling Use IFERROR or appropriate zero-denominator logic.
Manually rebuilding reports every week Use Excel Tables, PivotTables, PivotCharts, and Slicers.

15. A Practical Route Review Process

A simple monthly or weekly review can follow this sequence:

  1. Collect: Record calls, productive calls, sales, and route costs consistently.
  2. Calculate: Measure strike rate, CPC, CPPC, and sales per productive call.
  3. Compare: Compare routes, territories, salespeople, and time periods.
  4. Diagnose: Investigate stock, outlet potential, order size, journey design, and buying patterns.
  5. Act: Improve execution, assortment, outlet coverage, journey sequencing, or call frequency where evidence supports the change.
  6. Review: Measure the next period and check whether the operational change produced a measurable improvement.

Route Economics Checklist

☐ Total calls are recorded consistently

☐ Productive calls follow a clear company definition

☐ Strike rate is calculated correctly

☐ Route cost includes only defined attributable costs

☐ CPC is reviewed as an efficiency metric

☐ CPPC is reviewed alongside strike rate

☐ Sales per productive call is monitored

☐ Stock availability and outlet potential are considered

☐ Route decisions are based on multiple periods where possible

☐ Excel data is structured for repeatable reporting

Final Takeaway

Route economics gives FMCG sales teams a practical way to connect field activity with commercial output. The real value comes from looking at the metrics together: calls, productive calls, strike rate, sales per productive call, CPC, and CPPC.

Excel makes this analysis accessible because the calculations can be automated and the same dataset can be transformed into PivotTables, charts, and management dashboards.

The objective is not simply to identify a route with a high cost figure. The objective is to understand why the result is occurring and then use field evidence to decide what should be improved.

Smart Sales Secrets

Practical sales knowledge, FMCG tools, Excel skills, and field-tested thinking for professionals who want to improve how they work.

Comments

Popular posts from this blog

How to Improve FMCG Retail Execution: A Practical Guide to Shelf Visibility, Availability, Planograms & POSM

FMCG Territory Gap Analysis: How to Find Sales Leakage and Close Market Gaps

Data Cleaning & Excel Automation in FMCG Sales: Turn Raw Sales Data into Actionable Insights