Sales performance over the three-year period shows moderate growth followed by a noticeable decline in 2012, indicating emerging instability in overall performance. While the business remains profitable, revenue is heavily driven by a few top performers, creating potential risk if trends continue. Immediate attention is required to improve consistency and support underperforming representatives.
Kabir Retail Solutions provided transactional sales data for five sales representatives covering a three-year period (2010–2012). As the company prepares for the 2013 fiscal year, management requires clarity on individual performance, revenue contribution, and overall sales trends to support strategic decision-making.
This analysis aims to answer the following business questions:
- Who is the most consistent sales representative?
- Who generates the highest sales volume?
- Where is performance improving or declining?
The dataset includes sales transactions across five representatives over three years.
Key metrics analyzed:
- Total Revenue
- Quantity Sold
- Transaction Count
- Yearly Performance Trends
Aggregate Performance:
| Metric | Value |
|---|---|
| Total Quantity Sold | 1,224 units |
| Total Revenue | 269,280 |
| Average Transaction Value | 11,220 |
| Revenue Range | 5,280 – 20,900 |
Tola generated the highest total revenue (82,720) and recorded the highest number of transactions (7). This indicates a strong balance between sales volume and deal frequency, making Tola the most impactful contributor to overall business performance.
Abdul demonstrated steady growth in revenue across all three years, without major fluctuations. This consistency makes Abdul the most reliable performer for forecasting and long-term planning.
Ayo recorded the lowest revenue (30,800) and lowest activity level (3 transactions). Sales dropped significantly after 2010, with only slight recovery, indicating persistent underperformance and possible disengagement.
Multiple representatives, including Tola and Ese, experienced a drop in performance in 2012. This suggests a potential broader issue affecting sales, such as market conditions, internal challenges, or reduced demand.
Ada recorded zero sales in 2011, followed by recovery in 2012. This gap may indicate operational disruption, absence, or data reporting issues, and should be investigated.
| Sales Rep | Quantity Sold | Revenue |
|---|---|---|
| Tola | 376 | 82,720 |
| Abdul | 277 | 60,940 |
| Ese | 237 | 52,140 |
| Ada | 194 | 42,680 |
| Ayo | 140 | 30,800 |
| Sales Rep | Trend |
|---|---|
| Tola | Growth (2010–2011) → Decline (2012) |
| Abdul | Consistent growth across all years |
| Ayo | Sharp decline after 2010 → weak recovery |
| Ada | No activity in 2011 → recovery in 2012 |
| Ese | Stable → slight growth → decline |
(
)
Shows total revenue and quantity contribution by each sales representative.
Highlights performance trends and fluctuations across 2010–2012.
Includes calculated metrics such as SUMIF and COUNTIF used in the analysis.
Question: Which Sales Rep has the highest transaction count but not the highest revenue?
Answer: Abdul
- Abdul has a high number of transactions (6) but generates less revenue than Tola.
Interpretation: This suggests Abdul is handling more frequent but lower-value transactions, indicating an opportunity to improve revenue through upselling or targeting higher-value clients.
Sales trends show inconsistent performance across representatives, with a noticeable decline in 2012 for several key contributors.
Recommendation: The company should not immediately expand its workforce.
Instead, focus should be placed on:
- Improving underperforming representatives (Ayo)
- Addressing declining trends in key performers (Tola, Ese)
- Leveraging consistent performers (Abdul) for stability
Based on the analysis, the following actions are recommended:
- Reward High Performers: Recognize and retain Tola as a key revenue driver
- Improve Sales Efficiency: Train Abdul to increase average deal value
- Address Underperformance: Provide support or reassessment for Ayo
- Investigate Data Gaps: Review Ada's 2011 inactivity
- Stabilize Declining Trends: Identify causes of 2012 performance drops
- Reduce Dependency Risk: Diversify revenue contribution across team members
The analysis reveals that while Kabir Retail Solutions maintains strong revenue generation, performance is unevenly distributed and shows signs of decline in recent periods. Sustained success will depend on improving consistency, addressing underperformance, and strengthening overall sales strategy ahead of 2013.
Analysis completed using Microsoft Excel. All formulas used: SUM, SUMIF, COUNTIF, MIN, MAX, AVERAGE, COUNT, COUNTA.