Skip to product information
1 of 8

InkSheet Studio

CNC Machine Shop Job Tracker Spreadsheet Quote Calculator with Quantity Breaks Google Sheets

CNC Machine Shop Job Tracker Spreadsheet Quote Calculator with Quantity Breaks Google Sheets

Regular price $2.69 USD
Regular price $9.99 USD Sale price $2.69 USD
Sale Sold out
Quantity

INSTANT DOWNLOAD — HOW IT WORKS: This is a digital download, not a physical product — nothing is shipped. After checkout, your download link appears right on the confirmation page and is also emailed to you. Use the files in your favorite apps and projects, or print the PDF files at home or at a local print shop.

What does an hour on your mill actually cost you? Not the number you've always used — the real one, with the machine payment, the tooling wear and the overhead in it. And when a customer asks for 10 pieces, then asks what 500 would run, do both answers come from the same math?

This tracker prices machine work the way machine work really runs. Every machine on the Machine Rates tab builds its own hourly rate — depreciation, maintenance, tooling wear, power and its share of the shop's overhead — so a 3-axis mill and a manual lathe stop pretending to cost the same. A quote then runs the way the job runs: a setup paid once, a cycle paid per piece, material and outside processing on top. Cost per piece = material per piece + cycle time × machine rate + setup × machine rate ÷ quantity — which is why the Quantity Breaks tab can price the same bracket at nine quantities and be right at every one: $28.22 a piece at 10, $16.42 at 500, and the only thing that moved is the setup spreading. Won quotes walk a job board from Quoted to Shipped, and when a job is done the Actuals tab puts the quote and the truth side by side. In the sample week inside, a prototype plate quoted at 2.0 setup hours ran 2.6 — its margin fell from a planned 37.9% to 26.9%, and the sheet shows exactly where it went.

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

THE 9 TABS
• Start Here — plain-English quick start, plus the setting that runs the pricing: your target margin %
• Dashboard — quotes won and your win rate, work on the floor and what it's worth, balances still owed to you, profit on completed jobs, and tooling that needs ordering
• Machine Rates — six sample machines, each with an hourly rate built from its own purchase price, life, billable hours, maintenance, tooling wear, power and overhead share; add your own machines any time
• Quote Builder — one row per part: machine rate pulls in by itself, you add setup hours, cycle minutes, quantity, material and outside processing — out comes total cost, cost per piece, a suggested price at your target margin, and a flag on any price you set below it
• Quantity Breaks — one part at nine quantities (1 to 1,000): setup cost per piece falls as the run grows, run cost per piece stays put, and every quantity gets its own suggested price
• Job Board — won quotes become jobs and walk the stages: Quoted, Programmed, Running, QC, Shipped. Deposit in, balance due figures itself out
• Job Actuals vs Quote — the truth tab: quoted cost vs actual machine time, material and outside work, with profit and margin for every finished job
• Tooling Inventory — end mills, inserts, drills and taps on hand, what they're worth, and a REORDER flag when a bin runs low
• Monthly Summary — jobs completed, revenue, real costs and profit by month, rolled up by itself

HOW A QUOTE IS FIGURED — ONE METHOD, NO HIDDEN MATH
Machine time is priced from a real rate, not a guess: every machine on the Machine Rates tab builds its hourly rate from depreciation, maintenance, tooling wear, power and its share of shop overhead. Setup Cost = setup hours × machine rate. Run Cost = cycle minutes per piece ÷ 60 × machine rate × quantity. Total Cost = setup + run + material + outside processing (anodize, heat treat, plating). Cost Per Piece = total cost ÷ quantity. Suggested Price Per Piece = cost per piece ÷ (1 − target margin) — at the suggested price, with your costs covered, the margin you aimed for is the margin you keep. Your Price is always yours to set — the sheet just shows you the margin it really earns and flags anything below your target. The tracker starts at a 35% target margin; change it in one shaded cell on Start Here and every price, margin and flag follows it. This is a quoting and record-keeping tool: it organizes your numbers and does the arithmetic — what you charge and what your shop earns are always your calls.

THE SAMPLE WEEK
It comes loaded with one fictional week (Ridgeline Machine Works, October 2026 — six machines, six quotes out, six jobs on the board, three jobs graded in Actuals) so you can watch every formula work before you delete the samples and type your own. Two quotes price under their target and flag themselves. One finished job's setup ran long and the Actuals tab shows what it cost, line by line. Formulas are pre-filled down the columns — 12 quote rows, 20 job rows, 15 actuals rows, 20 tooling rows, ready to go.

FINISHED FILE — This listing is a digital item, delivered instantly as a file at checkout. The file is finished and ready to use — nothing is customized or personalized. If anything ever breaks or a formula misbehaves, message us and you will receive a corrected file free — forever, no time limit.

REQUIREMENTS: a free Google account. Your tracker lives in Google Sheets — nothing to install, and it works on the shop computer, your phone at the material rack, or wherever a customer asks "what would 500 run me?"

This is a digital product — no physical item will be shipped, and all sales are final (we can't accept returns or cancellations on digital downloads). Your files are available instantly after checkout. But don't worry: if anything isn't working right, message us anytime and we'll fix it for you — no time limit.

View full details