Cupcake Pricing Calculator
What should a dozen cupcakes cost? Work it out in minutes: batter, frosting, decorations, boxes and your time, all counted.
The Cupcake Pricing Calculator is a spreadsheet for home and cottage bakers. Enter what you pay for ingredients, list each flavor's batter and frosting, and it works out your real cost per cupcake. Then it suggests prices for singles, half dozens, dozens and mini dozens at your target margin, and shows your profit at the price you actually charge.
WHAT'S INCLUDED
- Cupcake Pricing Calculator, SAMPLE version (filled with example data so you can see how it works)
- Cupcake Pricing Calculator, BLANK version (ready for your business)
- Easy instructions PDF (Excel + Google Sheets)
Tabs:
- PRICE LIST: cost per cupcake (ingredients, labor, decoration, packaging), suggested price for each / ½ dozen / dozen / mini dozen, your dozen price, profit and margin, plus a profit chart
- FLAVORS: up to 12 flavors with batch yield, batter + filling cost and frosting + topping cost (automatic), hands-on minutes, decoration tier and packaging
- RECIPE LINES: one row per ingredient (batter, frosting, filling or topping) for one batch of each flavor
- INGREDIENTS: package size and price, cost per gram / ml / each calculates for you
- SETTINGS: labor rate, overhead %, sales / card fees, target margin, rounding, liner cost, mini factor, decoration tiers (extra cost + minutes) and packaging options
- START HERE: simple step-by-step instructions
Red highlights show when your price is below the suggested price.
Works in Google Sheets and Excel (Google Sheets is free; Excel 2016+ or Microsoft 365).
HOW DELIVERY WORKS
- Instant download: right after checkout you get a download link on screen and by email.
- You receive one ZIP file. Double-click it (Mac or Windows) to unzip the files.
- Excel: open the .xlsx file. Google Sheets: go to sheets.google.com > File > Import > Upload and choose the .xlsx (step-by-step in the instructions PDF).
- Open the SAMPLE file to see how it works, then fill in the BLANK file with your own details.
- This is a digital product. Nothing will be shipped.
GOOD TO KNOW
- A computer is recommended for setup. The Google Sheets mobile app works for quick updates.
- Sample names, numbers and prices are fictional examples.
- Not affiliated with Google or Microsoft.
- For personal or single-business use. Please don't resell or share the files.
- Because this is a digital download, we can't offer returns. If a file won't open or a formula isn't working, contact us and we'll fix it or send a replacement.
- Designed with the help of AI tools; formulas tested by OvenReadySheets.
Pairs with our Recipe Cost & Pricing Calculator, or save with the Bakery Pricing Bundle (4 pricing tools).