KPI Dashboard
Input
Formula
Attention
Alert
Budget ($)
$0
Current Cost ($) lifetime
$0
% Budget Used lifetime
0%
Billed to Date ($) lifetime
$0
Acceptance Rate
--
NCR Closure Rate
--
Documentation Errors
--
Productivity Rate
--
Schedule Variance
--
Burn Rate ($/Active Day)
--
Invoice Utilization
--
85% Notice
Not Yet
KPI Targets vs Actuals
| KPI | Target | Actual | Status |
|---|---|---|---|
| Acceptance Rate | 98% | -- | -- |
| NCR Closure Rate | 95% | -- | -- |
| Documentation Errors | 0 | -- | -- |
| Productivity Rate | 1.00 | -- | -- |
| Schedule Variance | 0% | -- | -- |
| Invoice Utilization | 85% | -- | -- |
Project Summary
| Project | Status | Current Cost | % Budget Used | Billed | % WO/PO Used |
|---|
Mileage Summary selected period
| Project | Total Miles | Mileage ($) |
|---|
| Employee | Total Miles | Mileage ($) |
|---|
Projects
Add project names here first; other tabs use this list for dropdowns and summaries.
| Project Name | AFE # | Project Manager | Contract | Start Date | End Date | Budget ($) | Current Cost ($) | % Budget Used | % Complete | WO/PO Value ($) | Billed to Date ($) | % WO/PO Used | Status |
|---|
Employees
Roster of inspectors and crew. Set the title once here, day rate is looked up from the classification rate table, and the title carries over to Quality Metrics, Cost Tracking, and Supplemental.
Contracts
MSAs and per-classification day rates by customer. Each contract has its own rate set; projects bind to a contract, and Cost Tracking resolves a day rate by looking up the project's contract first, then falling back to the legacy rate table.
Quality Metrics
Add an entry for an inspector, then add daily entries under them. Rolling averages update automatically.