Knowing the chemical cost per stop — each chemical’s typical amount times its unit cost — keeps a route profitable and flags pools that consume more than they should.
The example
Chlorine, acid, conditioner.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | Σ amount × cost | $5.10 |
| 3 | per stop | → $5.10 |
The formula
The formula:
How it works
How it works:
- List each chemical with its typical per-stop amount and unit cost.
- SUMPRODUCT(amounts, unit_costs) totals the per-stop chemical cost.
- Average across stops for a route chemical cost to fold into pricing.
- A pool that consumes far above average may have a leak, heavy use, or a chemistry problem.
Educational use only — not chemical-safety or professional advice. Pool chemical dosing varies by product strength, water chemistry, and local rules. Always follow the product label, add chemicals to water (never water to chemical), test before and after, and never mix chemicals. Verify with a professional.
Try it: interactive demo
Chemical cost (or vs route average).
Variations
Route average
Across stops:
Monthly chemical spend
× visits:
High-usage flag
Above average:
Pitfalls & errors
Unit cost. Cost per ounce/pound used, not per jug.
Typical amount. Use a representative per-stop dose.
Flag outliers. A chemical-hungry pool signals a problem.
Practice workbook
Frequently asked questions
How do I calculate chemical cost per stop in Excel?
How do I get the route average?
How do I flag a chemical-hungry pool?
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