Retail Supply Chain Performance Dashboard — 6-page interactive analytics suite covering executive overview, supply chain operations, product performance, sales team, geography, and customer segmentation

Retail supply chain performance
2014–2017 · 9,994 transactions · Sales + Calendar joined on order date
Total sales
$2.30M
All years combined
Total profit
$286K
Net after discounts
Profit margin
12.47%
Profit / Sales
Total orders
5,009
Distinct order IDs
Units sold
37,873
Total quantity
Return rate
8.00%
Returned = Yes
Avg discount
15.62%
Per transaction
Avg ship days
34.6 d
Order → ship
Monthly sales & profit trend (2014–2017)
Monthly sales peaking in Nov-Dec each year, profit following similar pattern.
Sales
Profit
Sales by region
West leads with $725K, East $679K, Central $501K, South $392K.
Sales by category
Technology 36%, Furniture 32%, Office Supplies 31%.
Avg ship days
34.6 d
All modes
Delayed orders
3,840
> 5 days to ship
On-time orders
6,154
≤ 5 days to ship
Delay rate
38.4%
Of all shipments
Orders by ship mode
Standard Class dominates with 5,968 orders.
Avg shipping days by mode
Same Day near 0, Standard Class averages 42 days.
Delayed vs on-time shipments
61.6% on time, 38.4% delayed.
On time (6,154)
Delayed (3,840)
Return rate by ship mode
Same Day has highest return rate at 11.8%.
Sales & profit by sub-category
Phones, Chairs, Storage lead in sales. Tables has negative profit.
Sales
Profit
Top 10 products by sales
Canon imageCLASS 2200 leads at $61K.
Low-margin high-sales products (profit margin < 5%)
Sales by rep
Anna Andreadi leads with $725K.
Profit by rep
Anna Andreadi leads with $108K profit.
Avg discount by rep
Kelly Williams highest at 24%.
Return rate by rep
Anna Andreadi has highest return rate at 15.3%.
Sales by state (top 20)
California $458K, New York $311K, Texas $170K.
Profit by region
West leads with $108K profit.
Orders by region
West has most orders at 1,611.
States with negative profit (loss makers)
Consumer sales
$1.16M
51.6% of total
Corporate sales
$706K
30.7% of total
Home Office sales
$430K
18.7% of total
Sales by segment
Consumer 51.6%, Corporate 30.7%, Home Office 18.7%.
Profit by segment
Consumer $134K, Corporate $92K, Home Office $60K.
Orders by segment
Consumer 2,586 orders, Corporate 1,514, Home Office 909.