How do you calculate liquid asphalt usage?

Multiply the mix tons by the binder content per ton, then divide by the pump and transfer efficiency. 1,250 tons at 12.5 gal per ton is 15,625 gal in the mix; at 98% efficiency the tank must supply 15,625 / 0.98 = 15,944 gal, the calculator's own example, with a 319 gal transfer allowance.

Where does the binder content per ton come from?

From your approved mix design: the binder content by weight of mix, net of any binder from recycled asphalt, converted to gallons or litres per ton with the binder's density. The workbook holds no typical contents; the example values are invented.

What transfer efficiency should I use?

Your own: binder that went into the mix divided by binder drawn from the tank, from your tank gauge and production reconciliation over a period. Polymer-modified binders often need longer line flushes; the example uses 97% for them and 98% for the rest.

How does the tank status work?

For each binder grade the workbook adds the binder every run needs and compares it with the inventory you typed: Under capacity at 90% or less of the tank, Near capacity up to 100%, Over capacity above it. Deliveries during the plan are not added, so Over capacity means a delivery must arrive before you run out.

Can I use litres and tonnes?

Yes. Choose L and tonne on Setup and type binder contents per tonne, prices per litre and inventories in litres. The units are labels: nothing is converted, so keep every value in the same units.

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 fixed test runs and shows Self-check: PASS.

Industry Cost Kits

Asphalt Binder Usage Excel Template

Liquid asphalt required = mix tons × binder content ÷ pump and transfer efficiency. Plan every production run from your mix designs and see the binder it needs, what it costs, and by binder grade whether the tanks hold enough for the plan.

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 asphalt binder usage template is a working Excel plan for asphalt plant managers, operators, QC technicians and purchasing staff. Every production run is one row with its mix and tons; the binder content comes from the mix design and the price and tank inventory from the binder grade. It ships with a fictional plant's two-week plan of four mixes on three binder grades, so every tile and chart is filled in when you open it.

In the example 19 runs make 16,140 tons of mix and need 205,632 gallons of liquid asphalt, 671,963 of binder or 41.63 per ton of mix. The polymer-modified PG 76-22 surface mix needs 56,388 gallons against 45,000 in its heated tank, so the plan is Over capacity on that grade and a delivery must land before the second week; PG 58-28 uses 94% of its tank and is Near capacity.

Each run agrees with the Liquid Asphalt Binder Usage calculator. The download is a plain .xlsx with no macros. A CSV with live formulas is also included for other tools; the dashboard, charts, dropdowns and self-check are in the .xlsx.

What this template includes

Runs table, one row per production run or job: date, job, mix, mix tons and transfer efficiency, with a Check column
Per run: binder grade, binder content and price looked up from Setup, theoretical binder, liquid asphalt required, transfer allowance, binder cost and binder cost per ton of mix
Setup lists of mix designs (binder grade and binder content per ton) and binder grades (price and inventory in the tanks), with gallon or litre and ton or tonne labels
Dashboard with four tiles (liquid asphalt required, binder cost, mix tons, grades short of inventory), binder required against inventory by grade, binder by day, and tables by grade, mix and day with a tank status in words
Method sheet with every formula, and a Verify sheet that re-checks the formulas against an independent reference and the Liquid Asphalt Binder Usage calculator (Self-check: PASS)
CSV with live formulas for the Runs table; the dashboard, charts, dropdowns and self-check are in the .xlsx

Suggested use case

Use it to plan binder orders for the coming weeks of production, to check a polymer-modified contract against the heated tank, or to cost binder per ton of mix for bids.

How to use it

On Setup, type your plant, currency and units.
List your mix designs with their binder grade and binder content per ton, and your binder grades with their delivered price and the inventory in the tanks.
On Runs, add one row per production run or job: date, job, mix, mix tons and transfer efficiency.
Fix anything the Check column names.
Open the Dashboard: binder required against the tanks by grade, binder cost and the binder needed each day.

Frequently Asked Questions

How do you calculate liquid asphalt usage?: Multiply the mix tons by the binder content per ton, then divide by the pump and transfer efficiency. 1,250 tons at 12.5 gal per ton is 15,625 gal in the mix; at 98% efficiency the tank must supply 15,625 / 0.98 = 15,944 gal, the calculator's own example, with a 319 gal transfer allowance.
Where does the binder content per ton come from?: From your approved mix design: the binder content by weight of mix, net of any binder from recycled asphalt, converted to gallons or litres per ton with the binder's density. The workbook holds no typical contents; the example values are invented.
What transfer efficiency should I use?: Your own: binder that went into the mix divided by binder drawn from the tank, from your tank gauge and production reconciliation over a period. Polymer-modified binders often need longer line flushes; the example uses 97% for them and 98% for the rest.
How does the tank status work?: For each binder grade the workbook adds the binder every run needs and compares it with the inventory you typed: Under capacity at 90% or less of the tank, Near capacity up to 100%, Over capacity above it. Deliveries during the plan are not added, so Over capacity means a delivery must arrive before you run out.
Can I use litres and tonnes?: Yes. Choose L and tonne on Setup and type binder contents per tonne, prices per litre and inventories in litres. The units are labels: nothing is converted, so keep every value in the same units.
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 fixed test runs and shows Self-check: PASS.