Technician Productivity & Utilization Dashboard
Turn raw time entries and completed-job logs into clear per-technician utilization and productivity numbers - billable vs paid hours, jobs per day, travel time - with a manager approval gate before any figure is used in a review or pay decision.
A private, login-protected dashboard that converts time and job data into fair, trended per-technician utilization and productivity metrics, locks a manager-approved snapshot per period, and exports a clean CSV for payroll or reviews.
Before you start
- A free Supabase account
- A free Vercel account
- A free Resend account
- A spreadsheet or CSV export of time entries and completed jobs
The problem this kills
You are supposed to coach your technicians fairly, balance the workload, and sign off on the numbers that feed reviews and pay. But the data lives in three places: a time-tracking sheet, a completed-jobs export, and a revenue report. Stitching them together by hand at the end of every period is slow, error-prone, and easy to argue with.
So one tech looks "slow" because their travel time is buried in their clock, another looks like a superstar because nobody netted out idle hours, and a part-timer gets compared head-to-head with a 40-hour tech. You end up making coaching and pay calls on numbers you are not fully sure about - and the techs can feel it.
This tool gives you one honest, defensible scoreboard. It defines billable vs non-billable on your terms, normalizes for PTO and part-time, shows the trend so a bad week does not become a verdict, and makes a manager approve the figures before anyone uses them.
What you'll build
A small, private web app for your service team:
- Import time entries (billable, travel, idle) and completed jobs - from a CSV or Google Sheet, with a clean path to your field-service system later.
- Per-technician metrics for any period: billable hours, paid hours, utilization %, jobs completed per day, average travel time, and revenue per billable hour.
- A normalization layer so PTO and part-time schedules do not distort utilization.
- Trend charts so you see direction, not just a single number.
- A manager approval gate: nothing becomes an "official" figure for reviews or pay until a manager reviews and approves the period snapshot.
- A CSV export in the exact columns your payroll or review process expects.
What's inside the Implementation Plan
The plan opens by interviewing you about your business - how you track time, what you count as billable, how PTO and part-time work, your typical and peak volumes, and your messy edge cases. It reads a short tailored spec back to you and waits for your thumbs-up. Everything it builds after that is shaped to your answers, not a generic template.
Then it walks you, step by step, through building the whole tool by pasting prompts into an AI coding agent. Every step ends with a ready-to-copy prompt. You do not write code - you direct the agent and confirm the results.
The governance it includes (this is the point)
- Login so only your team can open the dashboard.
- Row-level security so each company only ever sees its own data.
- A complete audit trail: who imported what, who approved which period, and when.
- A hard human-in-the-loop approval gate: the tool computes draft figures, a manager reviews and approves, and only an approved snapshot can be exported or used in a pay or review decision.
- Duplicate guards so the same tech-and-period cannot be imported or approved twice.
Who it's for
Service managers, dispatch supervisors, and field-service business owners who want to coach technicians fairly and make defensible workload and pay decisions - without a data analyst and without buying yet another platform.
You've got this - paste the first prompt and let the agent interview you.