Yards with more than one dog earn extra. Base price times stops plus extra-dog fees gives revenue; dividing by stops shows the average.
24 stops at $18 with 10 extra dogs at $5 makes $482.
The example
Three route days with different stops and extra dogs.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Case | Stops | Base | Extra dogs | Fee | Revenue | Avg/stop |
| 2 | Mon | 24 | $18 | 10 | $5 | $482 | $20.08 |
| 3 | Tue | 30 | $16 | 12 | $4 | $528 | $17.60 |
| 4 | Thu | 18 | $22 | 7 | $6 | $438 | $24.33 |
The formula
Revenue first, then average per stop:
How it works
Here is the logic, one piece at a time:
B2*C2is base revenue.D2*E2is extra-dog revenue.- The sum is route revenue.
- Dividing by
B2gives average per stop.
Track extra dogs weekly since counts change.
Try it: interactive demo
Enter stops, base price, extra dogs and fee.
Variations
Per hour
Divide by route hours.
Extra-dog share
Extra-dog revenue as percent.
Pitfalls & errors
Confirm dog counts monthly.
Do not multiply stops by dogs and fee; extra dogs are counted separately.
Show extra dog fees on the invoice.
Practice workbook
Frequently asked questions
Is the fee per visit or per month?
Can I tier the fee?
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