The key machine is steady counter income. Multiply the number of keys cut by your price per key and you have the day's key revenue at a glance.
40 keys at $3.50 each is $140 — a quick read on a slow-looking but profitable line.
The example
Three days, each with a key count and the price per key.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Day | Keys cut | Price / key | Revenue |
| 2 | Monday | 40 | $3.50 | $140.00 |
| 3 | Friday | 65 | $3.50 | $227.50 |
| 4 | Saturday | 90 | $4.00 | $360.00 |
The formula
One multiplication per day:
How it works
Counter revenue is just count times price:
B2is how many keys you cut that day.C2is your price per key.- Multiplying gives the day's key-cutting revenue.
Sum the revenue column for a weekly total, or divide by blanks used to confirm your material margin.
Try it: interactive demo
Enter the number of keys cut and your price per key.
Variations
Net of blank cost
Subtract the blank cost per key to see profit, not just revenue.
Pitfalls & errors
Track specialty keys (transponder, high-security) on a separate line — their price and cost are far higher than a basic blank.
Revenue is not profit. Subtract blank cost and machine wear to know what each key really earns.
Practice workbook
Frequently asked questions
How do I get profit instead of revenue?
Can I total the 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