Home Baker Recipe Cost & Quote Workbook

Price a bakery order from your own recipe costs

Turn ingredient package prices, batch yields and decorating time into a bakery order price and a customer quote.

Digital workbook for desktop Excel and Google Sheets

Home Baker Order and Pricing worksheet for 36 cookies showing a $45.60 modeled cost and a $60.80 selling price
The Excel order worksheet keeps the inputs and recommended selling price together.

What this workbook helps you do

A batch of 24 cookies and an order for 36 use the same recipe at different scales. The order can also take extra decorating time and a different box. Writing down the ingredient cost alone leaves several costs out of the price.

Keep your package prices and recipes in one workbook. Select a recipe and order quantity, add the costs specific to that order, and review the recommended price before preparing a separate customer quote.

Worked example

A 36-cookie order

A recipe yields 24 saleable cookies. The example allocates 1.5 batches of ingredients and preparation to a 36-cookie order, then adds the decorating, packaging and overhead for that order.

Divide $45.60 by 0.75 to price for a 25% margin. That leaves $15.20 of modeled profit after the entered costs. The customer quote shows 36 pieces and the $60.80 order total.

Try the free selling price calculator
Ingredients and preparation
$18.00
Decoration labor and materials
$19.00
Packaging and flat overhead
$8.60
Modeled order cost
$45.60
Price at 25% target margin
$60.80

How it works

  1. Enter what you pay

    Add the price, size and unit of each ingredient package, then enter the amounts used in your recipe.

  2. Work out the order cost

    Set the number of sellable pieces or servings in a batch and enter your prep time. Select the recipe, add the order quantity, and account for packaging and extras.

  3. Review and export the quote

    Choose a markup or margin, check the price, complete seller and customer details, and export only the Customer Quote sheet.

Recipe table with a 24-piece cookie yield, 30 minutes of preparation and an $18 hourly rate
Save the yield and prep time on the recipe so they can carry through to future orders.
Fictional bakery customer quote for 36 vanilla celebration cookies with a $60.80 total
The customer page shows the order and total while worksheet costs stay in your own copy.

What you can do

  • Reuse an ingredient's package cost across recipes. When the package price changes, the current recipes that use it recalculate.
  • Allocate ingredient and preparation costs by saleable yield. Use whole Piece quantities or Serving with fractional portions.
  • Add per-item and flat packaging, additional decoration time and materials, and flat order overhead.
  • Choose markup on cost or a target margin on selling price. Review modeled cost, price and profit, plus piece and dozen averages for Piece orders.

What’s included

  • Clean and fictional Example workbooks for installed desktop Excel.
  • Native Google Sheets Clean and Example templates. Use a Google account and a desktop browser to make your own copy.
  • Quick-start PDF and format-specific guides with setup and quote export instructions.

Important limits

  • Up to 100 ingredients, 50 recipes and 500 ingredient lines shared across recipes.
  • One current USD order with one product per quote. The customer print layout uses US Letter.
  • Taxes, selling and payment fees, discounts, inventory and automatic quote history are outside the workbook's scope.

Questions before you buy

Can I price a whole cake or a dessert sold by the slice?

Use Piece for whole items sold individually, including whole cakes, cupcakes or cookies. Use Serving for portion-based products. Serving accepts fractional yields and quantities.

How do I preserve a quote after ingredient prices change?

Save the PDF you send and, if you want to keep editable inputs, save a separate dated copy. The current workbook recalculates when package or order costs change.

Can I enter cup measurements for an ingredient I buy by weight?

For supported mass and volume conversions, enter the density for that ingredient. The cost of a cup of flour depends on how much that cup weighs.

Home Baker Recipe Cost & Quote Workbook

Digital download and checkout through Etsy.

Buy on Etsy