How do you calculate fastener cost per assembly?

Multiply the fasteners consumed (per assembly × assemblies + any extra) by the price per piece, add fixed handling, and divide by the assemblies. 36 per assembly on 100 assemblies plus 108 extra at 0.18 with 12 of handling is 679.44, 6.79 an assembly, the Fastener Cost per Assembly calculator's own example.

How are extra pieces worked out?

Pieces issued to the line minus the standard: pieces per assembly × assemblies built. They are the fasteners dropped, cross-threaded, scrapped with rework or miscounted.

What loss allowance should I use?

One that reflects your process and how you feed fasteners: bulk bins lose more than kitted or auto-fed ones. The example uses 2.5%; lines above it are worth a look at the station before the loss is built into the standard.

Why does cost per assembly matter for cheap parts?

Many go into each product. The cabinet in the example carries 96 fasteners costing 14.73 an assembly, and the extra pieces alone add 0.51.

Does it include the labour to fit them?

No. It is the material and handling cost of the fasteners. Fitting time belongs in the labour cost of the assembly.

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 lines and shows Self-check: PASS.

Manufacturing Cost and Quoting

Fastener Cost per Assembly Excel Template

Fastener cost per assembly = (pieces issued × price per piece + fixed handling) ÷ assemblies built. List every fastener on every product with the pieces actually issued, and see the extra pieces consumed beyond the bill of materials, the loss rate against your allowance, and what fasteners cost each finished assembly.

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 fastener cost per assembly template is a working Excel workbook for cost and manufacturing engineers, production managers and buyers. Each fastener on each product is one row with the pieces per assembly from the bill of materials, the assemblies built in the period, the pieces issued to the line from stores or kanban records, and any fixed sourcing, kitting or vendor-managed inventory charge; each fastener's price comes from Setup. The workbook gives the standard pieces, the extra pieces consumed, the loss rate against your allowance, the line's total, standard and extra cost and its cost per assembly, then totals each product and each fastener. It ships with eight fastener lines on three products at a fictional enclosure maker, so every tile and chart is filled in when you open it.

In the example a cabinet takes 36 M6 bolts; 100 cabinets should use 3,600, but 3,708 were issued. At 0.18 a piece with 12 of handling that is 679.44, 6.79 a cabinet, and the 108 extra bolts are a 3% loss against a 2.5% allowance. Cage nuts dropped behind the rails run at 5%, and rivets on the panel line at 3% from gun misfeeds. Fasteners cost each cabinet 14.73; across 750 assemblies extra pieces cost 73.82 of the 3,032.82 total.

Issues must match the assemblies built; work in progress at the line distorts short periods. The download is a plain .xlsx with no macros. A CSV with live formulas is also included for other tools; the dashboard, charts, dropdowns and self-check are in the .xlsx.

What this template includes

Setup sheet with your company, currency and loss allowance, the products, and the fasteners with their price per piece
Lines table, one row per fastener on each product: quantity per assembly, assemblies built, pieces issued and fixed sourcing and handling, with a Check column
Per line: standard pieces, extra pieces, loss rate, a status in words, total, standard and extra cost, and cost per assembly
Dashboard with four tiles (assemblies, fastener cost, cost of extra pieces, lines over the allowance), cost per assembly by product split into standard, extra and handling, loss rate by fastener against the allowance, and the product and fastener tables
Method sheet with every formula, and a Verify sheet that re-checks the formulas against an independent reference and the Fastener Cost per Assembly calculator (Self-check: PASS)
CSV with live formulas for the Lines table; the dashboard, charts, dropdowns and self-check are in the .xlsx

Suggested use case

Use it to put a true fastener cost into standard costs and quotes, to find the stations and fasteners losing the most pieces, or to check a feed system or kitting change.

How to use it

On Setup, type your company, currency and loss allowance, and list your products and your fasteners with their price per piece.
On Lines, give each fastener on each product a row: quantity per assembly, assemblies built, pieces issued and any fixed sourcing and handling.
Fix anything the Check column names.
Open the Dashboard: cost per assembly by product, and the fasteners losing more than the allowance.

Frequently Asked Questions

How do you calculate fastener cost per assembly?: Multiply the fasteners consumed (per assembly × assemblies + any extra) by the price per piece, add fixed handling, and divide by the assemblies. 36 per assembly on 100 assemblies plus 108 extra at 0.18 with 12 of handling is 679.44, 6.79 an assembly, the Fastener Cost per Assembly calculator's own example.
How are extra pieces worked out?: Pieces issued to the line minus the standard: pieces per assembly × assemblies built. They are the fasteners dropped, cross-threaded, scrapped with rework or miscounted.
What loss allowance should I use?: One that reflects your process and how you feed fasteners: bulk bins lose more than kitted or auto-fed ones. The example uses 2.5%; lines above it are worth a look at the station before the loss is built into the standard.
Why does cost per assembly matter for cheap parts?: Many go into each product. The cabinet in the example carries 96 fasteners costing 14.73 an assembly, and the extra pieces alone add 0.51.
Does it include the labour to fit them?: No. It is the material and handling cost of the fasteners. Fitting time belongs in the labour cost of the assembly.
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 lines and shows Self-check: PASS.