In E-commerce as well as offline modern trade, consumers are truly the king, with every tick of the clock bringing new choices.
Hence it has become both, vital and challenging for enterprises to be close to the end consumer.
An efficient distribution system, which reduces order to delivery and replenishment time becomes the key arrow in the arsenal of a Fast-Moving Consumer Goods (FMCG) company.
The key element to this is “Sales Beat Planning”.
“Sales Beat Plan” also called “Permanent Journey Plan” is a day level route plan made for field sales and marketing executives to visit several stores at a pre-defined frequency.
These visits are necessary not only to handle order collection but also for visual merchandising and most importantly competitor analysis.
Stock outages are periodically reported from retail stores as well as distributors to continuously replenish the orders. Stock displays at all stores are regularly audited and changed to gain a competitive advantage.
When one of the world’s largest FMCG enterprises approached us to optimize their sales beat planning with high benchmarked figures in mind, We at Locus decided to solve this for them. Without much ado, we jumped right in!
The goal of optimizing the sales beats was to have the right service levels at each retail outlet. The intent was to ensure that every outlet is serviced by the right person on the right day at the right time.
While doing so, it was also intended to come up with the most ideal beat size (the most optimal number of outlets within a beat) keeping the best possible mix of outlet types.
Additionally, what also needs to be suggested, was the sequence in which, the outlets in every beat would be visited. This indicated the need for a cluster with minimal back and forth, travel time and distance.
The problem is as complex as it is beautiful. Just to add to the complexity, any implementable solution envisioned for an NP-hard problem like this, requires beats to be intelligently designed. The design algorithm should be open to accommodate dynamic and fuzzy constraints that may occur on the ground.
With gigabytes of sales data, location trails and timestamps at our disposal and the best data scientists to derive insights out of it, we started to mimic the existing modus operandi to find potential areas to change. And thus, the first thing that we started with was to cleanse a few hundred thousand bad addresses.
The addresses were so malformed that they couldn’t be sensibly tagged to a set of latitude and longitude. Now, this is a problem that exists in most developing economies. Lack of infrastructure around capturing addresses results in poor data collection.
Courtesy Locus’s proprietary geocoding algorithms, we were good to go after a few iterations through efficient Tokenising, Machine Learning and Natural Language Processing of these addresses.
Conclusion
We moved on to replicate the client’s existing beat plans and ended up drawing several ground-breaking conclusions.
In parallel, we also analyzed behavioral factors that impact B2B sales.
Following were the factors that we narrowed on:
This was a breakthrough. Putting the pieces together, we had substantial data to conclusively derive the most optimal transaction time at each outlet. This was a function that we were trying to maximize per salesman.
Beats were to be designed such that the majority of the time is spent servicing the outlet rather than traveling.
Our routing engine smartly handles constraints like geographical proximity, variable walking speeds, traffic conditions, outlet availability, etc. and ensures that the same outlet is not visited by any two salesmen on the same day (known as “mirror beats” in the FMCG world).
We also ensured that the volume sold on a given day is within the range that can be delivered during the distribution cycle and is fair across the week.
Here’s a snapshot of Existing vs Locus generated beats for a sample data set
Source: Locus
With no easy algorithmic tool/product to map a beat to a salesman, we jumped at the opportunity to build one.
A few brainstorming sessions and failed attempts later, we had a tool to take the salesman’s historical performance, experience, and familiarity with outlets and associate him with the best beat. The basis time range of the input data, the tool tweaks the weights of each input parameter.
Source: Locus
In logistics, a successful on-ground deployment is a crucible. The beats have been successfully deployed and the salesman performance is being tracked and monitored for over a quarter.
Locus’ salesman-beat mapping has proven to be about 30 % more productive.
So, next time you think Sales Beats, think Locus FieldPro - Beat Planning Software for higher sales productivity.
Related Article: Ecommerce Disrupting the Consumer Packaged & Fast-Moving Consumer Goods Landscape
Related White Paper Reports
Fast-Moving Consumer Goods Insight Report II
This report discusses what goes behind the strategic decisions of Fast-Moving Consumer Goods (FMCG) companies, and how modern network optimization solutions can help improve them. Download Now!
Fast-Moving Consumer Goods Sales Beat Insight Report
In this report, we describe how Locus provides automated sales beat plans to optimize the mobile workforce for increased profitability, resource efficiency, and time savings. Download Now!
More Resources from Locus