Free Excel builder - with a headcount calculator

Beat plan: build one and see how many reps it needs

A beat plan says which customers a field person visits, on which weekday and in which weeks. Most templates stop at a list. This builder also shows the daily load, flags customers who are under-covered, and works out how many reps your customer list actually needs.

Free Excel workbook and an on-page calculator. No signup, no watermark.

Calculator

How many reps does your customer list need?

ClassCustomersVisits a month
A
B
C

What this beat needs

3

reps (2.5 before rounding up)

Visits needed a month
440
One rep can do a month
172
Visits a day per rep at 3 reps
6.1

Buffer covers travel gaps, leave and holidays. Classes and visits a month are yours to change.

Enter customers by class and the visits a month each class gets. Change the capacity to match your team. The workbook below does the same sum, then shows which weekdays are overloaded.

Download

Beat plan builder (Excel)

Beat plan builder with reps needed

Four sheets. Settings holds your class rhythm and rep capacity. Customers takes up to 100 customers with a class, weekday and weeks, and checks each one. Daily load counts visits per weekday per week and turns red above capacity. Reps needed gives the headcount, coverage and a list of plan checks. Thirty fictional customers show how it works, so clear them first.

Download .xlsx

How to build one

A beat plan in five steps

  1. 1

    List every customer you want covered

    Include the ones you visit rarely. A beat built only from favourites quietly drops everyone else.

  2. 2

    Give each one a class

    A for customers worth a visit every week, B for every fortnight, C for once a month. Class follows value and potential, not how friendly the owner is.

  3. 3

    Turn classes into visits a month

    A is four, B is two, C is one in the default rhythm. Multiply customers by visits and you know the work the beat contains before you assign anything.

  4. 4

    Give each customer a weekday and weeks

    Group customers by area so one day stays in one part of town. Spread A customers across every week and alternate B customers between weeks 1 and 3, or 2 and 4.

  5. 5

    Check the load and the headcount

    No weekday should carry more visits than one rep can do. Compare visits needed with what one rep can do in a month to see how many reps the beat needs.

Frequency

Customer classes and the weeks they are visited

ClassRhythmVisitsWeeks
AEvery week4 a monthWeeks 1, 2, 3 and 4
BEvery fortnight2 a monthWeeks 1 and 3, or 2 and 4
COnce a month1 a monthOne week, rotated

These are defaults. Change the visits a month for each class in the Settings sheet or the calculator.

Where it goes wrong

Four beat planning mistakes

  • Plotting a route and calling it a beat

    A beat is a coverage promise: who is visited how often. The route is how a day delivers it.

  • Loading Monday and Saturday

    Teams plan the middle of the week and leave the ends light. The load grid in the workbook shows it in red.

  • No buffer

    Reps lose time to travel gaps, leave and holidays. Plan to 90% of capacity or the first absence breaks the plan.

  • Never reclassifying

    A customer that grows stays a C for two years. Review classes every quarter against actual orders.

Beyond Excel

From a plan to proof that it was followed

A beat plan only matters if you can see what happened. In Zeba's site visit management software a manager plans each person's day from a week grid, chooses a set route or any order, copies last week and sees suggestions of customers not visited for the longest. The person sees the plan on the phone and marks each visit with a photo and note, and the manager sees planned against done. Zeba does not optimise routes or take orders. Pair it with field staff tracking and the site visit report card for the visit itself.

Got questions?

Beat plan: FAQs

Definitions, frequency, headcount and tracking.

  • A schedule that says which customers a field person visits, on which weekday and in which weeks of the month. It turns a customer list into a coverage commitment, so that every customer is visited as often as its importance deserves.
  • The two terms are used loosely. In most teams a beat plan is the repeating monthly schedule of areas and customers, and a journey plan is the actual route and order for one day.
  • It depends on visits a day and the visit frequency of your classes. As an example, a rep doing 8 visits a day for 24 days with a 10% buffer can do about 172 visits a month. With a 4, 2, 1 rhythm that is roughly 24 customers in each class, or far more if most are class C. Use the calculator for your own numbers.
  • Use class. Keep two or three classes only, tie each to a monthly visit count, and base the class on order value or potential. More classes than that make the plan hard to read.
  • Yes. The workbook on this page has a Customers sheet with class, weekday and weeks, a Daily load grid that turns red when a day is overloaded, and a Reps needed summary.
  • Compare planned visits with recorded visits. On paper that means checking cards after the fact. In Zeba, the manager sees planned against done for each person and day, with the position and photo for every visit.

Plan the week once, then see planned against done for every person. Zeba shows each visit with its photo and position.