The dashboard provides key information on the sales performance in the years 2018, 2019 and 2020. It is observed that, there is a significant increase in sale from 2018 to the following years. Event though, the sales target of $30 million is not reached in the year 2020, yearly sales has increased by 1.19%. The analysis shows some area to improve to increase sales performances.
Some Key insights:
- Total Sales & Profit
-
- Total sales amount $73.14M with a 29.16% profit margin that gives a $21.33M profit.
- There is a significant growth from 2018 followed by a small decline in 2021 according to the forecast. The trend at the end of 2020 is slightly downwards which justifies the forecast.
- Sales Performance by Channel
- Significant growth notices in the in-store and online channel. A slight decline in the growth of Wholesale channel in 2020. Customer are being more attracted to in-store and online purchase.
- Top Products
- Top product by sales and Most Ordered and Profitable Products shows some of the most popular products. Product 23, Product 37, and Product 40 are clearly the top 3 products based on sales, profitability and order quantity.
- Warehouse Performance & Lead Time
- Warehouse performance varies, with WARE-NBY1002 achieving the highest profit margin.
- Average lead time from order to delivery is 22 days. WARE – MKL 1006 shows takes more time to deliver the goods than it takes for the shipment, this is an are for improvement to increase operational efficiency.
- Total lead time for WARE-UHY1004 is significantly higher than the other warehouse shows the inefficiency of the warehouse. Some improvements can be brought on to reduce the lead time due to shipment to delivery.
- Sales KPIs & Annual Trends
- Setting up a target of $30M, the sales on 2020 is 6.05% below the target.
- YoY sales performance increased 1.19% which shows some improvements have been introduced. Focus should be brought on underperforming channels, optimizing the lead times among the warehouses, and optimizing sales teams performances to achieve targeted sales.
- Sales Team Performance
- Performance varies across teams, suggesting that aligning incentives and training with team goals could optimize results.
Conclusion
This dashboard provides actionable insights into sales performance, customer behavior, and operational efficiency. Key focus areas for improvement include optimizing lead time and bolstering underperforming sales channels to meet growth targets.
