This dashboard provides a visual way to review and review your sales of primary products by color. Primary products consist of typical flooring products sold by Square Foot like: Carpet, Cushion, LVT, Wood, Tile, VCT, Vinyl and Laminate.
Use the filter feature to select from a number of criteria both to filter your data and the Benchmark data.
You can filter on a specific color by clicking on the color in the Product Color Detail View.
Key Performance Indicators (KPI's):
Product Revenue: Product revenue for the "active filters".
Product Rev Prior: Product Sales revenue for the selected criteria for the prior selected date range (either Year Over Year or Trailing Months).
Product Rev Change: The percentage of change in sales revenue between the current and previous period of time for the selected date range.
GM: Product gross margin for the "active filters".
GM Prior: Product gross margin for the selected criteria and the prior date range (either Year over Year or Trailing Months).
GM Change: The percentage of change in gross margin between the current and previous period of time selected in the "active filters".
BM GM: Total product gross margin for the select criteria for qualified Business Insights participants.
Product Color Detail (top 100): This chart provides an overview of your company's top 100 Primary Product colors. These consist of typical flooring products: Carpet, Cushion, LVT, Wood, Tile, VCT, Vinyl and Laminate sold by the square foot.
Product sales revenue and gross margin are displayed as KPI’s. The dashboard also provides sales dollars, orders, gross profit, quantity, and average price figures for selected period of time, prior period of time and changes from period to period. Clicking on a specific product from the color list provides invoice detail information for all invoices from the selected time frame.
This dashboard contains two additional screens for data evaluation.
Click on the Color link to view the Invoice List. This will display all invoices that contain the selected style and color.
Click on the InvNum (Invoice Number) from the Style and Color Invoice List detail to view the Products Invoice Detail
Invoice Detail from Color
Article is closed for comments.