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.
| Item | Alloy | Bars | Diameter (mm) | Bar length (mm) | Density (kg/m3) | Price per kg | 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 |
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.
Related Tools
Steel Plate Cut List Weight Worksheet
Fill a cut list row by row and get piece weight, line weight and total order weight for plate, sheet and flat parts.
Supply Chain & InventoryPlate Order Weight, Freight and Truckload Calculator
Work out total weight, material cost, freight and number of truckloads for an order of steel or aluminum plates.
Engineering & PLMMaterial Substitution Request Form Template
Record why a material grade is being replaced, compare properties and capture engineering and quality approval.
Quality & InspectionMaterial Certificate of Conformance Template
Generate a material CoC with purchase order, specification, heat lot, test results and a signed statement of conformance.
More Supply Chain & Inventory tools
See all- Carbide Insert Inventory and Reorder Worksheet
- 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
Keep exploring
Free tools
- Steel and Aluminum Plate and Bar Weight CalculatorWeight and material cost of plate, round bar, square bar and hex bar in common metals, with kg per metre and a thickness sweep chart.
- Bar Stock Yield and Material Cost per Part CalculatorWork out how many parts come from each bar after cutoff and end loss, how many bars to buy, and the true material cost per part.
- CNC Material Blank Cost CalculatorSize the blank from the finished part and stock allowance, then cost it from bar length, saw kerf, end drop and chip scrap credit.
Guides
- Bar Stock Cost Estimating for Screw Machine and Swiss PartsEstimate bar stock cost for screw machine and Swiss parts: bar length, remnant, cutoff kerf, face-off, mill minimums and yield per bar, with ERP tips.
- How to Quote Swiss-Type Turned Parts Without Losing MarginHow to quote Swiss-type turned parts: cycle time, bar stock, setup amortization, secondary ops and quantity breaks, plus where AI can draft the quote for you.
- How to Quote Custom Compression Springs From a PrintHow spring makers estimate a custom compression spring quote: wire length, weight, coiler setup, run rate, secondary ops and scrap, plus where AI helps.