Retail Financial Dashboard
- Type:
- Pricing and margin optimization dashboard
- Key Metric:
- 51,290 transactions and $12,642,905 in total sales
- Coverage:
- January 1, 2011 to December 31, 2014
- Description:
- This dashboard examines retail sales, profit, discounts, transaction margins, weighted margins, and category or sub-category performance. It includes category breakdowns, discount buckets, monthly direction, sub-category comparisons, and a raw transaction list.
- Primary Use Case:
- Finding discount thresholds and product groups where pricing decisions materially affect profit.
- Website:
- Open the retail financial dashboard
- Tags:
- Retail, discount analysis, margin optimization, profitability
Decision signal
Weighted margin remained positive through the 10–20% discount bucket at 9.9%, then turned negative in the 20–30% bucket at -5.5%. Tables were especially weak, producing $757,034 in sales but a $64,083 loss and an -8.5% weighted margin.