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

Smart Sales Secrets • Sales Operations • Excel
```

FMCG Territory Gap Analysis: How to Find Sales Gaps and Improve Field Execution

A practical Excel framework for comparing target vs. achievement, locating sales gaps, investigating outlet and route performance, and turning field data into measurable action.

```
Practical FMCG Perspective: This guide is designed around the type of territory, outlet, route, distribution and sales analysis used in day-to-day field sales management. The examples are illustrative and can be adapted to a company's own reporting structure.

In FMCG sales, a territory can miss its target for many different reasons. The problem may be related to outlet coverage, SKU availability, route execution, distributor service, customer buying patterns, competitor activity, seasonality, or simply a change in the productivity of the market.

The important point is that a territory sales gap is a measurement problem first and a diagnosis problem second. A simple month-end total may tell you that sales are below target, but it does not automatically tell you where the gap started or what caused it.

Smart Sales Principle

A sales gap is a signal, not a diagnosis. First measure the gap, then locate it, investigate the relevant drivers, and only then decide the appropriate action.

What Is FMCG Territory Gap Analysis?

Territory gap analysis is the process of comparing planned sales with actual sales and then breaking the result down into useful dimensions such as salesperson, route, outlet, brand, SKU and time period.

A useful territory review should help answer questions such as:

  • What was the sales target?
  • How much was actually achieved?
  • How large is the weekly or monthly gap?
  • Which salesperson or route contributed to the gap?
  • Which outlets are declining?
  • Which brands or SKUs are losing movement?
  • Are productive calls and strike rate changing?
  • Are priority SKUs available in key outlets?
  • Is the planned journey plan being executed?
  • What action should be taken, by whom, and when should it be reviewed?

1. Start With Target vs. Achievement

The first step is simple: compare the target with actual achievement. Weekly analysis is often more useful than waiting until the end of the month because it can reveal a developing problem early enough to investigate it.

Week Target Achievement Shortfall Achievement %
Week 1 250,000 238,000 12,000 95.2%
Week 2 250,000 220,000 30,000 88.0%
Week 3 250,000 205,000 45,000 82.0%

Excel formulas:

Shortfall

=MAX(B2-C2,0) ```

Achievement %

=IF(B2=0,"",C2/B2)

Shortfall %

=IF(B2=0,"",MAX(B2-C2,0)/B2) ```

The example shows a worsening weekly achievement trend. That tells the sales manager that the gap deserves investigation; it does not, by itself, identify the cause.

2. Break the Territory Into Useful Dimensions

A territory total is only the starting point. The next step is to determine where the result changed.

Dimension What to Review
Salesperson Sales, calls, productive calls and trend
Route Coverage, sales and PJP execution
Outlet Previous-period vs. current-period sales
Brand Brand-wise movement
SKU Availability and sales trend
Time Daily and weekly trend

3. Find Sales Gaps at Outlet Level

Territory-level analysis can hide important outlet-level changes. A territory may appear stable overall while several important outlets are declining.

Outlet Previous Sales Current Sales Change
Al-Madina Store 18,500 11,200 -7,300
New City Mart 14,000 8,500 -5,500
Super Choice 9,500 9,100 -400

For a declining outlet, investigate questions such as:

  • Was the required stock available?
  • Did the outlet's buying pattern change?
  • Were priority SKUs available?
  • Was the outlet visited according to the planned frequency?
  • Was distributor delivery or service affected?
  • Did competitor activity change?
  • Is there a seasonal or local-demand factor?
Important: A declining outlet is an investigation point. It is not automatically proof that the salesperson is responsible for the decline.

4. Measure Productive Calls and Strike Rate

Sales calls provide another useful layer of territory analysis. One common metric is strike rate, which measures the proportion of total calls that become productive calls according to the company's definition.

Strike Rate = Productive Calls ÷ Total Calls

Example: 40 total calls and 28 productive calls
Strike Rate = 28 ÷ 40 = 70%

Excel formula:

=IF(D2=0,"",E2/D2)

A low strike rate should be investigated rather than automatically interpreted as poor field performance. Outlet selection, product availability, customer demand, route design, timing and other commercial factors can affect the result.

5. Check Distribution and SKU Availability

Sales performance can also change when important SKUs are repeatedly unavailable or when distribution coverage changes.

A territory review can include:

  • Repeated out-of-stock situations
  • Numeric distribution or relevant outlet coverage
  • Outlet coverage by salesperson and route
  • Brand-wise movement
  • SKU-wise sales trends
  • Distributor order fulfilment and service
  • Availability of priority SKUs in important outlets

Numeric distribution generally refers to the percentage or count of relevant outlets carrying a product, according to the company's measurement method.

If a priority SKU repeatedly becomes unavailable, there may be a supply or distribution component. The correct approach is to investigate the evidence before deciding which factor is the primary cause.

6. Analyse Routes and PJP Execution

PJP stands for Permanent Journey Plan — the planned schedule and route structure used for regular market visits.

Comparing planned calls with actual calls can reveal whether the route is being executed as designed or whether the plan itself needs review.

Route Planned Calls Actual Calls Productive Calls Sales Sales / Productive Call
Route A 45 42 29 165,000 5,689.66
Route B 40 31 18 112,000 6,222.22

Sales / Productive Call = Sales ÷ Productive Calls

