AnalystBuilt home Etsy shop

Small Business Finance

Cake Pricing & Recipe Cost Calculator

Ingredient costs, recipes, tiers and servings, suggested prices, quotes and orders

Cake Pricing & Recipe Cost Calculator: Price every cake from your real recipes
Price every cake from your real recipes
  • Cake Pricing & Recipe Cost Calculator: Price every cake from your real recipes
  • Are you underpricing? Suggested price at your target profit, after paying yourself
  • What each hour really pays you: Profit per hour for every cake, against your rate
  • Your bakery at a glance: Bookings, profit per hour, money to collect — and what needs attention
  • Recipe costs in any unit: Grams, cups, spoons or each — converted for you
  • Servings and batches by size: Party or wedding slices · cups per size set your batches
  • A printable quote with deposit: Tiers, flavors, total, deposit and balance — print or save as PDF
  • Every order, deposit and balance: Inquiry · Booked · Deposit paid · Ready · Picked up

from $10.99 on Etsy

Price on Etsy may vary (sales, your currency).

View on Etsy
  • Google Sheets + Excel versions included
  • Instant digital download, nothing is shipped
  • Sample data and a Start Here tab
  • One-time purchase, no subscription

Works in Google Sheets (free Google account) and Microsoft Excel 2016 or newer.

Stop guessing what to charge for a cake. This cake pricing calculator works out every cake from your own recipes: what the ingredients really cost, how many batches each tier needs, your time, decorations, boxes and boards. Then it gives you a suggested price at your target profit, the price per serving and what each hour of your work actually pays you.

Made for home bakers, custom cake decorators and small cake studios: tiered and wedding cakes, birthday cakes, sheet cakes, bento cakes, cupcakes. Ounces or grams, any currency.

What's inside

  • Start Here

    Quick guide, your bakery details for quotes and your settings: hourly rate, overhead per order, target profit, payment fees, waste allowance, deposit %

  • Dashboard

    Booked for the next 30 days, profit per hour, cost per serving, money to collect, underpriced cakes, upcoming pickups, orders by stage and revenue by month

  • Cake Builder

    Pick a cake and see it drawn tier by tier, with suggested price, your price, price per serving, profit per hour and where every dollar goes

  • Quote

    A one-page printable quote with tiers, flavors, total, deposit and due date

  • Orders

    Every order with pickup date, deposit, balance and a status: Inquiry, Booked, Deposit paid, Ready, Picked up, Cancelled

  • Cakes

    Your cake menu with cost, suggested price, per-serving price and a status for each

  • Cake Parts

    The tiers (size, batter, filling, frosting) and extras (flowers, toppers, boxes, boards) of each cake

  • Recipes and Recipe Lines

    Cost per batch and per cup for every batter, filling and frosting

  • Ingredients

    Your library of ingredients and supplies with pack prices, unit costs and price changes

  • Servings Chart

    Sizes with party and wedding servings and cups of batter, filling and frosting, all editable

Why you'll like it

  • Real recipe costs: type quantities in cups, tablespoons, grams, ounces or eggs, and the sheet converts them for you
  • Batches scale by pan size from the servings chart, so a 10-inch tier and a dozen cupcakes are costed correctly
  • Your time counts as a cost, so profit is what's left after you are paid
  • Profit per hour for every cake, next to the hourly rate you want
  • Underpriced and below-cost cakes are flagged with how much to raise
  • Deposits and balances tracked, with reminders for unpaid deposits and past pickups
  • Ingredient price watch: see which prices went up and which ones to recheck
  • Built by a data analyst: every number is a formula you can trace. No subscription, no app

How you get it

  1. Download on Etsy

    Buy the template on Etsy, then download START-HERE.pdf and the Excel .zip from your Purchases.

    How to download

  2. Make a copy

    Click MAKE A COPY in the PDF: your own Google Sheet is saved to your Google Drive. Prefer Excel? Open the .xlsx.

    How to make your copy

  3. Start

    Follow the Start Here tab. Type in the cream cells; the gray cells do the math for you.

    Clearing the sample data

You receive:

  • START-HERE.pdf — Google Sheets link + quick guide
  • cake-pricing-calculator-excel.zip — Excel version

Good to know

  • Comes with a sample bakery (12 cakes, 14 recipes, 26 orders) so you can see every status first; Start Here shows how to clear it.
  • The servings chart holds typical starting numbers for 4-inch-tall tiers. Edit them to match your pans and how you cut.
  • Up to 200 ingredients, 60 recipes, 60 cakes and 400 orders.
  • Best used on a computer; you can view it in the Google Sheets app on your phone.
  • For use in one business. Please do not resell or share the files.
  • Listing images show real screenshots of this template with sample data.

Not legal, tax or food-safety advice. Check your local cottage food rules.

Designed by me with the help of AI tools.

View Cake Pricing & Recipe Cost Calculator on Etsy

More in Small Business Finance