# Multi-Operation CNC Machining Quote Worksheet > Source: https://netray.co/tools/multi-operation-cnc-machining-quote-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable routing-style quote sheet: one row per operation, setup and run cost computed, outside processing added, cost per piece rolled up. ## Category cost-finance ## Industry CNC Machining ## Audience - Estimator - Sales engineer - Job shop owner ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Operation **Key:** op **Type:** text #### Work center **Key:** wc **Type:** select **Options:** - Saw - CNC mill 3-axis - CNC mill 5-axis - CNC lathe - Wire EDM - Deburr - Inspection - Outside process #### Setup **Key:** setup_hr **Type:** number **Unit:** hr #### Run time per piece **Key:** run_min **Type:** number **Unit:** min #### Rate **Key:** rate **Type:** number **Format:** currency **Unit:** $/hr #### Outside cost per piece **Key:** outside_pc **Type:** number **Format:** currency #### Qty **Key:** qty **Type:** number #### Setup cost **Key:** setup_cost **Type:** number **Expr:** setup_hr * rate **Format:** currency #### Run hours **Key:** run_hr **Type:** number **Expr:** run_min / 60 * qty **Format:** hours #### Run cost **Key:** run_cost **Type:** number **Expr:** run_hr * rate **Format:** currency #### Outside cost **Key:** outside_cost **Type:** number **Expr:** outside_pc * qty **Format:** currency #### Operation total **Key:** total **Type:** number **Expr:** setup_cost + run_cost + outside_cost **Format:** currency #### Per piece **Key:** per_pc **Type:** number **Expr:** total / qty **Format:** currency **Rows:** **Op:** 10 Saw cut blank **Wc:** Saw **Setup hr:** 0.25 **Run min:** 0.8 **Rate:** 55 **Outside pc:** 0 **Qty:** 50 **Op:** 20 Mill side 1 **Wc:** CNC mill 3-axis **Setup hr:** 1.5 **Run min:** 9.5 **Rate:** 95 **Outside pc:** 0 **Qty:** 50 **Op:** 30 Mill side 2 **Wc:** CNC mill 3-axis **Setup hr:** 1 **Run min:** 6 **Rate:** 95 **Outside pc:** 0 **Qty:** 50 **Op:** 40 Deburr and break edges **Wc:** Deburr **Setup hr:** 0.1 **Run min:** 2.5 **Rate:** 60 **Outside pc:** 0 **Qty:** 50 **Op:** 50 Final inspection **Wc:** Inspection **Setup hr:** 0.5 **Run min:** 3 **Rate:** 75 **Outside pc:** 0 **Qty:** 50 **Op:** 60 Anodize Type II **Wc:** Outside process **Setup hr:** 0 **Run min:** 0 **Rate:** 0 **Outside pc:** 2.4 **Qty:** 50 **Totals:** #### Total setup hours **Key:** setup_hr **Agg:** sum **Format:** hours #### Total run hours **Key:** run_hr **Agg:** sum **Format:** hours #### Setup cost **Key:** setup_cost **Agg:** sum **Format:** currency #### Run cost **Key:** run_cost **Agg:** sum **Format:** currency #### Outside processing **Key:** outside_cost **Agg:** sum **Format:** currency #### Conversion and outside cost **Key:** total **Agg:** sum **Format:** currency **Summary:** #### Conversion and outside cost per piece **Key:** conv_pc **Expr:** sum_total / avg_qty **Format:** currency **Primary:** true **Description:** Excludes material. Add material per piece from the blank cost calculator. #### Setup share of total **Key:** setup_share **Expr:** sum_setup_cost / sum_total * 100 **Format:** percent #### Outside processing share **Key:** outside_share **Expr:** sum_outside_cost / sum_total * 100 **Format:** percent #### Total labor and machine hours **Key:** hours_total **Expr:** sum_setup_hr + sum_run_hr **Format:** hours **Notes:** Keep the same quantity on every row for a single-lot quote. Material, freight, overhead and margin are added after this sheet, for example with the quantity price break calculator. Rates should be burdened hourly rates from your costing, not wages. ## Content **Intro:** A quote that rolls up by operation is easier to check, easier to adjust and closer to how your ERP routing will look once the job is won. This worksheet computes setup, run and outside processing cost for each operation and totals them per piece. **Sections:** #### How to use the worksheet **Body:** Add one row per routing operation in sequence. Enter setup hours, run time per piece in minutes, the burdened hourly rate for that work center, any outside processing cost per piece and the lot quantity. The sheet computes setup cost, run hours, run cost, outside cost, total and cost per piece for every operation, then totals them. The summary shows conversion cost per piece and shares for setup and outside processing. Add the material per piece and your margin from the other tools to reach a price. Export to Excel to attach to a quote file. **Bullets:** - Use outside processing rows for plating, heat treat, anodize and coating - Set rate to zero on outside rows so labor does not double count - Duplicate the sheet for each quantity break you intend to quote #### Method and formulas **Body:** For each operation, setup cost = setup hours x rate, run hours = run minutes / 60 x quantity, run cost = run hours x rate, and outside cost = outside cost per piece x quantity. Operation total adds the three and per-piece cost divides by quantity. This mirrors the routing cost rollup that ERP systems perform, with setup and run elements costed separately so you can see which dominates. Conversion cost is everything except material. Burdened rates should include labor, depreciation, maintenance, tooling, facility and overhead allocation, see the machine hour rate calculator. #### Reading the example **Body:** The example routing of six operations at 50 pieces totals roughly 1,350 dollars, or around 27 per piece before material. Setup is a noticeable share and the two milling operations dominate. If the customer will order 200 pieces, setup per piece will fall sharply while run cost per piece will not, which tells you where negotiation room exists. The outside processing share shows how much of the price you pass through, so build in handling, freight and a small allowance for rejects at the vendor. #### Common mistakes **Body:** Estimators often omit inspection and deburr because they feel small, but together they can exceed a milling op on tight-tolerance parts. Others use the same rate for every work center, which hides that five-axis time costs much more than a manual saw. Another trap is forgetting transit and wait time when outside processing extends lead time, which matters when quoting delivery. Finally, keep setup hours honest for repeat orders by quoting a reduced setup in a second sheet. **Cta:** If your quotes should come straight from ERP routings and work center rates, Netray can help wire estimates to the routing data you already maintain. **Faq:** #### Can I use different quantities per operation? **Answer:** You can, but cost per piece for the full job is easiest to read when all rows share one lot quantity. If an operation processes a different quantity, such as a batch heat treat, convert it to a per-piece cost first. #### Where does material go? **Answer:** Material is deliberately excluded so this sheet isolates conversion cost. Use the material blank cost calculator for material per piece, then add it before overhead and margin. #### What rates should I enter? **Answer:** Use burdened rates from your costing model, covering labor, depreciation, maintenance, power and an overhead share. Wages alone understate cost. A machine hour rate calculator helps build these. #### How do I add profit? **Answer:** Add material to conversion cost to get total cost per piece, then divide by one minus your target margin. The setup amortization calculator in this set applies margin on price and shows quantity breaks. ## Search terms cnc quote worksheet excel, machining quote template excel, multi operation routing cost, job shop quote spreadsheet, cnc part cost breakdown, machining estimate by operation, routing cost rollup worksheet, quote worksheet machine shop --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json