# Harness Connector and Terminal Requirements Rollup Worksheet

> Source: https://netray.co/tools/harness-connector-and-terminal-requirements-rollup-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

List every connector housing, terminal, seal and splice with spoilage and minimum order quantity, then see required quantities and extended cost.

## Category

supply-chain

## Industry

Wire Harness & Cable Assembly

## Audience

- Buyer
- Planner
- Estimator

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Reference

**Key:** ref

**Type:** text

#### Description

**Key:** desc

**Type:** text

#### Type

**Key:** type

**Type:** select

**Options:**

- Housing
- Terminal
- Seal
- Wedge / lock
- Backshell
- Splice
- Heat shrink
- Other

#### Qty per harness

**Key:** per

**Type:** number

#### Harnesses to build

**Key:** build

**Type:** number

#### Spoilage %

**Key:** spoil

**Type:** number

**Unit:** %

#### Order MOQ

**Key:** moq

**Type:** number

#### Unit cost

**Key:** unit

**Type:** number

**Format:** currency

#### Required qty

**Key:** need

**Type:** number

**Expr:** ceil(per * build * (1 + spoil / 100))

**Format:** integer

#### Buy qty (after MOQ)

**Key:** buy

**Type:** number

**Expr:** max(ceil(per * build * (1 + spoil / 100)), moq)

**Format:** integer

#### Extended cost

**Key:** ext

**Type:** number

**Expr:** max(ceil(per * build * (1 + spoil / 100)), moq) * unit

**Format:** currency

**Rows:**

**Ref:** J1

**Desc:** 24-position sealed housing

**Type:** Housing

**Per:** 1

**Build:** 200

**Spoil:** 1

**Moq:** 100

**Unit:** 3.85

**Ref:** J1-T

**Desc:** Female terminal, 20-22 AWG, tin

**Type:** Terminal

**Per:** 24

**Build:** 200

**Spoil:** 4

**Moq:** 5000

**Unit:** 0.065

**Ref:** J1-S

**Desc:** Single wire seal, 22 AWG

**Type:** Seal

**Per:** 24

**Build:** 200

**Spoil:** 3

**Moq:** 5000

**Unit:** 0.032

**Ref:** J1-W

**Desc:** Terminal position assurance wedge

**Type:** Wedge / lock

**Per:** 1

**Build:** 200

**Spoil:** 2

**Moq:** 200

**Unit:** 0.48

**Ref:** SP1

**Desc:** Solder sleeve splice, 18-22 AWG

**Type:** Splice

**Per:** 3

**Build:** 200

**Spoil:** 5

**Moq:** 250

**Unit:** 0.72

**Ref:** HS1

**Desc:** Adhesive-lined heat shrink 3:1, 25 mm

**Type:** Heat shrink

**Per:** 6

**Build:** 200

**Spoil:** 5

**Moq:** 500

**Unit:** 0.21

**Totals:**

#### Total pieces required

**Key:** need

**Agg:** sum

**Format:** integer

#### Total pieces to buy

**Key:** buy

**Agg:** sum

**Format:** integer

#### Total material cost

**Key:** ext

**Agg:** sum

**Format:** currency

**Summary:**

#### Average cost per line

**Key:** avg_line

**Expr:** sum_ext / count

**Format:** currency

#### Most expensive line

**Key:** max_line

**Expr:** max_ext

**Format:** currency

#### Pieces bought beyond requirement

**Key:** excess

**Expr:** sum_buy - sum_need

**Format:** integer

**Notes:** Required quantity is per x build x (1 + spoilage), rounded up. Buy quantity is the larger of required and the supplier minimum order quantity. Unit cost should be your price at the buy quantity, not the catalog price. Add one row per part number, not per circuit.

## Content

**Intro:** A single mid-size harness can carry a dozen connector, terminal, seal and splice part numbers, each with a different spoilage rate and a different minimum order. This worksheet rolls them up so purchasing buys the right quantity and estimating prices the real material cost.

**Sections:**

#### How to use the worksheet

**Body:** Add one row per part number. Enter the quantity used on a single harness, how many harnesses you plan to build, spoilage percent, supplier MOQ and unit cost. The sheet calculates required pieces, the buy quantity after MOQ and extended cost. Totals and the summary show the overall spend, the average line and how many pieces you are buying beyond the requirement because of minimums.

**Bullets:**

- Use the terminal count per harness, which equals crimped wire ends of that part
- Add seals and wedges as separate rows because they have their own MOQ
- Update Build qty on all rows when the order changes
- Export to Excel to paste into your quote or MRP load

#### Spoilage and MOQ logic

**Body:** Terminals are the highest-spoilage item because crimp setups, applicator changes and pull-test coupons consume them before good product starts. Typical allowances run from low single digits on automated reel-fed terminals up to higher rates on hand-fed or hard-to-source parts, so use your own scrap history. MOQ often drives the real material cost: buying 5,000 terminals for a 200-piece order means the excess either becomes inventory for the next order or a write-off. Show it explicitly rather than hiding it in unit price.

#### Reading the summary

**Body:** The pieces-beyond-requirement figure is a quick measure of MOQ exposure. A large number on low-cost terminals is usually fine if you rebuild the same part regularly. A large number on a high-cost connector housing means you should ask the distributor about split packs or look at a shared-part strategy across harnesses. Compare the total with your target material percentage of price before you finalize the quote.

#### Common mistakes

**Body:** Entering terminal counts from the connector cavity count rather than the actually populated circuits, so unused cavities get terminals and seals they do not need. Forgetting cavity plugs for sealed connectors. Treating a reel price as the unit price when the order is a partial reel. Quoting without lead time for terminal reels, which are often the schedule driver, particularly for military and automotive specific parts.

**Cta:** If connectors and terminals are managed through ERP BOMs and approved manufacturer lists, we can help build a rollup from live BOM and inventory data instead of retyping part lists.

**Faq:**

#### How do I count terminals per harness?

**Answer:** Count each populated circuit end that uses that terminal part number, then add any ring, spade or splice terminals used elsewhere. Do not count empty cavities. Cavity plugs and seals are separate rows if the connector is sealed.

#### What spoilage percent should I use?

**Answer:** Use your own history of terminals issued versus terminals in finished harnesses. Automated reel-fed crimping tends to be low, hand loading and multi-gauge changeovers higher. If you have no data, start with a modest allowance and update after the first builds.

#### Why show buy quantity separately?

**Answer:** Required quantity drives the build, but you can only buy in pack sizes or reels. Showing buy quantity exposes excess inventory cost and helps decide whether to charge the customer for the minimum or amortize it across repeat orders.

#### Can I use this for cable assemblies without connectors?

**Answer:** Yes. List ring terminals, ferrules, lugs, sleeves and boots as rows. The formulas do not depend on the type, only on the quantities and costs you enter.

## Search terms

harness connector rollup, terminal requirements worksheet, wire harness bom template excel, connector terminal quantity calculator, harness purchasing worksheet, terminal spoilage allowance, cable assembly bom cost, moq rollup excel

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