APEX GEAR PERFORMANCE ANALYSIS FOR THE YEAR 2021
Updated: Sep 8
INTRODUCTION
This project focused on exploring the company’s sales, product profitability, and regional performance. By visualizing key metrics such as total revenue, retailer contributions, and geographic trends, this report uncovers valuable insights to inform strategic decisions. From identifying the top-selling products and peak sales periods to highlighting the most lucrative markets.
DATA CLEANING
To ensure the accuracy of the analysis, I used different data cleaning methods to clean my data.
I Removed duplicates to eliminate inconsistencies in the dataset.
I Standardized date formats for precise time-based analysis.
I also Structured the dataset into an Excel table for easy management and dynamic insights.
KEY OBSERVATIONS
The company generated a total revenue of $89.82M during the year under review.
Men’s Street Footwear emerged as the top-performing product category, generating $20.8M in sales and approximately $8.28M in profit.
The Western Region led overall revenue performance with $26.9M, while regions such as the Midwest showed significant growth potential.
Charleston and New York were among the top-performing cities, generating approximately $3.99M and $3.98M in sales respectively.
July and December recorded the strongest sales periods, highlighting clear seasonal patterns driven by summer demand and holiday spending.
Men’s Street Footwear generated the highest profit at approximately $8.20M, while Women’s Athletic Footwear generated the lowest profit at approximately $3.89M.
Men’s products consistently outperformed their women’s counterparts across multiple categories, highlighting potential opportunities for growth within the women’s product segment.
STRATEGIC RECOMMENDATIONS
Strengthen Retailer Partnerships: Deepen partnerships with West Gear and Foot Locker through exclusive products, promotions, and joint marketing initiatives, while developing targeted strategies to improve Walmart’s underperforming sales.
Maximize Seasonal Demand: Capitalize on July’s peak performance by launching promotional campaigns in June to build early momentum. Use limited-time offers and loyalty programs to improve sales during weaker months.
Prioritize Regional Growth: Increase resource allocation to the high-performing Western Region while revitalizing the Midwest through locally tailored products, targeted marketing, and region-specific campaigns.
Expand Presence in Top Cities: Intensify marketing efforts in Charleston and New York through local partnerships, community events, and targeted campaigns, while developing tailored strategies for underperforming cities.
Build on Product Profitability: Leverage the strong profitability of Men’s Street Footwear through aggressive marketing while introducing bundles and cross-selling strategies to improve the performance of lower-performing product categories.
CONCLUSION
Apex Gear’s 2021 performance analysis reveals a company with strong market presence generating nearly $90M in revenue, demonstrating clear patterns of success through specific retailers (West Gear, Foot Locker), product categories (Men’s Street Footwear), regions (Western), and states (New York), while highlighting significant growth opportunities in underperforming segments. The substantial differences between top and bottom performers across all metrics indicate potential for increased revenue through targeted strategies that strengthen successful channels while revitalizing underperforming areas, particularly by leveraging established strengths in men’s footwear while developing women’s product lines. Strategic focus on seasonal patterns, regional preferences, retailer relationships, and consistent data analysis will position Apex Gear for sustainable growth and continued market relevance beyond 2021.
Comments