Shop rate calculator for trade shops and machine shops

Enter your techs, their billable time and your yearly overhead, and get the break-even rate, the rate to charge and a separate hourly rate for each machine.

Free tool · Contractors · Excel · Updated

1Start from a shop like yours

Example numbers. Replace them with your payroll, timesheets and last year's P&L.

2Your shop rate

Rate to charge per hour
$118.23
Break-even per hour
$100.49
Overhead per billable hour
$37.64
Each point of billable % lost
$1.71/hr

Dividing by all 10,400 paid hours gives $70.35 an hour. Your techs bill 7,280 of them (70.0%), so every billed hour has to cover $100.49.

Change any number below and the rate updates.

3Your techs and their billable time

Tech group 1
Tech group 2

Cost per paid hour is the wage plus payroll taxes, comp and benefits. Get it from the labor burden calculator. Billable is hours billed to customers as a share of hours paid. Flat-rate shops can go over 100%.

4Your yearly overhead

Overhead item 1
Overhead item 2
Overhead item 3
Overhead item 4
Overhead item 5
Overhead item 6
Overhead item 7
Overhead item 8

Leave out tech wages from step 3 and machine costs from step 5. Total overhead: $274,000 a year.

5Machines billed by the hour (optional)

Machine 1
Machine 2
Machine 3

6Your profit target

%

Profit as a share of the rate you charge.

7Where the rate comes from

LinePer billable hourPer year
Labor cost$62.86$457,600
Overhead$37.64$274,000
Break-even$100.49$731,600
Profit at 15% margin$17.73$129,106
Rate to charge$118.23$860,706

8Machine hour rates

MachineDepreciationUpkeep and spacePowerCost per run hourMachine ratePlus shop rate
CNC vertical mill$4.00$2.93$2.10$9.03$10.63$128.86
CNC lathe$3.60$2.64$1.68$7.92$9.32$127.55
Manual mill$1.33$3.20$0.42$4.95$5.83$124.06

Machine rate includes your profit margin. “Plus shop rate” is the hourly price when one person runs one machine.

9How billable time moves your rate

Billable changeBillable shareBillable hoursBreak-evenRate to chargeChange
−10 points60.0%6,240$117.24$137.93+$19.70
−5 points65.0%6,760$108.22$127.32+$9.09
−2 points68.0%7,072$103.45$121.71+$3.48
−1 point69.0%7,176$101.95$119.94+$1.71
Your numbers70.0%7,280$100.49$118.23–
+1 point71.0%7,384$99.08$116.56−$1.67
+2 points72.0%7,488$97.70$114.94−$3.28
+5 points75.0%7,800$93.79$110.35−$7.88
+10 points80.0%8,320$87.93$103.45−$14.78
Your numbers stay in this browser. Nothing is uploaded.

Want this done on your whole Excel? We fix quotes priced from a shop rate in a spreadsheet nobody has checked against real hours on your real data, tested with you.

Walk us through your quoting sheet

How do you calculate shop rate?

Add a year of labor cost and overhead, divide by the hours you bill, then add your profit margin.

Break-even rate = (labor cost + overhead) ÷ billable hours

Shop rate = break-even rate ÷ (1 − profit margin)

Example: 3 techs cost 40 dollars per paid hour each, for 2,080 hours a year, and bill 70% of those hours. That is 4,368 billable hours and 249,600 dollars of labor. With 150,000 dollars of overhead, the break-even rate is 91.48 dollars. At a 15% margin, the shop rate is 107.63 dollars.

Cost per paid hour is the wage plus payroll taxes, comp and benefits. The labor burden calculator works it out for each tech.

How do you find your break-even hourly rate?

Divide everything the shop spends in a year by the hours customers pay for, never by the hours you pay for.

Freelancer calculators divide by all 2,080 paid hours. Your techs also spend paid time driving, cleaning up, on callbacks and in training. Federal rules count travel from job site to job site during the workday as hours worked (29 CFR 785.38), so you pay for it even when you can’t bill it.

Example: the shop above spends 399,600 dollars a year. Divided by 6,240 paid hours, that looks like 64.04 dollars an hour. Divided by the 4,368 hours it bills, break-even is 91.48 dollars.

What goes into shop overhead?

Every cost you can’t put on one job: rent, office and owner salaries, insurance, trucks, software, marketing, utilities and accounting.

Federal contract cost rules group these indirect costs and spread them over one base shared by all the work (48 CFR 31.203). In a shop, that base is billable hours.

  • Overhead per billable hour = yearly overhead ÷ billable hours
  • Leave out tech wages, which are already in labor cost.
  • Leave out machine costs you price by the machine hour.

Example: 150,000 dollars of overhead over 4,368 billable hours is 34.34 dollars of overhead in every hour you bill.

Paste last year’s P&L into step 4 and it keeps the expense lines. See the overhead and profit calculator to turn them into a markup.

How do you calculate a machine shop rate?

Price each machine on its own and add it to the labor rate for the hours it runs.

Machine cost per hour = ((price − resale) ÷ years + maintenance + floor space cost) ÷ run hours a year + kW × electric rate

The first part is straight-line depreciation, the same amount each year over the machine’s useful life, as IRS Publication 946 describes it. Use the years you expect to run the machine, which can differ from the tax schedule.

Example: a 150,000-dollar CNC mill resold for 30,000 after 10 years, running 2,500 hours a year. Depreciation is 4.80 dollars an hour. Maintenance of 5,000 dollars and 200 square feet at 14 dollars add 3.12. Power at 15 kW and 14 cents adds 2.10. It costs 10.02 dollars a run hour, or 11.79 with a 15% margin.

For trucks and heavy equipment, use the equipment hourly rate calculator.

How does billable percent change your shop rate?

Fewer billable hours spread the same costs thinner, so the rate goes up.

Example: the 3-tech shop needs 107.63 dollars an hour at 70% billable. At 65% it needs 115.91 dollars; at 75% it needs 100.45. Dropping from 70% to 69% alone adds 1.56 dollars to every hour.

Billable percent = hours billed ÷ hours paid. Get both from last year’s invoices and payroll. The table under the calculator shows your rate from 10 points below to 10 points above.

Questions

Does the owner go in labor or overhead?

If you bill your own hours, add yourself as a tech group. If you run the business and rarely bill, put your salary in overhead.

Why does a 15% profit add more than 15% to break-even?

The calculator sets profit as a share of the price, so it divides by 0.85 instead of multiplying by 1.15. A 15% markup on break-even would leave only a 13% margin.

Do I charge machine time and labor time separately?

Either works. The “Plus shop rate” column gives the single hourly rate when one person runs one machine.

Can I paste my numbers from Excel?

Yes. Copy the cells in Excel or Google Sheets and paste them into any step, or load a CSV. Your numbers stay in this browser.

Sources

Lines of light running into one large blue period

Walk us through one problem.

We’ll tell you what we’d fix first.

Walk us through one problem

Free. 30 minutes. A one-page note within two business days.