Harness Connector and Terminal Requirements Rollup Worksheet
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.
| Reference | Description | Type | Qty per harness | Harnesses to build | Spoilage % (%) | Order MOQ | Unit cost | Required qty | Buy qty (after MOQ) | Extended cost | |
|---|---|---|---|---|---|---|---|---|---|---|---|
202 | 202 | $778 | |||||||||
4,992 | 5,000 | $325 | |||||||||
4,944 | 5,000 | $160 | |||||||||
204 | 204 | $98 | |||||||||
630 | 630 | $454 | |||||||||
1,260 | 1,260 | $265 |
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.
Load harness BOMs into your ERP planning
Optional: talk through pulling connector and terminal requirements straight from ERP BOMs and inventory.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
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.
- 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
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
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
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.
Frequently Asked Questions
How do I count terminals per harness?
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?
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?
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?
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.
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.
Related Tools
Wire and Cable Length Cost Calculator for Harness Builds
Turn finished wire length, twist take-up and scrap into feet per harness, reels to buy and wire cost per unit and per lot.
Industry TemplatesWire Harness Quotation Template
A fill-in quote document for harness and cable assembly work: part and revision, workmanship class, price breaks, NRE, lead time, assumptions and signatures.
Quality & InspectionCrimp Pull Force and Crimp Height Test Log Worksheet
Log pull force and crimp height by applicator and terminal, compare with your limits, and see pass or fail, margin and first pass yield.
Costing & FinanceWire Harness Price by Quantity and NRE Calculator
Convert material, labor hours, overhead, test cost, NRE and target gross margin into a unit price and a price-versus-quantity curve.
Electronics ManufacturingElectronics BOM Cost Calculator
Estimate loaded BOM cost per board and annual material spend, including volume pricing tiers, procurement overhead, and attrition.
More Supply Chain & Inventory tools
See all- Oracle Fusion Inventory Turns and Carrying Cost Calculator
- Distribution ERP Fill Rate Calculator
- Distributor Rebate Tracking Worksheet
- Branch Transfer Planning Worksheet
- Distributor Slow-Moving Inventory Review Worksheet
- Distributor Vendor Performance Scorecard Worksheet
- Distributor GMROI Calculator
- Distributor Backorder Cost and Fill Rate Calculator
- EOQ with Vendor Minimum Order Calculator
Keep exploring
Free tools
- Wire Harness Assembly Labor Time CalculatorBuild up harness labor minutes from operation counts and time standards, apply efficiency and difficulty, and see how setup spreads across lot size.
- Wire Harness RFQ Review ChecklistCheck the drawing package, BOM, class, test, material, compliance and commercial points on a harness RFQ before you commit to a price.
- Wire Harness Quotation TemplateA fill-in quote document for harness and cable assembly work: part and revision, workmanship class, price breaks, NRE, lead time, assumptions and signatures.
ERP fixes and how-tos
- How to Run a Cost Rollup in SyteLineRun a SyteLine standard cost rollup: use Simulate mode first, fix variance exceptions from missing routings or zero-cost items, then post new standard costs.
- How to create an assembly build or work order in NetSuiteHow to build assembly items in NetSuite: when to use a simple Assembly Build versus a Work Order, BOM setup, component availability, and completion steps.
Guides
- ERP for Cable Assembly and Wire Harness Manufacturers: What to RequireWhat a cable assembly or wire harness shop needs from ERP: BOM by drawing revision, wire by the foot, lot traceability, kitting, and test records.
- How to Quote a Wire Harness From a Customer DrawingStep-by-step wire harness quoting: read the drawing, build the BOM, price wire and connectors, time every termination, and add NRE, test and scrap.
- AI for Wire Harness RFQ Review and EstimatingHow AI helps harness and cable assembly estimators: read RFQ packages, find similar past jobs, flag missing data and draft quotes for human approval.
Manufacturing hubs
- WHMA and wire harness manufacturing: the A-620 standard, harness BOMs and the ERP problems that followWHMA and wire harness manufacturing: IPC/WHMA-A-620, crimp and cable assembly requirements, and the ERP, BOM and private AI issues harness shops face.
- IPC and its standards: what electronics manufacturers need to know, and the ERP and data work behind themIPC standards explained for electronics manufacturers: IPC-A-610, J-STD-001, IPC-6012 and IPC/WHMA-A-620, plus the ERP, traceability and private AI issues EMS shops face.