ADIDAS SALES PERFORMANCE ANALYSIS REPORT (2020–2021)

ADIDAS SALES PERFORMANCE ANALYSIS REPORT (2020–2021)

Analysis Dashboard

INTRODUCTION This report analyzes Adidas’ sales performance in the U.S. for 2020 and 2021 using data from multiple retailers, cities, and regions. The dataset includes metrics such as total sales, units sold, and operating profit across various product lines and sales methods. The goal of the analysis is to identify performance trends and key drivers of revenue and profitability. Microsoft Excel was used to conduct trend, regional, and retailer-based analyses. The insights derived will support Adidas management in making data-driven decisions to enhance market performance and profitability.

PRE-ANALYSIS BOARD PROJECT SPLIT Category 1 — Independent Variables • Retailer • Region • State • City • Product • Sales Method

Category 2 — Dependent Variables • Price per Unit • Units Sold • Total Sales • Operating Profit

POTENTIAL ANALYSES / QUESTIONS • Regional Performance by Revenue • State Performance by Revenue • City Performance by Units Sold • Retailer by Operating Profit • Product Performance by Units Sold • Retailer by Units Sold • Region by Units Sold • City by Units Sold

INDUSTRY TYPE Sportswear brand with significant revenue generation from multi-channel retail operations.

DATA STORY The dataset represents sales transactions of Adidas sportswear products across multiple U.S. retailers, cities, and regions for 2020 and 2021. It captures detailed records of products sold, quantities, sales revenue, and operating profits. The analysis provides insights into market performance, product demand patterns, regional contributions, and retailer profitability.

STAKEHOLDERS • Adidas Executives and Management Teams • Sales and Marketing Departments • Logistics and Operations Teams • Finance and Strategy Divisions

DEFINITION OF SUCCESS Success for Adidas is defined primarily by increased revenue generation, expanded market share, and sustained profitability across all retail and regional channels.

POTENTIAL INSIGHTS

1. Identify the most purchased products and bundle them with related items to boost total sales.
2. Determine top-performing cities by revenue to guide location-specific marketing campaigns.
3. Focus on high-demand product categories to optimize inventory and minimize stockouts.
4. Monitor regional sales trends to align product offerings with demand fluctuations.
5. Identify the highest-performing retailers and strengthen partnerships.
6. Assess the effectiveness of various sales methods and channels.

IN-ANALYSIS BOARD Analysis 1: Sales Trend Report

Observations:

1. Total sales amounted to $119.93 million, indicating strong overall performance.
2. July recorded the highest monthly sales of $13 million.
3. August followed closely with $12 million in total sales.
4. December ranked third, generating $11 million.
5. March recorded the lowest sales at $8 million. Insights: • Sales activity is consistently low in Q1 (January–March), indicating reduced consumer demand or limited promotional activity early in the year. • The sharp increase in July and August suggests a strong mid-year buying cycle, possibly linked to summer sports seasons or promotional events. • The December sales rise implies heightened consumer activity during holiday periods, showing seasonal sensitivity in Adidas sales. • The sales drop in March represents a deviation from the general upward trend, suggesting possible external factors such as reduced inventory or weaker campaigns.

Analysis 2: Top 5 Cities by Units Sold

Observations:

1. New York achieved the highest demand with 111,954 units sold.
2. Charleston followed with 102,483 units, reflecting strong regional performance.
3. Houston ranked third with 88,772 units sold.
4. Los Angeles recorded the lowest among the top five, with 76,384 units. Insights:
5. New York and Charleston emerge as major demand centers, reflecting high market penetration and strong brand affinity in these cities.
6. The smaller gap between the top two cities indicates relatively balanced performance across key urban markets.
7. Houston’s strong sales demonstrate steady demand in the South-Central region, highlighting its potential as a growing market.
8. Los Angeles, while in the top five, underperforms relative to its market size, suggesting that Adidas’ reach or consumer engagement may be weaker there.
9. The distribution of sales across cities indicates concentration in major metropolitan areas, with opportunity for expansion in emerging cities.
10. Customize product assortments by city to improve inventory turnover and customer satisfaction.

Analysis 3: Products by Units Sold

Observations:

1. Men’s Street Footwear achieved the highest sales with 593,320 units.
2. Combined men’s product categories (street footwear, athletic footwear, apparel) exceeded 1.33 million units.
3. Footwear significantly outperformed apparel categories.
4. Women’s Athletic Footwear (317,136 units) trailed men’s by over 100,000 units. Insights: • Men’s Street Footwear drives the majority of unit sales, confirming that men’s footwear remains Adidas’ core revenue generator. • The dominance of footwear categories over apparel indicates a stronger brand perception in shoes than in clothing. • The noticeable gap between men’s and women’s athletic footwear suggests higher male participation in performance categories or differing brand appeal by gender. • Women’s product lines, while performing steadily, lag behind men’s, highlighting an imbalance in market strength across gender segments. • The overall data reinforces that consumer preference is highest for footwear, particularly lifestyle and performance categories.

Analysis 4: Operating Profit by Retailer

Observations:

