This dashboard was created to help track and manage key post sales collection data.
It brings together important details like the number of style sold, buy depth, and bestsellers.
It also highlights how sales are distributed across fabrics, colours, and product categories. By consolidating this information in one place, it provides merchandising teams with a clearer view of performance, helping to spot trends, spark conversations, and quickly address any concerns.
Note, some of the widgets have Large Number Formatting switched on. (rounded to 2 dp)
1. "Sold Styles" - Total number of styles on sales orders.
2. "Sold Quantity" - Total number of units on sales orders.
3. "Average Buy Depth" - Average sales order quantity per sales order.
4. "Bestsellers" - List of bestseller products in descending order based on sales order quantity.
5. "RRP Weighted Average" - Average RPP across all sold units.
6. "Buy at RRP" - Total RRP value of sold units.
7. "Styles Not Sold" - Number of Styles not sold.
8. "RRP Weighted Margin" - Average RPP margin across all sold units.
9. "Buy at Cost" - Total Cost value of sold units.
10. "Withdrawn Products" - Number of Products withdrawn.
11. "Style" ( >Product ID) - Sales order value across Styles.
12. "Fabric" ( >Product ID) - Sales order value across Fabrics.
13. "Colour" ( >Product ID) - Sales order value across Colours.
14. "Size Category" ( >Product ID) - Sales order value across Size Categories.
15. "Product Category 1" ( >Product ID) - Sales order value across Product Category 1.
16. "Product Category 2" ( >Product ID) - Sales order value across Product Category 2.
17. "Product Category 3" ( >Product ID) - Sales order value across Product Category 3.
18. "Product Category 4" ( >Product ID) - Sales order value across Product Category 4.
19. "Product Category 5" ( >Product ID) - Sales order value across Product Category 5.
20. "Product Minimums" - Product minimums sorted in ascending style order.
21. "Collection Cost Summary" - Summary of product costs sorted by Style (1), Sales Order Quantity (2), Total Gross Profit (3).