Analyzing Merchandise Performance & Inventory Metrics
1. Need for Merchandise Performance Analysis
A modern retail store carries thousands of distinct Stock Keeping Units (SKUs). Merchandisers must continuously evaluate whether allocated shelf space and working capital are generating adequate returns.
Merchandise performance analysis answers four operational questions:
- Which products are selling fast and require immediate replenishment?
- Which categories are generating high revenue but inadequate profit margins?
- Which slow-moving items are tying up shelf space and need markdown liquidation?
- How efficiently is the retailer converting inventory investment into cash?
2. Gross Margin Return on Investment (GMROI)
GMROI is the single most vital productivity metric in retail merchandising. It measures the relationship between the total gross profit earned and the average amount of capital invested in inventory at cost.
In simple terms: GMROI tells a retailer how many rupees of gross margin are earned for every ₹ 1.00 invested in inventory.
GMROI Mathematical Formulas
Alternatively, GMROI can be factored into two operational drivers (Profitability × Velocity):
Worked Numerical Example of GMROI (DAVV Pattern):
A retail store department achieves annual sales of ₹ 20,00,000 with a gross margin of 40%. The average inventory carried at cost throughout the year is ₹ 4,00,000.
Calculation:
- Gross Margin in Rupees = 40% of ₹ 20,00,000 = ₹ 8,00,000
- GMROI = Gross Margin / Average Inventory at Cost
- GMROI = ₹ 8,00,000 / ₹ 4,00,000 = 2.0 (or 200%)
Managerial Interpretation: For every ₹ 1.00 invested in merchandise inventory, the retailer generates ₹ 2.00 in gross margin. A GMROI greater than 1.0 indicates that the product generates more gross profit than its holding cost.
3. Inventory Turnover Ratio (ITR / Stockturn)
Inventory Turnover measures how many times the average inventory is sold and replaced over a defined operational period (usually one year):
Strategic Trade-Offs of High vs Low Turnover:
| Dimension | High Inventory Turnover (e.g., Grocery/FMCG) | Low Inventory Turnover (e.g., Luxury Jewelry) |
|---|---|---|
| Cash Liquidity | Extremely fast cash flow conversion. | Working capital locked in display cases. |
| Merchandise Freshness | Zero obsolete stock; always fresh styles. | Risk of product obsolescence and shopwear. |
| Operating Margin | Operates on razor-thin gross margins (5% to 15%). | Compensated by very high margins (40% to 70%). |
| Operational Risk | High risk of stockouts if supplier delays orders. | Heavy inventory carrying and insurance costs. |
4. Sell-Through Percentage
The Sell-Through Percentage evaluates how quickly a specific batch of received merchandise sells within a designated timeframe (e.g., weekly or monthly):
Strategic Reorder & Markdown Triggers:
- Sell-Through > 80% in 3 weeks: The style is an explosive hit; reorder immediately or negotiate rapid factory replenishment.
- Sell-Through between 40% and 70%: Normal healthy movement; maintain standard merchandising plan.
- Sell-Through < 25% after 4 weeks: The item is failing; trigger promotional price markdowns or relocate to a prominent high-traffic endcap display.
5. Sales-to-Stock Ratio & Stock-to-Sales Ratio
Used by retail merchandise planners to monitor inventory balance against sales velocity:
Example: If a store maintains ₹ 3,00,000 of BOM stock to generate ₹ 1,00,000 in monthly sales, the Stock-to-Sales ratio is 3.0. A rising ratio indicates inventory is accumulating faster than sales are growing.
6. ABC Inventory Analysis (Pareto’s 80/20 Rule in Retail)
ABC analysis classifies retail SKUs into three distinct performance categories based on their contribution to overall store sales and profitability:
| SKU Category | % of Total SKUs | % of Total Revenue | Management & Inventory Control Policy |
|---|---|---|---|
| Class A Items | ~ 15% to 20% | ~ 70% to 80% | High Priority: Daily monitoring, zero tolerance for stockouts, tight safety stock, automated reordering. |
| Class B Items | ~ 30% | ~ 15% to 20% | Moderate Priority: Weekly review, standard buffer stock, periodic replenishment. |
| Class C Items | ~ 50% | ~ 5% to 10% | Low Priority: Periodic bulk buying, simplified records, candidates for rationalization or clearance. |
Summary Keypoints for DAVV Exams
- Merchandise Evaluation: Uses financial and operational metrics to optimize inventory ROI, reduce holding costs, and eliminate dead stock.
- GMROI: Gross Margin earned divided by Average Inventory at Cost. Reflects capital productivity.
- Inventory Turnover (ITR): Number of times inventory cycles through the store per year (Sales / Average Stock).
- Sell-Through Rate: Units sold divided by total received units; acts as an early warning trigger for markdowns.
- ABC Analysis: Pareto-based classification: A items (vital few), B items (moderate), C items (trivial many).
Frequently Asked Questions (DAVV Exam Pattern)
Q1. Define GMROI and explain how a retailer can improve it without raising selling prices.
Answer:
Gross Margin Return on Investment (GMROI) measures the gross margin rupees earned per rupee of inventory cost:
GMROI = (Gross Margin / Sales) × (Sales / Average Inventory at Cost).
A retailer can improve GMROI without increasing retail selling prices through two strategies:
- Lowering Procurement Cost: Negotiating higher trade discounts, buying in economic order quantities, or sourcing via private-label manufacturers, which expands the gross margin percentage without altering retail shelf prices.
- Accelerating Inventory Turnover: Reducing safety stock levels, utilizing Just-in-Time (JIT) delivery, and dropping slow-moving styles. This lowers the average inventory holding cost while maintaining identical sales volume.
Q2. What is ABC Analysis in retail inventory control? Why is it dangerous to treat all SKUs equally?
Answer: ABC Analysis segments retail inventory based on Pareto’s Law:
- Class A: The top 20% of SKUs generating 80% of sales.
- Class B: The middle 30% generating 15% of sales.
- Class C: The bottom 50% generating only 5% of sales.
Treating all SKUs equally is disastrous for a retail business. If equal management time and capital are allocated across all items, high-profit Class A goods will face frequent stockouts (infuriating prime customers and losing revenue), while capital and warehouse floor space become clogged with slow-moving, low-margin Class C products.