# CNC Job Quote Estimate Worksheet

> Source: https://netray.co/tools/cnc-job-quote-estimate-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable CNC quote worksheet that rolls material, setup, run time and outside services into a price per part.

## Category

cost-finance

## Industry

Machining

## Audience

- Estimator
- Shop owner
- Sales engineer

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Cost element

**Key:** item

**Type:** text

#### Basis

**Key:** basis

**Type:** select

**Options:**

- Per lot
- Per part

#### Quantity or hours

**Key:** qty

**Type:** number

#### Rate or unit cost

**Key:** rate

**Type:** number

**Format:** currency

#### Lot cost

**Key:** lot

**Type:** number

**Expr:** qty * rate

**Format:** currency

**Rows:**

**Item:** Material, 6061-T6 block

**Basis:** Per lot

**Qty:** 250

**Rate:** 6.4

**Item:** Programming and CAM

**Basis:** Per lot

**Qty:** 3

**Rate:** 75

**Item:** Setup (hours)

**Basis:** Per lot

**Qty:** 2.5

**Rate:** 85

**Item:** Run time (hours, 250 parts at 14.5 min)

**Basis:** Per lot

**Qty:** 60.4

**Rate:** 85

**Item:** Deburr and inspect (hours)

**Basis:** Per lot

**Qty:** 8

**Rate:** 55

**Item:** Outside service, clear anodize

**Basis:** Per lot

**Qty:** 250

**Rate:** 2.2

**Totals:**

#### Direct cost for the lot

**Key:** lot

**Agg:** sum

**Format:** currency

**Summary:**

#### Overhead and margin at 25 percent

**Key:** markup

**Expr:** sum_lot * 0.25

**Format:** currency

#### Quoted lot price

**Key:** price_lot

**Expr:** sum_lot + markup

**Format:** currency

**Primary:** true

#### Price per part at 250 pieces

**Key:** price_part

**Expr:** price_lot / 250

**Format:** currency

**Primary:** true

**Description:** Change 250 to your quantity in your own copy after export.

**Notes:** Rates and the 25 percent markup are examples. Use your own machine hour rates and margin policy. Per part rows still use quantity times rate to give a lot cost, so enter the full lot quantity.

## Content

**Intro:** Quotes lose money when a cost element is forgotten or run time is guessed. This worksheet breaks a CNC quote into material, programming, setup, run, finishing and outside services, and rolls it up into a lot price and a price per part.

**Sections:**

#### How to use the worksheet

**Body:** List each cost element as a row. For material, enter pieces and cost per piece including scrap allowance. For labor and machine time, enter hours and your burdened hourly rate. For outside services, enter quantity and unit price from the vendor quote. The lot cost column multiplies quantity by rate, and the summary adds markup to get a quoted lot price and price per part. Edit the example rows, add your own, and export to Excel to keep a dated quote record.

#### How the estimate is built

**Body:** Run time is the line most worth getting right: it is cycle time per part times quantity, divided by 60, and often needs an allowance for loading, tool changes and inspection. Setup is spread across the lot, so small lots carry a high per part burden. Use a machine hour rate that includes depreciation, power, maintenance and floor space, not just labor.

**Bullets:**

- Material: include saw cuts, drop-off and a scrap allowance
- Programming: charge once per lot or amortize across repeat orders
- Setup: count first piece inspection and proveout time
- Outside services: add freight and any minimum charge

#### Common mistakes

**Body:** The usual mistakes are using a lathe or mill rate that ignores overhead, estimating cycle time from the program without handling time, and forgetting outside process minimums that dwarf small lots. Also check quantity breaks, since the price per part at 25 pieces is very different from 250. Revisit estimates against actuals after the job, and feed the real cycle time back into your next quote.

**Cta:** If you want estimates tied to ERP routings, machine rates and actual job costs, Netray can scope a read-only review. This worksheet needs none of that.

**Faq:**

#### What markup should I use?

**Answer:** It depends on your overhead structure and market. The 25 percent here is only an example. Calculate your own from overhead recovery and target margin rather than copying a figure.

#### Does run time include setup?

**Answer:** No. Setup is a separate row spread across the lot, which is why small quantities cost more per part.

#### How do I handle several quantity breaks?

**Answer:** Duplicate the worksheet per quantity, or export to Excel and add columns. Setup and programming stay constant while run time and material scale with quantity.

#### Should I add a scrap allowance?

**Answer:** Yes, usually in the material quantity or run hours. Base it on your history for the process and material rather than a fixed rule.

## Search terms

cnc quote spreadsheet, machine shop quoting template excel, cnc job estimate worksheet, machining quote template, job shop estimating spreadsheet, cnc cost estimate excel, machine shop pricing worksheet, cnc part quote calculator

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json