# Spring Quote and Wire Cost Estimate Worksheet

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

## Short answer

Compute wire weight, material, labor and setup per spring, add markup, and total a multi-line spring quote.

## Category

cost-finance

## Industry

Springs and Fasteners

## Audience

- Estimator
- Sales engineer
- Plant manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Part

**Key:** part

**Type:** text

#### Wire

**Key:** mat

**Type:** select

**Options:**

- Music wire
- Hard drawn
- Stainless 302
- Chrome silicon
- Phosphor bronze

#### Wire dia (in)

**Key:** d

**Type:** number

**Format:** decimal

#### Mean dia (in)

**Key:** dm

**Type:** number

**Format:** decimal

#### Total coils

**Key:** nt

**Type:** number

**Format:** decimal

#### Order qty

**Key:** qty

**Type:** number

**Format:** integer

#### Wire $/lb

**Key:** wire_price

**Type:** number

**Format:** currency

#### Scrap %

**Key:** scrap

**Type:** number

**Format:** decimal

#### Cycle (sec each)

**Key:** cycle

**Type:** number

**Format:** decimal

#### Machine + labor $/hr

**Key:** rate

**Type:** number

**Format:** currency

#### Setup $ per run

**Key:** setup

**Type:** number

**Format:** currency

#### Markup %

**Key:** markup

**Type:** number

**Format:** decimal

#### Wire lb each

**Key:** wire_lb

**Type:** number

**Expr:** pi / 4 * d * d * pi * dm * nt * 0.284

**Format:** decimal

#### Material each

**Key:** mat_each

**Type:** number

**Expr:** pi / 4 * d * d * pi * dm * nt * 0.284 * wire_price * (1 + scrap / 100)

**Format:** currency

#### Labor each

**Key:** lab_each

**Type:** number

**Expr:** cycle / 3600 * rate

**Format:** currency

#### Setup each

**Key:** setup_each

**Type:** number

**Expr:** setup / qty

**Format:** currency

#### Price each

**Key:** price

**Type:** number

**Expr:** (pi / 4 * d * d * pi * dm * nt * 0.284 * wire_price * (1 + scrap / 100) + cycle / 3600 * rate + setup / qty) * (1 + markup / 100)

**Format:** currency

#### Material extended

**Key:** mat_ext

**Type:** number

**Expr:** pi / 4 * d * d * pi * dm * nt * 0.284 * wire_price * (1 + scrap / 100) * qty

**Format:** currency

#### Line total

**Key:** ext

**Type:** number

**Expr:** (pi / 4 * d * d * pi * dm * nt * 0.284 * wire_price * (1 + scrap / 100) + cycle / 3600 * rate + setup / qty) * (1 + markup / 100) * qty

**Format:** currency

**Rows:**

**Part:** SPR-1001 compression

**Mat:** Music wire

**D:** 0.08

**Dm:** 0.72

**Nt:** 10

**Qty:** 5000

**Wire price:** 2.4

**Scrap:** 3

**Cycle:** 4

**Rate:** 55

**Setup:** 180

**Markup:** 35

**Part:** SPR-1002 extension

**Mat:** Hard drawn

**D:** 0.063

**Dm:** 0.5

**Nt:** 13

**Qty:** 2500

**Wire price:** 1.9

**Scrap:** 4

**Cycle:** 7

**Rate:** 55

**Setup:** 220

**Markup:** 35

**Part:** SPR-1003 torsion

**Mat:** Stainless 302

**D:** 0.072

**Dm:** 0.6

**Nt:** 6.5

**Qty:** 1000

**Wire price:** 5.8

**Scrap:** 5

**Cycle:** 9

**Rate:** 62

**Setup:** 260

**Markup:** 40

**Part:** SPR-1004 compression

**Mat:** Chrome silicon

**D:** 0.12

**Dm:** 1.1

**Nt:** 8.5

**Qty:** 800

**Wire price:** 4.1

**Scrap:** 4

**Cycle:** 12

**Rate:** 62

**Setup:** 240

**Markup:** 38

**Totals:**

#### Total pieces

**Key:** qty

**Agg:** sum

**Format:** integer

#### Total material

**Key:** mat_ext

**Agg:** sum

**Format:** currency

