Home Bakery Pricing Calculator - Recipe Cost, Cake Pricing, Menu Profit Check & Order Tracker (Excel & Google Sheets)

Know what every bake really costs - including your time - and stop under-charging.

NEW IN THIS VERSION: Menu & Profit tab

• Every menu item: real cost per item, suggested price, YOUR price

• Profit per item and margin

• Clear verdict: "Good price", "Under-priced" or "Losing money"

• Type how many you sell a month - see your planned monthly profit

WHAT'S INCLUDED (2 files)

• Home_Bakery_Pricing_Calculator_EXAMPLE.xlsx - filled-in example (3 recipes, menu, orders)

• Home_Bakery_Pricing_Calculator.xlsx - ready for your bakery

TABS

• How To Use - simple guide

• Dashboard - sales this year, orders, unpaid balances, orders due in the next 7 days, sales by month

• Menu & Profit (NEW) - your price vs real cost for every item

• Ingredients - up to 100 ingredients, cost per gram / ml / piece worked out

• Recipe 1, 2, 3 - ingredients, packaging, your hourly wage, overhead and margin = suggested price per batch and per item

• Orders - up to 300 orders: deposit, balance due, due date, status

HOW IT WORKS

1. Add your ingredients with pack size and price

2. Build a recipe - get your suggested price

3. Check Menu & Profit to see which items to re-price

WORKS IN: Microsoft Excel, Google Sheets (File > Import) and Apple Numbers.

Instant download. Suggested prices are a guide based on the numbers you enter. Please check local food-business rules where you live.

Personal / single-business use. Please do not resell or share.

Images made by me from the real spreadsheet; some design help from AI tools.