Retail Supermarket KPI and Profitability Management Practices

Analyzing the profitability of supermarkets and grocery stores requires tracking clear indicators such as sales per square foot, average transaction value, and customer retention rate. However, in any retail industry, it is crucial to strike a balance: too many KPIs can obscure the significance of each metric, while too few fail to provide a comprehensive view. Therefore, it is essential to clearly define the appropriate quality and quantity of retail KPIs for each business area.

In this article, we will explore the most important retail metrics, inventory management indicators, and essential merchandising practices that are relevant for making informed decisions that will help improve business processes, increase sales, and improve customer satisfaction score.

Proper key performance indicators (KPIs) are fundamental to efficient supermarket inventory management, as these indicators drive future performance and profit. Most key metrics are coupled with inventories as a primary asset of the retail business and with sales as the ultimate result in retail.

There are 6 typical inventory management indicators: 

• Inventory costs;
• Sales;
• Overstocks;
• Lost sales;
• Service level;
• Inventory turnover.

These KPIs are essential for managing stock levels efficiently and minimizing costs related to overstocking or stockouts. Aside from inventory indicators, some retail indicators affect them directly or indirectly: supplier reliability level, delivery lead time, gross margins return on investment, profit margins, cost of goods sold, demand variability, terms of deferred payments to suppliers, the financial cycle, and others. We will mention them in the context of each indicator.

You can do without that calculation, but no one in the company will be able to understand exactly what operating activities the money is invested in and when it will profit.

Each of the retail KPIs above is responsible for one of the facets of inventory management. There is overstock in the inventory structure, but information about the percentage and overstock cost provides insight into the effectiveness of purchasing logistics. Lost sales provide information about the income lost because of an insufficient level of product availability.

Now, let us take a more detailed look at inventory turnover and other performance metrics.

An inventory costs indicator is used for a general understanding of the business's investment in stock on hand and its dynamics over time. 

To accurately calculate the inventory costs, the stock on hand at the prices of the batches in which the delivery of this product took place is used, since the purchase price varies depending on the batch.

Except for tracking this KPI dynamically at the moment, the assessment of the structure of stocks clearly demonstrates how much the insurance stock, display, surplus, and the sales inventory cost the supermarket.

Monitoring dynamics should be paired with continuous assessment of the general stock structure with a focus on:

1. Safety stock costs (GREY), 
2. Overstocks (BLUE), 
3. Sales demand (GREEN).

Sales is the most analyzed key performance indicator in retail business. Besides the main function of generating turnover, the total sales give an idea of the nature of demand, customer expectations, the range quality, the promotion effectiveness, the quality of merchandising, and operational personnel. In fact, everyone in a retail company works for the good of sales. From the point of view of category management, sales are analyzed by categories, from POS, suppliers and other dimensional perspectives.

This retail KPI indicates the percentage and value of inventories purchased in excess or that appeared as a result of declining demand. This is an excess stock that is created due to a decrease in sales or an over-ordering of goods. In fact, a surplus is perfectly normal; there are overstocks in any retail chain. The question is only about the excess stock percentage. Overstock can have the following objective reasons:

• decrease in demand;
• post-promotion surplus;
• advance preparation for seasonal holidays. 

But in our practice, overstocks often arise as a result of mistakes made in inventory management: buying a large number of goods with a supplier discount without an accurate calculation of economic feasibility and other actions aimed at increasing inventory for no reason. Besides the very fact of the surplus, it is worth evaluating how long this surplus has been on the shelf or in the warehouse.

Related:  How using inventory management machine learning could improve your retail business?

Surplus stock requires long-term monitoring to be able to identify products that generate the highest surplus. You can further decide on how to manage it in one of the following ways:

1. Redistribute internally. Before choosing this path, you have to analyze the stocks and surplus structure, as well as assess the needs of the POS where the move is made. It is important that this process be automated or partially automated.
2. Return to the suppliers. Returns are quite expensive: they must be properly organized starting from the goods collected in the store and documenting and sending them back to the supplier without loss. The organization of this process can be costly. Therefore, retail chains increasingly don’t make returns to suppliers. 
3. Discount the products. When choosing this strategy, it is important to build a holistic picture, choose paths with the least risks, and weigh this against the benefits for each outlet.
4. Utilize.

Lost sales indicates the percentage and value of statistically potential sales that did not occur due to lack of stock.

Lost sales can be caused by: partial or complete under-delivery from the supplier, lack of parameters for ordering, sharp increases in demand for specific groups of goods, cannibalization and other reasons. Lost sales often result from a combination of these factors. So it is important to focus on the most common cause and increase the availability of the product and its sales.

It is difficult to get an absolutely accurate figure for lost sales due to the specifics of the KPI itself, but this doesn't mean that lost sales should be completely abandoned when analyzing the inventory management efficiency.

The LEAFIO Inventory Optimization solution features a lost sales report that indicates the reason for each lost sale and shows the latest dynamics by category or group. Such granularity can easily identify the root cause of the problem and address it in time.

Service level is a retail KPI that indicates the percentage of assortment available on the shelves. This signifies the assortment matrix fulfillment and product availability at the locations. It is similar to lost sales, but is measured in pieces instead of money. Service level is an accurate retail KPI of the product availability on the shelf and is one of the two key performance indicators used by inventory managers. The second indicator is inventory turnover. 

