How to Build an Effective FMCG Permanent Journey Plan (PJP): A Practical Guide to Outlet Coverage, Route Planning, Call Frequency & Sales Execution
How to Build an Effective FMCG Permanent Journey Plan (PJP)
A Practical Guide to Outlet Coverage, Route Planning, Call Frequency, Productivity & Sales Execution
Practical FMCG Sales, Distributor Operations & Field Execution
A Permanent Journey Plan should do more than list outlet names against weekdays. A useful PJP creates a repeatable structure for deciding which outlets should be visited, how often they should be visited, which outlets belong together geographically, how much work a salesperson can realistically complete, and how execution should be measured and improved.
Introduction: Why a Good PJP Matters in FMCG Sales
In FMCG sales, market coverage is not simply about having a large outlet list. A salesperson can have hundreds of outlets in a territory and still lose productivity if the journey plan creates excessive travel, unrealistic call loads, irregular visits or poor coordination between order taking and delivery.
A well-designed Permanent Journey Plan (PJP) provides a recurring operating structure for field sales. It helps the sales team organize outlet coverage, visit frequency, route geography, daily workload and execution measurement.
However, there is no single PJP template that is correct for every FMCG company. The appropriate structure depends on factors such as outlet density, product category, sales potential, order cycle, territory size, distribution model, service expectations, working days and distributor capability.
This guide therefore presents a practical planning framework rather than a universal set of fixed rules.
With over 11 years of experience in corporate sales and field sales operations, I have seen that route plans become much more useful when they are connected to actual outlet potential, geography, sales capacity, distributor execution and measurable field results. The framework below is built around those practical considerations and should be adapted to the policies and operating model of each company.
How This Practical PJP Framework Was Developed
This framework combines practical field-sales planning logic with the operational questions that supervisors and managers need to answer when reviewing a territory.
The planning approach considers:
- Outlet universe and outlet classification
- Historical sales and commercial potential
- Geographic clustering and travel efficiency
- Call frequency and customer service requirements
- Salesperson working capacity
- Planned versus actual calls
- Productive versus non-productive calls
- Strike rate and average lines per order
- Order-to-delivery coordination
- Route adherence and legitimate deviations
- Distributor and supervisor review
- Excel-based tracking and dashboard reporting
The objective is not to create a complicated document. The objective is to create a PJP that a salesperson can execute, a supervisor can verify, and a manager can use for better decisions.
Who This Guide Is For
This guide can be useful for:
- Salesmen and order bookers
- Sales supervisors
- Territory and area managers
- Distributor sales teams
- Sales operations teams
- FMCG business owners managing field coverage
- Professionals building PJP trackers and sales dashboards in Excel
What You Will Learn
- How to build the outlet universe before creating routes
- How to segment outlets according to business requirements
- How to determine practical visit frequencies
- How to cluster outlets geographically
- How to calculate realistic salesperson capacity
- How to create a daily and weekly PJP
- How to distinguish planned calls from productive calls
- How to measure route adherence and missed calls
- How to connect PJP execution with secondary sales
- How to build an Excel PJP tracker and dashboard
- How to diagnose weak route performance
- How to audit and continuously improve a PJP
1. What Is a Permanent Journey Plan?
A Permanent Journey Plan is a recurring schedule that defines the planned sequence and frequency of market visits for a salesperson or sales team.
At its simplest, it answers five questions:
- Who? Which salesperson owns the outlet?
- Where? Which geographic route or cluster does the outlet belong to?
- When? On which day should the outlet normally be visited?
- How Often? What visit frequency is appropriate?
- How Will It Be Measured? Was the planned visit completed and was it productive?
A PJP is different from a simple outlet list. It converts the outlet universe into an executable field plan.
2. PJP vs Beat Plan vs Daily Route vs DSR
| Term | Purpose |
|---|---|
| PJP | Recurring structure of outlet coverage and visit frequency. |
| Beat / Route | Geographic or customer cluster used for field execution. |
| Daily Journey Plan | The specific route and calls planned for a particular day. |
| DSR | Daily Sales Report showing actual sales and execution results. |
3. Start With the Outlet Universe — Not the Route Sheet
One of the most common PJP mistakes is starting with weekdays before confirming which outlets actually exist in the territory.
Create an outlet master first.
| Field | Example |
|---|---|
| Outlet Code | OUT-00125 |
| Outlet Name | ABC General Store |
| Channel | General Trade |
| Area | Area A |
| Route | Route 01 |
| Potential Class | High / Medium / Lower |
| Visit Frequency | Based on business requirement |
| Last Visit | Date |
| Status | Active / Inactive |
Before finalizing the PJP, remove duplicate outlets, investigate inactive outlets, update addresses and verify that the outlet master reflects the current market.
4. Data Quality Comes Before Route Quality
A sophisticated dashboard cannot compensate for poor master data.
Before building the route, check:
- Are outlet codes unique?
- Are duplicate outlets removed?
- Are permanently closed outlets marked inactive?
- Are new outlets included?
- Are salesperson assignments current?
- Are geographic areas correctly classified?
- Are recent sales records available where relevant?
- Has the outlet list been physically verified where necessary?
For a practical operation, the outlet master should be reviewed periodically rather than treated as a permanent document that never changes.
5. Segment Outlets Before Assigning Visit Frequency
Not every outlet requires the same service frequency. Segmentation should consider factors such as:
- Sales potential
- Historical order frequency
- Product range
- Customer importance
- Stock movement
- Channel characteristics
- Service requirements
- Geographic practicality
You may use a simple High / Medium / Lower classification, or a more detailed commercial segmentation.
6. Build the Frequency Matrix
Once outlets are segmented, assign an appropriate visit frequency.
| Segment | Illustrative Planning Approach | Decision Basis |
|---|---|---|
| High Priority | More frequent coverage may be appropriate | Potential, movement, service requirement |
| Medium Priority | Regular planned coverage | Sales opportunity and order cycle |
| Lower Priority | Less frequent planned coverage may be sufficient | Demand, geography and service economics |
The key principle is simple: frequency should be justified by business need, not copied from another territory.
7. Geographic Clustering to Reduce Unproductive Travel
After deciding frequency, group outlets into practical geographic clusters.
For example:
- Monday — Route 01
- Tuesday — Route 02
- Wednesday — Route 03
- Thursday — Route 04
- Friday — Route 05
- Saturday — Route 06 or required cycle coverage
This is only an illustration. The correct structure depends on territory size, outlet density, traffic conditions, working hours and company policy.
A route should minimize unnecessary movement while still meeting the required customer coverage.
8. Calculate Salesperson Capacity Before Loading the Route
A PJP becomes unrealistic when more calls are assigned than a salesperson can reasonably complete.
Consider:
- Available field hours
- Average time per outlet
- Travel time between outlets
- Breaks and administrative requirements
- Order-taking complexity
- Outlet operating hours
- Traffic and geographic constraints
- Special customer requirements
An illustrative capacity calculation can be expressed as:
This is only a planning estimate. Travel time and operational interruptions must also be considered.
9. Worked Example: Turning an Outlet Universe Into a PJP
Consider a hypothetical territory containing 120 active outlets:
- 24 high-priority outlets
- 48 medium-priority outlets
- 48 lower-priority outlets
Suppose management decides, after reviewing sales potential and service requirements, that the territory needs a six-day recurring cycle. The supervisor should not simply divide 120 outlets by six and assume 20 calls per day.
Instead, the supervisor should ask:
- Which outlets need more frequent coverage?
- Which outlets are geographically close?
- How much travel time exists between clusters?
- How many calls can realistically be completed each day?
- Which outlets have specific delivery or ordering constraints?
- Where are missed calls already occurring?
The result may be a route where daily call counts differ. That is not necessarily a problem. A route with fewer calls can be appropriate if the outlets require more travel or service time.
10. Create the Daily Journey Plan
A practical daily route sheet should answer:
- Which salesperson?
- Which route?
- Which outlets?
- What sequence?
- What priority?
- What planned visit?
- What actual visit?
- What order result?
- What reason was recorded if the visit was missed?
| Sequence | Outlet | Priority | Planned | Actual | Order | Reason if Missed |
|---|---|---|---|---|---|---|
| 1 | Outlet A | High | Yes | Yes | Yes | — |
| 2 | Outlet B | Medium | Yes | Yes | No | No requirement |
11. Planned Calls vs Actual Calls
A PJP should never be evaluated only by what was planned. Actual execution must be recorded.
For example:
In Excel:
This KPI should be interpreted together with route quality, outlet importance and reasons for deviation. A low percentage may indicate weak execution, but it can also reflect genuine operational constraints.
12. Productive Calls vs Total Calls
A visit is not automatically productive just because the salesperson reached the outlet.
Depending on the company's reporting definition, a productive call may involve an order, required sales activity, merchandising execution or another measurable commercial outcome.
Excel:
13. Route Adherence: Was the Planned Route Actually Followed?
Coverage alone may not explain what happened in the field.
Track whether the salesperson followed the planned route and record legitimate deviations.
Possible reasons for deviation include:
- Outlet closed
- Customer unavailable
- Emergency market issue
- Delivery-related requirement
- Weather or road disruption
- Management-approved route change
- Incorrect outlet information
- Other documented operational reason
The objective is not to punish every deviation. The objective is to distinguish planned flexibility from uncontrolled route discipline.
14. Connect PJP With Secondary Sales
A PJP is a sales execution tool, so route reporting should eventually connect with sales outcomes.
Useful measures can include:
- Sales value by route
- Sales value by salesperson
- Number of productive outlets
- Strike rate
- Average lines per order
- Outlet-level sales trend
- Missed-call count
- New outlet activation
Do not assume that a higher call count automatically means better performance. Quality of coverage and commercial productivity should be evaluated together.
15. Strike Rate — Measure It, But Interpret It Carefully
Strike rate generally describes the proportion of eligible calls that result in an order, according to the company's definition.
A low strike rate may result from several different causes:
- Weak outlet selection
- Low demand
- Stock availability issues
- Pricing or competitive pressure
- Incorrect visit timing
- Weak selling execution
- Outlet already holding sufficient stock
- Incorrect route frequency
Therefore, the KPI should trigger investigation rather than an automatic conclusion about salesperson performance.
16. Average Lines Per Order
Two salespeople may generate the same number of orders while producing different product-mix results.
Average lines per order can provide another layer of analysis.
This can help identify whether orders are narrow or whether the salesperson is successfully developing the product range where appropriate.
17. Missed Calls Must Have a Reason
Simply counting missed calls is not enough.
Create a reason category so management can identify patterns.
| Missed-Call Reason | Possible Corrective Action |
|---|---|
| Route overloaded | Recalculate daily capacity |
| Outlet closed | Review visit timing |
| Travel too high | Re-cluster geography |
| Outlet inactive | Update outlet master |
| Operational disruption | Document and review |
18. Order-to-Delivery Execution Must Align With the PJP
Order taking and delivery are connected processes. If the sales route creates orders that cannot be serviced according to the distributor's operating model, customer experience can suffer.
Therefore, PJP planning should consider:
- Order cut-off times
- Delivery schedules
- Distributor warehouse capacity
- Vehicle availability
- Geographic delivery constraints
- Customer service commitments
- Credit and approved commercial limits where applicable
There is no universal 24-hour delivery rule for every FMCG operation. Service windows vary by company, geography, distributor capability and customer agreement.
19. PJP Governance: Who Owns What?
| Role | Typical Responsibility |
|---|---|
| Salesperson | Execute planned calls and record actual results accurately. |
| Supervisor | Review route feasibility, adherence, missed calls and corrective actions. |
| Area Manager | Review territory-level effectiveness and approve significant changes according to company process. |
| Distributor Team | Coordinate order processing, stock and delivery execution. |
20. Build an Excel PJP Tracker
Excel can turn a static PJP into a practical management tool.
A useful workbook can contain:
- Outlet Master
- PJP Master
- Daily Execution
- Sales Data
- Missed Call Reasons
- KPI Summary
- Management Dashboard
Recommended PJP Tracker Columns
| Date | Salesperson | Route | Outlet Code | Outlet Name | Planned | Actual | Productive | Sales | Reason |
|---|---|---|---|---|---|---|---|---|---|
| Date | Name | R01 | OUT001 | ABC Store | Yes | Yes | Yes | Amount | — |
21. Useful Excel Functions for PJP Management
Depending on workbook structure, useful functions can include:
- SUMIFS — summarize sales by salesperson, route, outlet or period.
- COUNTIFS — count planned, actual or productive calls.
- XLOOKUP — retrieve outlet or salesperson information from master data.
- IFERROR — prevent calculation errors in KPI formulas.
- PivotTables — summarize execution by route, salesperson or date.
- PivotCharts — visualize trends.
- Data Validation — standardize route, status and reason selections.
- Conditional Formatting — highlight missed calls and weak coverage.
Example:
Excel:
22. Use Data Validation to Improve Data Quality
Free-text reporting creates unnecessary variations such as:
- Missed
- missed call
- Miss call
- MC
Instead, create a controlled dropdown list.
For example:
This makes PivotTables and dashboards much more reliable.
23. Build a PJP Management Dashboard
A management dashboard should show the information needed for action, not simply decorate the spreadsheet.
Useful KPI cards include:
- Planned Calls
- Actual Calls
- Coverage %
- Productive Calls
- Productive Call Rate
- Strike Rate
- Missed Calls
- Sales Value
- Average Lines per Order
Useful charts can include:
- Coverage by salesperson
- Coverage by route
- Sales by route
- Missed calls by reason
- Productive calls trend
- Outlet-level sales trend
A dashboard should allow a manager to move from “What happened?” to “Why did it happen?” and finally to “What should we change?”
24. PJP KPI Definitions Must Be Clear
Different companies can define KPIs differently. Therefore, document the exact definition used in your workbook.
| KPI | Definition |
|---|---|
| Coverage % | Actual eligible visits ÷ planned eligible visits. |
| Productive Call Rate | Productive calls ÷ eligible calls. |
| Strike Rate | Orders ÷ eligible calls, according to company definition. |
| Missed Calls | Planned eligible visits not completed. |
| Average Lines/Order | Product lines sold ÷ orders. |
25. Root-Cause Analysis: Do Not Stop at the KPI
Suppose coverage falls. The next question should be: Why?
Use a simple diagnostic structure:
Example:
Symptom: Route 04 has repeated missed calls.
Data: The route contains a high number of outlets and significant travel time.
Possible root cause: The route may be overloaded rather than simply poorly executed.
Action: Recalculate route capacity and review geographic clustering.
Follow-up: Monitor the revised route for the next review cycle.
26. Corrective Action Framework
| Problem | Possible Cause | Corrective Action |
|---|---|---|
| Low Coverage | Overloaded route | Recalculate capacity |
| Low Strike Rate | Poor outlet timing or demand issue | Review outlet frequency and selling conditions |
| High Travel Time | Weak clustering | Redesign route geography |
| Repeated Closed Outlets | Wrong visit timing | Adjust visit schedule |
| Low Lines/Order | Narrow product mix | Review assortment opportunity |
27. PJP Governance and Change Control
A PJP should not change casually every few days, but it also should not become permanently frozen.
Maintain a simple change log:
- PJP version
- Effective date
- Route changed
- Reason for change
- Approved by
- Review date
This creates traceability and helps management understand whether repeated changes are solving a problem or simply creating instability.
28. When a PJP Needs Different Treatment
The framework in this article is designed for practical FMCG field-sales planning, but different operating models may require different approaches.
For example:
- Pre-sales operations
- Van sales
- Wholesale distribution
- Modern trade
- Direct distribution
- Rural territories
- Highly seasonal businesses
- Territories with major delivery constraints
- Businesses with telesales or digital ordering
In these situations, the PJP should be adapted rather than copied unchanged.
29. Review the PJP Periodically
A permanent journey plan should be recurring, but the word “permanent” does not mean “never change.”
Review it when:
- The outlet universe changes significantly
- Territory boundaries change
- Salesperson responsibility changes
- Product portfolio changes
- Customer behavior changes
- Delivery capability changes
- Repeated missed calls appear
- Travel time becomes inefficient
- New commercial priorities are introduced
The objective is controlled improvement, not constant route disruption.
30. Common FMCG PJP Mistakes
- Creating the PJP without a clean outlet master.
- Assigning the same frequency to every outlet.
- Ignoring travel time.
- Loading too many calls into one day.
- Measuring only call quantity.
- Ignoring productive calls.
- Recording missed calls without reasons.
- Using inconsistent Excel data entries.
- Building dashboards without clear KPI definitions.
- Changing routes without documenting the reason.
- Ignoring delivery constraints.
- Treating the PJP as a static document.
- Using one territory's route logic as a universal rule.
31. Practical PJP Audit Checklist
☐ Outlet master is updated
☐ Duplicate outlets have been checked
☐ Inactive outlets are identified
☐ Salesperson ownership is correct
☐ Outlet segmentation has a clear business basis
☐ Visit frequency is documented
☐ Routes are geographically practical
☐ Daily workload is realistic
☐ Travel time has been considered
☐ Planned calls are measurable
☐ Actual calls are captured
☐ Productive calls are defined
☐ Missed calls have reasons
☐ Strike-rate definition is documented
☐ Sales data can be connected to routes
☐ Excel formulas have been checked
☐ Dashboard KPIs have clear definitions
☐ Route changes are documented
☐ Distributor delivery constraints are considered
☐ PJP has a review cycle
32. PJP Quality Test: Can Someone Else Understand It?
A strong practical test is to give the PJP to another supervisor and ask whether they can understand:
- Who owns each outlet?
- Which route does the outlet belong to?
- When should it normally be visited?
- How often should it be visited?
- How many calls are expected?
- What happened during actual execution?
- Why were calls missed?
- Which routes are underperforming?
- What corrective action is required?
If the answers require the original planner to explain everything verbally, the PJP may need better documentation.
33. The Smart PJP Framework
MAP: Build the complete outlet universe.
SEGMENT: Classify outlets using relevant commercial and operational factors.
CLUSTER: Group outlets into practical geographic routes.
PLAN: Assign frequency and realistic daily workload.
EXECUTE: Follow the route and record actual results.
MEASURE: Track coverage, productivity, strike rate, sales and other defined KPIs.
DIAGNOSE: Investigate the reasons behind weak results.
IMPROVE: Correct the route, frequency, data or execution process based on evidence.
34. Frequently Asked Questions
What is the main purpose of a PJP?
The main purpose is to create a structured, recurring plan for market coverage so that the sales team knows which outlets to visit, when to visit them and how execution will be measured.
Should every outlet be visited with the same frequency?
No. Visit frequency should reflect business requirements, outlet potential, order cycle, service expectations, geography and company strategy.
How many calls should a salesperson make in one day?
There is no universal number that is appropriate for every territory. Capacity depends on field hours, travel time, outlet density, call complexity and operating conditions.
Is a PJP only for salespeople?
It is primarily an execution plan for field sales, but supervisors, area managers and distributor teams can use it for planning, monitoring and coordination.
Can I create a PJP in Excel?
Yes. Excel can be used to maintain the outlet master, route plan, daily execution, KPI calculations and management dashboard.
What is the difference between coverage and strike rate?
Coverage measures whether planned visits were completed. Strike rate generally measures how many eligible calls generated an order, according to the company's definition. They answer different questions.
Should a PJP ever be changed?
Yes. It should be reviewed and adjusted when outlet distribution, territory structure, customer behavior, product strategy or operational conditions materially change.
What should management do when coverage is low?
First identify the reason. Check route capacity, travel time, outlet availability, operational disruptions and execution behavior before deciding on a corrective action.
35. Final Takeaway
A Permanent Journey Plan is more than a weekly list of outlets. A useful FMCG PJP connects market geography, outlet potential, visit frequency, salesperson capacity, daily execution, distributor coordination and measurable performance.
The strongest PJP is not necessarily the one containing the most outlets. It is the one that can be realistically executed, measured consistently, explained with reliable data and improved when market conditions change.
If you are building a PJP from scratch, start with the outlet universe. Then segment, cluster, calculate capacity, assign frequencies, create the route, measure execution and investigate the reasons behind gaps.
MAP → SEGMENT → CLUSTER → PLAN → EXECUTE → MEASURE → DIAGNOSE → IMPROVE
About the Author
Saleem Jabbar writes practical sales and FMCG resources through Smart Sales Secrets, focusing on field execution, distributor operations, sales reporting, Excel, inventory and commercial decision-making.
The frameworks published here are intended as practical guidance based on sales and field-operations experience. Company policies, customer agreements, local market conditions and distributor operating models should always be considered before applying a framework in the field.
Practical knowledge for the complete sales journey — from Salesman to Supervisor, Area Manager, Regional Manager and beyond.
Comments
Post a Comment