R
Retail Sales Analytics
United States · 2014–2017 · 488 Orders · 366 Customers
Total Sales
$1.13M
4 years combined
Total Profit
$401K
35.5% margin
Profit Margin
35.5%
Across all categories
Total Orders
488
Unique transactions
Customers
366
Active accounts
YoY Growth (2017)
−13.6%
vs 2016
Monthly Sales Trend Sales vs Profit
Monthly performance across all selected years
Annual Comparison
Sales & Profit by year
Sales by Region
Revenue distribution per region
Sales by Category
Product category breakdown
Customer Segment
Sales by client segment
Total Customers
366
Unique clients
Avg Sales / Customer
$3,086
Per unique customer
Top Customer
Becky Martin
$57,670 sales
Top Region
Central
$349K in sales
Customer Count by Region
Distribution of customers across regions
Sales by Ship Mode
How customers prefer to receive orders
Top 10 Customers by Sales
Ranked by total revenue contribution
| # | Customer Name | Region | Orders | Sales | Share of Total |
|---|
Best Category
Technology
$453.6K sales
Best Margin Category
Office Supplies
36.1% margin
Top Sub-Category
Accessories
$144.6K · 39.4% margin
Lowest Margin
Bookcases
27.8% margin
Sales by Sub-Category (Top 10)
Ranked by total revenue
Profit Margin by Sub-Category
Which products deliver best margins
Region × Category Sales Matrix
Sales breakdown per region and product category
| Region | Furniture | Office Supplies | Technology | Total |
|---|
Business Insights Report
Key findings from the 2014–2017 retail sales analysis
📈 Overall Sales Performance
Total revenue across 2014–2017 reached $1.13M with a healthy profit of $401K. The business achieved its peak in 2014 at $322.9K, followed by a dip in 2015 (−18.9%). A partial recovery was seen in 2016 (+11.6%), but 2017 declined again to $252.5K, signaling a concerning downward trend that requires strategic attention.
🏆 Regional Dominance
The Central region leads with $349.6K in sales (31% of total), closely followed by West at $308.4K. The South region is the weakest performer at $211.9K, suggesting untapped potential or market challenges. West leads in profit margin, making it the most efficient region for returns on investment.
💻 Technology Dominates Categories
Technology products generate the highest revenue at $453.6K (40% of total sales), and deliver the highest absolute profit at $163.4K. The Central region accounts for the vast majority of Technology sales ($208K), indicating heavy concentration risk. Office Supplies edge out Furniture slightly on profit margin (36.1% vs 34.3%).
⭐ Top Sub-Categories
Accessories is the standout sub-category with $144.6K in sales and the highest margin among top performers at 39.4%. Machines and Tables also contribute significantly (~$140K each). Bookcases show the weakest margin at 27.8%, while Paper and Furnishings are low-volume — candidates for portfolio optimization.
⚠️ Revenue Concentration Risk
The top 10 customers represent a significant portion of total revenue, with Becky Martin alone contributing $57.7K — nearly 5% of all sales from a single order. This level of concentration in individual customers creates revenue vulnerability if key accounts are lost.
🚚 Standard Class Dominates Shipping
Standard Class shipping accounts for $683.5K (60.5%) of all sales, indicating most customers opt for economy over speed. First Class and Same Day combined only represent 20% of revenue. Offering targeted shipping incentives for premium modes could improve margins on smaller, high-value orders.
👥 Consumer Segment Leads
The Consumer segment generates $601K (53.2%) of total sales, more than Corporate and Home Office combined. This suggests the business is primarily B2C-oriented. Growing the Corporate segment — which shows higher average order values — could be a key strategy for improving per-transaction revenue efficiency.
📊 Strategic Recommendations
1. Revive 2017 momentum by analyzing what drove 2014 peak. 2. Expand South region presence — lowest performer with growth potential. 3. Protect top 10 customers with loyalty programs. 4. Accelerate Technology sales beyond Central region. 5. Optimize Furniture margins — high sales but lowest margin category.