A high service level boosts customer satisfaction by ensuring product availability, leading to repeat purchases and building trust. Satisfied customers are more likely to return, improving the customer retention rate and fostering loyalty that drives long-term business success.

Inventory turnover is the inventory ratio to sales, indicating how many days of sales the current balance will sustain. It is commonly referred to in either days or a number of times (yearly) when the entire goods sold. Inventory turnover is a relative indicator and is often used for a specific category, brand, supplier, or company as a whole. 

The inventory turnover ratio is calculated by formula:

Inventory turnover = the cost of goods ÷ average inventory for the same period

Sales can drop without compromising availability. Then the issue may be with the range. It could have become less relevant for new or repeat customers or to sales promotion or the sales floor customer experience. If there was no decrease in sales, it is possible that there was an increase in inventory. In this event, you have to analyze whether the surplus has increased. 

If this is not the case, but the stock has grown, you should understand why this has happened: perhaps new stores have opened, the demand of which has not yet reached the target level, and then you just have to wait. Perhaps the stock has increased due to seasonality. However, the retail business is usually aware of these nuances. If there was a deterioration in inventory turnover, not supported by events, this is an occasion for deep analysis to see the cause for this growth.

Evaluating shelf space and store plan performance can create a more efficient shelf display at supermarkets and grocery stores that is attractive to customers and directly impacts store profitability. In merchandising management, such indicators are:

• Shelf space profitability;
• Shelf space returns;
• Profit share ratio;
• Elasticity.

Let's take a closer look at these merchandising indicators for supermarket and grocery retailers.

Every grocery store owner uses a space profitability measure to track effectiveness of the display through the profit the goods are generating in a given area and how fast the products are turning. 

There are several key tracking metrics how much profit the goods placed in the display area bring, their turnover, etc.

Correct profitability indicator helps to:

• display the effectiveness of the use of retail space per meter;
• display the profit from each meter of the layout to evaluate the performance of a category.

Space profitability formula is:

Sales per meter = gross profit ÷ linear meter of the calculation

Face profit helps to display the amount of profit from each face in the category.

How do you get it?

Face profit = gross profit ÷ number of facings

Stock profitability helps to show the profit from each inventory unit.

How do you get it?

Stock profitability = gross profit ÷ money stock equivalent on the shelf

Comparing the dynamics of the indicators gives a clear understanding of the shelf space performance: 

• efficiency deviations of a particular store compared to the company’s benchmark;
• category display efficiency for each store;
• category shelf display efficiency within a store/department/planogram, etc.

For retail business owners these indicators serve as a basis for regular planogram review and adjustment that drives the efficiency of the macro space, total sales revenue, and profit margins. A perfect scenario would be for the merchandising manager to automatically recalculate facings in the merchandising solution by employing the indicators above in an algorithm and sending updated layouts to the locations. 

Shelf space returns indicate the sales area efficiency and help identify the poorly performing sales area in a store. It is calculated for each category, supplier, SKU, and reflects the ratio of the allocated area to sales. It assesses how well the space is distributed between categories and reveals whether a category is represented properly in terms of profits it generates in a given area. 

The LEAFIO Planogram Optimization solution features built-in analytics on shelf space returns that can be conveniently viewed in a dashboard or a table. 

By the way, measuring foot traffic and square foot sales are useful indicators of how well new customers know your brands, how successful marketing campaigns are, and whether your storefronts are performing well.

Profit share ratio (planogram products facings to profit share) indicates whether the space has been allocated correctly for each SKU. The SKU facings to the SKU ABC-analysis position holds the key to profit increase. Keeping the ratio at a minimum leads to a rise in the profitability of the layout.

Elasticity is a retail KPI that reflects the profit potential of merchandising and determines the possible change rate of GMROS (gross margin on selling space). This defines the effectiveness of the sales area.

Merchandising analysis helps supermarkets and grocery stores improve in store sales and turnover performance as well as monitor assortment performance and manage surplus or shortage of goods. Assessing efficiency impacts the layout accuracy, compliance with supplier agreements and internal requirements, and improves the customer satisfaction.

1. Essential Inventory KPIs: Key metrics like inventory costs, sales, overstocks, lost sales, service levels, and inventory turnover are vital for managing stock levels, minimizing costs, and ensuring availability.
2. Insights into Overstock and Lost Sales: Overstocking and lost sales provide critical data on purchasing efficiency and product availability, helping to identify causes and take corrective action to minimize profit loss.
3. Sales and Profitability Metrics: Indicators such as sales, space profitability, and shelf space returns provide a comprehensive view of store performance, customer demand, and merchandising effectiveness.
4. Advanced Merchandising KPIs: Metrics like profit share ratio and elasticity help refine space allocation and optimize gross margin on selling space, driving improved profitability and customer satisfaction.
5. Tech-Driven Solutions: Tools like LEAFIO Inventory Optimization and Shelf Efficiency enable granular analysis, automate adjustments, and enhance decision-making processes to streamline operations and maximize results.

Explore how to implement these KPIs and solutions—request a demo and consultation with LEAFIO AI experts!

Related:  All About Planograms: Usage in Retail