Most paving contractors already have the numbers. Tonnage comes off the plant tickets, mix cost comes off the invoices, the density failures are in a folder somewhere and the callbacks live in somebody’s inbox. What is usually missing is the one page that says, for December, which of those numbers beat their target and which did not – and whether the year as a whole agrees with the month.
That is what the Paving Contractor KPI Dashboard in Power BI is. Twelve asphalt-paving KPIs, eight KPI groups, a month picker, and MTD and YTD traffic lights side by side on the same row. It ships as a fully editable .pbix with the Excel data pack that drives it and a user manual PDF, for a one-time $12.99 (regular $19.99).
Which family is this? KPI Dashboard, not Dashboard, not Scorecard
NextGenTemplates runs three ranges whose paving names look almost identical, so it is worth being blunt about which one this article is describing.
- KPI Dashboard (this one) – a month picker, a target-versus-actual scorecard, three-state traffic lights, a KPI Trend page and a KPI Definition page. Built for the monthly performance review.
- Dashboard – the analytical line, which slices revenue and volume by crew, job, region or period. Different job entirely; no targets, no traffic lights.
- KPI Scorecard – a lighter single-file build with its own shorter KPI list. Already live for paving in Excel and Google Sheets.
They complement each other rather than repeat, but if you only want one, the KPI Dashboard is the one that scores a month against target and keeps a prior year beside it.
The twelve KPIs, and why the list is shaped this way
The KPI list is not a generic construction set with “paving” written on top. Every one of the twelve is something an asphalt contractor already argues about at month end:
| KPI | Group | Unit | Direction |
|---|---|---|---|
| Asphalt Tons Placed | Production | Tons | Higher is better |
| Crew Productivity | Production | Sq Yd/Crew-Day | Higher is better |
| Mix Cost per Ton | Cost | USD/Ton | Lower is better |
| Gross Margin % | Financial | % | Higher is better |
| Bid Win Rate % | Commercial | % | Higher is better |
| Density Test Failures | Quality | Count | Lower is better |
| Rework Square Yards | Quality | Sq Yd | Lower is better |
| Customer Callbacks | Service | Count | Lower is better |
| Equipment Utilisation % | Equipment | % | Higher is better |
| Equipment Downtime Hours | Equipment | Hours | Lower is better |
| Days Sales Outstanding | Financial | Days | Lower is better |
| Recordable Incident Rate | Safety | Per 200k Hrs | Lower is better |
Five are higher-is-better and seven are lower-is-better, and that split is the reason the scoring works the way it does.
Direction-aware achievement: why beating a cost target scores above 100%
The usual failure of a homemade KPI sheet is that it divides actual by target for everything. Do that with Mix Cost per Ton and a good month looks like a bad one, because you spent less than budget.
This build tags every KPI as UTB (higher is better) or LTB (lower is better) in the data pack, and scores accordingly: UTB scores Actual / Target, LTB scores Target / Actual. In the shipped December 2025 sample, Mix Cost per Ton came in at $83.10 a ton against an $85.45 target and scores 102.8%. Density Test Failures came in at 12 against a tolerance of 15 and scores 125.0%. Both read as wins, because both are wins.
The traffic light is then a plain band: On Target at 100% or more, At Risk from 95% up to 100%, Missed below 95%.
Page 1 – KPI Scorecard
Five slicers run across the top – Month, KPI Group, Owner, Priority and Direction – and they are synced, so a selection here follows you to the other pages. Under them sit five summary cards: Total KPIs, MTD Target Met, MTD At Risk, MTD Target Missed and Achievement MTD. Each card carries its own 12-month trend bar and a month-on-month delta.
The scorecard table below reads, per KPI: KPI Name, KPI Group, Unit, a 12-month sparkline, Actual (MTD), Target (MTD), Achievement % (MTD), Status Light (MTD), YoY Arrow (MTD), Actual (YTD), Achievement % (YTD) and Status Light (YTD). Rows sort worst-first, so the conversation starts where it should.
The shipped December 2025 sample reads 12 KPIs, 6 met, 3 at risk, 3 missed, 99.9% achievement for the month. The three misses are Customer Callbacks (84.6%), Rework Square Yards (85.7%) and Bid Win Rate % (94.8%) – a service problem, a quality problem and a commercial problem, which is a realistic shape for a paving month.
The two-horizon trick
Printing MTD and YTD lights on the same row is the single most useful thing on the page, because a KPI cannot hide behind a good month. Gross Margin % in the sample is On Target for December at 104.3% but At Risk for the year at 97.9%. Days Sales Outstanding does the opposite: At Risk for the month at 97.7%, On Target for the year at 101.2%. One number, two verdicts, and both are worth knowing.
Page 2 – KPI Trend
Pick a KPI from the “Select KPI Name” list on the left and the whole page becomes that KPI. Six context cards name the selected KPI, its group, unit, direction, owner and priority. Five value cards give KPI Actual (MTD), KPI Target (MTD), KPI Achievement % (MTD), KPI Status (MTD) and KPI YoY % (MTD).
Then two line charts, three lines each – this year, last year, target: CY MTD vs PY MTD vs Target MTD by Month and CY YTD vs PY YTD vs Target YTD by Month. With Asphalt Tons Placed selected the cards read 3,992 actual against a 3,853 target, 103.6%, On Target, and a YoY of -2.8% – so a month that beat budget still placed less tonnage than the same month last year. That is exactly the kind of thing a single MTD number hides.
The prior-year line is real. The data pack carries two full years of actuals, 2024 and 2025, so every PY line and YoY arrow comes from typed history rather than an estimate.
Page 3 – KPI Definition
This is the page most KPI packs leave out. The same KPI selector is synced from the Trend page, and for whichever KPI is selected you get the formula and the plain-English definition. Asphalt Tons Placed reads “Sum of Mix Tons Placed”, defined as “Hot-mix asphalt tonnage placed and compacted across all active jobs”. Mix Cost per Ton reads “Total Mix Purchase Cost / Tons Delivered”, defined to include haul and fuel surcharge.
Say that out loud in a review and half the usual argument disappears – nobody relitigates whether the surcharge is in the number before the discussion starts.
Under the cards sits a Monthly Detail table for all twelve months with a total row, plus an MTD Actual vs Target by Month chart and an Achievement % by Month chart. For Asphalt Tons Placed the twelve rows run from 3,926 in January to 3,992 in December, with October the only At Risk month at 97.5%.
Page 4 – Get More Templates, plus two hidden tooltip pages
Page 4 is a short catalogue and customisation page. Behind the four visible pages sit two hidden tooltip pages, KPI Detail and Trend Detail, both 280×360, which surface on hover and never appear in the page tabs. There is no right-click drill-through in this report – worth saying plainly, because builds in this family vary.
The data pack, and how to make it yours
Data.xlsx has four sheets:
- Read Me – how the model works, including the rule that trips most people up: for a %, a Days figure, a USD-per-ton rate or an index, the YTD value is the average of the months so far, never a sum. A compliance percentage that adds up to 1,900% by December makes every YTD chart useless.
- KPI Definition – 12 rows, one per KPI: group, unit, formula, definition, Type (UTB/LTB), owner, priority.
- Input_ Target – 144 rows: 12 KPIs by 12 months, MTD and YTD.
- Input_ Actual – 288 rows, because it carries 2024 as well as 2025.
Nothing in the report hard-codes a KPI name. Add a row to KPI Definition plus its monthly Target and Actual rows to add a KPI; delete those rows to remove one; rename a KPI in all three sheets (the name is the join key) to rename it. Then Home > Refresh, and the counts, the scorecard, the selector list and every chart follow.
Setting it up
- Unzip all three files –
.pbix,Data.xlsx, user manual PDF – into one folder and keep them together. - Open the
.pbixin Power BI Desktop, free from Microsoft, Windows only. The sample data is already loaded, so look around first. - Before your first refresh: Home > Transform data > Data source settings > Change Source, and point it at your copy of
Data.xlsx. The path saved in the file is the folder it was built in. - Edit KPI Definition first, then Input_ Target, then Input_ Actual – the reporting year and the year before it.
- Home > Refresh. Pick a month on the KPI Scorecard, then a KPI on KPI Trend.
An owner and a priority on every row
Each of the twelve KPIs carries a named owner and a priority, so a missed light has somebody’s name against it. The sample ships seven ownership lines – Paving Operations, Estimating & Purchasing, Finance, Quality Control, Project Management, Equipment & Fleet and Safety & Compliance – at Critical (5 KPIs), High (5) or Medium (2). The Owner and Priority slicers then let a fleet manager pull the page down to the two equipment KPIs, or a director pull it down to the five Critical ones, without touching anything else.
What it does not do
Being clear about the boundaries saves refund emails:
- No live feed. No API, no gateway, no telematics, no weigh-bridge or plant-ticket connector, and no link to Sage, QuickBooks, Xero, Procore, HCSS, B2W or ServiceTitan. You type actuals into the workbook and refresh.
- No per-job drill-down. It is a company-level monthly scorecard; jobs, lifts and streets are not dimensions in the model.
- Not a QC or materials-testing system. Density Test Failures is a count you type in. There is no mix design, no acceptance limit, no DOT submittal.
- Not a safety management system. Recordable Incident Rate is a number you supply; there is no OSHA 300/300A recordkeeping, no work-zone or flagging compliance, no training records.
- No benchmarks. Every figure in the file, including all twelve targets, is sample data. There is no NAPA, Asphalt Institute or state DOT reference behind any number. Replace the targets before anyone treats a traffic light as meaningful.
More on this blog: Paving Contractor KPI Scorecard in Excel, HVAC Contractor KPI Dashboard in Excel and Drywall Contractor KPI Dashboard in Excel.
Frequently asked questions
Do I need a paid Power BI licence?
No. Power BI Desktop is free from Microsoft and opens, edits and refreshes the file; it runs on Windows only. A Pro or Premium seat is needed only if you publish the report to the Power BI Service to share it.
Can I use my own KPI list?
Yes – that is the design. Add, delete or rename KPIs in the three sheets and refresh. Nothing in the report is hard-coded to the twelve shipped.
Is there an Excel or Google Sheets version?
The lighter paving KPI Scorecard is live now in Excel and Google Sheets – close in name, different in build, its own KPI list. An Excel edition of this same KPI Dashboard is being prepared alongside this one and will appear in the KPI Dashboard category when it is listed.
What exactly is in the download?
One ZIP with the .pbix report, Data.xlsx and a Power BI Dashboard user manual PDF. One-time payment, lifetime access to the file.
Get the template
The Paving Contractor KPI Dashboard in Power BI is $12.99 (regular $19.99), a one-time payment with no subscription: get it on NextGenTemplates.com.
Same build, other trades: Drywall, Masonry, Painting, Flooring Installation, Electrical, HVAC, Carpentry Workshop and Welding Shop KPI Dashboards in Power BI.
Written by PK – Microsoft Certified Professional, 15+ years in Excel, Google Sheets and Power BI, founder of NextGenTemplates. Last updated 2 September 2026.
