# Foundry Charge Makeup and Cost Worksheet

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

## Short answer

Plan a charge from returns, pig iron, scrap and additions and see total weight, cost per kg and the carbon contribution of the mix.

## Category

cost-finance

## Industry

Foundry

## Audience

- Foundry metallurgist
- Melt deck supervisor
- Cost accountant

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Charge material

**Key:** material

**Type:** text

#### Type

**Key:** source

**Type:** select

**Options:**

- Returns
- Pig iron
- Steel scrap
- Purchased scrap
- Ferroalloy
- Carburizer

#### Weight

**Key:** weight

**Type:** number

**Unit:** kg

#### Cost per kg

**Key:** cost_kg

**Type:** number

**Format:** currency

#### Extended cost

**Key:** ext

**Type:** number

**Expr:** weight * cost_kg

**Format:** currency

#### Carbon content

**Key:** carbon

**Type:** number

**Unit:** percent

#### Carbon added

**Key:** c_kg

**Type:** number

**Expr:** weight * carbon / 100

**Format:** decimal

**Help:** Kilograms of carbon in the charge item

**Rows:**

**Material:** Foundry returns (ductile)

**Source:** Returns

**Weight:** 2400

**Cost kg:** 0.18

**Carbon:** 3.6

**Material:** Sorel pig iron

**Source:** Pig iron

**Weight:** 1200

**Cost kg:** 0.72

**Carbon:** 4.2

**Material:** Clean steel scrap

**Source:** Steel scrap

**Weight:** 2000

**Cost kg:** 0.34

**Carbon:** 0.2

**Material:** Graphite carburizer

**Source:** Carburizer

**Weight:** 60

**Cost kg:** 1.1

**Carbon:** 98

**Material:** FeSi 75

**Source:** Ferroalloy

**Weight:** 55

**Cost kg:** 1.65

**Carbon:** 0.1

**Totals:**

#### Total charge weight

**Key:** weight

**Agg:** sum

**Format:** number

#### Total charge cost

**Key:** ext

**Agg:** sum

**Format:** currency

#### Total carbon

**Key:** c_kg

**Agg:** sum

**Format:** decimal

**Summary:**

#### Charge cost per kg

**Key:** cost_per_kg

**Expr:** sum_ext / sum_weight

**Format:** currency

**Primary:** true

#### Charge carbon, percent of weight

**Key:** charge_c

**Expr:** sum_c_kg / sum_weight * 100

**Format:** decimal

**Notes:** Charge carbon is before melting losses and pickup. Real carbon in the bath depends on practice, so use this to compare mixes, then confirm with a spectrometer sample. Costs per kg are examples.

## Content

**Intro:** Charge makeup sets the cost and the starting chemistry of every melt. This worksheet lets you try returns, pig iron, scrap and additions and see cost per kg and carbon content before you load the furnace.

**Sections:**

#### How to use this worksheet

**Body:** Replace the sample rows with the materials you actually stock. Enter weight and cost per kg for each, and the carbon percent. The sheet totals weight and cost, then shows cost per kg and the carbon content of the mix. Change the proportion of returns against purchased material to see how the cost moves. Export to Excel to keep a library of standard charges per alloy.

#### The method

**Body:** Cost per kg is total extended cost divided by total weight. Carbon contribution is the sum of weight times carbon percent for each material, divided by total weight. This is a simple weighted average. It ignores melt loss, oxidation of silicon and manganese, and carbon pickup or burn off, so treat it as a planning figure and confirm with the furnace sample.

#### Returns and cost

**Body:** Returns from gates, risers and scrapped castings are the cheapest metal in the building, but a high share can accumulate trace elements and gas. Many foundries limit returns in critical grades such as ductile iron. Compare a high returns mix to a high pig iron mix on cost and on risk to nodularity and chemistry control.

#### Common mistakes

**Body:** Do not forget to include ferroalloys and carburizer, which add cost out of proportion to weight. Do not use stale prices. Do not compare charges at the same cost per kg without comparing yield, since a cheap charge with high loss may cost more per good casting.

**Cta:** If material costs and lots live in an ERP, Netray can help compare planned charges against actual consumption privately on your servers.

**Faq:**

#### Does this account for melt loss?

**Answer:** No. It shows the charge as loaded. Apply your melt loss percentage separately, or use it to compare the relative cost of mixes before applying the same loss to each.

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

**Answer:** The cost math works for any alloy. The carbon column is aimed at iron and steel. For other metals, relabel the column to a key element or ignore it.

#### What carbon values should I use?

**Answer:** Use the certificate value for pig iron and carburizer, and your typical analysis for returns. The sample numbers are illustrative only.

#### How do I store standard charges?

**Answer:** Export to Excel and keep one sheet per alloy and furnace, updating prices monthly.

## Search terms

foundry charge calculation excel, furnace charge makeup sheet, cupola charge calculator, induction furnace charge worksheet, melt cost per kg, charge mix cost iron foundry, returns scrap pig iron ratio, foundry metal cost worksheet

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