Portable toilets are not a one-time sale — each unit gets pumped and serviced on a schedule for as long as it is on site. Multiply units by weeks of service by the per-service rate, then add the delivery to invoice the whole run.
Six units on a one-week festival at $25 a service is $150 plus a $120 delivery — a $270 invoice.
The example
Three jobs, each with a unit count, the weeks of weekly service, the per-service rate, and delivery.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Job | Units | Weeks | Rate | Delivery | Total |
| 2 | Festival | 6 | 1 | 25 | 120 | 270 |
| 3 | Job site | 3 | 8 | 22 | 90 | 618 |
| 4 | Wedding | 4 | 1 | 28 | 75 | 187 |
The formula
The service charge is a three-way product; delivery is added once:
How it works
Two parts, one recurring and one flat:
B2*C2is the number of unit-weeks — how many weekly services will be performed in total.*D2multiplies by the per-service rate to get the recurring service charge.+E2adds the flat delivery-and-pickup fee, which is charged once no matter how long the rental runs.- If a unit is serviced twice a week, put the service count in the weeks column or add a services-per-week factor.
Long job sites stack weeks; short events lean on the delivery fee — the same formula prices both.
Try it: interactive demo
Enter the units, weeks of service, per-service rate, and delivery fee.
Variations
Twice-weekly service
High-traffic sites get serviced twice a week — double the service count.
Hand-wash station add-on
Add a per-unit-week charge for a paired hand-wash station.
Pitfalls & errors
Delivery is a one-time fee — do not multiply it by weeks. Keep it outside the units-times-weeks product or a long rental will overcharge the drop-off many times over.
Bill by service performed, not calendar week, when a rental starts mid-week. Count actual pump-outs so a five-day job is not charged as two full weeks.
Practice workbook
Frequently asked questions
Why separate delivery from the service charge?
How do I handle a partial final week?
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