# PCBA Turnkey Quote Worksheet with BOM Rollup and Attrition

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

## Short answer

Enter BOM lines with quantity per board, unit price, attrition and placement counts, then roll up material, placement and through-hole cost into a per-board cost and quote price.

## Category

cost-finance

## Industry

Electronics Manufacturing

## Audience

- EMS estimator
- Buyer
- Cost engineer

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Ref designators

**Key:** ref

**Type:** text

#### MPN or description

**Key:** mpn

**Type:** text

#### Category

**Key:** category

**Type:** select

**Options:**

- Passive
- IC
- Connector
- Electromechanical
- PCB
- Other

#### Qty per board

**Key:** qty_per

**Type:** number

#### Unit price

**Key:** unit_price

**Type:** number

**Format:** currency

**Help:** Price at the quoted buy quantity.

#### Attrition and overage

**Key:** attr_pct

**Type:** number

**Unit:** %

**Help:** Extra parts bought to cover placement losses, setup and MOQ rounding, as a percent of required parts.

#### SMT placements per board

**Key:** smt_pts

**Type:** number

#### Through-hole joints per board

**Key:** th_pts

**Type:** number

#### Material per board with attrition

**Key:** mat_board

**Type:** number

**Expr:** qty_per * unit_price * (1 + attr_pct / 100)

**Format:** currency

**Rows:**

**Ref:** C1-C42

**Mpn:** 100nF 0402 X7R (CL05B104KO5NNNC)

**Category:** Passive

**Qty per:** 42

**Unit price:** 0.0042

**Attr pct:** 4

**Smt pts:** 42

**Th pts:** 0

**Ref:** R1-R58

**Mpn:** 10k 1% 0402 (RC0402FR-0710KL)

**Category:** Passive

**Qty per:** 58

**Unit price:** 0.0031

**Attr pct:** 4

**Smt pts:** 58

**Th pts:** 0

**Ref:** U1

**Mpn:** STM32G431CBT6 MCU LQFP48

**Category:** IC

**Qty per:** 1

**Unit price:** 4.85

**Attr pct:** 0.5

**Smt pts:** 1

**Th pts:** 0

**Ref:** U2

**Mpn:** AP2112K-3.3TRG1 LDO

**Category:** IC

**Qty per:** 1

**Unit price:** 0.19

**Attr pct:** 1

**Smt pts:** 1

**Th pts:** 0

**Ref:** J1

**Mpn:** USB-C receptacle 16 pin

**Category:** Connector

**Qty per:** 1

**Unit price:** 0.62

**Attr pct:** 1

**Smt pts:** 1

**Th pts:** 0

**Ref:** J2

**Mpn:** 2x5 pin header 2.54 mm

**Category:** Connector

**Qty per:** 1

**Unit price:** 0.38

**Attr pct:** 1

**Smt pts:** 0

**Th pts:** 10

**Ref:** PCB1

**Mpn:** 4 layer ENIG bare board

**Category:** PCB

**Qty per:** 1

**Unit price:** 3.4

**Attr pct:** 2

**Smt pts:** 0

**Th pts:** 0

**Totals:**

#### Total parts per board

**Key:** qty_per

**Agg:** sum

**Format:** integer

#### Total SMT placements

**Key:** smt_pts

**Agg:** sum

**Format:** integer

#### Total through-hole joints

**Key:** th_pts

**Agg:** sum

**Format:** integer

#### Material per board with attrition

**Key:** mat_board

**Agg:** sum

**Format:** currency

**Summary:**

#### SMT placement and reflow (0.015 per placement)

**Key:** placement_cost

**Expr:** sum_smt_pts * 0.015

**Format:** currency

#### Through-hole labor (0.10 per joint)

**Key:** th_cost

**Expr:** sum_th_pts * 0.10

**Format:** currency

#### Material handling burden (4 percent of material)

**Key:** mat_burden

**Expr:** sum_mat_board * 0.04

**Format:** currency

#### Fixed per-board inspection, test and packing

**Key:** fixed_ops

**Expr:** 2.5

**Format:** currency

#### Cost per board

**Key:** board_cost

**Expr:** sum_mat_board + placement_cost + th_cost + mat_burden + fixed_ops

**Format:** currency

