Supply Chain Blog

The Right Data and Metrics are Vital for FMCG Route to Market Success

Posted by Ross Marie on Thu, Nov 29, 2018

For a successful Fast Moving Consumer Goods (FMCG) Route to Market Strategy, we must be able to measure our performance across the market, internally within the company and externally against the competition and wider benchmarks. For example, we must be able to measure our own sales performance, our brand/SKU distribution, our new product introductions, our volume, our revenue, our share, our displays, our in-store facings, our pricing and promotion performance, etc.

essential data and metrics for rtm strategy successWe must be able to do this by territory, by area/region, nationally, by channel, by sub-channel, by key account, by distributor, by retail group, etc. We then need the ability to easily compare these measured results against our targets, our competition and any other benchmarks. We must have the functionality to do this historically, against the current performance and against future targets.

The goal here from a RtM standpoint is to get as detailed, reliable and up to the minute information as possible, to allow us to take corrective action against problems or to recognise success as early as possible to spread it far and wide.

Welcome to my blog series on the 20 Steps to Route to Market Excellence model. Some of you reading this may have gone to ‘Mr Google’ for some help. What I am trying to do here is to point you in the right direction to create an amazing RtM strategy.

Over the past number of weeks, we have gone through the first 9 steps of my model. The focus of this post is Step 10, ‘Data & Metrics’.

Here are some examples of questions you can ask under Step 10 – Data & Metrics:

  1. Based on the RtM Review in Step 1, what is the data that is currently available to us?
  2. What are the performance measures that we are currently measuring against?
  3. What are our current data requirements, in absolute terms and in terms of data capture and maintenance?
  4. Based on the RtM strategy we have chosen what are the likely future data requirements?
  5. To what extent are there any specific areas we need to measure based on external factors (e.g. wider organisation requirements, legislation, regulations, brand launches, restructures, etc.)
  6. Do we currently receive data from our distributors, our retailers, our key accounts, any other customers or partners? What is the data – e.g. sales, stock, etc. If we do, what are we doing with it? If not, is this possible in the future? Have we tried to get it in the past?
  7. Is the data that we will look to measure currently available in the marketplace? Do we need to pay for it? Do we have it internally within our own systems?
  8. If we do not have the data available, will we be able to use a third party to provide it?
  9. Do we currently measure our levels of display, facings or adherence to planograms in the market? How do we do this? How effective it the measurement and our adherence?
  10. Do we have an existing Revenue Management Model? If so, what does it measure? Does our model capture the difference between pricing, mix and volume changes?
  11. Do you have volume that is moving from the traditional trade to the organised trade and eroding margins? Does our Revenue Management Model capture this?
  12. Are our Trade Discounts out-pacing our sales growth? To what extent are we capturing this?
  13. Do we have a cross functional approach to revenue management? Are sales, supply chain, marketing, trade marketing all involved in the process? Are we feeding this information into the correct departments for action?
  14. Which department controls pricing and promotions in our organisation? Is it part of the RtM function and how will it be measured, and the information captured?
  15. Is the current Revenue Management Model fit for purpose? If not, what might a new model look like?
  16. What systems are we using to measure all of this and keep track of performance? Do we have an infield CRM or hand held linked to a back-office system? Can we generate reports with ease or do we have information on spreadsheets? Do we have a system to consolidate this data and information? To what extent are we reliant on spreadsheets for this?
  17. What are the actions that need to take place to have these KPIs measured?
  18. Do we have access to external KPIs, either from the wider organisation or from our marketplace, so that we can benchmark our local activities?
  19. What are the agreed data requirements and set of KPIs that we will capture to measure the success of the RtM strategy going forward?
  20. What is our agreed Revenue Management Model?

I hope you find this useful, any views and comments are welcome. Next week I will cover Step 11 ‘Sales Incentive Program’. Please subscribe to the blog on this page, to ensure you don’t miss the latest updates on RtM excellence in execution and the 20 Steps model. If you would like to know more about the 20 Steps click here.

Tags: 20 Steps to RtM Excellence, RtM Strategy, Ross Marie, RTM, Retail, ERP, Promotions, Information, RTM Assessment Tool, Distribution, Sales, Traditional Trade, FMCG, Route to Market, ERP/SAP, SKU

FMCG ERP and The Beatles.......? Spreadsheets cause damage.

Posted by Dave Jordan on Wed, Jul 04, 2018

