# Sheet Metal Quote Builder Worksheet with Quantity Breaks

> Source: https://netray.co/tools/sheet-metal-multi-quantity-quote-builder-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable worksheet where each row is a part at a quantity, computing unit cost, unit price, extended price and profit.

## Category

cost-finance

## Industry

Sheet Metal Fabrication

## Audience

- Estimator
- Sales engineer
- Owner-manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Part / quantity break

**Key:** item

**Type:** text

#### Qty

**Key:** qty

**Type:** number

#### Material per part

**Key:** material

**Type:** number

**Format:** currency

**Help:** Net material cost, from the nest report.

#### Laser min per part

**Key:** cut_min

**Type:** number

**Unit:** min

#### Brake min per part

**Key:** bend_min

**Type:** number

**Unit:** min

#### Blended shop rate

**Key:** rate

**Type:** number

**Format:** currency

**Unit:** $/hr

#### Finish per part

**Key:** finish

**Type:** number

**Format:** currency

#### Hardware per part

**Key:** hardware

**Type:** number

**Format:** currency

#### Total setup hours

**Key:** setup_hr

**Type:** number

**Unit:** hr

#### Margin %

**Key:** margin

**Type:** number

**Format:** percent

#### Unit cost

**Key:** unit_cost

**Type:** number

**Expr:** material + (cut_min + bend_min) / 60 * rate + finish + hardware + setup_hr * rate / qty

**Format:** currency

#### Unit price

**Key:** unit_price

**Type:** number

**Expr:** unit_cost / (1 - margin / 100)

**Format:** currency

#### Extended price

**Key:** ext_price

**Type:** number

**Expr:** unit_price * qty

**Format:** currency

#### Profit

**Key:** profit

**Type:** number

**Expr:** (unit_price - unit_cost) * qty

**Format:** currency

**Rows:**

**Item:** BRK-2201 bracket, qty 25

**Qty:** 25

**Material:** 1.85

**Cut min:** 0.9

**Bend min:** 0.6

**Rate:** 125

**Finish:** 1.2

**Hardware:** 0.4

**Setup hr:** 0.9

**Margin:** 32

**Item:** BRK-2201 bracket, qty 100

**Qty:** 100

**Material:** 1.78

**Cut min:** 0.85

**Bend min:** 0.55

**Rate:** 125

**Finish:** 1.05

**Hardware:** 0.38

**Setup hr:** 0.9

**Margin:** 32

**Item:** BRK-2201 bracket, qty 500

**Qty:** 500

**Material:** 1.7

**Cut min:** 0.8

**Bend min:** 0.5

**Rate:** 125

**Finish:** 0.9

**Hardware:** 0.35

**Setup hr:** 0.9

**Margin:** 30

**Item:** ENC-5010 enclosure, qty 10

**Qty:** 10

**Material:** 14.2

**Cut min:** 4.5

**Bend min:** 6.2

**Rate:** 125

**Finish:** 8.5

**Hardware:** 3.1

**Setup hr:** 2.2

**Margin:** 35

**Item:** ENC-5010 enclosure, qty 50

**Qty:** 50

**Material:** 13.6

**Cut min:** 4.2

**Bend min:** 5.8

**Rate:** 125

**Finish:** 7.4

**Hardware:** 2.9

**Setup hr:** 2.2

**Margin:** 33

**Totals:**

#### Total pieces

**Key:** qty

**Agg:** sum

**Format:** integer

#### Total quoted price

**Key:** ext_price

**Agg:** sum

**Format:** currency

#### Total profit

**Key:** profit

**Agg:** sum

**Format:** currency

**Summary:**

#### Blended margin on all lines

**Key:** blended_margin

**Expr:** sum_profit / sum_ext_price * 100

**Format:** percent

**Primary:** true

#### Average price per piece

**Key:** avg_unit

**Expr:** sum_ext_price / sum_qty

**Format:** currency

**Notes:** Unit cost = material + (laser + brake minutes) / 60 x shop rate + finish + hardware + setup hours x rate / quantity. Use a blended hourly rate that already includes labor and overhead. Add outside processing, packaging and freight as separate lines or inside finish.

## Content

**Intro:** A quote that looks right at quantity 100 can lose money at quantity 10 because setup does not scale down. This worksheet prices each quantity break on its own row so setup, margin and total profit show up for every option you send.

**Sections:**

#### How to use the worksheet

**Body:** Add a row for each part at each quantity you plan to quote. Enter net material cost from your nest or cut list, laser and brake minutes per part, a blended hourly shop rate, finish and hardware cost per part, and the total setup hours for the job. Set a margin percentage. The sheet computes unit cost, unit price, extended price and profit, and the footer shows blended margin and average price per piece. Download the result to Excel to share or paste into your quote.

**Bullets:**

- Use one row per quantity break rather than editing the same row.
- Pull minutes from the laser and press brake calculators in this set.
- Keep setup hours as a job total, not per part.

#### Formulas used

**Body:** Unit cost equals material, plus machine and labor time at the shop rate, plus finish and hardware, plus setup hours times rate divided by quantity. Unit price equals unit cost divided by one minus margin, which gives a true margin on price rather than a markup on cost; 30 percent margin is a price 1.43 times cost, not 1.30 times. Extended price is unit price times quantity and profit is price minus cost times quantity. Blended margin is total profit divided by total price.

#### Reading the result

**Body:** The example shows the same bracket at 25, 100 and 500 pieces. Unit price falls as setup spreads over more parts and material and run times improve slightly with larger nests. Compare blended margin across customers and review any row where margin falls under your floor. A drop in unit price greater than the setup savings alone means you are giving away margin on volume.

#### Common mistakes

**Body:** Applying markup instead of margin understates the price needed. Another common error is using the same material cost at all quantities when a larger nest or mill quantity price changes it. Estimators also forget to include inspection, packaging and freight, or quote a quantity break without checking that the customer can order the higher quantity.

**Cta:** If quotes are rebuilt by hand in spreadsheets, Netray can help connect estimating to ERP items, routings and rates. Ask for an expert review of your quoting workflow.

**Faq:**

#### What margin should a sheet metal shop target?

**Answer:** It varies with customer, volume and competition. Many job shops aim for gross margins of 25 to 40 percent on price. Use the worksheet to see what each line really earns and set a floor below which you require approval.

#### What is the difference between markup and margin?

**Answer:** Markup is a percentage added to cost; margin is the share of price that is profit. A 30 percent margin needs a price of cost divided by 0.70, which is a 42.9 percent markup. This sheet uses margin on price.

#### How do I set the blended shop rate?

**Answer:** Divide total monthly fabrication costs including labor, equipment, facility and overhead by productive machine hours. Many shops use one blended rate for quoting and refine it by work center in ERP. Review it each quarter.

#### Can I add rows for outside processing?

**Answer:** Yes. Add a row or put the outside processing cost per part inside the finish column. For plating, anodize or heat treat, include any minimum lot charge and freight in the per part value.

## Search terms

sheet metal quote worksheet excel, sheet metal estimating spreadsheet, fabrication quote template quantity breaks, sheet metal quote builder, laser press brake quote spreadsheet, metal fabrication cost estimate template, quote with quantity price breaks, sheet metal pricing worksheet

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