Quote by dozen
Set quantity and yield to match how the order will be sold, especially when one batch makes more than the customer ordered.
Dozen-order worksheet
Cupcake Pricing Calculator
Use this cupcake pricing worksheet when a customer asks for a dozen, several mixed flavors, or a party tray. It keeps batter, frosting, liners, boxes, decorating time, delivery, and target margin in one quote ledger.
Pricing checklist
Keep the quote tied to the real order
Separate packaging
Include liners, inserts, cupcake boxes, labels, and bags instead of burying them inside ingredient cost.
Count decorating labor
Add time for piping, color changes, toppers, sprinkles, setup, cleanup, and boxing.
Active worksheet
Load a preset, edit every row, or clear the ledger for a custom order.
Quote inputs
Pick a starter order, then adjust the yield, labor, overhead, add-ons, and pricing mode for this quote.
Bakery preset
Labor and overhead
Overhead mode
Packaging and add-ons
Use add-ons for delivery, rush timing, premium decoration, or packaging that is not already listed in the ingredient ledger.
Pricing mode
Margin protects a percent of the final price; markup adds a percent to cost.
Keep margin below 100%; most home bakery retail quotes land between 35% and 55% once labor is counted.
Ingredients and supplies
Enter package costs and the recipe amount used. Matching units convert directly; saved bakery densities handle common weight-to-volume rows.
6 rows6 priced
| Item | Type | Package cost | Package size | Used | Line cost | |
|---|---|---|---|---|---|---|
| $2.53 | ||||||
| $1.21 | ||||||
| $8.99 | ||||||
| $1.37 | ||||||
| $1.08 | ||||||
| $2.20 |
Current row totalbefore yield, waste, labor, and margin$17.38