Supply Chain & InventoryFree worksheetPDF, Excel, Word exportMachining

Round Bar Stock Weight and Material Quote Worksheet

Buyers and machine shops price bar by weight, but drawings and quotes are in diameter and length. This worksheet converts between the two so you can check a supplier quote or plan a stock purchase quickly.

Download:

Weight per bar (kg)	Weight per meter (kg/m)	Extended cost
46.2403	15.4134	$1,064
11.5601	3.8534	$168
32.0442	10.6814	$1,846
22.9022	7.6341	$1,408
16.9646	5.6549	$570

Total bars

Total material cost

$5,055

Average cost per bar

$86

Prices are placeholders. Replace them with your supplier quote. Weight is theoretical for a full round section at the density entered.

Automate bar stock pricing from your ERP

Optional conversation about pulling supplier prices and stock sizes from your ERP into quote sheets.

Optional. The tool and every export work without this. No spam.

How to fill the quote sheet

Add one row per bar item. Enter the number of bars, the diameter and stock length in millimetres, the density of the alloy and the price per kilogram. The worksheet returns weight per bar, weight per meter and extended cost. Replace the example prices with your own and export to Excel to attach it to a purchase request.

Use the actual stock length, commonly 3 or 6 meters
Enter the supplier price per kg, not per piece
Keep cut charges on a separate line
Add a row for each alloy

The math behind bar weight

The cross section of a round bar is pi times the diameter squared divided by four. Multiply by length for volume, and by density for mass. A 50 mm steel bar has an area of about 1963 square mm, so one meter holds 1.963 million cubic mm, or 0.001963 cubic meters, which weighs about 15.4 kg at 7850 kg/m3. The weight per meter column makes quick checks easy against the handbook tables that suppliers publish.

Reading results and avoiding errors

Compare the weight per meter with the supplier table. If they differ by more than a few percent, one of you is using the wrong diameter or density. Remember that cold drawn and ground bar is held to tight diameter tolerances, while hot rolled bar can run over nominal size and weigh more. Price per kg often changes by size and by alloy, so quote each size separately. When you store these values in an ERP, keep the price unit of measure explicit so a per-kg price is never read as a per-bar price.

Verify density for the specific alloy
Check price basis: per kg, per cwt or per piece
Add a rounding allowance for sawing

Frequently Asked Questions

How do I check a supplier bar weight table?

Compute weight per meter with this sheet and compare it to the table for the same diameter and alloy. A match within a percent or two is normal. Larger gaps usually mean a different density or a rounded diameter.

Does it work for hex or square bar?

No, it uses the round section formula. For square bar use side squared times length times density, and for hex bar use the across flats area of about 0.866 times flats squared. Those need a different area term.

What density is used for brass?

Free machining brass such as C36000 is about 8500 kg/m3. Other brasses range roughly from 8400 to 8700, so check your supplier datasheet when accuracy matters.

Why does my invoice weight differ?

Invoices use scale weight, while this sheet gives nominal theoretical weight. Hot rolled bar commonly weighs slightly more than nominal. Also check whether the invoice includes cut ends or packaging.

If you want purchase prices, bar sizes and stock weights pulled straight from your ERP into a sheet like this, we can set that up as a read-only agent.

Talk to an Expert Explore More Free Tools

Related Tools

Discrete Manufacturing

More Supply Chain & Inventory tools

See all

Back to All Tools