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.
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.
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
Four sheets. Blue type is an input; black type is a formula.
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.