New: NextGenTemplates Academy - video courses on Excel formulas with AI and Pivot Tables & dashboards. Early-bird: 20% off with code EARLYBIRD20 - first 20 orders only.See the courses →
PKComments Off on Carpentry Workshop KPI Scorecard in Excel
The Carpentry Workshop KPI Scorecard in Excel reports 10 joinery KPIs across 5 KPI groups, spread over 9 worksheets, with room to grow to 20 KPIs. Each KPI carries 12
PKComments Off on Painting Contractor KPI Dashboard in Excel
Most painting contractors know their revenue and almost nothing else. The bid went out, the crew went out, the invoice went out, and somewhere in the middle the margin either
PKComments Off on Roofing Contractor KPI Dashboard in Excel
Roofing is a trade where the money is won or lost in the gap between the signature and the final sign-off. A crew installing a square a day slower than
PKComments Off on Welding Shop KPI Scorecard in Excel
Most fabrication shops can tell you last month's revenue to the dollar. Far fewer can say, on the second Tuesday of the month, how much of the paid welder hours
PKComments Off on Flooring Installation KPI Scorecard in Excel
Most flooring companies know their revenue. Far fewer can say, in the first week of the month, how many square feet went down against plan, what share of jobs was
PKComments Off on Roofing Contractor KPI Scorecard in Excel
Most roofing companies already know their revenue. Far fewer can say, on the second Tuesday of the month, what share of jobs finished on time, how much of the crew's
PKComments Off on Garden Centers KPI Dashboard in Excel
A garden centre is four businesses sharing one car park: a retail shop, a living-goods nursery, a coffee shop and an online click-and-collect counter. Each throws off numbers in a
PKComments Off on DIY Home Improvement Stores KPI Dashboard in Excel
A DIY and home improvement chain generates an awkward mix of numbers. Comparable-store sales growth behaves like a supermarket metric. Special-order fill rate and job-site delivery behave like a distribution
PKComments Off on Discount Stores KPI Dashboard in Excel
Discount retail is a business of small margins repeated at enormous volume. When your average unit retail is $2.63 and your average basket is under $17, a 40-basis-point slip in
PKComments Off on HVAC Contractor KPI Scorecard in Excel
Most HVAC companies already know their numbers. What they usually do not have is one page that puts all of them side by side, marked against target, for a single