Score Card
Summary
This document consolidates performance data into a single location, enabling seamless month-to-month comparisons or evaluations against a defined baseline. By providing a comprehensive overview, it supports a clear understanding of revenue potential and reveals key contributing factors. This structured format enables data-driven decision-making by surfacing trends and offering insights to assist in optimizing performance and maximizing revenue opportunities.
Business Value and Relevance
This scorecard outlines the core Key Performance Indicators (KPIs) being monitored and their related business use cases. These KPIs serve as benchmarks to assess performance, uncover trends, and ensure alignment with strategic objectives. By leveraging these insights, businesses can take informed actions to maintain relevance and enhance decision-making.
The following table displays the KPIs organized by category for clarity. These metrics provide essential insights that support evaluation, highlight performance trends, and guide effective business decisions.
Understanding Key Performance Indicators
Total monthly Revenue from all Assets
Shows total revenue generated by all assets within a given month. This KPI provides insights into financial performance across the asset base.
Why it matters:
- Strategic Planning: Informs resource allocation and investment decisions.
- Performance Monitoring: Supports monthly tracking of overall revenue performance.
Average Monthly Revenue per Asset
Displays the average monthly revenue generated per asset, helping businesses understand asset-level contribution.
Why it matters:
- Asset Benchmarking: Highlights underperforming or high-performing assets.
- Improvement Opportunities: Suggests areas for improving asset utilization and strategies.
Average Daily Units Sold per Asset
Reveals sales velocity by showing average daily units sold per asset.
Why it matters:
- Sales Effectiveness: Provides insight into asset sales productivity.
- Trend Detection: Helps track seasonal or outlet-specific sales trends.
Average Units Sold per Door Opening (All Assets)
Assesses the effectiveness of customer interaction with assets by correlating door openings with units sold.
Why it matters:
- Utilization Insights: Highlights how efficiently assets convert engagement into sales.
- Sales Optimization: Helps identify ways to improve merchandising or stocking strategies.
Average Number of Out-of-Stock Days per Product
Indicates how often products are unavailable, providing a view into inventory availability.
Why it matters:
- Revenue Impact: Reveals lost sales opportunities due to stockouts.
- Customer Experience: Supports initiatives to improve product availability and satisfaction.
Total Monthly Missed Revenue for All Assets
Estimates revenue that could have been realized if stockouts had not occurred.
Why it matters:
- Lost Opportunity Analysis: Quantifies financial impact from inefficiencies.
- Stock Management: Informs strategies to minimize revenue loss.
Average Monthly Missed Revenue per Asset
Identifies the unrealized revenue per asset, helping businesses target performance gaps.
Why it matters:
- Forecast Accuracy: Informs improvements in forecasting and replenishment planning.
- Revenue Recovery: Guides actions to reduce missed revenue potential.
Missed Sales Uplift (%)
Shows the percentage increase in sales that could have occurred without missed opportunities. This is presented as an expandable card that allows users to explore missed sales data by product and outlet.
Why it matters:
- Performance Potential: Highlights room for growth by recovering missed sales.
- Benchmarking: Assists in comparing current sales vs. potential.
Own Share of Shelf (%)
Displays the percentage of shelf space allocated to the business's own brand. Presented as an expandable card, it enables users to explore own-brand shelf share data at the outlet level.
Why it matters:
- Brand Presence: Supports evaluation of brand visibility in stores.
- Sales Opportunity: Guides actions to improve shelf share and drive growth.
Foreign Share of Shelf (%)
Shows the proportion of shelf space taken by competitor brands. An expandable card reveals competitor shelf share data by outlet.
Why it matters:
- Competitive Intelligence: Informs strategies to regain or expand shelf presence.
- Brand Differentiation: Helps position own brand more effectively.
Empty Share of Shelf (%)
Measures shelf space that is unoccupied. Displayed as an expandable card, it offers a detailed view of empty shelf share across various outlets.
Why it matters:
- Operational Efficiency: Identifies gaps in stocking and supply chain practices.
- Revenue Potential: Surfaces opportunities to convert empty space into sales.
Target Portfolio Compliance (%)
Assesses how many of the targeted products are available in an asset. The expandable card breaks down the compliance information by outlet, offering actionable insights.
Why it matters:
- Product Availability: Tracks compliance with product placement goals.
- Sales Enablement: Supports product strategy execution at the outlet level.
Average Daily Door Openings per Asset
Shows the number of times an asset is accessed daily, reflecting customer interaction. Presented as an expandable card, it displays detailed data for each asset within an outlet.
Why it matters:
- Engagement Metric: Indicates how frequently customers interact with assets.
- Opportunity Analysis: Helps correlate engagement with sales performance.
Average Monthly Replenishment Frequency per Asset
Tracks how often each asset is restocked during a month.
Why it matters:
- Inventory Efficiency: Aids in planning replenishment cycles.
- Stockout Prevention: Helps maintain product availability.
Geo-fence Violation Alerts (%)
Monitors assets that leave a designated geographic area. This expandable card provides insights into each alert, including its age, asset owner, and the assigned responsible person.
Why it matters:
- Asset Control: Enhances security and transparency in asset movement.
- Operational Oversight: Enables prompt response to unauthorized movements.
High Temperature Alerts (%)
Monitors the percentage of assets exceeding temperature thresholds for extended periods. This expandable card provides insights into each alert, including its age, asset owner, and the assigned responsible person.
An alert will be triggered if the recorded values fall outside the defined range ("Temperature Above" and "Temperature Below" thresholds) for the defined period (e.g. 24hrs). The alert will automatically close once the temperatures return within the acceptable range.
Why it matters:
- Product Integrity: Supports quality assurance for temperature-sensitive goods.
- Risk Mitigation: Triggers corrective action to maintain standards.
This structured scorecard empowers businesses with actionable performance insights, supporting ongoing optimization and sustained growth.