Cake and Bake Pricing Calculator UK

How much should a custom cake cost? This spreadsheet works it out from your own shop prices, in pounds, with UK pack sizes.

List what you buy (pack price, pack size, g, kg, ml, l or each), build up to 50 bakes from that list, then price an order: pick the recipe and the tin, add decorations, packaging, your hours, oven time and delivery. You see the total cost, a minimum price, the price at your target profit, and the price per serving.

Included:

• Settings: hourly rate, oven cost per hour, packaging, delivery per mile, target profit %, deposit %, VAT registered or not (flat 20% if yes), and a tin table of round and square sizes in inches with portions you can edit
• Ingredients: up to 200 items with cost per g, ml or each
• Recipes: 50 bakes, 20 lines each
• Cake pricing: up to three tiers, scaled by tin area, or priced by portions for cupcakes, brownies and cookies
• Quote sheet: prints on one A4 page, with deposit and balance
• Orders log: paid and unpaid

Two .xlsx files come in the download: a made-up home baker with six bakes (example prices, replace with your own) and a blank copy. Works in Excel 2016 or later and Google Sheets. No macros.

Planning maths, not tax or accounting advice. Waste is not counted unless you add it to your quantities.