# Foundry Furnace Charge Mix and Cost Worksheet

> Source: https://netray.co/tools/foundry-furnace-charge-mix-cost-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Build a furnace charge row by row and see total weight, cost per kg and the blended carbon and silicon before melt losses.

## Category

industry-templates

## Industry

Foundry and Forging

## Audience

- Foundry metallurgist
- Melt shop supervisor
- Cost accountant

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Charge material

**Key:** material

**Type:** select

**Options:**

- Pig iron
- Foundry returns
- Steel scrap
- Cast iron scrap
- Ferrosilicon 75%
- Carburizer
- Ferromanganese
- Other

#### Weight

**Key:** kg

**Type:** number

**Unit:** kg

#### Cost per kg

**Key:** cost

**Type:** number

**Format:** currency

#### Carbon

**Key:** c_pct

**Type:** number

**Unit:** %

#### Silicon

**Key:** si_pct

**Type:** number

**Unit:** %

#### Extended cost

**Key:** ext

**Type:** number

**Expr:** kg * cost

**Format:** currency

#### Carbon in charge

**Key:** c_kg

**Type:** number

**Expr:** kg * c_pct / 100

**Format:** decimal

**Unit:** kg

#### Silicon in charge

**Key:** si_kg

**Type:** number

**Expr:** kg * si_pct / 100

**Format:** decimal

**Unit:** kg

**Rows:**

**Material:** Pig iron

**Kg:** 200

**Cost:** 0.55

**C pct:** 4.2

**Si pct:** 1.5

**Material:** Foundry returns

**Kg:** 500

**Cost:** 0.22

**C pct:** 3.4

**Si pct:** 2.2

**Material:** Steel scrap

**Kg:** 300

**Cost:** 0.36

**C pct:** 0.3

**Si pct:** 0.25

**Material:** Ferrosilicon 75%

**Kg:** 8

**Cost:** 1.6

**C pct:** 0.1

**Si pct:** 75

**Material:** Carburizer

**Kg:** 6

**Cost:** 1.1

**C pct:** 98

**Si pct:** 0

**Totals:**

#### Total charge weight (kg)

**Key:** kg

**Agg:** sum

**Format:** decimal

#### Total charge cost

**Key:** ext

**Agg:** sum

**Format:** currency

#### Total carbon (kg)

**Key:** c_kg

**Agg:** sum

**Format:** decimal

#### Total silicon (kg)

**Key:** si_kg

**Agg:** sum

**Format:** decimal

**Summary:**

#### Charge cost per kg

**Key:** cost_per_kg

**Expr:** sum_ext / sum_kg

**Format:** currency

**Primary:** true

#### Blended carbon before losses

**Key:** blend_c

**Expr:** sum_c_kg / sum_kg * 100

**Format:** decimal

**Primary:** true

**Description:** Percent. Actual carbon recovery in the melt differs.

#### Blended silicon before losses

**Key:** blend_si

**Expr:** sum_si_kg / sum_kg * 100

**Format:** decimal

**Description:** Percent. Silicon oxidizes in melting; add recovery factors.

**Notes:** Compositions are typical examples, not specifications. Replace them with supplier certificates. The blend ignores melt loss and element recovery, so adjust for your furnace and verify with spectrometer samples before tapping.

## Content

**Intro:** A charge sheet tells the melt crew what to load and tells the cost accountant what it costs. This worksheet keeps weight, price and the main chemistry contributions together so you can see cost per kilogram and the starting blend.

**Sections:**

#### How to use the worksheet

**Body:** Add a row for each charge material, then enter the weight, the price per kilogram, and the carbon and silicon percentages from the supplier certificate or your own analysis. The sheet computes extended cost and the kilograms of carbon and silicon, and then totals the charge. Adjust the carburizer or ferrosilicon to bring the blend near the target before the first spectrometer sample.

**Bullets:**

- Update prices from your latest purchase orders.
- Use measured returns chemistry rather than nominal values.
- Save a version per alloy grade and export to Excel.

#### The method behind it

**Body:** Blended percent for an element is the sum of element kilograms divided by total charge kilograms. Cost per kilogram is total cost divided by total weight. These are mass balances only. Real melts lose silicon and manganese to oxidation and recover carburizer at less than 100 percent, so many foundries use recovery factors per element and furnace type.

#### Reading the result and common mistakes

**Body:** Compare the blended values against the grade specification before melting. If returns are a large share, small drift in their chemistry has a large effect, so test them. Steel scrap lowers cost but also lowers carbon, which then has to be made up with carburizer at a cost.

**Bullets:**

- Treating the blend as the final tap chemistry.
- Using book prices that do not include freight.
- Forgetting that rusty or oily scrap carries lower metal yield.
- Ignoring trace elements such as sulfur and phosphorus.

**Cta:** If charge records and heat chemistry live in spreadsheets, we can discuss tying them to your ERP item costs and lot traceability. The worksheet is free to use as is.

**Faq:**

#### Does this replace a charge calculation program?

**Answer:** No. It is a mass-balance sheet for cost and starting chemistry. Dedicated melt control systems also model element recovery, slag and furnace specifics. The worksheet is useful for quick comparisons and for documenting a standard charge.

#### Why is silicon different from the final analysis?

**Answer:** Silicon oxidizes and joins the slag during melting, so recovery is below 100 percent, especially in long holds or cupolas. Foundries apply a recovery factor from their own history. Use spectrometer results to calibrate.

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

**Answer:** The structure works for any alloy, but change the columns you track. Steel foundries often track carbon, manganese and chromium, and aluminum foundries track silicon and magnesium. Edit the example rows with your own data.

#### How do I handle returns cost?

**Answer:** Many foundries cost returns at a transfer value near scrap or at remelt cost, since the metal was already paid for. Pick a method your cost accountant agrees to and keep it consistent so grade costs can be compared.

## Search terms

foundry charge calculation excel, furnace charge mix worksheet, cupola charge calculation, induction furnace charge sheet, gray iron charge make up, charge cost per kg foundry, foundry melt charge template, charge material cost worksheet

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