# Forging Part Family Input Weight and Yield Worksheet

> Source: https://netray.co/tools/forging-part-family-input-weight-and-yield-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Calculate input weight, yield and annual material pounds and cost for a family of forged parts using flash, scale and bar-end loss assumptions per part.

## Category

engineering-plm

## Industry

Forging

## Audience

- Forging engineer
- Estimator
- Buyer

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Part number

**Key:** part

**Type:** text

#### Material

**Key:** mat

**Type:** select

**Options:**

- 1045
- 4140
- 4340
- 8620
- 304 SS
- 6061 Al
- Ti-6Al-4V

#### Finished forging weight

**Key:** fin_wt

**Type:** number

**Unit:** lb

#### Annual quantity

**Key:** qty

**Type:** number

**Unit:** pcs

#### Flash and trim allowance

**Key:** flash

**Type:** number

**Unit:** % of forging

#### Scale loss

**Key:** scale

**Type:** number

**Unit:** % of heated billet

#### Saw kerf and bar-end loss

**Key:** endloss

**Type:** number

**Unit:** % of billet

#### Bar price

**Key:** price

**Type:** number

**Format:** currency

**Unit:** $/lb

#### Billet weight

**Key:** billet_wt

**Type:** number

**Expr:** fin_wt * (1 + flash / 100) / (1 - scale / 100)

**Format:** decimal

**Unit:** lb

#### Stock weight per piece

**Key:** stock_wt

**Type:** number

**Expr:** fin_wt * (1 + flash / 100) / (1 - scale / 100) * (1 + endloss / 100)

**Format:** decimal

**Unit:** lb

#### Material yield

**Key:** yield

**Type:** number

**Expr:** 100 / ((1 + flash / 100) / (1 - scale / 100) * (1 + endloss / 100))

**Format:** percent

#### Finished pounds per year

**Key:** fin_lb

**Type:** number

**Expr:** fin_wt * qty

**Format:** number

#### Stock pounds per year

**Key:** annual_lb

**Type:** number

**Expr:** qty * fin_wt * (1 + flash / 100) / (1 - scale / 100) * (1 + endloss / 100)

**Format:** number

#### Annual material cost

**Key:** annual_cost

**Type:** number

**Expr:** price * qty * fin_wt * (1 + flash / 100) / (1 - scale / 100) * (1 + endloss / 100)

**Format:** currency

**Rows:**

**Part:** FG-1021 connecting rod

**Mat:** 4340

**Fin wt:** 4.2

**Qty:** 18000

**Flash:** 12

**Scale:** 2

**Endloss:** 2.5

**Price:** 0.78

**Part:** FG-1044 flange

**Mat:** 1045

**Fin wt:** 7.8

**Qty:** 9000

**Flash:** 10

**Scale:** 2

**Endloss:** 2

**Price:** 0.62

**Part:** FG-2010 pinion blank

**Mat:** 8620

**Fin wt:** 2.6

**Qty:** 40000

**Flash:** 15

**Scale:** 2

**Endloss:** 3

**Price:** 0.74

**Part:** FG-3305 valve body

**Mat:** 304 SS

**Fin wt:** 11.5

**Qty:** 3000

**Flash:** 14

**Scale:** 1.2

**Endloss:** 2

**Price:** 2.35

**Part:** FG-4107 bracket

**Mat:** 6061 Al

**Fin wt:** 1.9

**Qty:** 25000

**Flash:** 18

**Scale:** 0.5

**Endloss:** 3

**Price:** 1.85

**Totals:**

#### Finished pounds per year

**Key:** fin_lb

**Agg:** sum

**Format:** number

#### Stock pounds per year

**Key:** annual_lb

**Agg:** sum

**Format:** number

#### Annual material cost

**Key:** annual_cost

**Agg:** sum

**Format:** currency

**Summary:**

#### Weighted material yield

**Key:** overall_yield

**Expr:** sum_fin_lb / sum_annual_lb * 100

**Format:** percent

**Primary:** true

#### Annual pounds lost to flash, scale and bar ends

**Key:** loss_lb

**Expr:** sum_annual_lb - sum_fin_lb

**Format:** number

#### Average material cost per finished pound

**Key:** cost_lb

**Expr:** sum_annual_cost / sum_fin_lb

**Format:** decimal

**Notes:** Flash percentages and scale loss in the example rows are illustrative only. Take flash from the die design, scale from your heating method (induction usually gives less than gas fired) and bar-end loss from your sawing practice. Flash is usually remelted by the mill as scrap, not returned to you, so treat it as a real cost.

## Content

**Intro:** Material is the largest cost on most forgings, and it is set by how much steel has to be heated to make a pound of finished part. This worksheet applies flash, scale and bar-end losses to each part, then rolls up annual pounds, yield and cost for the whole family.

**Sections:**

#### How to use the worksheet

**Body:** Enter the finished forging weight, annual quantity and bar price for each part. Then add the losses specific to that part: flash and trim allowance as a percentage of the forging weight, scale loss as a percentage of the heated billet, and saw kerf and bar-end loss as a percentage of the billet. The worksheet computes billet weight, stock weight per piece, yield, annual stock pounds and annual cost. Use it to compare designs, to set purchase quantities with your mill, or to see how a switch from gas to induction heating changes yield.

#### The method

**Body:** The forging must be heavier than the finished part by the flash that is trimmed away, so the forging weight including flash is the finished weight times one plus the flash fraction. Scale forms during heating and falls off, so the billet that goes into the furnace must be heavier by dividing by one minus the scale fraction. Bar-end and saw kerf add a final percentage on the billet. Material yield is the inverse of the combined factor. Annual cost is stock weight times quantity times bar price.

**Bullets:**

- Billet weight = finished weight x (1 + flash) / (1 - scale)
- Stock weight = billet weight x (1 + bar-end loss)
- Yield = finished weight / stock weight

#### Reading the result and common mistakes

**Body:** Yields in the 70 to 85 percent range are typical for closed die work on steel, and lower for complex shapes with heavy flash. Check any part far from the family average. Common errors include applying scale to the finished weight instead of the billet, forgetting bar-end loss when bars are cut to exact multiples, and using the same flash allowance for every shape. Another is ignoring that stainless and titanium lose less to scale but cost much more per pound, so a small yield gain has a big dollar effect.

**Cta:** If you want billet requirements and yields calculated from your BOMs and mill orders, we can connect this to your ERP on your own servers.

**Faq:**

#### What is a normal scale loss for steel forging?

**Answer:** Scale loss depends on temperature, time in the furnace and atmosphere. Induction heating generally gives lower loss than gas fired furnaces because of shorter heating time. Many shops use a figure of a few percent of billet weight; measure it from your own weigh-backs.

#### How is flash allowance determined?

**Answer:** Flash is set by die design: the gutter and land geometry control how much material escapes at the parting line. The die designer or process engineer should give the expected flash weight, which you convert to a percentage of the forging weight.

#### Can I use this for aluminum or titanium?

**Answer:** Yes. Set lower scale loss values and adjust the bar price. Aluminum and titanium have different flash and trim behavior, so use your own die data. The same formulas apply to any hot forged material.

#### Why is yield not the same as one minus scrap?

**Answer:** Yield here describes material that ends up in the finished part, so flash, scale and bar ends all count as loss. It is not the same as quality scrap, which is parts rejected after forging and should be added separately in costing.

## Search terms

forging input weight calculation, forging material yield, billet weight with flash and scale, forging scale loss percentage, forging stock weight calculator excel, annual forging steel requirement, forging flash percentage, forging material cost worksheet

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json