Profit Margin Decline Analysis
Investigating why profit margin declined despite record revenue growth by analyzing product performance, customer behavior, pricing strategy, discounts, and regional profitability.
Business Problem
Although the company achieved record revenue growth in 2017, profit margin declined from 13.43% in 2016 to 12.74% in 2017. Management wanted to understand what caused profitability to fall despite increasing sales and customer growth.
Business Questions
- Why did profit margin decrease despite higher revenue?
- Which products generated high revenue but low profitability?
- Did discounts contribute to margin erosion?
- Which customer segments were least profitable?
- Which regions produced the highest and lowest profits?
- What actions should management take to improve profitability?
Key Performance Indicators
- Revenue: $733.22K
- Profit: $93.44K
- Orders: 1,687
- Customers: 693
- Average Order Value: $434.63
- Average Selling Price: $58.77
- Profit Per Unit: $7.49
- Profit Margin: 12.74%
- Revenue Per Customer: $1.06K
- Profit Per Customer: $134.83
Key Insights
Revenue Performance
Revenue reached its highest level in company history, increasing to $733.22K. However, higher sales did not translate into proportional profitability.
Product Performance
Canon ImageCLASS 2200 Advanced Copier generated the highest revenue and profit. However, Binders and Machines significantly reduced overall profit margin despite contributing substantial sales volume.
Customer Analysis
Consumer customers generated the highest revenue while Corporate customers produced the lowest profit margin. Revenue growth increasingly came from lower-margin customer segments.
Regional Performance
California remained the most profitable state, while Wyoming generated the lowest overall profit, indicating regional profitability differences.
Pricing & Discounts
Average Selling Price declined from $61.93 to $58.77 while average discount increased to 7.07%, reducing profitability across many transactions.
Root Cause Analysis
- Higher discount rates reduced profit per sale.
- Sales shifted toward lower-margin products such as Binders, Tables, and Machines.
- Average selling price declined.
- Average order value decreased.
- Growth was driven primarily by lower-margin customer segments.
Recommendations
- Reduce dependence on low-margin products.
- Review company discount strategy.
- Prioritize higher-margin products.
- Focus marketing on more profitable customer segments.
- Continuously monitor margin by product, customer segment, and region.
Business Impact
The analysis demonstrates that revenue growth alone is not an indicator of business success. By identifying the products, pricing strategies, customer segments, and regions responsible for margin erosion, management can improve profitability while maintaining sustainable sales growth.
