Which hours belong in the three fields?
Use available paid hours for the period, actual hours punched to jobs and labor hours billed on repair orders. Start with one technician and one completed pay period, then reconcile the same dates across payroll and the shop system. If a Friday job is invoiced Monday, you may need a longer period or a cutoff reconciliation to avoid treating timing as poor performance.
Definitions vary between software vendors and shops. One dashboard might call billed hours divided by paid hours productivity, while another treats it as overall proficiency. This calculator follows the distinction in the AutoZone shop KPI handbook. It compares billed time with actual job time for efficiency, and actual job time with available time for productivity. Preserve those denominators alongside any report you give a buyer.
How does a pay plan change cost per billed hour?
An hourly plan starts from available paid hours times the rate. A flat-rate plan starts from billed hours times the applicable rate. In both cases, the calculator uses the larger of the calculated pay and the period guarantee. A salaried example starts from the salary entered for that pay period. Add supplemental compensation, including applicable overtime premium, before multiplying by the payroll burden.
The worksheet estimates cost from inputs you supply. It cannot decide what pay a worker is legally owed under local rules or what payroll taxes apply. Reconcile the output to the actual register and benefit invoices. Avoid counting the same overtime twice when your supplemental figure already includes base wages. Use the technician roster and pay-plan tracker to document the pay basis and any written guarantees.
What do the operating ratios look like in a real workweek?
Illustrative composite — not a real client. A technician has forty available hours, clocks thirty to repair work and bills thirty-six. Productivity is 30 ÷ 40 = 75%. Efficiency is 36 ÷ 30 = 120%. A flat rate of $25 yields $900, which exceeds an illustrative $800 guarantee. Another $100 of compensation brings direct pay to $1,000. With a 10% payroll burden the loaded amount is $1,100, or about $30.56 per billed hour.
Those two percentages point to different questions. The person completed the billed work effectively during job time, but ten available hours went elsewhere. Look for a bottleneck in authorization, parts staging, bay access or dispatch. Some time may support training, safety checks or a second technician on a complex diagnosis. A payroll change will not fix a missing part or an unavailable lift.
How should you compare results with an industry survey?
Use the published survey distribution as a reference group. In its 2025 Industry Survey, Ratchet+Wrench reported that 30% of respondents placed technician efficiency in the 80–99% band and 26% placed productivity in the 80–89% band. These are shares of responding shops in particular bands. They are not universal standards or estimates of what your next hire will produce.
- Reconcile available hours to payroll and job punches to technician assignments.
- Match billed time to closed work and check for unpaid diagnostic or warranty labor.
- Review hours and loaded payroll over more than one pay cycle.
- Ask how the service mix, shop equipment and shift schedule explain the result.
If you are buying, review the technician diligence guide and compare the roster with retention plans. If you are selling, the owner-technician impact calculator helps you replace owner labor without assuming every paid hour is billed. A bay capacity check can then show whether another person would have a place to do the work.
What should a buyer check before comparing two technicians?
Start with the work assigned. A diagnostic lead who spends much of the week guiding apprentices can have weaker billed hours while protecting the whole shop from comebacks. A technician assigned repeatable maintenance jobs may bill more efficiently without the same customer or technical responsibility. Compare similar service categories and mark training, warranty and internal work separately.
Then look at how time is recorded. Missing clock-out events can inflate job time, while group assignments may credit all billed labor to a lead. Review a sample of completed tickets and ask the shop manager to explain how shared work is allocated. If no one knows which person completed which stage, the percentages cannot support a retention or hiring decision on their own.
Track changes in guarantees and pay plans across the year. A recent raise that has not yet run through a full reporting period can make the seller’s most recent earnings look stronger than the buyer’s likely cost. Rebuild the payroll schedule at current terms and document future commitments the buyer expects to keep. If a key technician plans to leave after closing, add the realistic vacancy, recruitment and training costs to a separate operating case.
When a monthly payroll report crosses several pay periods, allocate both wages and hours consistently. A bonus paid in one period for work completed earlier can distort a weekly comparison. Record both the cash payment date and the operating period so your buyer can reproduce the annual economics.
How does the same repair week look under two pay plans?
Use forty available hours, thirty-two clocked job hours and thirty-six billed hours for one technician. Efficiency is 112.5 percent because thirty-six billed hours were produced in thirty-two job hours. Productivity is eighty percent because thirty-two of the forty available hours were spent on recorded jobs. Under an hourly plan at $30 per paid hour, assume no minimum guarantee beyond base pay, a $100 bonus for the week and a twenty percent employer burden. Gross payroll before burden is $1,300. Loaded payroll totals $1,560, giving a loaded cost of $43.33 per billed hour.
Change only the plan to flat rate at $34 per billed hour, with a $1,150 weekly guarantee. Retain the $100 bonus and twenty percent burden. Thirty-six billed hours at $34 earn $1,224, which exceeds the guarantee. Loaded payroll is $1,588.80, or approximately $44.13 per billed hour. The operating ratios have not changed because the technician performed the same work in both scenarios. Read the pay comparison alongside what the actual employment agreement says about overtime, minimums, paid leave and bonuses. This worksheet’s plan options are economic scenarios; the terms your payroll provider must apply depend on the actual arrangement.
What happens in a low-volume week with a guarantee?
Leave available hours at forty and clocked job hours at thirty-two, but reduce billed hours to twenty-four in the flat-rate scenario. The proposed hours would earn only $816 at the stated rate, so the $1,150 guarantee controls. With the same bonus and burden, loaded pay becomes $1,500. Dividing by twenty-four hours produces $62.50 per billed hour. Efficiency drops to seventy-five percent, while productivity remains eighty percent. A slowdown in sold hours can move cost sharply even when hours spent working in the bay stay constant. Examine the unsold work before attributing the change to technician performance.
For example, your service writer may have billed a fixed diagnostic fee that covered only part of a difficult electrical investigation. The technician could have recorded every clocked hour correctly. A warranty comeback can use paid time without creating new billed hours, and an internally completed used-car inspection may be coded to a different department. Follow individual lines from open order to final invoice. An agreement to bill the fleet later can shift revenue into the next week even if all work was completed Friday. Reconcile the date basis before comparing two technicians on a leaderboard.
Which denominator should you use for a salaried lead technician?
Use the same time period for salary, bonus, available hours and billed work. Set salary or guarantee to the amount applicable to that period when you choose the fixed-pay plan. A lead technician who spends paid time training an apprentice may have lower job-time productivity while improving another employee’s output. Mark training time separately and explain which paid hours remain in the denominator. Removing training time only for the lead employee while leaving every apprentice hour in a team comparison can conceal the real cost of producing the work.
If no job hours were clocked, efficiency cannot be computed. If no hours were billed, the loaded cost per billed hour cannot be computed either, even when you owe full weekly pay. Preserve those unavailable results and investigate the period. Substituting one invented hour gives a dramatic number that cannot be reconciled with payroll or invoices. If clocked job time exceeds available hours, check whether overtime was omitted or two overlapping jobs were clocked simultaneously before editing a field just to clear the input error.
How can you translate the numbers into a decision about staffing or price?
Show the technician’s labor categories, warranty time, diagnostic complexity and sublet activity next to the ratios. Compare weeks with similar available hours and workloads. A technician assigned difficult programming cases can have a very different mix from a colleague doing scheduled maintenance. Ask who controls dispatch, whether the correct tooling is present, and whether estimates include adequate diagnostic time. You can then distinguish the part of your cost problem that comes from selling hours from the part that comes from payroll structure.
Finally, compare loaded cost per billed hour with the effective labor rate you actually collect. Use labor sales net of discounts divided by billed hours for the same tickets. That difference still has to support service writers, occupancy, software, tools, administration and profit. A buyer planning to lift posted rates should investigate how existing fleet contracts price labor and whether customer demand supports the change. An observed gap between the posted rate and collected rate can make a larger difference to the deal than a small change in weekly bonus design.