LaborRateAnalysis

Pull to refresh

Labor Analysis

Calculated directly from the invoices, time entries and shop settings

17hats line categories

Checks every imported 17hats invoice line and re-tags the ones tagged Labor that aren't labor — by their description. Preview first; nothing is written until you apply.

Source2026-01-01 → 2026-11-17

Labor Analysis · 2026-01-01 to 2026-11-17

The headline numbers for the dates and source you picked. Service revenue is what the shop billed for its time; billable % is how much of the paid shop time ended up on an invoice; labor gross margin is what's left of labor revenue after paying the shop staff. Look for: red tiles — they're below the targets you set in Shop targets. The small gray line under each number says how it's worked out.

Service Revenue

Not enough data

No invoice lines in this date range

Labor — + diagnostic & service jobs $0.00

Trip / Delivery Revenue

Not enough data

No trip/delivery lines in this range

Trip charges & delivery fees

Billed Labor Hours

Not enough data

No billed labor hours in this range

Hourly labor lines only

Effective Labor Rate

Not enough data

No billed labor hours in this range

Labor $ ÷ billed hours (after discounts)

Billable %

Not enough data

No shop staff set up in Shop Settings

Billed ÷ paid shop hours (—) · Target 45%

Shop Labor Cost

Not enough data

No shop staff set up in Shop Settings

Loaded pay × shop share

Cost per Billed Hour

Not enough data

No shop staff set up in Shop Settings

Shop pay + overhead ÷ billed hours — the same as break-even

Labor Gross Margin %

Not enough data

No shop staff set up in Shop Settings

Labor lines vs tech pay only (no overhead) · Target 65% · Incl. diagnostic & service jobs: —

Delivery/Rental Labor Cost

Not enough data

No shop staff set up in Shop Settings

Loaded pay × delivery + rental share

Parts Margin %

Not enough data

No parts sales in this range

Same figure as the Parts section below

Should we charge more?

Whether your labor rate covers what the shop costs to run. Every tile is a rate per billed hour. The two break-even boxes work from all of the shop's costs — tech pay plus overhead — because they answer "do I cover everything". The margin box works from tech pay only, the standard way shops measure labor gross margin. Green means what you actually collect per hour covers it, red means it doesn't. Raise the hours slider to see every box at a higher volume — the shop's cost doesn't move, so the rate each hour must carry does. Look for: red tiles. If your effective rate is under break-even, each billed hour loses money. Then use the sliders to compare charging more against billing more hours.

Shop overhead isn't set, so break-even only covers tech pay — not rent, insurance, tools or the truck. Add your costs on the Shop Budget page.

Labor margin target:%of labor revenue over tech pay — no overhead. Saved in shop settings.

Current Rate

Not enough data — Set it on the Shop Budget page

What you post and quote

The price you charge per hour before any discount.

Effective Rate

Not enough data — No billed labor hours in this range

labor sold — ÷ —

What you actually collected per billed labor hour, after discounts.

Break-even (labor lines only)

Not enough data — No shop staff set up in Shop Settings

(shop pay — + overhead $0) ÷ —

Every billed hour has to bring in this much to pay shop techs and overhead, counting nothing from diagnostic or job fees.

Break-even after fees

Not enough data — No shop staff set up in Shop Settings

(shop pay + overhead − $0.00 diagnostic & job fees) ÷ —

Diagnostic fees and flat-rate jobs already paid for that tech time, so labor only has to cover what's left.

Rate for 65% labor margin

Not enough data — No shop staff set up in Shop Settings

tech pay — ÷ — = —/hr tech cost; ÷ (1 − 65%)

Standard shop measure: only technician wages plus payroll taxes and benefits for shop time — not overhead. 35¢ of each labor dollar pays the techs, 65¢ is margin. Overhead is covered by the two break-even boxes.

Rate change: +$10.00/hr

Extra revenue year to date at the hours you billed (—)

Not enough data — no billed hours

Almost all profit — same work, higher price. Assumes no customers leave.

Added billed hours: +0 hrs year to date— total

Now: — billed year to dateTotal hours above = billed so far + hours added

Shop capacity year to date: 2977 hrs (2 techs × 6.5 hrs/day × 229 workdays). Already at capacity.

Extra revenue year to date at the current rate (—)

Not enough data — current rate not set

Move the slider to see the effect of billing more of the hours you already pay for.

Internal Labor Cost by Department

What shop time spent on your own carts costs you — prepping carts for sale, fixing rental carts, shop upkeep. It never shows on a customer invoice, so it's easy to forget. Look for: departments where this is large. Add it to the cost of cart sales or rentals when you judge whether they make money.

Not enough data. No time logged on internal work orders in this range.

Service Department P&L

Did the service department make money in these dates? Everything it billed for labor, fees and trips, plus the profit on parts, minus what you paid the shop staff. Look for: a red bottom line, or a thin one — this is before rent, insurance and other overhead, so it needs to be comfortably positive.

Labor revenue$0.00
Diagnostic revenue$0.00
Service job revenue (flat rate)$0.00
Trip / delivery revenue$0.00
Parts gross profit$0.00
− Shop labor costNot enough data
Service gross profitNot enough data

Trip / delivery revenue is shown before delivery-driver pay (see Delivery/Rental Labor Cost).

Parts

