# Machine Hour Rate Worksheet

> Source: https://netray.co/tools/job-shop-machine-hour-rate-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Editable worksheet that converts machine price, life, hours, power draw and maintenance into a cost per run hour for each machine.

## Category

cost-finance

## Industry

Machine Shops

## Audience

- Estimator
- Shop owner
- Controller

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Machine

**Key:** machine

**Type:** text

#### Purchase price

**Key:** price

**Type:** number

**Format:** currency

#### Depreciation life

**Key:** life

**Type:** number

**Unit:** years

#### Productive hours per year

**Key:** hours

**Type:** number

**Unit:** hours

#### Average power draw

**Key:** kw

**Type:** number

**Unit:** kW

#### Electricity rate

**Key:** kwh_rate

**Type:** number

**Format:** currency

**Unit:** per kWh

#### Maintenance and tooling per year

**Key:** maint

**Type:** number

**Format:** currency

#### Depreciation per hour

**Key:** dep_hr

**Type:** number

**Expr:** price / life / hours

**Format:** currency

#### Power per hour

**Key:** power_hr

**Type:** number

**Expr:** kw * kwh_rate

**Format:** currency

#### Maintenance per hour

**Key:** maint_hr

**Type:** number

**Expr:** maint / hours

**Format:** currency

#### Machine cost per hour

**Key:** rate

**Type:** number

**Expr:** price / life / hours + kw * kwh_rate + maint / hours

**Format:** currency

**Rows:**

**Machine:** VMC 40x20 (3-axis)

**Price:** 95000

**Life:** 10

**Hours:** 3200

**Kw:** 8

**Kwh rate:** 0.12

**Maint:** 6500

**Machine:** CNC lathe with bar feeder

**Price:** 140000

**Life:** 10

**Hours:** 3400

**Kw:** 11

**Kwh rate:** 0.12

**Maint:** 8000

**Machine:** 5-axis VMC

**Price:** 320000

**Life:** 10

**Hours:** 2800

**Kw:** 15

**Kwh rate:** 0.12

**Maint:** 14000

**Machine:** Manual mill

**Price:** 18000

**Life:** 15

**Hours:** 1200

**Kw:** 2

**Kwh rate:** 0.12

**Maint:** 800

**Summary:**

#### Average machine cost per hour

**Key:** avg_rate

**Expr:** sum_rate / count

**Format:** currency

**Primary:** true

#### Highest machine rate

**Key:** max_rate

**Expr:** max_rate

**Format:** currency

**Notes:** This covers direct machine cost only. Add operator labor, floor space, insurance, software and overhead separately to arrive at a full shop rate. Use productive hours, not calendar hours.

## Content

**Intro:** A single blended shop rate hides the fact that a five-axis machine costs far more per hour to run than a manual mill. This worksheet builds a machine-specific cost from purchase price, depreciation life, power, maintenance and the hours you can really sell.

**Sections:**

#### How to use the worksheet

**Body:** List each machine and enter its purchase price, depreciation life, expected productive hours per year, average power draw and annual maintenance and tooling spend. The sheet calculates depreciation, power and maintenance per hour and adds them into a machine cost per hour. Edit the sample rows, export to Excel and add labor and overhead on top to reach the rate you quote.

#### The formula

**Body:** Machine cost per hour equals purchase price divided by life in years divided by productive hours per year, plus kilowatts times the electricity rate, plus annual maintenance divided by productive hours. The key input is productive hours. A machine that runs 1,600 spindle hours in a year costs twice as much per hour as the same machine running 3,200, so be honest about utilization.

**Bullets:**

- Use productive hours, not 2,080 paid hours
- Use realistic average kW, not the nameplate maximum
- Include tooling and wear parts in maintenance
- Revisit the sheet when you add shifts or machines

#### Reading the result

**Body:** Compare machine rates against what you charge. If a 5-axis machine costs a few times more per hour to run than a 3-axis VMC but you quote both at the same rate, parts that need the 5-axis are underpriced. Utilization is the lever: the same machine at higher hours has a lower rate, which is why filling the schedule matters.

#### Using it with your ERP

**Body:** JobBOSS, E2 Shop System, Global Shop Solutions and ProShop all let you set a rate per work center. Enter the machine cost plus labor and burden as the work center rate so routings and quotes pick it up. Review it when the work center cost actuals drift from the quote assumptions.

**Cta:** If you want work center cost actuals compared with your quoted rates automatically, Netray can help build that view from your ERP.

**Faq:**

#### Is this my full shop rate?

**Answer:** No. It is the machine cost per hour only. A shop rate also includes operator labor and benefits, floor space, insurance, software, supervision and general overhead. Add those to get the number you use to price a job.

#### What depreciation life should I use?

**Answer:** Use your accounting policy or the realistic useful life of the machine, commonly 7 to 15 years for CNC equipment. Some shops use replacement cost instead of purchase price to avoid under-recovering for inflation.

#### How do I pick productive hours?

**Answer:** Estimate hours the spindle is actually cutting and billable, after setup, downtime and idle time. Pull actuals from your ERP or machine monitoring if you have it. Many shops find the real number is well below shifts times days.

#### Can I add rows for more machines?

**Answer:** Yes. Add as many rows as you need, then export. Totals and the average update automatically.

## Search terms

machine hour rate calculator, cnc machine hourly rate worksheet, shop rate calculation excel, machine shop hourly rate, cost per machine hour, machine burden rate, job shop estimating rates

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json