A pooper-scooper route runs on subscriptions, not one-off jobs. Multiply the visits a yard gets each month by the per-visit rate and add a small base fee, and every client's monthly bill writes itself.
Four weekly visits at $15 plus a $10 base is a $70 monthly bill — eight visits runs $130.
The example
Three clients, each with visits per month, the per-visit rate, and a flat monthly base.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Client | Visits | Rate | Base | Monthly |
| 2 | Weekly | 4 | 15 | 10 | 70 |
| 3 | Twice-wk | 8 | 15 | 10 | 130 |
| 4 | Daily | 20 | 12 | 10 | 250 |
The formula
The visit charge scales; the base fee is flat:
How it works
A recurring charge and a flat fee:
B2*C2multiplies the visits a client gets each month by your per-visit rate.+D2adds a flat monthly base fee that covers routing, disposal, and account overhead.- Higher-frequency clients often get a lower per-visit rate — keep the rate in its own column so it can vary.
- The base fee is what makes a low-frequency yard worth the drive; without it a once-a-month client barely covers gas.
Sum the monthly column for your recurring revenue, or multiply by 12 to project the year.
Try it: interactive demo
Enter the visits per month, per-visit rate, and monthly base fee.
Variations
Extra-dog surcharge
Add a per-dog charge beyond the first.
Annual value
Project a client's yearly revenue.
Pitfalls & errors
Do not multiply the base fee by visits — it is a flat monthly charge. Keep it outside the visits-times-rate product or a daily client gets billed the base twenty times.
Give higher-frequency clients a lower per-visit rate but keep the base. Frequent stops are more efficient per visit, and the base still covers the fixed cost of carrying the account.
Practice workbook
Frequently asked questions
Why add a base fee at all?
How do I bill a client who adds a dog mid-month?
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