CNC Machine Shop Tracker

What does an hour on your mill actually cost you? Not the number you've always used — the real one, with machine payment, tooling and overhead in it. This tracker prices machine work the way it runs, across 9 tabs. The Machine Rates tab builds each machine's hourly rate from depreciation, maintenance, tooling, power and overhead — the sample shop's VMC-2 builds to $52.17 an hour, its lathe to $20.33. A quote runs the way the job runs: setup paid once, cycle per piece, material and outside processing on top. That is why the Quantity Breaks tab prices one bracket at nine quantities, right at every one: $28.22 a piece at 10, $16.42 at 500.

The samples are one fictional week at Ridgeline Machine Works, October 2026 — six machines, six quotes, six jobs, three graded in Actuals: a plate quoted at 2.0 setup hours ran 2.6; margin fell 37.9% to 26.9%. This is a record-keeping tool, not financial advice.

Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.

What you receive is the finished file, delivered instantly at checkout as a PDF containing your Google Sheets copy link. Open it, choose "Make a copy," and the file is yours. It runs in Google Sheets on a free Google account — nothing to install — and sample data is included so you can see the formulas work. If a file ever breaks, you receive a corrected copy of the file free. This is a digital product — no physical item will be shipped.