Principles of Retailing: Merchandising and Pricing - Merchandise Planning Process, Sales Forecasting Assortment Planning OpentoBuy

What This Is

The Merchandise Planning Process is a critical component of retail management that involves forecasting sales, planning assortment, and determining the open-to-buy (OTB) budget. This process is essential for retailers to ensure they have the right products in stock at the right time, minimizing stockouts and overstocking. For instance, Amazon uses advanced algorithms to forecast sales and adjust its assortment accordingly, resulting in a 20% increase in sales and a 15% reduction in inventory costs.

Key Frameworks & Metrics

• Wheel of Retailing: Describes how retailers evolve from low-price to upscale over time, with a focus on increasing profitability through product differentiation and premium pricing.
• GMROI (Gross Margin Return on Inventory Investment): Gross margin divided by average inventory cost – measures inventory profitability and helps retailers optimize their inventory levels.
• Inventory Turnover: Measures the number of times inventory is sold and replaced within a given period, indicating inventory efficiency and cash flow.
• Customer Lifetime Value (CLV): Estimates the total value a customer will bring to a retailer over their lifetime, helping retailers prioritize customer retention and loyalty programs.
• Omnichannel Maturity Model: Evaluates a retailer's ability to provide a seamless shopping experience across online and offline channels, with five stages: Basic, Integrated, Unified, Customer-Centric, and Personalized.
• CAC (Customer Acquisition Cost): Measures the cost of acquiring a new customer, helping retailers optimize their marketing and sales strategies.
• LTV (Lifetime Value): Estimates the total value a customer will bring to a retailer over their lifetime, helping retailers prioritize customer retention and loyalty programs.
• Basket Size: Measures the average value of a customer's purchase, indicating the effectiveness of pricing and promotion strategies.
• Conversion Rate: Measures the percentage of website visitors or in-store customers who make a purchase, indicating the effectiveness of marketing and sales strategies.
• Open-to-Buy (OTB): The amount of money available for purchasing new inventory, helping retailers manage their inventory levels and cash flow.

Step-by-Step Process

1. Sales Forecasting: Use historical data, market trends, and seasonal fluctuations to estimate future sales.
2. Assortment Planning: Analyze customer demand, product life cycles, and competition to determine the optimal product mix.
3. Open-to-Buy (OTB) Planning: Determine the available budget for purchasing new inventory, considering factors like cash flow, inventory levels, and sales forecasts.
4. Inventory Management: Implement inventory control systems to ensure accurate tracking, minimize stockouts, and optimize inventory levels.
5. Category Management: Analyze sales data, customer behavior, and market trends to optimize product assortment and pricing within each category.
6. Private Label Development: Evaluate the feasibility of launching a private label, considering factors like production costs, marketing strategies, and customer demand.

Common Mistakes

• Mistake: Ignoring inventory turnover and focusing solely on sales growth.
• Correction: Regularly review inventory turnover to identify opportunities for improvement and optimize inventory levels.
• Mistake: Treating all channels separately, rather than integrating them into a unified omnichannel strategy.
• Correction: Implement a unified inventory management system to ensure seamless inventory visibility across online and offline channels.
• Mistake: Over-reliance on discounts and promotions, rather than focusing on long-term customer relationships.
• Correction: Prioritize customer retention and loyalty programs to build long-term relationships and increase customer lifetime value.

Retail Strategy Tips

• When expanding omnichannel, ensure unified inventory visibility to prevent stock-outs online.
• Use data analytics to optimize product assortment and pricing within each category.
• Prioritize customer retention and loyalty programs to build long-term relationships and increase customer lifetime value.

Quick Practice Scenario

Scenario: A department store has high footfall but low conversion. Which metric would you analyze first and why?

Answer: Conversion Rate. Analyzing conversion rate would help identify the effectiveness of marketing and sales strategies, and inform decisions to improve the shopping experience and increase sales.

Last-Minute Cram Sheet

• GMROI = Gross Margin / Average Inventory Cost
• Inventory Turnover = Cost of Goods Sold / Average Inventory Value
• CLV = (Average Order Value x Purchase Frequency) / (1 - Customer Churn Rate)
• Omnichannel Maturity Model has five stages: Basic, Integrated, Unified, Customer-Centric, and Personalized
• CAC = Marketing and Sales Expenses / Number of New Customers
• LTV = CLV x Customer Churn Rate
• Basket Size = Total Sales / Number of Transactions
• Conversion Rate = Number of Sales / Number of Website Visitors or In-Store Customers
• OTB = Available Budget for Purchasing New Inventory
• Omnichannel is not just being present on all channels – it's about a seamless integrated experience across channels.