How do you calculate connector seating capacity?

Multiply the connectors seated per cycle by the cycles available, then by uptime and first-pass yield. 4 per cycle over 480 cycles is 1,920 gross; at 90% uptime and 97% yield that is 1,676 good connectors, the Connector Seating Capacity calculator's own example.

How are available cycles worked out?

Scheduled hours × 3,600 ÷ cycle time in seconds. 40 hours at a 30 s cycle is 4,800 cycles. Take changeovers and planned stops out of the hours first.

What is the difference between downtime loss and yield loss?

Downtime loss is the output of the hours the station is not seating: gross × (1 − uptime). Yield loss is connectors cycled but not seated right first time: gross × uptime × (1 − yield). The chart shows which one costs each station more.

How many extra hours does a short station need?

The shortfall divided by the station's good output per cycle (connectors per cycle × uptime × yield), times the cycle time. The sealed 4-way press in the example is 287 connectors short: 1.6 hours.

Does first-pass yield include connectors that fail the push-back test?

It should: anything that has to be re-seated or re-terminated is not good first time. Take the rate from your own seating or pull-test records.

Does the workbook use macros?

No. It is a plain .xlsx with ordinary formulas, tables and native charts. The Verify sheet re-checks the formulas against fixed test stations and shows Self-check: PASS.

Production and Throughput

Connector Seating Capacity Excel Template

Good seating capacity = connectors per cycle × available cycles × uptime × first-pass yield. Give every connector seating station a row and see its good capacity for the week against the demand it must cover, what downtime and re-seats cost it, and the extra hours a short station needs.

Free, and a plain .xlsx with no macros to enable. A CSV with live formulas and a printed how-to guide come with it.

Overview

This connector seating capacity template is a working Excel workbook for wire harness production planners, manufacturing engineers and cell leads. Each connector seating or insertion station is one row with its connector family, the connectors it seats per cycle, its scheduled hours and cycle time for the window, its uptime and first-pass seating yield from your records, and the connectors it has to seat. The workbook gives the available cycles, the gross capacity, what downtime and re-seats take from it, the good capacity, how much of it the demand uses, and the extra hours a station needs when it is short. It ships with eight stations planned for a week at a fictional harness maker, so every tile and chart is filled in when you open it.

In the example bench press A seats sealed 2-way connectors four at a time on a 30 s cycle: 4,800 cycles in 40 hours, 19,200 gross and 16,762 good at 90% uptime and 97% yield, so 14,000 connectors load it to 84%. The sealed 4-way press is 4% short of its 7,500 and needs 1.6 more hours. The automatic inserter loses 20,736 connectors to its 88% uptime, far more than the 1,217 lost to re-seats, and runs at 99.4% of its good capacity; the dashboard shows each station's gross capacity as good output and losses so stations of every size compare.

Changeovers between connector families are not modelled; take them out of the hours. The download is a plain .xlsx with no macros. A CSV with live formulas is also included for other tools; the dashboard, charts and self-check are in the .xlsx.

What this template includes

Setup sheet with your plant, the planning window and the near-capacity threshold
Stations table, one row per station: connector family, connectors per cycle, hours, cycle time, uptime, first-pass yield and demand, with a Check column
Per station: available cycles, gross capacity, downtime loss, yield loss, good capacity, load, a status in words, shortfall and extra hours
Dashboard with four tiles (stations, good capacity, demand, stations over capacity), demand as a share of good capacity, the shares of each station's gross capacity that are good output, yield loss and downtime loss, and the station table
Method sheet with every formula, and a Verify sheet that re-checks the formulas against an independent reference and the Connector Seating Capacity calculator (Self-check: PASS)
CSV with live formulas for the Stations table; the dashboard, charts and self-check are in the .xlsx

Suggested use case

Use it to check the week's harness schedule before committing it, to find the seating station that will run short, or to see whether downtime or re-seats cost a station more output.

How to use it

On Setup, type your plant, the planning window and the near-capacity threshold.
On Stations, give each station a row: connector family, connectors per cycle, hours, cycle time, uptime, first-pass yield and demand.
Fix anything the Check column names.
Open the Dashboard: good capacity against demand, and where each station loses output.

Frequently Asked Questions

How do you calculate connector seating capacity?: Multiply the connectors seated per cycle by the cycles available, then by uptime and first-pass yield. 4 per cycle over 480 cycles is 1,920 gross; at 90% uptime and 97% yield that is 1,676 good connectors, the Connector Seating Capacity calculator's own example.
How are available cycles worked out?: Scheduled hours × 3,600 ÷ cycle time in seconds. 40 hours at a 30 s cycle is 4,800 cycles. Take changeovers and planned stops out of the hours first.
What is the difference between downtime loss and yield loss?: Downtime loss is the output of the hours the station is not seating: gross × (1 − uptime). Yield loss is connectors cycled but not seated right first time: gross × uptime × (1 − yield). The chart shows which one costs each station more.
How many extra hours does a short station need?: The shortfall divided by the station's good output per cycle (connectors per cycle × uptime × yield), times the cycle time. The sealed 4-way press in the example is 287 connectors short: 1.6 hours.
Does first-pass yield include connectors that fail the push-back test?: It should: anything that has to be re-seated or re-terminated is not good first time. Take the rate from your own seating or pull-test records.
Does the workbook use macros?: No. It is a plain .xlsx with ordinary formulas, tables and native charts. The Verify sheet re-checks the formulas against fixed test stations and shows Self-check: PASS.