Master Data: Failure to Plan…Planning to Fail

“Master Data”. If you are like most Sales professionals who have worked on a large systems integration project, the very phrase probably sends chills down your spine. As fundamental as the data in your system may be, it is absolutely one of the hardest things for most consumer goods companies to ‘nail’ and tends to be a continual source of frustration even long after the project has finished and the organisation has moved into ‘business as usual.’ 

While an initial implementation may work perfectly for the static view of the business at the point in time that the project goes live, a failure to plan for future changes can prove disastrous down the line.

The general areas of concern tend to revolve around a few key areas:

  • Changes in Customer Business Structure: Given the fast pace of change in the retail environment, erstwhile competitors are buying one-another, forming new alliances and partnerships, or changing approach entirely (moving from mass merchandising to club/discount and vice-versa.) 
  • Changes in Product Mix: Product groupings, whether referred to as ‘Promoted Product Groups’, ‘Product Group’, or ‘SKU Group’ are generally configured to allow an account manager to easily promote products together. Typically, these products are grouped based upon a shared list price such that a discount can be applied equally to all of the SKUs in a range (for instance, providing a deal on a number of different flavours of 100g crisp packages.) As manufacturers move through the Revenue Growth Management lifecycle, they may find that these groupings no longer make sense based on the price/place continuum and may need to rebuild product groups on a near-annual basis. 
  • Innovation: As manufacturers continue to see commoditisation and ‘own brand’ competition deteriorate brand equity, one of the key ways to ensure a spot on the shelf is through line extension and continual innovation. The new product introduction process introduces all kinds of headaches to the sales planner, ranging from incomplete Master Data and ‘dummy’ products to invalid product costing causing financial posting failures. How does an account manager deal with the need to provide accurate forecasts to marketing, management, and demand planning when there isn’t even a SKU setup in their ERP system?

Best Practices in Master Data Management

A ‘failure to plan is a plan to fail’ has been written on the epitaph of many a great sales systems project. The question to ask yourself when determining which direction to take during a TPx implementation is one of upfront cost versus continued running costs. The more complex solutions may be more difficult to implement initially but represent substantial cost avoidance over time. 

The following strategies outline the various approaches taken by FMCG companies to approach the design of their Master Data and the implications to long-term maintenance. Whether you are sitting on a bespoke TPx system that has been in place for 20 years or midway through an implementation, ask yourself: Where are we on the spectrum? And where do we, as a business, need to be?

Customer Hierarchy Approach

Maturity LevelBasicAdvancedBest in Class
DescriptionPlanning is done at the lowest level of the customer hierarchy, typically based upon the ‘sold-to’ level for each account. Used primarily in markets where either the customer or product is a new entrant, this level of planning represents an easy starting point for smaller companies. 
This approach’s ease proves limiting approach in the long run, however, as it is not able to scale as the business grows. 
The introduction of a multi-level customer hierarchy allows the manufacturer to move beyond setting a ‘static’ planning level for each customer, instead providing flexibility to the business. 
This approach allows sales to maintain a ‘planning level’ for each hierarchy branch, representing the lowest level where prices and promotions can be planned for a given part of the business. 
Multiple concurrent hierarchies are available, allowing the business to see different ‘cuts’ of data based on user need (Marketing versus Supply Chain) and effective dated hierarchies allow a business to see a past and future view of the business in anticipation of changes. 
Planning levels are flexible, and conditions can be applied at various levels dependent upon business need.
Pros and ConsPros: Simple ImplementationEase of change Cons:Not scalablePoor visibility to ‘total business’ if detailed plans are not maintained for every single customerPros:Flexible and varied levels for planningScalable across the enterprise Cons:Complex business process to change planning levelsIncreased data burdenPros:Extremely flexible; supports any business scenarioSupports IBP and global reportingCons:High complexity Requires substantial systems alignment

Product Hierarchy Approach

Maturity LevelBasicAdvancedBest in Class
DescriptionAll planning is done at the very lowest level (SKU), while reporting roll-ups allow managers to understand trends at the Size, Brand, or Segment level. 
Such a design works well in a static view of the world but brings up numerous issues when the product portfolio changes; for instance, adding a new SKU to the customer’s assortment may require updating every planned promotion for that customer individually.
SKU group planning allows the user to plan conditions across an entire range of products at once, reducing the amount of ‘clicks’ to manage the customer plan. 
More advanced TPx tools allow for the quick addition or removal of SKUs from existing promotions wherever the SKU group has already been planned. 
Full hierarchical planning allows for creation of conditions across brands, categories, and various sub-levels within the hierarchy. 
More advanced tools allow users to save ‘selections’ of data not related to the hierarchy and have all matching SKUs to be automatically added or removed from promotions over time.
Pros and ConsPros: Quick implementationGuaranteed compatibility across systemsCons:Extremely detailed planningChanges require major overhauls to the customer plan Pros:Good balance between flexibility and stabilityChanges optionally incorporated based upon listing changesCons:Key Account Managers take added responsibility for listingsSKU group changes are difficult to manage across timePros:Extreme flexibilityComplete integration and visibility across systemsCons:Automated hierarchy changes can drastically change plansLack of control for Key Account Managers  

Innovation Management Capability

Maturity LevelBasicAdvancedBest in Class
DescriptionPlanning is done using a ‘like’ product to capture plans until the real product is available in Master Data; at that point, Key Account Managers must rebuild their plans to account for the introduction of a new product.Local administrators create ‘dummy’ products which are used for sales and promotion planning. When real products are created in Master Data, planners use ‘find and replace’ functionality quickly include the proper product details in their promotions.  Full integration is achieved between the Master Data team, Supply Chain, and Sales, and products are created in Master Data even with partial details. 
These products are flagged as ‘New Products’ which controls certain functionality in TPx systems (workflows, pricing, integration, etc.) When the ‘New Product’ flag is removed, the special rules are no longer applied. 
Pros and ConsPros: Simplest design and business processRequires linkage to Master DataCons:No management visibility to new product impactHigh risk of error or omissionPros:Full flexibility within the Sales departmentVisibility into innovation plans for each accountCons:Disconnected Master Data between systemRisk that dummy products create errors downstreamPros:Full alignment across systems and business process areasFull visibility into innovation risks and opportunitiesCons:Business rules must be defined upfrontIncreased need for interdepartmental communication 

As with most things in life, moderation is the key; a blend of strategies based upon business realities combined with a pragmatic approach is the best way to guarantee success. Too much focus on creating a perfect process may ensure a never-ending project that fails to go live, whereas too little can create a major business disruption at the first year-end cutover. 

Regardless of the scale of your sales operation or TPx implementation budget, Master Data Management should be a core competency within your project team and one of the very first focus areas during initial design discussions with a vendor.

Recent Resources
News

UpClear Takes Five Enterprise Planning Best-in-Class Distinctions from Promotion Optimization Institute 

UpClear has been awarded five “Best-in-Class” distinctions by the Promotion Optimization Institute...
Articles

How Vita Coco Uses BluePlanner TPM for  Direct Store Delivery 

Who knew Coconut Water could be this complex?  Vita Coco has grown...
News

UpClear on Inc 5000 for the 9th Consecutive Year 

For the ninth consecutive year (2014-2022), UpClear is on the Inc. 5000 list of...

Book a Demo