Not Your Father’s Category Manager

Posted by admin | demand intelligence,price elasticity,price strategy,promotion planning | Wednesday 18 August 2010 12:39 pm

By Jim Sills, Chief Technology Officer, Revionics Inc.

Category Management is undergoing a quiet revolution. Gone are the days when a category manager could trust in intuition and experience alone. The new generation is embracing Retail Science to make better price, promotion, merchandise and assortment decisions. Retail Science applies sophisticated data analysis to help better understand what customers want. Data sources include Point-of-Sale (POS), Transaction Log (TLOG), competitive pricing, panel, syndicated, weather, demographic, and location attributes. Data cleansing, quality assurance tests and outlier analysis are essential for measuring causal relationships. The result is a demand model that accounts for price elasticity, promotional lift, merchandising, seasonality, cannibalization, affinity, space, and assortment. Category managers use this demand model to evaluate and compare scenarios. For example, a supplier may offer a incentive to promote Cheerios. The category manager can evaluate the category profit accounting for vendor incentives, cannibalization, and affinity.  This analysis shows how cannibalization of private label erodes category margin. Even the impact on loyalty customers can be evaluated in terms of basket size and trip frequency by customer segment.

Other examples where Category Managers are leveraging Retail Science include:

Store-Zone Clustering.  Stores in proximity to competitors, population density, household income, median age, and other factors influence customer behavior and sensitivity to price. Store zone clustering identifies the optimal store zoning and can improve profit by 1% of sales for some retailers (higher profits have been realized and this benefit is above and beyond that from price optimization alone). This analysis is based on category-store price elasticity and takes into account demographic data, competitor data, and store attributes. The principal components driving a store into one cluster versus another are evident from this analysis.  For example, zone one may be characterized by highly price sensitive, middle-income, densely populated, customers with a given ethnicity ratio and strong competition from Walmart within 2.5 miles. The strength of each of these factors in driving a store into a given zone is evident from the analysis.

KVI Items. Key Value Items (KVI) have the greatest influence on customer price perception and represent an important segment of a retailer’s business. Frequently, just 10% of a retailer’s items account for 90% or more of customer price perception and have the greatest influence on traffic. These items can come from many different categories and there can be multiple groupings. Examples include highly sensitive items, competitive items, traffic drivers, and basket builders. Retail Science can be applied to identify the top KVI items combining item profit and sales with price elasticity, market-basket analytics, and syndicated data. Understanding which items are the “true KVIs” and positioning them aggressively yields the most return while allowing the freedom to price non-KVI items in line with margin targets.

Pricing. Price elasticity relates the change in units to the change in price as indicated in the table below.

Price Elasticity      Price Change      Unit Change

1.0                          -10%                     +10%

2.0                          -10%                     +20%

0.5                         +10%                        -5%

Retailers can realize more profit and sales by increasing the price on items with low price elasticity and decreasing the price on items with high elasticity. The first step is to identify the category role and strategy. For example, some categories are identified as Convenience, Traffic Drivers, Margin Enhancer, and Turf Protector in this source from AC Nielson:

Consumer-Centric Category Management.  Hoboken: John Wiley & Sons, Inc., 2006

Willard Bishop is especially strong in working with retailers to identify how best to define category roles and map those roles into strategies that can leverage Retail Science. These strategies and the science account for Private Label to National Brand Gaps, Good-Better-Best relationships, Ending Numbers, Price Chance Frequency, Minimum/Maximum Price Change rules, Price-Per-Unit relationships, Margin Targets and Competitive Price Index. Competitive prices can be collected or purchased from Rival Watch.

Promotion. Promoting the wrong product or the wrong offer erodes category profitability. As mentioned earlier, Retail Science can be used to evaluate supplier incentives. It can also be used to recommend the best items to promote and at what offers. During the planning stage a Category Manager can use the Demand Model to evaluate “what if” scenarios. For instance, which is the best item to promote on the front page in a major feature? What is the impact of merchandising the item in an end cap or a display? Is BOGO better than 10 for $10?  In all of these comparisons the Retail Science accounts for supplier funds, cannibalization, and affinity.

