Goal of the analysis:
The goal of a Product Line Profitability by Retailer analysis in the consumer packaged goods (CPG) industry is to evaluate the financial performance of each product line across different retail partners. This analysis helps companies understand which product lines generate the most profit with specific retailers, identify underperforming products or retailers, and make informed decisions about product assortment, pricing strategies, and promotional efforts. The ultimate aim is to optimize profitability across the retail network by focusing on the most profitable product-retailer combinations.
Data required:
- Sales data by product line and retailer (e.g., units sold, revenue generated)
- Gross margin data by product line (e.g., cost of goods sold, pricing structure)
- Promotional costs by retailer (e.g., trade promotions, discounts, in-store promotions)
- Retailer-specific pricing agreements (e.g., volume discounts, pricing tiers)
- Inventory turnover rates by retailer and product line
- Supply chain and logistics costs (e.g., transportation, warehousing)
- Retailer fees and terms (e.g., slotting fees, shelf space agreements, marketing allowances)
- Competitor benchmarking data for similar product lines at competing retailers
- Consumer demand and sales velocity for each product line by retailer
- Product return rates and defect data for each retailer
Detailed step-by-step instruction on how to conduct the analysis:
1. Define the objectives of the analysis.
Set clear objectives for the product line profitability analysis. Goals may include identifying the most profitable product-retailer combinations, improving profitability for underperforming product lines, or optimizing product assortment for specific retailers.
For example, a goal might be to increase profitability by 15% for the top three product lines at the company’s largest retailer within the next year.
2. Gather sales and margin data by product line and retailer.
Collect sales and margin data for each product line across all retail partners. This includes revenue, units sold, and gross margin for each product line at each retailer.
The gross margin formula is:
Gross Margin (%) = ((Revenue – Cost of Goods Sold) / Revenue) x 100
For example, if a product line generates $1 million in revenue with $600,000 in cost of goods sold at a specific retailer:
Gross Margin = (($1,000,000 – $600,000) / $1,000,000) x 100 = 40%
3. Calculate net profitability for each product line by retailer.
Once gross margin data is collected, subtract any additional costs associated with selling through each retailer, such as trade promotions, retailer fees, and logistics costs.
The formula for net profitability is:
Net Profit = Revenue – (Cost of Goods Sold + Trade Promotions + Retailer Fees + Logistics Costs)
For example, if a product line generates $1 million in revenue, incurs $600,000 in cost of goods sold, $100,000 in trade promotions, $50,000 in retailer fees, and $50,000 in logistics costs:
Net Profit = $1,000,000 – ($600,000 + $100,000 + $50,000 + $50,000) = $200,000
Compare net profitability across retailers to identify which product-retailer combinations generate the highest returns.
4. Evaluate retailer-specific costs and fees.
Analyze the costs and fees associated with selling through each retailer, such as slotting fees, shelf space agreements, and marketing allowances.
Retailers may charge different fees based on the product line, shelf space requirements, or promotional support. Track these costs to understand their impact on overall profitability and whether they erode margins for certain product lines.
5. Assess product performance and sales velocity.
Review the sales velocity and performance of each product line by retailer. Sales velocity measures how quickly products sell through at retail locations, which impacts profitability and inventory management.
The formula for sales velocity is:
Sales Velocity = Units Sold / Time Period (e.g., per week, per month)
Compare sales velocity across retailers to determine which retailers are driving the highest sales for specific product lines. High sales velocity generally correlates with higher profitability, as products move faster, reducing holding and inventory costs.
6. Analyze inventory turnover and logistics costs.
Evaluate inventory turnover rates and logistics costs for each retailer. High inventory turnover rates typically indicate that products are selling well, minimizing storage and warehousing costs.
Conversely, low turnover rates may indicate excess stock and higher storage costs, reducing profitability.
Inventory Turnover is calculated as:
Inventory Turnover = Cost of Goods Sold / Average Inventory
For example, if a retailer’s product line had $600,000 in cost of goods sold and $200,000 in average inventory:
Inventory Turnover = $600,000 / $200,000 = 3
7. Review promotional and trade spend impact.
Analyze how trade promotions and discounts impact product line profitability at each retailer. While promotions may drive short-term sales, they can erode margins if not managed carefully.
Calculate the ROI of trade promotions by the retailer to ensure that promotional spending delivers incremental growth.
The formula for trade promotion ROI is:
ROI (%) = ((Incremental Profit from Promotion – Trade Promotion Spend) / Trade Promotion Spend) x 100
For example, if a promotion generates $100,000 in incremental profit and the trade promotion spend is $50,000:
ROI = (($100,000 – $50,000) / $50,000) x 100 = 100%
Promotions with low ROI or negative margins may need to be reconsidered.
8. Benchmark product line profitability against competitors.
Compare the profitability of your product lines at key retailers with those of competitors. Identify areas where competitors may be outperforming in terms of sales volume, pricing, or promotional support.
Use this benchmarking data to adjust product offerings, pricing strategies, or promotional efforts to remain competitive and optimize profitability.
9. Identify underperforming product lines or retailers.
Identify product lines or retailers that consistently underperform in terms of profitability. For example, if a product line generates low sales or negative margins with a specific retailer, consider discontinuing the product at that retailer or renegotiating terms to improve profitability.
Conversely, high-performing product lines should be prioritized for expanded distribution or additional promotional support.
10. Optimize product assortment and pricing strategies.
Based on the analysis, optimize the product assortment for each retailer by focusing on high-margin, high-performing products. Adjust pricing strategies to reflect the profitability dynamics of each retailer.
For instance, consider raising prices on top-performing products at certain retailers to maximize profitability, or offering promotions selectively to boost underperforming lines.
Format of the output of analysis:
The output of a Product Line Profitability by Retailer analysis typically includes:
- Sales and gross margin data by product line for each retailer
- Net profitability analysis, accounting for trade promotions, retailer fees, and logistics costs
- Retailer-specific cost breakdowns, including slotting fees and promotional spend
- Sales velocity and inventory turnover rates by product line and retailer
- Promotional ROI calculations, highlighting the impact of trade promotions on profitability
- Benchmarking data comparing product line profitability with competitors at key retailers
- Identification of underperforming product lines or retailers with suggestions for improvement
- Recommendations for optimizing product assortment, pricing, and promotional strategies
- Actionable insights for improving profitability across retailers and product lines
How to interpret results:
- High profitability and strong sales velocity: If certain product lines are highly profitable and have strong sales velocity at specific retailers, prioritize these product-retailer combinations for further investment and promotional support. These are key growth drivers for the business.
- Low profitability despite high sales: If a product line has high sales but low profitability due to high retailer fees or promotional costs, evaluate whether it’s possible to renegotiate terms, reduce promotional spend, or raise prices to improve margins.
- Underperforming product lines at specific retailers: If a product line consistently underperforms at certain retailers, consider adjusting pricing, discontinuing the product, or reallocating resources to more profitable product-retailer combinations.
- Ineffective promotions: If promotions consistently deliver low or negative ROI, adjust promotional strategies or reduce trade spend on these initiatives. Focus promotional efforts on retailers or products with proven ROI.
Steps a company can take to improve on this measure:
- Prioritize high-margin product-retailer combinations: Focus on product lines and retailers that deliver the highest margins. Expand distribution and promotional support for these high-performing combinations to drive growth.
- Optimize trade promotions: Allocate trade spend to promotions that generate positive ROI and incremental sales growth. Eliminate or reduce low-ROI promotions that erode profitability without delivering long-term benefits.
- Renegotiate retailer agreements: Work with retailers to renegotiate slotting fees, promotional allowances, or shelf space terms, especially if costs are reducing margins. Establish agreements that align retailer incentives with your profitability goals.
- Improve inventory turnover: Focus on improving inventory turnover rates at retailers where products are moving slowly. Implement demand forecasting tools to optimize stock levels and reduce excess inventory, which leads to higher storage costs.
- Adjust pricing strategies: Review pricing strategies for underperforming product lines and retailers. In some cases, raising prices on high-demand products may improve profitability without impacting sales, while price reductions may boost sales for slow-moving products.
Request the PDF Download of How to Analyze a Consumer Packaged Goods Company
