Executive Sales Summary - TY vs LY
The Executive Sales Summary - TY vs LY dashboard provides a high-level view of sales performance, growth dynamics, and commercial concentration across customers, products, and sales representatives. It helps executive leadership evaluate revenue momentum, margin performance, volume impact, and reliance on top contributors for strategic sales and market decisions.
Benefits of this dashboard
- Oversee executive revenue performance: Provides a consolidated view of commercial performance to support strategic sales planning and executive reporting.
- Identify growth and decline trends: Enables rapid detection of revenue acceleration or contraction through clear year‑over‑year variance analysis.
- Monitor margin sustainability: Supports profitability governance by tracking changes in margin structure alongside revenue growth.
- Evaluate sales‑force effectiveness: Highlights top‑performing sales representatives to guide incentive management and sales resource allocation.
- Analyze customer and product concentration: Identifies revenue dependency on key customers and products to manage commercial risk and diversification strategy.
Key performance indicators (KPIs)
| KPI | Description |
|---|---|
| Net Sales Current Year | Total recognized sales revenue for the selected fiscal period in the current year. Higher values indicate stronger current-period commercial performance, while lower values indicate revenue contraction or weaker demand. |
| Net Sales Last Year | Total recognized sales revenue for the equivalent period in the prior year. Serves as the baseline for year-over-year growth analysis. |
| Net Sales Variance | Percentage change in net sales between the current year and the prior year. Higher positive values indicate revenue growth acceleration, while negative values indicate declining sales performance. |
| Margin % Current Year | Current-year gross margin as a percentage of net sales. Higher margins indicate stronger pricing power and cost efficiency, while lower margins indicate margin pressure from cost inflation or pricing erosion. |
| Margin Variance % | Year-over-year percentage change in gross margin. Positive variance indicates improving profitability structure, while negative variance indicates margin deterioration. |
| Quantity Variance % | Year-over-year percentage change in sales volume. Higher values indicate volume-driven growth, while negative values indicate declining unit demand. |
Filters
You can filter the dashboard with these panels:
- Year
- Period
- Company
- Location
- Product Lines