# Machine Hour Rate Build-Up Worksheet

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

## Short answer

Calculate a fully loaded machine hour rate per machine from depreciation, power, maintenance, tooling and floor space.

## Category

cost-finance

## Industry

Discrete Manufacturing

## Audience

- Cost accountant
- Estimator
- Controller

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Machine

**Key:** machine

**Type:** text

#### Installed cost

**Key:** price

**Type:** number

**Format:** currency

#### Salvage value

**Key:** salvage

**Type:** number

**Format:** currency

#### Useful life

**Key:** life

**Type:** number

**Unit:** years

#### Productive hours / year

**Key:** hours

**Type:** number

**Unit:** hours

#### Average power draw

**Key:** kw

**Type:** number

**Unit:** kW

#### Power cost per kWh

**Key:** kwh_cost

**Type:** number

**Format:** currency

#### Maintenance / year

**Key:** maint

**Type:** number

**Format:** currency

#### Floor space cost / year

**Key:** space

**Type:** number

**Format:** currency

#### Tooling and consumables / hour

**Key:** tooling_hr

**Type:** number

**Format:** currency

#### Depreciation / hour

**Key:** dep_hr

**Type:** number

**Expr:** (price - salvage) / life / hours

**Format:** currency

#### Machine hour rate

**Key:** rate

**Type:** number

**Expr:** (price - salvage) / life / hours + kw * kwh_cost + (maint + space) / hours + tooling_hr

**Format:** currency

**Rows:**

**Machine:** 3-axis VMC

**Price:** 140000

**Salvage:** 20000

**Life:** 10

**Hours:** 3600

**Kw:** 12

**Kwh cost:** 0.14

**Maint:** 7500

**Space:** 6000

**Tooling hr:** 4.5

**Machine:** 5-axis machining center

**Price:** 480000

**Salvage:** 70000

**Life:** 12

**Hours:** 3400

**Kw:** 25

**Kwh cost:** 0.14

**Maint:** 22000

**Space:** 9000

**Tooling hr:** 8.2

**Machine:** CNC lathe with bar feeder

**Price:** 210000

**Salvage:** 30000

**Life:** 10

**Hours:** 4000

**Kw:** 15

**Kwh cost:** 0.14

**Maint:** 11000

**Space:** 6500

**Tooling hr:** 3.8

**Machine:** Wire EDM

**Price:** 160000

**Salvage:** 15000

**Life:** 10

**Hours:** 3000

**Kw:** 8

**Kwh cost:** 0.14

**Maint:** 9000

**Space:** 4500

**Tooling hr:** 5.6

**Totals:**

#### Highest machine rate

**Key:** rate

**Agg:** max

**Format:** currency

#### Lowest machine rate

**Key:** rate

**Agg:** min

**Format:** currency

#### Average machine rate

**Key:** rate

**Agg:** avg

**Format:** currency

**Notes:** Operator labor is excluded so the rate can be used with separate labor rates. Productive hours should be realistic run hours after setup, maintenance and idle time, not calendar hours. Add interest on capital as part of maintenance and space if your policy requires it.

## Content

**Intro:** A machine hour rate tells you what one hour of a machine costs before labor and material. Estimators use it to quote work, and cost accountants use it to set work center rates in the ERP. This worksheet builds the rate line by line so every assumption is visible.

**Sections:**

#### How to use the worksheet

**Body:** Add one row per machine or work center. Enter installed cost, salvage value, useful life and the productive hours you realistically expect each year. Add average power draw and your electricity price, yearly maintenance and floor space cost, and the hourly cost of tooling and consumables. The sheet calculates depreciation per hour and the total rate. Export to Excel and compare rates across machines before you update work center records.

#### The formula

**Body:** Machine hour rate = (cost minus salvage) divided by life divided by productive hours, plus power draw times power price, plus (maintenance plus floor space) divided by productive hours, plus tooling per hour. Straight line depreciation is used for clarity. If your books use accelerated depreciation, many shops still use straight line for costing so rates do not fall as the machine ages.

**Bullets:**

- Use run hours, not shift hours.
- Average power draw is lower than nameplate kW.
- Include coolant, inserts and wear parts in tooling.

#### Reading the result

**Body:** The 5-axis center costs several times the VMC per hour in the example, mainly because of depreciation. If you quote both at the same shop rate, you subsidise one with the other. Compare the computed rate with the rate in your ERP routing. A large gap means either quotes or standard costs are wrong, and it usually shows up as margins that look fine on paper and thin in practice.

#### Common mistakes

**Body:** The biggest error is using too many productive hours. A machine that runs 6,000 hours a year on paper often runs 3,000 to 4,000 real cutting hours. The second is leaving out maintenance contracts and controls software. Third, many shops apply one blended rate across all machines. Keep individual rates, then group similar machines into one work center rate if the ERP needs it.

**Cta:** If you want machine rates maintained from ERP asset, maintenance and energy data instead of spreadsheets, Netray can discuss how that could work in your setup.

**Faq:**

#### What is included in a machine hour rate?

**Answer:** Typically depreciation, power, maintenance, floor space, tooling and consumables, and sometimes interest on capital and insurance. Operator labor and overhead recovery are often handled separately so rates stay comparable across machines.

#### How many productive hours should I use?

**Answer:** Use actual spindle or run hours you can sustain, usually well below calendar or shift hours. Start from last year's machine monitoring or job report data. Using too many hours understates the rate and leads to underpriced quotes.

#### Should salvage value be included?

**Answer:** Yes if you expect meaningful resale or trade-in value. Many shops use a conservative figure of 10 to 15 percent of cost for machine tools. Setting it to zero is acceptable and simply makes the rate slightly higher.

#### How does this relate to my ERP work center rate?

**Answer:** Most ERPs store an hourly run rate or burden rate on the work center or resource. The machine hour rate here can feed the machine component, while labor and general overhead are added by separate rates.

## Search terms

machine hour rate calculation, machine hour rate excel, machine rate worksheet, cnc machine hourly rate calculator, machine cost per hour template, work center rate build up, shop rate machine hour

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