A new homeowner wants every lock rekeyed on one visit. Charge the trip fee once and a flat rate per lock, and the count does the rest.
A $45 trip plus 6 locks at $18 is $153 — the whole house rekeyed on a single ticket.
The example
Three jobs, each with a trip fee, a lock count, and the per-lock rekey rate.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Job | Trip | Locks | $ / lock | Total |
| 2 | New homeowner | $45 | 6 | $18 | $153.00 |
| 3 | Office suite | $45 | 12 | $18 | $261.00 |
| 4 | Single deadbolt | $45 | 1 | $18 | $63.00 |
The formula
One product plus a one-time fee:
How it works
The trip fee is fixed; the locks scale:
B2is the trip fee, charged once for the visit.C2*D2is the rekey work: lock count times your per-lock rate.- Adding them gives the job total, whether it is one deadbolt or a whole office.
Keyed-alike jobs sometimes discount past a certain count — add a lookup if your pricing breaks at, say, 10 locks.
Try it: interactive demo
Enter the trip fee, lock count, and per-lock rate.
Variations
Volume rate past a break
Drop the per-lock rate once the count passes a threshold.
Add new hardware
Include the cost of any locks being replaced, not just rekeyed.
Pitfalls & errors
Confirm the lock count on arrival — back doors, garage entries, and gate locks are the ones customers forget to mention.
Rekeying reuses the existing lock; replacing hardware is a separate, higher line. Do not quote a rekey rate on a lock that needs replacing.
Practice workbook
Frequently asked questions
How do I give a volume rate?
What if a lock needs replacing?
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