How to Build an Effective FMCG Permanent Journey Plan (PJP): A Practical Guide to Outlet Coverage, Route Planning, Call Frequency & Sales Execution

SMART SALES SECRETS • FMCG 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

By Saleem Jabbar
Practical FMCG Sales, Distributor Operations & Field Execution
What this guide is designed to solve

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.

Practical experience note:

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:

  1. Who? Which salesperson owns the outlet?
  2. Where? Which geographic route or cluster does the outlet belong to?
  3. When? On which day should the outlet normally be visited?
  4. How Often? What visit frequency is appropriate?
  5. 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
PJPRecurring structure of outlet coverage and visit frequency.
Beat / RouteGeographic or customer cluster used for field execution.
Daily Journey PlanThe specific route and calls planned for a particular day.
DSRDaily 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 CodeOUT-00125
Outlet NameABC General Store
ChannelGeneral Trade
AreaArea A
RouteRoute 01
Potential ClassHigh / Medium / Lower
Visit FrequencyBased on business requirement
Last VisitDate
StatusActive / 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.

Important: A/B/C frequency rules should be treated as planning examples, not universal FMCG standards. Actual frequency should be determined by company strategy, territory conditions, outlet potential, product category and service requirements.

6. Build the Frequency Matrix

Once outlets are segmented, assign an appropriate visit frequency.

Segment Illustrative Planning Approach Decision Basis
High PriorityMore frequent coverage may be appropriatePotential, movement, service requirement
Medium PriorityRegular planned coverageSales opportunity and order cycle
Lower PriorityLess frequent planned coverage may be sufficientDemand, 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:

Available Field Time ÷ Average Time Required per Call = Approximate Call Capacity

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:

  1. Which outlets need more frequent coverage?
  2. Which outlets are geographically close?
  3. How much travel time exists between clusters?
  4. How many calls can realistically be completed each day?
  5. Which outlets have specific delivery or ordering constraints?
  6. 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.

Key lesson: PJP quality is not measured by having the same number of outlets every day. It is measured by whether the workload is realistic, commercially justified and executable.

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
1Outlet AHighYesYesYes—
2Outlet BMediumYesYesNoNo 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:

Coverage % = Actual Visits ÷ Planned Visits × 100

In Excel:

=IFERROR(Actual_Visits/Planned_Visits,0)

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.

Productive Call Rate = Productive Calls ÷ Eligible Calls × 100

Excel:

=IFERROR(Productive_Calls/Eligible_Calls,0)

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.

Strike Rate = Productive Orders ÷ Eligible Calls × 100

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.

Average Lines per Order = Total Product Lines Sold ÷ Total Orders

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 overloadedRecalculate daily capacity
Outlet closedReview visit timing
Travel too highRe-cluster geography
Outlet inactiveUpdate outlet master
Operational disruptionDocument 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
SalespersonExecute planned calls and record actual results accurately.
SupervisorReview route feasibility, adherence, missed calls and corrective actions.
Area ManagerReview territory-level effectiveness and approve significant changes according to company process.
Distributor TeamCoordinate 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:

Missed Calls = Planned Visits - Actual Visits

Excel:

=Planned_Visits-Actual_Visits

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:

Outlet Closed • Customer Unavailable • Route Overloaded • Operational Issue • Wrong Outlet Data • Other

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 RateProductive calls ÷ eligible calls.
Strike RateOrders ÷ eligible calls, according to company definition.
Missed CallsPlanned eligible visits not completed.
Average Lines/OrderProduct 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:

SYMPTOM → DATA → ROOT CAUSE → ACTION → FOLLOW-UP

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 CoverageOverloaded routeRecalculate capacity
Low Strike RatePoor outlet timing or demand issueReview outlet frequency and selling conditions
High Travel TimeWeak clusteringRedesign route geography
Repeated Closed OutletsWrong visit timingAdjust visit schedule
Low Lines/OrderNarrow product mixReview 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

  1. Creating the PJP without a clean outlet master.
  2. Assigning the same frequency to every outlet.
  3. Ignoring travel time.
  4. Loading too many calls into one day.
  5. Measuring only call quantity.
  6. Ignoring productive calls.
  7. Recording missed calls without reasons.
  8. Using inconsistent Excel data entries.
  9. Building dashboards without clear KPI definitions.
  10. Changing routes without documenting the reason.
  11. Ignoring delivery constraints.
  12. Treating the PJP as a static document.
  13. 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 → SEGMENT → CLUSTER → PLAN → EXECUTE → MEASURE → DIAGNOSE → IMPROVE

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.

The practical formula is:

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.

SMART SALES SECRETS
Practical knowledge for the complete sales journey — from Salesman to Supervisor, Area Manager, Regional Manager and beyond.
Important Note: Examples, formulas and planning structures in this article are illustrative. Actual PJP design, call frequency, productivity expectations, delivery windows and KPI definitions vary by company, territory, channel, product category and operating model. Always adapt the framework to your organization's approved policies and actual field conditions.

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