The beans in a cup are easy to count. The cost of offering that cup is harder. A useful drink cost sheet separates the recipe from the wider business so that a tidy ingredient figure does not become an unsupported profit claim. Start with one actual menu item, one size and one preparation method. Add alternatives later. A sheet that tries to represent every drink in its first version usually hides its assumptions.
List each ingredient, its purchase unit, purchase price and recipe quantity. Keep units consistent and record whether delivery or other charges are included. Use invoices for real operating decisions. If you are planning before purchase, label supplier quotes and hypothetical figures clearly. A quoted price has a date and conditions; it should not silently become a permanent fact in a spreadsheet that nobody revisits after opening.
Show the arithmetic
For a deliberately hypothetical example, suppose a kilogram of coffee costs 24 currency units and a drink uses 18 grams. The coffee portion costs 24 divided by 1,000, multiplied by 18: 0.432 currency units before waste or other costs. Keep the unrounded calculation in the sheet and round the display sensibly. This is an arithmetic example, not a market price, recipe recommendation or statement about what any café should charge.
Add the other components used by that drink: milk, any actual additions, and takeaway packaging where applicable. Do not assign a takeaway cup to a dine-in drink unless your costing method deliberately averages packaging across service types. State that method if you choose it. Record ingredients that are discarded during preparation separately enough to understand them. An unexplained percentage added at the bottom may conceal a problem you could otherwise measure and improve.
Keep contribution separate from profit
The US Small Business Administration’s planning guidance distinguishes startup costs, recurring expenses and break-even analysis. That distinction is useful when reading a drink sheet. The difference between a selling price and selected variable costs still has to contribute towards other business expenses. It is not automatically the owner’s profit, and it does not establish whether the whole menu supports the business.
Make a separate operating-cost section for labour, premises, utilities, service contracts, administration and other relevant expenses, using qualified accounting advice for the business’s actual treatment. Some costs change in steps or combine fixed and variable elements. Do not force every item into a neat category simply because the first template has only two columns. Write down the approach so that another person can understand how the figures were allocated.
Test a few realistic changes
Change one input at a time: a supplier price, packaging choice or measured recipe quantity. Observe which drinks are most affected. Avoid treating a planned sales mix as guaranteed. A menu with different drinks needs an assumption about what customers buy, and that assumption should be checked against actual sales when available. Keep a simple base case and clearly labelled alternatives rather than overwriting the original figures every time you consider a change.
Review the sheet when a supplier, recipe or portion changes. Give it an owner and an update date. Protect formula cells from accidental edits and keep a small example calculation visible so mistakes are easier to spot. Ask someone else to follow one drink from invoice to final number. If they cannot reproduce it, improve the labels before relying on the result for a purchasing or pricing discussion.
Use the sheet to ask better questions: which input changed, which waste is measured, and which cost remains outside this calculation? Bring those questions to your accountant or adviser when making business decisions. A transparent estimate with stated limits is more useful than a precise-looking percentage that cannot explain where its numbers came from.