Description
Full Walkthrough
Cafe & Bakery Recipe Cost Calculator
A recipe costing and food cost calculator for restaurants, cafes, caterers, bakers and food businesses. Turn pack sizes and prices into true unit costs, build recipe cards from a dropdown, and see cost per portion, food cost %, profit per portion and a suggested menu price at your target food cost.
This is the Cafe & Bakery Blush edition: the same workbook as our Recipe Cost & Food Cost Calculator, in a berry, blush and cocoa design. It comes with the same sample cafe and restaurant recipes to show how it works; replace them with your own bakes.
Who it’s for
Cafe owners, home bakers, cake makers, dessert and coffee shops and small food businesses that price bakes, drinks and plates for sale.
What’s inside
- Start Here – a 5-step quick-start guide inside the file
- Dashboard – Average food cost %, dishes above target, profit per dish and charts
- Recipe Cards – Up to 30 costing cards with ingredients, cost per portion and suggested price
- Menu Summary – Every dish with cost, price, food cost %, profit and status
- Ingredients – Price list: pack size, pack price, yield % and true unit cost
- Settings – Currency, target food cost %, tax and ingredient categories
Features
- Ingredient price list with pack size, pack price and unit cost
- Yield % for trim and waste so costs are realistic
- Up to 30 recipe costing cards with up to 12 ingredients each
- Cost per batch and cost per portion
- Food cost % at your menu price, with colour status
- Suggested menu price at your target food cost %
- Menu summary and dashboard with profit per dish charts
- Your own currency, target % and tax setting
How delivery works
- Instant download right after purchase: the .xlsx workbook plus a step-by-step Setup Guide PDF.
- Works in Microsoft Excel (Windows, Mac, Excel for the web) and Google Sheets (upload to Google Drive and open with Google Sheets, or File > Import).
- Comes with realistic sample data so you can see how it works, and clear instructions to remove it.
- No macros, no add-ons, no subscriptions. Pay once, use it for as long as you like.
FAQ
What is a good food cost %?
Many restaurants aim for 25-35%. Set your own target on Settings and every recipe is measured against it.
Does it work in Google Sheets?
Yes. Upload to Google Drive and open with Google Sheets, or use File > Import. Dropdowns and formulas work the same.
Can I use grams and kilos?
Yes. Price each ingredient in the unit you like (g, ml, each) and use the same unit in recipes.
Does it update when supplier prices change?
Yes. Change a pack price on Ingredients and every recipe card, the menu summary and the dashboard update.
Also available in Chef Cream, Paprika & Olive: Recipe Cost & Food Cost Calculator (the original edition)
This is a digital product. No physical item will be shipped.
Want your own store like this one? createdigitaltools.com runs on Hostinger WordPress hosting. Start your own shop with Hostinger, or try the no-code Hostinger Website Builder.
Affiliate links: I may earn a commission at no extra cost to you.
