Coffee & Drive-Thru Menu Pricing Calculator

Free food-cost calculators cost one drink. This one works through your whole menu: four cup sizes, add-ons, milk swaps, packaging, drive-thru vs delivery-app pricing, a menu engineering summary and a supplier price-increase what-if. All of it is in one Excel workbook that also works in Google Sheets.

Built for owners of coffee shops, drive-thru coffee stands and small QSRs.

What It Does

Ingredient Cost Library

• Enter items the way you buy them: 5 lb bag, 1 gal jug, 750 mL bottle, 24-can case
• Converts between weights, volumes and counts (lb, oz, g, gal, qt, fl oz, mL, pumps, servings)
• Yield / waste % for every ingredient
• Density field for weight-to-volume items (a sauce bought by the pound, poured by the ounce)
• Flags duplicate names, missing prices and units that won't convert

Batch Recipes

• Cost house-made cold brew, sweet cream or simple syrup once. Each one shows up as an ingredient automatically.

Drink Recipes: Cost Per Cup By Size

• 20 drink blocks, 4 sizes each (12 / 16 / 20 / 24 oz by default, and you can rename them)
• Ingredient cost + packaging = total cost per cup, next to your current price

Packaging

• Cups, lids, sleeves, straws, carriers, bags, napkins and seals, priced from your case cost
• Kits are matched to each drink by type and size (Hot 12 oz, Iced 24 oz...)
• Per-channel add-ons for drive-thru and delivery, like a carrier for every 4 drinks or a bag and seal

Modifiers & Add-Ons

• Syrups, extra shots, cold foam, sauces and toppings: cost per add, your upcharge, a suggested upcharge
• Flags add-ons that lose money, are given away free, or come in under your target

Milk Alternatives

• Oat, almond, soy, coconut, breve and more: extra cost vs. your base milk at every size
• Shows whether one flat upcharge still covers your biggest cup

Menu Pricing

• Suggested price from your target margin, rounded the way you price (up to the next $0.25, .95 endings, etc.)
• Cost % and margin $ on every drink and size, with OK / WATCH / HIGH COST % / LOW $ MARGIN flags
• Optional target margin by menu category (energy drinks, blended, espresso...)

Drive-Thru Vs In-Store Vs Delivery App

• Net margin for each channel after card fees, delivery-app commission %, app markup and channel packaging
• The delivery-app price you'd need to match your in-store margin

Menu Engineering Summary

• Enter monthly units sold from your POS
• Every item classed Star / Plowhorse / Puzzle / Dog, with a suggested move
• Sales-weighted cost %, gross profit per month, and food-cost % flags

What-If: Supplier Price Increases

• Enter a % increase by category (coffee, dairy, milk alternatives, syrups, packaging...) or for single items
• See the new cost per cup, the monthly and annual gross profit hit, and the price that holds your cost % or your margin $

What'S Included

• 1 Excel workbook (.xlsx) with 13 tabs: Start Here, Settings, Ingredients, Batch Recipes, Packaging, Recipes, Modifiers, Milk Alternatives, Menu Pricing, Channel Pricing, Menu Engineering, What-If, Lists
• 1 quick-start guide (5-page PDF)
• Working formulas, dropdowns and color-coded input cells. No macros.

Room for 150 ingredients, 30 packaging items, 20 drinks x 4 sizes, 25 modifiers and 10 milk options.

Please Note

• The workbook comes filled with clearly labeled EXAMPLE data so you can see the math work. Those numbers are made up. They are not benchmarks, supplier quotes or recommended prices. Replace them with your own invoices and menu.
• "Cost" means ingredients + packaging. Labor, rent and overhead are not included.
• Suggested prices are math on the targets you set. Check them against your market before you change your menu board.
• Works in Microsoft Excel (desktop or web) and Google Sheets (upload to Drive, then File > Save as Google Sheets). Numbers is not supported.
• This is a digital download. Nothing will be shipped.
• Planning tool only. Not financial, tax or legal advice.

Buy on Etsy