Notice that Route B has a higher sales-per-productive-call figure in this example. That does not automatically mean Route B is better. Outlet mix, route potential, SKU mix, customer type and other factors can influence the metric.

If planned calls are consistently higher than actual calls, investigate PJP execution, route practicality, outlet availability, travel time, workload and route design.

7. Build the Analysis in Excel

Excel becomes much more powerful when the source data is structured correctly. A simple sales table can support PivotTables, PivotCharts, formulas and slicers.

Recommended Sales Data Structure

Date Salesperson Route Outlet Brand SKU Sales
01-Sep Ahmed Route A Al-Madina Brand X SKU-01 5,500
01-Sep Bilal Route B New City Mart Brand Y SKU-02 3,200
Important Excel modelling point: Keep call activity at its own reporting level when the sales table contains multiple SKU rows per outlet. Repeating the same call count on every SKU row can inflate PivotTable totals and produce misleading strike-rate calculations.

Separate Call Activity Table

Date Salesperson Route Total Calls Productive Calls
01-Sep Ahmed Route A 10 7
01-Sep Bilal Route B 8 5

With properly structured data, you can build:

  • Sales by salesperson
  • Sales by route
  • Sales by outlet
  • Sales by brand and SKU
  • Daily and weekly sales trends
  • Total calls and productive calls
  • Strike rate
  • Sales per productive call

PivotTables and PivotCharts can turn these datasets into a practical territory dashboard. Depending on the Excel version and workbook design, slicers can also be used for salesperson, route, brand, SKU and month-level filtering.

Data-model tip: Keep targets at the correct reporting level and period. Do not simply repeat a monthly target on every transaction row unless the workbook has been designed to handle that structure correctly.

8. Core Excel Formulas for Territory Analysis

Metric Excel Formula
Shortfall =MAX(B2-C2,0)
Achievement % =IF(B2=0,"",C2/B2)
Shortfall % =IF(B2=0,"",MAX(B2-C2,0)/B2)
Strike Rate =IF(D2=0,"",E2/D2)
Sales / Productive Call =IF(E2=0,"",C2/E2)

Formula references assume the worksheet layout used in the examples. Adjust the cell references to match your own workbook. Format percentage formulas as percentages and currency values according to your business reporting convention.

9. Convert the Analysis Into an Action Plan

Analysis has limited value if the report ends with “sales are low.” The next step is to connect the evidence with a specific action, owner and review point.

Observed Signal What to Investigate Possible Action
Sales declining in key outlets Stock, buying pattern, competitor activity, visit frequency Prioritize affected outlets and verify the reason
Low strike rate Outlet selection, availability, call execution Review repeated nonproductive calls and their causes
SKU sales declining Availability, distribution and demand Check distributor/outlet stock and distribution coverage
Weak route coverage PJP execution, route design and workload Compare planned vs. actual calls and review route practicality

Avoid vague actions such as “Improve sales.” A stronger action identifies what needs to change, who owns it, and when the result will be reviewed.

10. Use the Five-Step Territory Diagnosis

1. Measure
How large is the gap?
```
2. Locate
Where is the gap?
3. Investigate
What factors may explain it?
4. Act
What measurable action is required?
5. Follow Up
Did the action change the result?
```

11. Common Territory Analysis Mistakes

  • Waiting until month-end to investigate the gap
  • Looking only at territory totals
  • Assuming the cause before checking the evidence
  • Ignoring outlet-level sales trends
  • Repeating manual reports without improving the data structure
  • Treating every shortfall as a permanent problem
  • Ignoring distribution or SKU availability
  • Comparing routes without considering route potential and outlet mix
  • Stopping the analysis after identifying the gap
  • Creating a dashboard without defining the action that should follow it

12. Weekly Territory Review Checklist

Frequently Asked Questions

What is the main purpose of FMCG territory gap analysis?

Its purpose is to identify where actual sales are diverging from the plan and provide a structured way to investigate the factors behind the difference.

Can Excel be used for territory gap analysis?

Yes. Excel can be used to structure sales data, calculate achievement and shortfall, analyse outlet and route trends, create PivotTables and PivotCharts, and build interactive reporting with tools such as slicers where appropriate.

Does a sales shortfall automatically mean poor salesperson performance?

No. A shortfall is an outcome that requires investigation. Availability, distribution, outlet demand, route structure, customer mix, competition, seasonality and other factors can also influence sales.

Why should call data sometimes be kept separately from sales data?

If one outlet visit contains multiple SKU-level sales rows, repeating the same call count on each row can inflate totals in PivotTables. Keeping call activity at its appropriate reporting level helps prevent double-counting.

Final Takeaway

```

Effective territory management is not simply about knowing whether a target was achieved. It is about understanding how the result developed, where the gap occurred, what evidence may explain it, and what measurable action should happen next.

A practical FMCG territory analysis connects target achievement with weekly trends, salesperson activity, route execution, outlet movement, SKU availability and distribution. With a properly structured Excel workbook, formulas, PivotTables, PivotCharts and relevant filters can turn raw sales data into a repeatable management process.

The key question is:
“Where did the gap occur, what evidence explains it, and what measurable action should happen next?”

```
Smart Sales Secrets
```

Practical Sales • FMCG • Excel • Data • Field Execution

Built to turn practical sales knowledge into useful, actionable tools.

```

Comments

Popular posts from this blog

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

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