Category Managers are now using Retail Science to segment loyalty customers and identify the best one-to-one offers that will drive basket profit and trip frequency. Market Basket Analysis is applied to identify item-level affinity to understand how much a promotion on meat will drive sales in produce.

Retail Science benefits Category Managers best when it is imbedded in tools that support Supplier Collaboration and Ad Planning including pre-press layout with integration to publication tools such as Adobe InDesign or Quark.

Markdown. Simple clearance strategies such as 25%, 50%, and 75% markdown spread across three months leave money on the table. Too often items are marked down when demand is sufficient to clear inventory. Similarly, there are items with large inventory that require deeper or earlier markdown to maximize profit. Retail Science identifies the best markdown amounts and dates. Category managers can specify strategy objectives such as clear inventory or maximize profit. Coherence rules can be applied to simplify signage and shelf tags.

Assortment & Space.  Space and price are inseparable. Suppose that demand is high for a particular item, so high that the retailer often has a whole in the shelf. Is it better to increase the price, or to add another facing?  Retail Science can be used to jointly optimize space and price. In some cases the recommended number of facing is zero—meaning that it is recommended that the item be removed from the assortment. Retail science can also leverage syndicated data from IRI to recommend new items to add to the assortment. At a macro level, categories that need more or less linear space are identified.

Price, Promotion, Markdown, Assortment, and Space impact category profit and sales. A single Product Lifecycle application that integrates all of these applications is extremely useful to Category Managers. For one, a single integrated platform can identify and resolve pricing conflicts. Such as, a 10 for $10 promotion on August 1 would be in conflict with an Everyday price change from $1.19 to $0.89 on July 25. An integrated platform can also provide a single unified forecast which can be compared with the financial plan and actual profit and sales.

At Revionics we specialize in a SaaS-based Product Lifecycle platform that is putting the power of Retail Science into the hands of the next generation of Category Managers.

Are you able to think strategically about your categories?

Posted by admin | price optimization,price strategy,pricing management | Tuesday 10 August 2010 8:39 am

By Dan Muldowney, Strategic Account Executive

One common characteristic I have found with many retailers that I have worked over the last six years is that category managers spend far too much of their valuable time on price maintenance.   Strategy often takes a backseat to other priorities such as shifting costs and competition.  In many instances where the category managers have pricing analysts to assist, the majority of their time is spent on price oversight and approval as well as negotiating promotional events with vendors and still not strategic.

When you consider the tasks and processes involved in price management, a single vendor cost change may trigger tens to hundreds of price changes within a category. Line pricing rules, size parity, zone pricing, private label shielding and other category rules must be followed in order to maintain role hierarchy and intent for the affected category. Without automation, a simple cost changes prove to be a very time consuming challenge.

Over the last ten years many retailers have looked to life cycle price management and optimization vendors to automate these price management processes.  This technology has been embraced by several leading retailers and help to further cost justification of price optimization. Through use of a price optimization system, these retailers have found that their category managers can shift their focus to work more closely with their vendors. Time spent previously managing tactical tasks can now be dedicated to strategic pricing practices. Additional time saving benefits can be gained when implementing vendor collaboration software.

When I work with a retailer evaluating price optimization, I almost always recommend a “crawl, walk, run” approach when evaluating life cycle price optimization solutions.  Just because the system can optimize pricing does not mean it has to Day One. Start easy with automation.  Once users become more comfortable with the system functions and navigation, then try optimization for few categories and monitor the benefits. When confident of the systems benefits, the pricing team can decide to roll out price optimization across all categories, or go even further and investigate promotional and clearance or markdown optimization.

While the sizzle of an optimization solution is the science, there is a great deal of value provided by automating pricing tasks.  Ask yourself this question the next time you are dealing with price management functions “Is there something that I can be doing to better my category performance and make my pricing activities be more strategic?”

Pricing software for grocery and other fast-moving consumer goods retailers
that delivers price optimization, promotion optimization, and markdown optimization.

Copyright Revionics ©, Inc. All rights reserved. Privacy Policy.