1. West Gear led with approximately $9 million in profit.
2. Foot Locker followed with $8 million, while Sports Direct achieved $7 million.
3. Walmart recorded the lowest profit at $3 million.
4. Specialty retailers significantly outperformed general retailers in profitability. Insights: • West Gear and Foot Locker account for the largest share of profits, confirming that specialty sports retailers are Adidas’ most profitable partners. • Profitability decreases significantly among general retailers such as Walmart and Amazon, suggesting thinner margins in mass retail channels. • The profit pattern aligns with retailer specialization, where dedicated sports retailers perform better due to brand positioning and target audience alignment. • The concentration of profit within three top retailers indicates dependency on a small group of high-performing partners.

Analysis 5: Sales Method by Revenue

Observations:

1. Online sales generated 37.49% of total revenue, the highest among all methods.
2. Outlet sales followed with 32.77%.
3. In-store sales accounted for 29.74%, the lowest share. Insights: • The dominance of online sales, contributing 37.49% of total revenue, indicates a strong consumer shift toward digital purchasing channels and successful e-commerce adoption by Adidas. • The significant share of outlet sales (32.77%) suggests that customers are highly responsive to discounted or promotional offerings, reflecting price sensitivity across certain market segments. • The lower proportion of in-store sales (29.74%) implies that traditional retail channels are losing relative market share, possibly due to increased online convenience or limited in-store engagement activities. • Overall, the sales distribution demonstrates a changing retail dynamic where online and outlet channels collectively drive over two-thirds of Adidas’ revenue, highlighting the growing importance of digital and value-based sales strategies.

Analysis 6: Sales by Region

Observations:

1. The West region generated the highest revenue with a percentage of 30.30%
2. The Northeast ranked second with a percentage of 20.87%
3. The Southeast followed with 17.82%
4. The South and Midwest recorded 17.12% and 13.89%, respectively.
5. The performance gap between the West and other regions indicates stronger consumer demand or marketing efficiency in that area. Insights: • The West region clearly outperforms all others, showing higher concentration of consumer demand and retail activity. • The Northeast and Southeast also record strong sales, pointing to healthy brand visibility and mature markets in these regions. • The South and Midwest show relatively weaker performance, implying potential limitations in retail coverage or consumer engagement. • The performance gap between regions reflects geographic disparities in market maturity, brand presence, and promotional strength.

Analysis 7: Sales by State

Observations:

1. New York led with $6.42M in revenue.
2. Florida and California followed with $5.93M each.
3. Texas and South Carolina generated $4.58M and $2.93M respectively.
4. The top five states contributed nearly 30% of total sales.
5. States such as Nebraska, Minnesota, and Wisconsin recorded minimal performance. Insights: • New York, Florida, and California lead state-level sales, confirming their role as Adidas’ key revenue hubs. • The top five states account for nearly one-third of total sales, revealing a high concentration of market activity in select areas. • Mid-tier states such as Washington and Oregon display moderate but stable demand, indicating opportunity for incremental growth. • Low sales in states such as Nebraska and Wisconsin suggest limited brand penetration or retail presence in those areas. • The state-level pattern highlights uneven market distribution, with most sales concentrated in economically or demographically dense states.

POST-ANALYSIS BOARD POST-ANALYSIS OBSERVATIONS

1. Sales peaked in July, August, and December, with March being the lowest-performing month. Sales patterns were consistent across product categories and regions.
2. Regional sales ranked: West > Northeast > Southeast > South > Midwest. The West dominated overall product performance.
3. Retailer profitability ranked: West Gear > Foot Locker > Sports Direct > Kohl > Amazon > Walmart. Specialty retailers led across most performance metrics.
4. Best-selling product categories were Men’s Street Footwear, Men’s Athletic Footwear, Women’s Apparel, and Women’s Footwear lines.
5. Sales methods ranked: Online > Outlet > In-store. Online performance was strongest across all products and regions.

POST-ANALYSIS RECOMMENDATIONS

1. Peak Period Optimization: Leverage high-performing months (July, August) by replicating successful sales strategies and preparing adequate inventory.
2. Low Month Recovery: Investigate and address low sales in March through promotions and new campaigns.
3. Regional Focus: Maintain dominance in the West while replicating its successful strategies in the South and Midwest.
4. E-commerce Growth: Sustain online sales infrastructure through digital marketing and logistics partnerships
5. Outlet Strategy: Expand successful outlet models from the West to other regions.
6. Retailer Expansion: Encourage retailers lacking in-store presence (e.g., Amazon, Kohl) to expand physically in underrepresented regions.
7. Retailer Collaboration: Partner with Sports Direct and Walmart in the South to grow market share.
8. Retailer Prioritization: Strengthen high-profit retailers (West Gear, Foot Locker) through exclusive collections and promotions.
9. Underperforming Retailers: Reassess Walmart’s partnership and product mix to improve performance.
10. Sales Channel Optimization: Expand outlet-exclusive lines and regional promotions with Sports Direct to drive growth.
11. Product Focus: Expand Men’s Street Footwear line with new editions and collaborations.
12. Product Launch Timing: Align major product releases with peak demand months (July–August) to maximize sales impact.

CONCLUSION The analysis demonstrates that Adidas achieved strong sales and profitability across multiple channels and regions in 2020–2021. The West region, men’s footwear products, and specialty retailers were the key performance drivers. Despite consistent overall growth, performance disparities across regions, months, and retailers indicate opportunities for optimization. By leveraging digital transformation, regional strategy replication, and targeted product innovation, Adidas can sustain its growth trajectory and further enhance profitability.

Data Source: Dataset from Kaggle