Snow is priced per push by depth tier (more snow, higher charge) or as a flat seasonal contract. A depth-to-price table turns a storm’s inches into the per-visit charge.
The example
$80 base, 5 inches = 1.5x.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | Tier mult | 1.5x |
| 3 | Per push | → $120 |
The formula
The formula:
How it works
How it works:
- Build a depth tier table: inches band → price multiplier (sorted ascending).
- VLOOKUP the storm’s inches (approximate match) for the multiplier.
- Multiply the base push price for the per-visit charge.
- A seasonal contract trades per-push billing for a flat fee — compare expected pushes.
Per-push vs seasonal is a risk trade. Per-push (with depth tiers) bills for exactly what falls — great in a heavy winter, lean in a mild one. A seasonal flat fee gives you predictable revenue and the client a predictable cost, but you carry the weather risk. Estimate expected pushes × average per-push price and compare to the seasonal number before quoting either; the depth-tier table makes the per-push side precise.
Try it: interactive demo
Base push price and snow depth.
Variations
Seasonal break-even
Pushes to match flat:
Expected season cost
Pushes × price:
Flat price per tier
Direct price table:
Pitfalls & errors
Approximate match. Depth bands need TRUE and a sorted table.
Per-push vs seasonal. Compare expected pushes before choosing.
Define bands. Set clear inch ranges so billing isn’t disputed.
Practice workbook
Frequently asked questions
How do I price snow removal per push in Excel?
How many pushes match a seasonal fee?
Per-push or seasonal — which is better?
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