#### Total quote value

**Key:** ext

**Agg:** sum

**Format:** currency

**Summary:**

#### Average price per piece

**Key:** avg_price

**Expr:** sum_ext / sum_qty

**Format:** currency

#### Material share of quote

**Key:** mat_share

**Expr:** sum_mat_ext / sum_ext * 100

**Format:** percent

**Description:** Material as a percent of total quoted value, markup included.

**Notes:** Wire weight = wire cross-section area x (pi x mean diameter x total coils) x 0.284 lbm per cubic inch, which fits steel and stainless; adjust the density in your own copy for bronze (about 0.32). Hooks, loops, legs, heat treatment, finishing, plating, packaging and freight are not included, add them as separate lines or in the markup. The wire-length approximation ignores end allowances.

## Content

**Intro:** Spring quotes are mostly wire, machine time and setup spread over the run. This worksheet turns wire diameter, mean diameter and coils into wire weight, then adds scrap, cycle time, setup and markup to give a unit price and a total for each quote line.

**Sections:**

#### How to use it

**Body:** Enter one row per part. Take wire diameter, mean diameter and total coils from the drawing, then add your current wire price per pound, expected scrap, machine cycle in seconds, burdened machine and labor rate, and the setup cost for the run. The worksheet computes wire weight per spring, material, labor and setup per piece, and the price after markup. Edit the quantity to see how setup amortizes: doubling the run roughly halves setup per piece. Export to Excel to attach to your quote or paste into your estimating system.

**Bullets:**

- Use a burdened machine rate, not just labor.
- Add secondary operations such as heat treat and plating as separate lines.
- Quote several quantities to give a price-break table.

#### How the cost is built

**Body:** Wire length is approximated as pi x mean diameter x total coils. Weight is the cross-section area times that length times density. Material per piece is weight times price per pound times one plus scrap. Labor per piece is cycle seconds over 3600 times the hourly rate. Setup per piece is the setup cost divided by quantity. The three are summed and marked up. This captures the three drivers of spring cost, wire, machine time and setup, and ignores second-order items that vary by shop.

#### Reading the results

**Body:** Look at the material share first. Small, high-volume springs are usually dominated by machine time and setup, so wire price barely moves the quote. Large wire and exotic alloys flip that, and the wire price per pound or a minimum buy from the mill becomes the main cost. Compare setup per piece at your quantity with labor per piece: if setup is larger, the quote is sensitive to run length and you should offer a quantity break. Check the average price per piece against recent actual quotes to calibrate cycle time.

#### Common mistakes

**Body:** Estimating errors on springs are repetitive and cost margin quietly.

**Bullets:**

- Forgetting scrap and mill length remnants, which can exceed the listed percent on short runs.
- Using total coils but wire length of the free body only, missing hooks and legs.
- Spreading setup over the quantity when the real run is split into releases.
- Not updating wire price, which moves with surcharges.

**Cta:** If quote costs sit in spreadsheets and the ERP holds actual job costs, we can connect the two so your estimates are checked against actual cycle time and scrap by part family.

**Faq:**

#### How do I estimate wire weight for a spring?

**Answer:** Multiply the wire cross-section area by the wire length and the material density. Wire length is about pi times the mean coil diameter times the total coils, plus the length of any hooks or legs. This worksheet automates the coil part for steel density.

#### Why does unit price drop so much with quantity?

**Answer:** Setup is a fixed cost per run, so spread over more pieces it falls per unit. Wire and run time per piece stay about constant, which is why price break tables for springs flatten out once the setup share is small.

#### What markup should I use?

**Answer:** That depends on your overhead and market. Many shops add overhead into the machine rate and use markup for margin. Use your actual burdened rates and win-loss history, not a rule, and check results against what customers accepted.

#### Does the worksheet include finishing and tooling?

**Answer:** No. Heat treatment, plating, shot peening, grinding, special tooling and packaging are separate costs. Add them as extra lines in the worksheet or fold them into the markup. The notes show where to adjust density for non-steel wire.

## Search terms

spring quote worksheet, spring cost estimating, spring wire weight calculator, spring manufacturing cost estimate, spring pricing spreadsheet, custom spring quote template, spring unit cost excel, spring coiling cost

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