**Primary:** true

#### Price at 25 percent gross margin

**Key:** price_25

**Expr:** board_cost / (1 - 0.25)

**Format:** currency

**Primary:** true

#### Material share of cost

**Key:** mat_share

**Expr:** sum_mat_board / board_cost * 100

**Format:** percent

**Notes:** Summary rates are illustrative defaults for a mid-volume US EMS line and are fixed in this sheet: replace them with your own rates in the exported Excel file. Attrition percentages commonly run higher for small passives (reel tail and feeder losses) and lower for expensive ICs. Prices should reflect the price break at your buy quantity, and MOQ rounding can be added as extra attrition. This is a cost rollup, not a substitute for a costed BOM in your ERP.

## Content

**Intro:** A turnkey PCBA quote begins with the BOM, but material cost is not quantity times price: attrition, MOQ rounding and placement count change the answer. This worksheet rolls a BOM into cost per board and a quote price.

**Sections:**

#### How to use the worksheet

**Body:** Paste or type each BOM line with reference designators, manufacturer part number, category, quantity per board and the unit price at your buy quantity. Add an attrition percentage, which is the overage you buy beyond what the board needs. Enter SMT placements and through-hole joints for each line; for most SMT lines they equal quantity per board, but multi-pin or multi-site parts may differ. The computed column shows material per board with attrition, and the summary rolls up placement, through-hole labor, burden, fixed operations and price.

#### The method

**Body:** Material per board is quantity per board times unit price times (1 plus attrition). Placement cost is the placement count times a per-placement rate, and through-hole cost is the joint count times a per-joint rate. Burden is a percent of material that covers receiving, kitting, storage and procurement time. Price is cost divided by (1 minus the target gross margin). This follows standard electronics assembly costing: materials, direct process, burden, then margin.

**Bullets:**

- Mat = qty x price x (1 + attrition)
- Cost = material + placement + TH + burden + fixed
- Price = cost / (1 - margin)
- Use price breaks at the real buy quantity

#### Choosing attrition

**Body:** Attrition covers placement losses, machine setup consumption, scrap from rework and rounding to full reels or MOQs. Small passives typically need higher percentages because of reel tails and feeder pick errors, while costly BGAs or modules are bought almost exactly. If a manufacturer requires full reel purchases, include the unused stock as either attrition or an explicit residual inventory charge. For low quantity builds, MOQ rounding can dominate cost, so a buy quantity calculator is a useful companion.

#### Common mistakes

**Body:** Do not use list prices from a single distributor snapshot; refresh at quote time and record the date, because component prices and lead times move. Do not forget non-BOM items like solder paste, stencils, labels and packaging. Counting each line as one placement understates cost on lines with many reference designators. Finally, consider currency, tariffs and freight on imported parts, which sit outside the BOM unit price and belong in burden or a separate line.

**Bullets:**

- Date-stamp price sources
- Include non-BOM consumables
- Count placements per designator
- Add tariff and freight where relevant

**Cta:** If your BOMs and standard costs live in an ERP, we can build an agent that rolls up a quote from live data, with price sources and assumptions visible, running on your own infrastructure.

**Faq:**

#### What attrition percentage is typical?

**Answer:** It varies by part and process. Many shops use a few percent for chip passives, and under a percent to a couple of percent for ICs and costly parts, then adjust with measured placement loss data. Start from your own scrap records and update it regularly.

#### Does this worksheet include NRE?

**Answer:** No. It focuses on recurring cost per board. Add stencil, programming and fixture costs separately, for example with an NRE amortization calculation, and decide whether to bill them as a separate line.

#### Can I export it to Excel?

**Answer:** Yes. Export gives you the table with computed material per board and the summary, so you can change the rates, add rows and connect it to your own pricing sheet.

#### How do I handle alternates and DNP lines?

**Answer:** Include only the approved part for each line and set quantity per board to zero for do-not-populate lines so they appear but do not affect cost. Keep alternates in a separate approved vendor list.

## Search terms

pcba quote worksheet, bom cost rollup excel pcb assembly, turnkey pcba quote template excel, bom attrition overage cost, pcb assembly cost breakdown spreadsheet, ems quote calculator excel, bom costing worksheet electronics, pcba quote bom rollup

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