Junk Removal: Disposal Cost from Weight

Excel Formulas › Junk Removal

All versions

The landfill charges by the ton; the scale ticket reads in pounds. Divide by 2,000 and multiply by the tipping rate to know what every load costs to dump.


Quick formula: Pounds over 2,000, times the per-ton rate:
=B2/2000*C2

An 1,800 lb garage cleanout at a $60/ton tipping fee costs $54 to dump — a cost your price has to clear.

Functions used (tap for the full reference guide):

The example

Three loads, each with a scale weight and the facility's per-ton rate.

ABCD
1JobWeight (lb)$ / tonDisposal cost
2Garage cleanout1,800$60$54.00
3Renovation debris4,500$60$135.00
4Yard waste900$40$18.00

The formula

Convert first, then price:

=B2/2000*C2 // pounds to tons, then x tipping rate

How it works

Units drive the formula:

  1. B2 is the load weight in pounds, straight off the scale ticket.
  2. /2000 converts pounds to US tons, which is how the landfill bills.
  3. *C2 applies the facility's tipping rate per ton.

Yard waste, clean concrete, and mixed C&D often have different rates — keep a rate per material column.

Try it: interactive demo

Interactive

Enter the scale weight and the landfill's per-ton rate.

Variations

Facility minimum fee

Many transfer stations bill a minimum no matter how light the load.

=MAX(MinFee,B2/2000*C2)

Disposal as percent of job price

Track what share of each job the dump takes.

=(B2/2000*C2)/JobPrice

Pitfalls & errors

Metric tons are 2,204.6 lb — if your facility bills metric, the /2000 shortchanges the math by 10%.

Weigh in and out (gross minus tare) — pricing off the truck's gross weight bills your own vehicle as junk.

Practice workbook

📊
Download the free Junk Removal: Disposal Cost from Weight practice workbook
Edit the yellow Weight and $ / ton cells; the Disposal cost recalculates.

Frequently asked questions

What is a typical tipping fee?
US landfill tipping fees commonly run $40–$80 per ton and vary by region and material. Plug in your facility's posted rate.
How does this feed my pricing?
Disposal is one of three legs — labor, truck, dump. Price each load so the tipping cost plus labor still leaves your margin.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related formulas: Junk Removal: Truckload Pricing · Junk Removal: Truck Fill Percent · Cost per Mile

Function references: QUOTIENT