INVENTORY BOSS — CAFÉ DRINK COST WORKSHEET
Guide: https://inventory-boss.net/blog/cafe-drink-cost-per-cup

Copy, edit or print. This is a manual worksheet, not an automatic calculator.
Use one currency. The guide's figures are examples, not market prices.

Date: __________________  Drink and size: __________________
Currency: ______________  Selling price (exclude tax collected): __________

INGREDIENTS — repeat for each ingredient
Ingredient: __________________
Pack price: ______  Pack quantity: ______  Unit (g/ml/etc.): ______
Amount consumed per sold drink, including measured waste: ______
Ingredient cost = pack price x amount consumed / pack quantity: ______
Use the same unit for both quantities. Do not add a waste allowance again
if the amount consumed already includes that loss.

OTHER COSTS PER DRINK
Cup, lid and other packaging: ______
Direct work minutes: ______  Hourly labor cost: ______
Direct labor = minutes / 60 x hourly labor cost: ______
Allocated overhead (do not repeat direct labor): ______
Other costs included, with explanation: __________________

CALCULATE
Total entered cost = ingredients + packaging + labor + overhead + extras: ____
Amount left = selling price - entered cost: ______
Margin on entered costs (%) = amount left / selling price x 100: ______
Target margin (%; must be below 100): ______
Price for target margin = entered cost / (1 - target margin / 100): ______
Round the final price up to the next cent to meet the chosen target.
The simple formula excludes fees that change with selling price.

CHECK BEFORE USING THE PRICE
Actual coffee and milk used versus recipe amount: __________________
Shared costs and sales volume used for the allocation: ______________
Payment fees, taxes or other costs still excluded: __________________
Date to recheck supplier prices and portions: _______________________

Free calculator: https://inventory-boss.net/#cost-calculator