Junk haulers price by volume: what fraction of the truck the job fills. Multiply that fraction by your full-load price and you have a fast, fair quote.
A half-truck haul against a $600 full load is $300 — the standard way volume-based haulers quote on the spot.
The example
Three hauls sized as a fraction of a full truck.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Job | Load fraction | Full load | Quote |
| 2 | Half load | 0.50 | $600 | $300 |
| 3 | Quarter load | 0.25 | $600 | $150 |
| 4 | Full load | 1.00 | $600 | $600 |
The formula
Scale the full price by the fill:
How it works
Volume pricing is one multiplication:
B2is how much of the truck the job fills, as a decimal (0.5 = half).C2is what a packed truck costs.- Multiplying scales the full price to the actual load;
ROUNDgives a clean dollar quote.
Have a trip minimum? Floor the quote with =MAX(Minimum,ROUND(B2*C2,0)) so tiny loads still cover the run.
Try it: interactive demo
Enter the load fraction and your full-load price.
Variations
Apply a trip minimum
Never quote below a minimum that covers fuel and labor.
Pitfalls & errors
Enter the fraction as a decimal (0.5), not a percent label, or the price will be off by 100x.
Heavy debris (concrete, dirt) may hit a weight limit before the truck looks full — price those by weight instead.
Practice workbook
Frequently asked questions
How do I estimate the load fraction on site?
What about a trip minimum?
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