How do I calculate a machine hour rate from scratch?

Add annual fixed costs (depreciation or lease, PM, floor space, dedicated operator) and divide by planned productive hours, then add per-hour variable costs like energy. Example: 60,000 in annual fixed costs over 3,000 productive hours is 20 per hour, plus 4 per hour energy equals a 24 dollar machine hour rate. The template separates fixed and variable so changing utilization only rescales the fixed portion, which is where most of the rate lives.

How many productive hours should I use as the denominator?

Use realistic productive hours, not calendar hours. One shift is about 2,000 paid hours a year, but after breaks, changeovers, maintenance, and no-demand time you often net 1,600 to 1,800 productive hours. Two shifts land near 3,400 to 3,600. Using a too-optimistic denominator understates your rate and erodes margin on every quote. Tie this number to your OEE availability so the planned hours reflect how the machine actually runs.

Should I use depreciation or lease cost in the machine rate?

Use whichever reflects your actual annual cash or book cost, but not both. For owned equipment, use annual depreciation, often straight-line over 7 to 10 years, so a 350,000 machine contributes about 43,750 per year over 8 years. For leased equipment, use the annual lease payment. If the machine is fully depreciated but still running, some shops keep a nominal replacement reserve so the rate does not collapse and underprice future capacity.

How do I allocate floor space cost to a single machine?

Take the machine footprint plus its working aisle and material staging, then multiply by your occupancy cost per square foot per year. If the cell uses 400 square feet at 12 dollars per square foot annually, that is 4,800 per year added to fixed costs. Include the aisle and staging because that space is committed to the machine. At 3,000 productive hours, that 4,800 adds 1.60 per hour to the rate.

Should the operator be included in the machine hour rate?

Only if the operator is dedicated to that one machine. Include their fully loaded cost if so. If one operator tends three machines, either leave labor out of the machine rate and cost it separately per part, or divide the operator cost by three before adding it. Double-counting labor in both the machine rate and the unit cost sheet is a common error that inflates quotes by 15 to 30 percent.

Why is my machine hour rate so high?

Almost always the denominator. A machine with 50,000 in annual fixed cost over 1,500 productive hours costs 33 per hour, but over 3,000 hours it drops to 17. Low utilization is the usual culprit, so check whether you budgeted too few hours or the machine truly sits idle. Adding a shift or moving work onto an underloaded machine spreads the same fixed cost over more hours and directly lowers the rate you quote.

Manufacturing Cost and Quoting

Machine Hour Rate Spreadsheet Template

Build a machine hour rate by allocating depreciation, maintenance, energy, floor space, and operator cost across productive hours.

Overview

This Machine Hour Rate Spreadsheet is for cost engineers, estimators, and plant managers who need a defensible dollars-per-hour figure for a machine or work center. The rate rolls up depreciation or lease, maintenance, energy, floor space, and any dedicated operator cost, then divides by productive hours. Quoting off a made-up rate either loses jobs or loses money on every hour the machine runs. A built-up rate lets you justify the number in a customer audit and see exactly which cost category makes the machine expensive.

You enter annual figures for each category: depreciation or lease, preventive maintenance, energy cost per hour, floor space allocation, and operator cost if the machine has a dedicated tender. You also set annual planned production hours based on your shift pattern and realistic uptime. The sheet sums annual fixed costs, adds the per-hour variable costs like energy, and divides the fixed portion by planned hours to produce the machine hour rate. The denominator matters most: fewer productive hours push the rate up fast.

In a real workflow, build the rate once per machine per year and revisit it when utilization or energy prices shift. If the rate looks too high, check your planned hours first, since a machine budgeted for one shift carries its full depreciation over far fewer hours than a two-shift machine. Feed the resulting rate straight into the Unit Cost Spreadsheet as your machine hour rate. Pair it with the Machine Hour Rate Calculator for a quick estimate, then use this sheet to document the full buildup for budgeting.

What this template includes

Annual depreciation or lease cost input
Preventive maintenance cost per year
Energy cost per hour
Floor space allocation and cost rate
Operator cost if dedicated to one machine
Annual planned production hours
Calculated machine hour rate

Suggested use case

Use this to set machine rates for quoting, cost center budgeting, or comparing the economics of owned vs. contract capacity.

How to use it

Enter the annual cost for each cost category.
Set planned annual production hours based on shifts and uptime.
Review the rate and adjust planned hours if the rate seems too high.
Use the resulting rate in your unit cost or job quote calculation.

Frequently Asked Questions

How do I calculate a machine hour rate from scratch?: Add annual fixed costs (depreciation or lease, PM, floor space, dedicated operator) and divide by planned productive hours, then add per-hour variable costs like energy. Example: 60,000 in annual fixed costs over 3,000 productive hours is 20 per hour, plus 4 per hour energy equals a 24 dollar machine hour rate. The template separates fixed and variable so changing utilization only rescales the fixed portion, which is where most of the rate lives.
How many productive hours should I use as the denominator?: Use realistic productive hours, not calendar hours. One shift is about 2,000 paid hours a year, but after breaks, changeovers, maintenance, and no-demand time you often net 1,600 to 1,800 productive hours. Two shifts land near 3,400 to 3,600. Using a too-optimistic denominator understates your rate and erodes margin on every quote. Tie this number to your OEE availability so the planned hours reflect how the machine actually runs.
Should I use depreciation or lease cost in the machine rate?: Use whichever reflects your actual annual cash or book cost, but not both. For owned equipment, use annual depreciation, often straight-line over 7 to 10 years, so a 350,000 machine contributes about 43,750 per year over 8 years. For leased equipment, use the annual lease payment. If the machine is fully depreciated but still running, some shops keep a nominal replacement reserve so the rate does not collapse and underprice future capacity.
How do I allocate floor space cost to a single machine?: Take the machine footprint plus its working aisle and material staging, then multiply by your occupancy cost per square foot per year. If the cell uses 400 square feet at 12 dollars per square foot annually, that is 4,800 per year added to fixed costs. Include the aisle and staging because that space is committed to the machine. At 3,000 productive hours, that 4,800 adds 1.60 per hour to the rate.
Should the operator be included in the machine hour rate?: Only if the operator is dedicated to that one machine. Include their fully loaded cost if so. If one operator tends three machines, either leave labor out of the machine rate and cost it separately per part, or divide the operator cost by three before adding it. Double-counting labor in both the machine rate and the unit cost sheet is a common error that inflates quotes by 15 to 30 percent.
Why is my machine hour rate so high?: Almost always the denominator. A machine with 50,000 in annual fixed cost over 1,500 productive hours costs 33 per hour, but over 3,000 hours it drops to 17. Low utilization is the usual culprit, so check whether you budgeted too few hours or the machine truly sits idle. Adding a shift or moving work onto an underloaded machine spreads the same fixed cost over more hours and directly lowers the rate you quote.