How do you calculate rubber compound cost?

Multiply the batch weight by the compound's price per kg and add the mixer setup charge; divide by the usable compound after mixing scrap for the cost per usable kg. 500 kg at 3.80 a kg plus 180 of setup is 2,080; at 94% yield 470 kg is usable, 4.43 a kg, the Rubber Compound Cost calculator's own example.

How do you price a compound from its phr recipe?

Multiply each ingredient's phr by its price per kg, add them up and divide by the total phr. 100 phr of polymer at 2.00 and 50 phr of filler at 1.00 is 250 over 150 phr, 1.67 a kg.

Why does the price split by ingredient type matter?

It shows what drives each compound's price. In most compounds the polymer is the largest part even when fillers and oils make up most of the weight, so a polymer price change moves the compound price most.

Why do small batches cost more per kg?

The setup charge is the same for a small batch as a large one, so it is spread over fewer kilograms. 180 over a 150 kg batch is 1.20 a kg before yield; over 800 kg it is 0.23.

What does mixing yield change?

Only usable compound can be moulded, so the whole batch cost falls on what survives mixing scrap. At 86% yield every usable kilogram carries 16% more cost than at 100%.

Does the workbook use macros?

No. It is a plain .xlsx with ordinary formulas, tables and native charts. The Verify sheet re-checks the formulas against a fixed test recipe and batches and shows Self-check: PASS.

Industry Cost Kits

Rubber Compound Cost Excel Template

Compound price per kg = Σ (phr × ingredient price) ÷ total phr, and batch cost per usable kg = (batch kg × price per kg + mixer setup) ÷ (batch kg × mixing yield). Price every compound from its recipe, cost every mixed batch, and see which batches run above their target.

Free, and a plain .xlsx with no macros to enable. A CSV with live formulas and a printed how-to guide come with it.

Overview

This rubber compound cost template is a working Excel workbook for rubber compounders, mixing room managers, estimators and cost accountants. Each compound's recipe is written in parts per hundred rubber on the Recipes sheet, and the ingredient prices on Setup turn it into a blended price per kg, split by polymer, filler, oil and plasticiser, cure system and other. Each mixed batch is a row with its compound, weight, the yield of usable compound after mixing scrap and the mixer setup charge; the workbook gives its cost per usable kg against the compound's target. It ships with five compounds from fourteen ingredients and ten batches at a fictional custom mixer, so every tile and chart is filled in when you open it.

In the example the EPDM seal compound is 329 phr: 100 of EPDM at 3.40 a kg diluted by 150 of filler and 70 of oil to a blended 1.79 a kg, more than half of it polymer. An 800 kg batch at 96% yield with a 180 setup costs 2.10 per usable kg, under its 2.15 target; a 150 kg sample batch of the same compound carries the same setup on far less compound and costs 3.22. An NBR batch that ran hot and was partly scrapped yielded 86% and cost 3.34 per usable kg against a 3.10 target.

Mixing energy, labour and overhead are only in the batch cost if you include them in the setup charge. The download is a plain .xlsx with no macros. A CSV with live formulas is also included for other tools; the recipes, dashboard, charts, dropdowns and self-check are in the .xlsx.

What this template includes

Setup sheet with your plant, currency and near band, the ingredients with their type and price per kg, and the compounds with their target cost per usable kg, total phr and blended price
Recipes table, one row per compound and ingredient: phr, with the ingredient's type, price and phr-weighted cost, and a Check column
Batches table, one row per mixed batch: date, compound, batch weight, mixing yield and setup charge; per batch the blended price, material and total cost, usable kg, cost per usable kg and a status in words
Dashboard with four tiles (batches, compound mixed, batch cost, batches above target), what each compound's price per kg is made of by ingredient type, cost per usable kg against target by batch, and the compound and batch tables
Method sheet with every formula, and a Verify sheet that re-checks the formulas against an independent reference and the Rubber Compound Cost calculator (Self-check: PASS)
CSV with live formulas for the Batches table; the recipes, dashboard, charts, dropdowns and self-check are in the .xlsx

Suggested use case

Use it to price rubber compounds from their formulations when ingredient prices move, to cost mixed batches for quotes and margin checks, or to see what small batches and mixing scrap add to the cost of usable compound.

How to use it

On Setup, type your plant and currency, list your ingredients with their type and price per kg, and your compounds with their target cost per usable kg.
On Recipes, give each compound's ingredients a row with their phr.
On Batches, give each mixed batch a row: compound, batch weight, mixing yield and setup charge. Fix anything the Check columns name.
Open the Dashboard: what each compound's price is made of, and every batch's cost per usable kg against target.

Frequently Asked Questions

How do you calculate rubber compound cost?: Multiply the batch weight by the compound's price per kg and add the mixer setup charge; divide by the usable compound after mixing scrap for the cost per usable kg. 500 kg at 3.80 a kg plus 180 of setup is 2,080; at 94% yield 470 kg is usable, 4.43 a kg, the Rubber Compound Cost calculator's own example.
How do you price a compound from its phr recipe?: Multiply each ingredient's phr by its price per kg, add them up and divide by the total phr. 100 phr of polymer at 2.00 and 50 phr of filler at 1.00 is 250 over 150 phr, 1.67 a kg.
Why does the price split by ingredient type matter?: It shows what drives each compound's price. In most compounds the polymer is the largest part even when fillers and oils make up most of the weight, so a polymer price change moves the compound price most.
Why do small batches cost more per kg?: The setup charge is the same for a small batch as a large one, so it is spread over fewer kilograms. 180 over a 150 kg batch is 1.20 a kg before yield; over 800 kg it is 0.23.
What does mixing yield change?: Only usable compound can be moulded, so the whole batch cost falls on what survives mixing scrap. At 86% yield every usable kilogram carries 16% more cost than at 100%.
Does the workbook use macros?: No. It is a plain .xlsx with ordinary formulas, tables and native charts. The Verify sheet re-checks the formulas against a fixed test recipe and batches and shows Self-check: PASS.