Some time ago I wrote about the way spreadsheets were undermining expensively assembled ERP’s in FMCG, Brewing and Pharmaceutical companies. They still are, by the way.

Not too long ago a paper on Public Debt and Austerity published by 2 eminent Harvard Professors was found to contain errors in the Excel coding. Several significant countries were excluded from the data analysis and therefore the conclusions could not be accurate.

The glitch was spotted by a student who like everyone else, believed he and not the professors must be wrong. If you can make mistakes at this level then think what may be happening in your demand planning office. A decimal point in the wrong place or a misplaced cell could lead to market place challenges in stock availability or indeed, excess.Beatles_ERP_Spreadsheets

The bug in that Public Debt spreadsheet leads me to the Beatles – what a segue! Here is what Lennon & McCartney might have written about spreadsheets and ERPs.

Yesterday, an IT man took my Excel away
Now I have to plan a different way

How I wish it was yesterday

Certainly, I’m not as comfortable as I used to be
There's a new ERP in front of me.
How yesterday came shockingly

Why Excel had to go I don't know, IT wouldn’t say
Did I plan something wrong? How I long for the Excel way.

Yesterday, spreadsheet planning was the only way
Now I need to learn a different way
I need to believe in our ERP

Why Excel had to go I don't know, IT wouldn’t say
Did I plan something wrong? How I long for the Excel way.

Yesterday, poor planning was the only way
Error riddled spreadsheets everyday
Now I don’t believe in yesterday
Mm mm mm mm mm mm mm

You can catch up with the classic Beatles track by clicking here.

If you do not run an ERP that relegates spreadsheets to useful and reliable supporting tools then you are risking poor planning in your business.  If you are running an ERP you might check exactly where the data comes from, where critical calculations are really made and how secure is the information.

Image courtesy of artur84 at freedigitalphotos.net

 

Tags: Dave Jordan, CEO, Pharma, ERP/SAP, Supply Chain, Forecasting & Demand Planning, ERP

How Spreadsheets Undermine Your FMCG ERP

Posted by Dave Jordan on Mon, Jun 11, 2018

Despite what you may wish to believe the answer is probably, yes. You have invested heavily in brand new ERP software and similarly heavily in some smart, young consultancy people to run the implementation. You will have spent some timing debating and making these choices as the change to an all encompassing and integrated ERP is a huge step and at the same time a huge risk for your company.

Suddenly the flexibility to back-date or correct entries is lost or at least there is a rigid and auditable procedure to follow in order to make any adjustments. Sudden uplifts in Sales cannot be slipped in unnoticed at month-end and neither can supply shortages or marketing tardiness with promotional activity. Everything you do in a good ERP is recorded and can be seen.

ERP System ImplementationIf your ERP really is the only software being used to run your business then a hearty well done to you. However, in a surprisingly large number of companies the all important role of change management has not received the required seniority or focus.  Staff who have been using spreadsheets for maybe 10 - 15 years (it was released in 1985!) cannot and will not stop using them just because they have been trained in a new ERP.  Spreadsheets are like a cuddly teddy at bedtime; they are familiar, comforting, not demanding and always there!

An element of your decision to implement a new ERP was probably a supplier guarantee that people productivity and data accuracy would be improved. In reality you will find staff operating a covert shadow ERP on the same old spreadsheets. Detailed planning, sales and allocation decisions are being made on spreadsheets and then manually inserted into ERPs. Commonly, decisions are taken in isolation of S&OP and lack the consistency that ERP master data brings plus the all important history development for the business baseline.

Staff efficiency and data accuracy have certainly not improved; they have worsened. The tedious “cut and paste” of data into the ERP is time consuming and fraught with error. Post ERP implementation is always a rough time for businesses  as they get to grips with a new way of working but is it any wonder some stay in a continual state of intensive care?

If you pay sufficient attention to change management you can lessen the impact. Should staff not see the medium terms benefits outweighing the short term inconvenience then they will operate the shadow ERP.  The change manager has to clearly show what the ERP brings to people first and subsequently the company – not the other way around.

Of course, one solution might be to deactivate the spread sheet program on the network until ERP discipline is second nature? Now, who is brave enough to do that?

Image courtesy of HikingArtist

Tags: FMCG, Dave Jordan, Pharma, ERP/SAP, Integrated Business Planning, Supply Chain Analytics, ERP