How much you make on the parts you sell. Margin is the share of the sale price you keep (a $100 part that cost $60 is 40% margin). Markup is how much you added on top of cost (the same part is a 67% markup). 17hats history has no part costs, so those are estimated from the assumed markup at the bottom of this section. Look for: margin dropping below about 30–35% overall, and a low % Revenue on Actual Cost — that means most figures here are estimates, not real costs.

Parts Sales

Not enough data

No parts sales in this range

Parts Cost

Not enough data

No parts sales in this range

Actual + estimated

Parts Gross Profit

Not enough data

No parts sales in this range

Margin % (GP ÷ sales)

Not enough data

No parts sales in this range

Markup % (GP ÷ cost)

Not enough data

No parts sales in this range

% Revenue on Actual Cost

Not enough data

No parts sales in this range

Rest is estimated

Battery parts

Parts Sales

Not enough data

No parts sales in this range

Parts Cost

Not enough data

No parts sales in this range

Actual + estimated

Parts Gross Profit

Not enough data

No parts sales in this range

Margin % (GP ÷ sales)

Not enough data

No parts sales in this range

Markup % (GP ÷ cost)

Not enough data

No parts sales in this range

% Revenue on Actual Cost

Not enough data

No parts sales in this range

Rest is estimated

General parts

Parts Sales

Not enough data

No parts sales in this range

Parts Cost

Not enough data

No parts sales in this range

Actual + estimated

Parts Gross Profit

Not enough data

No parts sales in this range

Margin % (GP ÷ sales)

Not enough data

No parts sales in this range

Markup % (GP ÷ cost)

Not enough data

No parts sales in this range

% Revenue on Actual Cost

Not enough data

No parts sales in this range

Rest is estimated

Gross margin by category · past 12 months

How much you keep on each type of part over the past 12 months (this one ignores the date range above). Uses real cost where it's recorded, otherwise an estimate. Look for: short bars on part types you sell a lot of — that's where a price check pays off. The % actual cost tells you how much to trust each bar.

Not enough data

Top 20 Parts by Revenue

Your 20 biggest-selling parts by dollars. Estimated means there's no real cost on file, so the margin is a guess. Look for: estimated rows near the top — check those against your supplier's current price first, because they move the most money.

No parts sales in this range.

Low-Margin Alert

Parts sold for less than 20% margin where the real cost is known — these are probably priced too low or were sold at cost. Look for: the same part showing up repeatedly; it likely needs a new price in the catalog.

No low-margin lines with actual cost.

Assumed Markup (for estimated costs)

Only used to guess the cost of parts that have no cost recorded (most 17hats history). Set it to your typical markup for each group. Look for: keep these close to reality — if they're too high, every estimated margin above looks better than it is.

Where Shop Hours Go

Every hour you paid shop staff for, split four ways: billed to a customer, clocked on a job but never billed, spent on your own carts (internal), and not tracked at all. Look for: a big gray Untracked slice — that's paid time nobody can account for, usually because techs aren't clocking in. Green is the only part that earns money.

Paid shop hours: 0.0 hrs

Not enough data. Set staff hours per week in Shop Settings.

Billed Hours & Effective Rate

Blue bars are labor hours billed each month; the orange line is the average you actually collected per hour. Look for: busy months vs. slow ones (plan staffing and promotions around them), and a dropping orange line — that means more discounts or half-rate work crept in.

Billed hoursEffective rate

Not enough data — no billed hours in this range

Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov

Revenue by Category

Where each month's money came from: labor, diagnostic fees, flat-rate service jobs, trip fees, parts, rentals and cart sales. Look for: how much of the business is service versus parts and sales. Parts and cart sales bring in big dollars but keep less of each dollar than labor does.

LaborDiagnosticService jobsTripPartsRentalCart Sales

Not enough data — no revenue in this range

Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov

Per-Technician Breakdown

How each tech's paid time turns into billed time. Productivity = share of paid hours clocked on jobs. Efficiency = billed hours ÷ clocked hours (over 100% means they beat the time you charged). Cost includes payroll taxes and benefits. 17hats history has no tech names, so it shows as Unassigned. Look for: low productivity (time not on jobs) versus low efficiency (time on jobs that didn't get billed) — they need different fixes. Needs techs clocking in on FleetCare work orders.

Cost and profit per tech are visible to the owner only.

Not enough data. Add staff with a shop tech share in Shop Settings.

Labor by Customer

Who you do the most labor for, and the average rate each one really pays. Click a column to sort. Look for: big customers with an Avg Rate under your posted rate — they're getting discounts or half-rate hours, which is worth knowing before you renew or quote them.

Not enough data — no labor lines in this range

Discounted Labor

Every labor line billed below your current rate, and what that cost you compared with full price. Look for: discounts you didn't mean to give. Deliberate deals are fine; the same customer showing up again and again is worth a conversation.

Not enough data — Current labor rate not set (Shop Budget & Targets page)

Unbilled Time

Jobs where techs clocked more hours than ended up on the invoice, biggest gap first. That's time you paid for and didn't charge. Look for: the top few rows — either the job was quoted too low or hours were left off the invoice. Only works once techs clock in on FleetCare work orders.

Not enough data — no time entries yet

AI Summary (optional)

A few sentences reading this page back to you in plain English. Written only from the numbers on this page — it can't see anything else.

Shop targets & overhead

Rate not set · margin target 65% · billable target 45% · no overhead lines yet