On target
6
Amber
5
Red
1
KPI Scorecard
Business KPIs against target with achievement, red-amber-green status, change since last period and a perspective summary.
4 free kpi performance templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 4 spreadsheets from KPIs & Performance, Suppliers & Vendors and Store Operations. Start with KPI Scorecard, Supplier Performance Scorecard and Retail Store KPI Scorecard: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
On target
6
Amber
5
Red
1
Business KPIs against target with achievement, red-amber-green status, change since last period and a perspective summary.
Average score
3.9
Preferred suppliers
1
Needing review
3
Quarterly weighted supplier scores on quality, delivery, price, responsiveness and compliance, with ratings, quarter-on-quarter trend and review flags.
Sales
$308,840
Conversion rate
14%
Average transaction value
$33
Weekly footfall, transactions, units and sales by store, turned into conversion, basket value and units per sale.
Revenue this month
$655,000
Revenue, last 12 months
$7,013,000
EBITDA margin this month
16%
One page that answers how the business did this month: revenue, margins, EBITDA, cash, DSO and customers against target, with 12-month trends.