Free Excel templates

A free machine shop rate calculator in Excel

Machines, billed hours, rates, material, scrap, payroll and costs in; utilization, contribution and full cost per billed hour, EBITDA, the debt service coverage ratio, break-even hours a day and the rate the covenant needs out. No macros.

The file comes prefilled with Halvercote Precision, the fictional CNC job shop of the book, for 2025: 30,800 billed hours on three machine groups, utilization of 65.6 percent, revenue of $4,877,180, a contribution of $99.89 per billed hour against a full cost of $109.08, payroll of $1,997,264, EBITDA of $563,175 and a DSCR of 1.11. The break-even is 100.6 billed hours a working day, 125.5 are needed for the covenant, and the blended rate that would have met it is $114.12 against $112.22 charged.

Get the calculator

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.

Machine_Shop_Rate_Calculator.xlsx (20 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this calculator

This file is the one-page summary of The Machine Shop Owner. The book explains every line: why hours by machine group come before dollars, how a shop rate is built from cost, why overruns and remade parts are hours nobody pays for, why the two-shift payroll is a cost of the period, and how the year is planned to the bank covenant.

DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide

What is in the file

Four sheets. Blue type is an input; black type is a formula.

Inputs
Up to three machine groups with machines, working days, shifts and hours per shift, and machine-days out of service; billed hours and rates by group; material cost per billed hour and the markup; outside processing and its markup; overrun and scrap rates; tooling, consumables and power per hour run; freight; hourly teams, overtime and salaries; payroll taxes; fixed costs, debt service, distributions and the covenant ratio.
Calculator
Available hours and utilization by group; hours run and unbilled hours; revenue by line; variable costs and contribution per billed hour; payroll; EBITDA, the DSCR, full cost per billed hour, break-even billed hours a day, the billed hours a day needed for the covenant and the blended rate that would meet it, each with a one-line definition beside it.
Read Me
How to replace the case with your own shop, and which inputs to check with your advisers.
Checks
The calculator compared with the figures printed in the book for the case.

Three things to try

Put the 2024 scrap and overruns back. Change scrap and rework from 4.1 to 2.4 percent and overruns from 8 to 4 percent, and watch hours run, the machine running costs and EBITDA move without a single extra order.

Raise one group's rate. Add a few dollars to the vertical mill rate only. The blended rate, EBITDA and the gap to the covenant rate all move together.

Replace the case. Type your own machines, hours, rates and costs over the blue cells. If a line does not make sense, the definition beside it says what it measures.

Related reading