FMCG Territory Gap Analysis: How to Find Sales Leakage and Close Market Gaps
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.
```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?
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.
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 |
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.
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
How large is the gap?
Where is the gap?
What factors may explain it?
What measurable action is required?
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?”
Practical Sales • FMCG • Excel • Data • Field Execution
Built to turn practical sales knowledge into useful, actionable tools.
```
Comments
Post a Comment