Tree Service: Stump Grinding Price

Excel Formulas › Tree Service

All versions

Stump grinding is priced by the inch of diameter, but small stumps still have to cover the trailer trip. MAX keeps every quote at or above your minimum charge.


Quick formula: Diameter times your per-inch rate, floored at the minimum:
=MAX(D2,B2*C2)

A 24-inch oak at $5 per inch quotes $120; a 12-inch maple computes $60 but bills the $100 minimum.

Functions used (tap for the full reference guide):

The example

Three stumps, each with a diameter, per-inch rate, and your job minimum.

ABCDE
1StumpDiameter (in)$ / inchMinimumPrice
2Oak stump24$5.00$100$120.00
3Small maple12$5.00$100$100.00
4Big cottonwood40$5.50$100$220.00

The formula

MAX picks whichever is larger — the computed price or the minimum:

=MAX(D2,B2*C2) // floor the per-inch price at the minimum

How it works

Two candidate prices, and the bigger one wins:

  1. B2*C2 is the measured price: diameter in inches times your per-inch rate.
  2. D2 is the minimum charge that covers travel and setup.
  3. MAX returns the larger of the two, so small stumps never underprice the trip.

Measure diameter at ground level, widest point — that is what the grinder actually chews through.

Try it: interactive demo

Interactive

Enter the stump diameter, per-inch rate, and your minimum.

Variations

Multiple stumps, one trip

Sum the per-inch prices, then apply one job minimum to the total.

=MAX(Minimum,SUM(PriceRange))

Surcharge for hard access

Add a flat fee when the grinder cannot reach the stump directly.

=MAX(D2,B2*C2)+AccessFee

Pitfalls & errors

Measure at the ground, not waist height — stumps flare at the base and the flare is what you grind.

For multi-stump jobs, apply the minimum once to the job total, not to every stump, or you will overquote and lose the job.

Practice workbook

📊
Download the free Tree Service: Stump Grinding Price practice workbook
Edit the yellow Diameter, $ / inch, and Minimum cells; the Price recalculates.

Frequently asked questions

What does grinding cost per inch?
Rates commonly run $3–$7 per inch of diameter depending on region and access. The formula works with whatever rate you plug in.
How deep does the price assume?
Standard grinds go 4–6 inches below grade. Charge extra for deeper grinds or surface roots — add a flat cell for it.

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: Snow Plow Pricing · Towing: Storage Fee Total · Pressure Washing: Job Quote

Function references: MAX