How does the template estimate CNC cycle time?

Per operation it adds handling minutes, stock removed divided by your metal-removal rate, toolpath length divided by feed, and tool changes times the chip-to-chip time on Setup. In the example, side A removes 38 cm3 at 18 cm3/min (2.11 min), runs 2,400 mm of finishing path at 1,200 mm/min (2.00 min), makes 8 tool changes at 5 s (0.67 min) and adds 1.0 min of handling: 5.78 minutes per part.

How is tool wear costed?

Each tool's price is divided by its edges or regrind lives and by the parts one edge machines. A 12 mm carbide rougher at 85 with three lives (new plus two regrinds) that machines 250 parts per life costs 85 / 3 / 250 = 0.113 per part. The tool total is multiplied by parts to start, because scrapped parts wear tools too.

Is the margin on cost or on price?

On price. The unit price is total cost divided by one minus the target margin, then rounded up to your price step. A 25 percent margin on price is a 33.3 percent markup on cost, so 60.00 of cost becomes 80.00. The Margin achieved row shows the real margin after rounding.

Why does the price fall so much between 10 and 250 parts?

Setup, programming and fixtures are fixed per batch. In the example, 278.75 of setup and 615 of programming and fixtures add 89.38 per part at 10 parts but only 3.58 per part at 250. Outside processing lot charges do the same: a 150 minimum anodising charge is 15.00 per part at 10 pieces and the 2.40 piece price at 250.

How does it relate to the Machining Cost per Part calculator?

The calculator returns (batch quantity x variable cost per part + fixed adders) / batch quantity. This workbook builds both parts from your operations: fixed per batch is setup cost plus overhead on it plus amortised programming and NRE; variable per part is everything else. The build runs the example's 100-part break and the calculator's own example (250 parts, 18.50 variable, 925 of adders: 22.20 per part) through the calculator's engine.

Can I use inches and my own currency?

Yes. Choose mm or in on the Quote Builder; blank sizes, toolpath and feed use that unit and stock removed and MRR use cm3 or in3. Material prices can be per kg or per lb, converted exactly with 1 lb = 0.45359237 kg. Type your currency code on Setup and it appears on every price, chart and the printed quote; no exchange rate is applied.

Industry Cost Kits

CNC Machining Quote Excel Template

Estimate CNC cycle time from stock removed, removal rate, toolpath, feed and tool changes, cost every operation, tool and charge, and price five quantity breaks on a printable quote.

Overview

This CNC machining quote template is an Excel estimating tool for machine shops that quote milled and turned parts. It ships with a complete example for a fictional shop, a 6061 aluminium hydraulic manifold block milled on two sides and hard anodised, priced at 10, 25, 50, 100 and 250 parts, so you can see every number move before you enter your own RFQ.

The heart of it is the operations table. Each operation's cycle time is handling minutes, plus stock removed divided by the metal-removal rate you achieve roughing, plus toolpath length divided by feed, plus tool changes times your chip-to-chip time. Take the volumes and toolpath lengths from your CAM system or estimate them from the drawing; units cancel, so millimetres or inches both work. Each operation is priced at its machine's hourly rate, setup hours become a batch cost, and a cutting-tool table turns tool price, edges and parts per edge into a tool-wear cost per part.

For every quantity break the workbook costs material, machine time and tool wear on parts to start (quantity divided by first-pass yield), spreads setup, programming and fixtures over the quantity, adds outside processing at the larger of the lot charge and price times quantity, overhead and markup, and prices to your target margin on price, rounded up to your price step. The Dashboard shows the break you pick with two charts and the cost build-up, and the Quote sheet prints a customer-ready quotation. The fixed and variable split matches the Machining Cost per Part calculator on this site, and the build checks it against the calculator's engine.

What this template includes

Operations table that builds each cycle time from handling minutes, stock removed and metal-removal rate, toolpath length and feed, and tool changes at your chip-to-chip time
Machine and bench rates and material prices on Setup, with blank sizing for round or rectangular bar in mm or inches and prices per kg or lb
Cutting-tool table that turns tool price, edges or regrind lives and parts per edge into a tool-wear cost per part
Programming, fixtures and NRE that are amortised or billed separately, and outside processing with lot charges and lead times
Five quantity breaks with parts to start for your first-pass yield, a line-by-line cost build-up, overhead, margin on price, rounded unit price, extended price and lead time
Dashboard for the quantity you pick: unit price, cost, margin against target, cycle time, two charts and the cost build-up with shares
A protected, printable Quote sheet with your company details, the price table, separately billed charges, terms and an acceptance block
Verify sheet that recomputes the cycle times and price build-up on fixed inputs against an independent reference

Suggested use case

Use it to price milled and turned parts from the cutting data you already have, to see which operation and which cost line drive the price, and to send a clean quote with quantity breaks the same day.

How to use it

On Setup, enter your company details, currency and terms, costing defaults, chip-to-chip time, machine rates and material prices.
On Quote Builder, fill in the RFQ details, choose the material and size the blank.
List each operation with its machine, setup hours, handling minutes, stock removed and MRR, toolpath and feed, and tool changes.
List the cutting tools, programming and fixture charges, and any outside processing; type five quantity breaks.
Pick a quantity on the Dashboard to read price, cost, margin and the cost build-up, then print the Quote sheet or save it as PDF.

Frequently Asked Questions

How does the template estimate CNC cycle time?: Per operation it adds handling minutes, stock removed divided by your metal-removal rate, toolpath length divided by feed, and tool changes times the chip-to-chip time on Setup. In the example, side A removes 38 cm3 at 18 cm3/min (2.11 min), runs 2,400 mm of finishing path at 1,200 mm/min (2.00 min), makes 8 tool changes at 5 s (0.67 min) and adds 1.0 min of handling: 5.78 minutes per part.
How is tool wear costed?: Each tool's price is divided by its edges or regrind lives and by the parts one edge machines. A 12 mm carbide rougher at 85 with three lives (new plus two regrinds) that machines 250 parts per life costs 85 / 3 / 250 = 0.113 per part. The tool total is multiplied by parts to start, because scrapped parts wear tools too.
Is the margin on cost or on price?: On price. The unit price is total cost divided by one minus the target margin, then rounded up to your price step. A 25 percent margin on price is a 33.3 percent markup on cost, so 60.00 of cost becomes 80.00. The Margin achieved row shows the real margin after rounding.
Why does the price fall so much between 10 and 250 parts?: Setup, programming and fixtures are fixed per batch. In the example, 278.75 of setup and 615 of programming and fixtures add 89.38 per part at 10 parts but only 3.58 per part at 250. Outside processing lot charges do the same: a 150 minimum anodising charge is 15.00 per part at 10 pieces and the 2.40 piece price at 250.
How does it relate to the Machining Cost per Part calculator?: The calculator returns (batch quantity x variable cost per part + fixed adders) / batch quantity. This workbook builds both parts from your operations: fixed per batch is setup cost plus overhead on it plus amortised programming and NRE; variable per part is everything else. The build runs the example's 100-part break and the calculator's own example (250 parts, 18.50 variable, 925 of adders: 22.20 per part) through the calculator's engine.
Can I use inches and my own currency?: Yes. Choose mm or in on the Quote Builder; blank sizes, toolpath and feed use that unit and stock removed and MRR use cm3 or in3. Material prices can be per kg or per lb, converted exactly with 1 lb = 0.45359237 kg. Type your currency code on Setup and it appears on every price, chart and the printed quote; no exchange rate is applied.