The coffee gets the attention, but the cup, lid, and sleeve add up too. Sum the packaging pieces to see the disposable cost baked into every to-go drink.
A $0.12 cup, $0.04 lid, and $0.03 sleeve cost $0.19 per drink — real money at hundreds of cups a day.
The example
Three cup sizes, each with its cup, lid, and sleeve cost.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Size | Cup | Lid | Sleeve | Total cost |
| 2 | 12 oz | $0.12 | $0.04 | $0.03 | $0.19 |
| 3 | 16 oz | $0.14 | $0.04 | $0.03 | $0.21 |
| 4 | 20 oz | $0.17 | $0.05 | $0.03 | $0.25 |
The formula
SUM adds the packaging pieces:
How it works
Each piece is a real cost per drink:
B2:D2covers the cup, lid, and sleeve for that size.SUMadds them into one packaging cost per drink.- Add this to your coffee and milk cost to get the full cost of goods behind a latte.
Multiply the packaging cost by daily drink count to see how much disposables cost you each day.
Try it: interactive demo
Enter the cup, lid, and sleeve cost.
Variations
Add a straw or stopper
Include extra disposables for cold or blended drinks.
Pitfalls & errors
Price each piece from the case: divide the case price by the count to get a true per-unit cost.
Do not forget the sleeve and stir stick on hot drinks — small items still add up across thousands of cups.
Practice workbook
Frequently asked questions
How do I price each piece?
Is packaging part of my pour cost?
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