Sales & Revenue Dashboard – Key Insights (Full Year 2022)

Overall Performance vs Targets

1. Total Revenue: $24.9M → -1.9% below target ($25.4M)
2. Total Profit: $10.5M → -1.8% below target ($10.65M)
3. Total Orders: 25.2K → -0.6% below target (25.16K)
4. → Very close to plan, only minor shortfalls.

Top Performers

1. Top 3 Products by Revenue (2020–2022):
2. Mountain-200 Black, 42
3. Mountain-200 Black, 46
4. Mountain-200 Silver, 38
5. → Mountain-200 series dominates revenue consistently for three years.
6. Top 3 Best-Selling Products (by units)
7. Mountain Tire Tube
8. Patch Kit/8 Patches
9. Water Bottle – 30 oz.
10. → Low-price, high-volume consumables lead in units.
11. Top 3 Products by Return Rate (highest returns)
12. Mountain-100 Silver, 44
13. Road-650 Red, 52
14. Touring-2000 Blue, 46
15. → Overall return rate is very healthy at 2.2%, but these three models need quality/packaging attention.

Category & Customer Insights

1. Sales Mix by Category:
2. Bikes: 44.82%
3. Accessories: 36.76%
4. Clothing: 18.41%
5. → Bikes drive almost half of revenue.
6. Customer Priority:
7. 92.91% Standard
8. 7.09% Priority
9. → Very low share of high-value/rush orders.

Regional Orders

1. Australia – 6K
2. Southwest – 5K
3. Northwest – 4K
4. Canada – 3K
5. United Kingdom – 3K
6. → Australia remains the strongest market.

Revenue Trend

1. Strong Q1–Q2, peak in May–June, followed by steady decline through the second half of the year → clear seasonal pattern with weak Q4.

Key Takeaways & Recommendations

1. Mountain-200 series is the undisputed flagship — protect and expand this line.
2. Low-price accessories (tubes, patches, bottles) drive massive unit volume and customer retention — perfect for bundling and loyalty programs.
3. Return rate is excellent (2.2%), but three specific models stand out — initiate quality review and improved packaging/testing for Mountain-100 Silver and Road-650 Red.
4. Heavy Q3–Q4 revenue drop — launch stronger promotions, early Black Friday, or new model releases in Q4 to smooth seasonality.
5. Priority customer segment is tiny (7%) — explore up-sell/cross-sell programs to convert standard customers into higher-value priority buyers.

Overall: Solid, stable business with clear flagship products, very healthy return rate, and predictable seasonality that offers a clear opportunity for Q4 improvement.

The dashboard is designed using Flexa Design, Flexa Tables, and Flexa Charts from Flexa Intel.