Your cost per shot starts with yield: how many shots one bag of beans pours. Divide the bag's grams by your dose per shot and round down to whole shots.
A 1,000 g bag at an 18 g dose yields 55 full shots (the leftover 10 g cannot make a 56th).
The example
Three bags and dial-in doses with the whole shots each yields.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Bean | Bag (g) | Dose (g) | Shots |
| 2 | House blend | 1,000 | 18 | 55 |
| 3 | Single origin | 340 | 20 | 17 |
| 4 | Decaf | 1,000 | 16 | 62 |
The formula
Round down so you never count a partial shot:
How it works
Yield is just a division you floor:
B2is the bag weight in grams.C2is your dose per shot — the grams of ground coffee in the portafilter.- Dividing gives raw shots;
ROUNDDOWNdrops the fraction because leftover grams cannot pull a full shot.
Cost per shot is the next step: divide the bag price by this shot count.
Try it: interactive demo
Enter the bag weight and your dose per shot.
Variations
Cost per shot
Divide the bag price by the shots to cost each pull.
Double shots
For double-dose drinks, divide by the doubled dose.
Pitfalls & errors
Account for grinder retention and purge — real yield is usually a shot or two below the math.
Keep grams with grams. Mixing ounces and grams throws the count off completely.
Practice workbook
Frequently asked questions
Why round down?
How do I get cost per shot?
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