Build the quote sheet in a spreadsheet and ask AI to draft its layout and formulas, not to do the sums. Give it four blocks: servings and ingredients for each tier, baking and design hours at your own hourly rate, delivery with set-up time, then a buffer. Test it on a cake you have already priced.
Most quotes go wrong in one of two places. Either the baker prices per slice, which ignores the fact that design hours and delivery do not rise or fall with the guest list, or they ask a chatbot for the final figure and trust arithmetic they never see. A sheet with visible formulas fixes both. The cake below, three tiers and 74 servings, comes to $650 once everything is counted.
Why a flat price per slice fails on tiered cakes
Couples compare cakes by cost per slice because every pricing guide leads with it, so your sheet should still print that figure. Treat it as an output, never as the input. Four kinds of cost move independently of one another:
- Servings-driven: batter, filling, buttercream and the oven time that goes with them grow with the guest list.
- Tier-driven: boards, dowels, boxes, assembly and the risk of stacking depend on how many tiers there are, not on how many people eat them.
- Design-driven: a textured finish takes an afternoon whatever the size, and forty hand-made sugar flowers take days.
- Distance-driven: delivery and set-up depend on where the venue is and how awkward the access is.
A flat rate averages the four. It overcharges a large, plain cake and undercharges a small, ornate one, which is usually the cake the couple will photograph most. Keeping the blocks separate lets you see which one is moving the price when a couple changes their mind.
The cake we are pricing: three round tiers, 74 servings
Take a one-baker business that handles a couple of wedding cakes on a busy weekend. The enquiry is for three round tiers of 6, 8 and 10 inches, each four inches tall (two layers). The flavour is lemon sponge with lemon curd, finished in meringue buttercream with a palette-knife texture. The couple's florist supplies fresh flowers and the baker places them. The venue is 24 miles away and the cake has to be set up on its table.
Servings come from a chart, not a guess. Wilton's serving guide gives wedding servings for a cake four inches high, based on slices of about 1 x 2 inches. Its party servings use bigger slices, about 1½ x 2 inches, so the count is lower.
| Tier | Wedding servings (about 1 x 2 inch slices) | Party servings (about 1½ x 2 inch slices) |
|---|---|---|
| 6-inch round | 12 | 12 |
| 8-inch round | 24 | 20 |
| 10-inch round | 38 | 28 |
| Three tiers | 74 | 60 |
Two details from the same Wilton page matter when you build the Servings tab. Cakes between three and six inches tall give the same count because they are cut the same way, and a cake shorter than three inches gives half the listed servings. Whichever chart you adopt, print the slice size on the quote, so a couple who imagined a bigger slice can see why the cake feeds fewer people.
Then ask the question no chart can answer: is cake the only dessert? If the couple have 90 guests and nothing else is served, 74 servings is 16 short, and the sheet is the place to find that out before the design is agreed. A comparison of two ways to close the gap comes near the end.
Set your hourly rate before opening the sheet
Labour is the largest block, so it gets one number that every formula points to. A rate that only covers your pay ignores the cost of having a kitchen at all. Here is the sum, with illustrative figures. Monthly overheads (kitchen rent share, insurance, utilities, registration fees, equipment replacement, software, van running costs) come to $780. You can realistically bill 104 hours a month, meaning hours spent on orders rather than shopping, cleaning and answering messages. That is $780 ÷ 104 = $7.50 of overhead in every billable hour. Add the $22.50 an hour you want to take home and the rate is $30.
Put $30 in one cell on a Rates tab and never type it into a formula. When rent or butter prices change, you edit one cell and every quote you build afterwards moves with it.
AI is useful at this step in one narrow way: a missing-cost check. Paste your list of overhead items, without the amounts, and ask what a wedding cake business normally carries that is not on it: insurance, food-safety training, pan and board replacement, card and invoicing fees, the subscription for the sheet itself. Treat the answer as a reason to go back through your bank statements, not as a list of facts about your business.
Ask AI for the layout, then fix what it gets wrong
Describe the sheet once, in plain words, with the figures that do not change. A prompt shaped like this one is meant to get a layout you can build in ten minutes:
I make wedding cakes and need a quote sheet in Google Sheets. The formulas must also work in older versions of Excel, so use VLOOKUP, not XLOOKUP. Build three tabs.
Tab 1, Rates: hourly labour rate, mileage rate, buffer percentage, deposit percentage, second-payment percentage.
Tab 2, Servings: pan size in inches and wedding servings for a 4-inch-high tier (6 = 12, 8 = 24, 10 = 38, 12 = 56, 14 = 78, 16 = 100; slices about 1 x 2 inches).
Tab 3, Quote: one block each for (a) tiers and total servings, (b) ingredients at a cost per serving, (c) structure and decoration materials, (d) labour hours split into baking and assembly, design, and client admin, (e) delivery: drive minutes each way, minutes on site, round-trip miles, (f) subtotal, buffer, total rounded to the nearest 5, price per serving, and a three-part payment schedule.
Give me the cell layout as a table with the exact formula in each cell. Never hard-code a rate inside a formula; point to the Rates tab.What comes back is a table of cells and formulas. An abbreviated, illustrative version looks like this:
| Cell | Label | Formula |
|---|---|---|
| Quote!C4 | Servings, top tier | =VLOOKUP(B4,Servings!$A$2:$B$7,2,FALSE) |
| Quote!C7 | Total servings | =SUM(C4:C6) |
| Quote!C10 | Ingredients | =C7*B10 |
| Quote!C17 | Labour | =SUM(B14:B16)*Rates!$B$2 |
| Quote!C21 | Delivery | =((B19*2+B20)/60)*Rates!$B$2+B21*Rates!$B$3 |
| Quote!C24 | Total | =MROUND(C22+C22*Rates!$B$4,5) |
Before building anything an assistant returns, check five things:
- Hard-coded numbers. Any 30 or 0.65 sitting inside a formula has to become a reference to the Rates tab, or the next price change will miss it.
- One-way trips. Drive minutes must be doubled. Assistants often count the journey once because the prompt said "drive minutes".
- A single hours cell. If labour is one lump, design time vanishes into it. Keep baking, design and admin on separate lines.
- Order of operations. The buffer applies to the subtotal of every block, and rounding comes last.
- Whole servings. Servings are whole numbers, prices round to the nearest $5, and the per-serving figure shows cents.
Then test with the numbers in the line-by-line table further down. The total must come to $650.27 before rounding. If it does not, find the block that differs rather than asking the assistant to explain itself. And resist pasting the whole quote into a chat and asking for the total: a formula either works or shows an error, whereas a chatbot writes a sum that looks right. Why AI gets sums wrong explains the mechanism.
Design time: three bands you time yourself
Design is where quotes drift, because the hours are invisible until you measure them. Time the decoration of your next three wedding cakes with a phone timer, baking excluded, and fix three bands from what you see. The hours below are illustrative; replace them with your own.
| Band | What it covers | Design hours |
|---|---|---|
| 1, Clean | Smooth buttercream or ganache, ribbon, flowers supplied and placed | 1.5 |
| 2, Textured | Palette-knife or comb texture, simple piping, gold leaf accents | 3.0 |
| 3, Hand-made | Sugar flowers, hand-painting, lace or stencil work | 7.0 plus a count of pieces |
The main cake is band 2 (3.0 hours) plus 1.5 hours for placing the florist's flowers, so design is 4.5 hours.
The assistant's job is to sort a couple's description into a band and count the hand-made pieces, not to guess hours. Here is a prompt and an illustrative reply for a typical rambling brief:
Here are my three design bands: [paste the table]. Read the couple's description below. Return the band, a count of every hand-made element, anything I must ask them, and nothing about price or hours.
Description: "Rustic, a bit naked with some texture, a cascade of cream and blush flowers, maybe some of those sugar peonies from the photo, five or six, and gold leaf if possible."- Band: 2, textured, with a band 3 element.
- Hand-made count: sugar peonies, 5 to 6 (confirm the number and the size).
- Ask them: are the cascade flowers fresh or sugar, and who supplies them; is gold leaf wanted on every tier or one; "naked" means exposed sponge, so confirm they are happy with that finish for a cake travelling 24 miles.
What you would fix: the reply treats "five or six" as settled, so ask for one number before quoting. And write the rule the assistant cannot know: any hand-made element moves the quote up until it has been counted. A realistic failure is a "naked cake with flowers" slotted into band 1, followed by a reference photo with forty sugar peonies two weeks later. The hours were never in the quote, and the couple has already agreed the price.
Delivery and set-up as a block of its own
Delivery is a service with its own price, not a favour folded into the cake. The block has four inputs: drive minutes each way, minutes on site, round-trip miles (or kilometres, if that is your unit; the formula is identical) and whether the access needs a second person. Drive time both ways plus time on site, multiplied by your hourly rate, plus miles at your running cost per mile, plus the helper's cost when you need one.
Take distance and drive time from a mapping tool, not from the chatbot. A language model has no live view of road distances or closures, and a wrong figure here goes straight into the price. Ask the couple the access questions that change the block: are there steps or a lift, how far is the unloading point from the table, is the room indoors and cool, who will meet you, and what is the delivery window.
The two venues below use the same cake and the same rates. The nearby one is the main example: 45 minutes each way, 30 minutes on site and 48 miles in total. The far one is a barn with a long approach: 95 minutes each way, 60 minutes on site, 150 miles, and a second person at $20 an hour for the whole trip.
| Delivery line | Nearby venue | Distant barn |
|---|---|---|
| Driving and set-up time | 2.0 h × $30 = $60.00 | 4.17 h × $30 = $125.00 |
| Mileage at $0.65 | 48 × $0.65 = $31.20 | 150 × $0.65 = $97.50 |
| Second person at $20 an hour | none | 4.17 h × $20 = $83.33 |
| Delivery block | $91.20 | $305.83 |
| Cake total after buffer, rounded | $650 | $880 |
A flat $25 delivery fee would have lost about $280 on the barn job. Set a minimum delivery charge as well, so that a ten-minute drive to a hotel still covers your loading and set-up time.
The $650 three-tier quote, every line shown
Here is the whole sheet for the main cake, with every working shown. This is the table to type into your own sheet when you test it.
| Block | Line | Working | Amount |
|---|---|---|---|
| Servings | 6, 8 and 10-inch rounds | 12 + 24 + 38 | 74 |
| Ingredients | Lemon sponge, curd, buttercream | 74 × $1.35 | $99.90 |
| Materials | Boards, dowels, box, ribbon | input | $24.00 |
| Materials | Gold leaf, flower prep supplies | input | $42.00 |
| Labour | Baking and assembly | 5.5 h × $30 | $165.00 |
| Labour | Design (band 2 plus flower placing) | 4.5 h × $30 | $135.00 |
| Labour | Consultation, tasting, admin | 1.5 h × $30 | $45.00 |
| Delivery | Driving and set-up | 2.0 h × $30 | $60.00 |
| Delivery | Mileage | 48 × $0.65 | $31.20 |
| Subtotal | $602.10 | ||
| Buffer | 8% of the subtotal | $602.10 × 0.08 | $48.17 |
| Total | Rounded to the nearest $5 | $650.27 | $650.00 |
| Per serving | For comparison only | $650 ÷ 74 | $8.78 |
The ingredient figure of $1.35 a serving comes from a costed recipe, which the bakery pricing calculator tutorial shows how to build. The buffer covers a remake, an ingredient price rise between quote and bake day, and card fees. The baker's own pay sits inside the hourly rate, so nothing here is profit in disguise; a business with employees would add a separate margin line.
Read the table for where the money goes. Labour is $345, over half the price. Ingredients and materials together are $165.90, about a quarter. Delivery is $91.20, about a seventh. Design alone, at $135, is a fifth of the price, which is why the band matters more than the flavour. On the couple's copy, show the cake and delivery as two lines plus any extras. The labour breakdown is yours.
Deposits and payment dates, with the amounts filled in
The same total drives the payment schedule, so the sheet should calculate it. Rounded to whole dollars:
| Payment | Share | Amount | Due | What it secures |
|---|---|---|---|---|
| Booking deposit | 30% | $195 | On accepting the quote | The date, closed to other couples |
| Second payment | 40% | $260 | 8 weeks before | Design and flavours confirmed, ingredients ordered |
| Balance | 30% | $195 | 14 days before | Final guest count and delivery slot |
Those shares are a policy choice, not a rule. What matters is that each payment is tied to a decision the baker has made on the couple's behalf. The deposit closes the date, the second payment follows the ingredient order, and the balance arrives before the final bake. Here is illustrative wording, which a solicitor should review because what is enforceable depends on the law that applies to your sales:
Your date is held once the booking deposit is paid. The deposit is not refundable, because the date is then closed to other couples. The second payment is due eight weeks before the wedding, when design and flavours are confirmed. The balance is due fourteen days before; guest numbers can change by up to 10% until then, and changes after that are quoted separately. This quote is valid for fourteen days.
An assistant can turn your decisions into plain-English terms in a minute. It cannot make the decisions, and it should not decide what happens when a couple cancels at week six. Settle that first. If you want to take the deposit online with a payment link instead of a bank transfer, taking deposits online with Stripe or Square covers the set-up.
Turn the enquiry email into sheet inputs
The slowest part of quoting is usually reading a loosely written enquiry and working out what is missing. Here is one (illustrative):
Hi, we're getting married on a Saturday in June at a barn about 40 minutes from you. About 90 guests, and we'd love three tiers, lemon if possible, with flowers on the cake. Two of our guests are gluten-free. Budget around $500? Thanks, [first name]
Extract these fields from the enquiry below: wedding date, venue, guest count, tiers, flavours, design details, dietary needs, budget. If a field is vague or missing write ASK and say what I need to ask. Do not guess a price, hours or a distance.| Field | What the assistant returns | What you do with it |
|---|---|---|
| Date | "A Saturday in June" (ASK: exact date) | Check the diary before anything else |
| Venue | "A barn, about 40 minutes" (ASK: name and address) | Map the real distance, then fill the delivery block |
| Guests | 90 (ASK: is cake the only dessert?) | If so, 74 servings is short, so show two options |
| Design | "Flowers on the cake" (ASK: fresh or sugar, who supplies) | Choose the design band once you know |
| Dietary | Two gluten-free guests (ASK: coeliac or preference) | Price a separate gluten-free portion as its own line |
| Budget | About $500 | Below the $650 sheet total, so say so early and kindly |
Look at what you would fix. The assistant must not convert "40 minutes" into miles, and the budget should inform the conversation, not set the price. Never let it write an allergen statement for you either. Say only what your kitchen controls, and check the allergen rules that apply to you. A reply built from the table asks the six questions in one email, quotes by structure rather than by a number, and carries your name rather than a signature the assistant invented:
Hi [first name], congratulations. To price your cake properly I need six things: the exact date, the venue name, whether cake is your only dessert, whether the flowers will be fresh or sugar and who supplies them, what the gluten-free guests need, and the number you are comfortable spending. Once I have them I'll send a single price with delivery and set-up as its own line. [your name]
For wider enquiry handling, including a form that collects these fields before you ever see the email, the custom cake enquiry assistant tutorial goes through the set-up.
Two ways to feed 120 guests
Suppose the couple confirm 120 guests and cake is the dessert. The three tiers give 74 servings, so something has to change. The sheet prices both routes in minutes.
- Four real tiers. Add a 12-inch round: 12 + 24 + 38 + 56 = 130 servings. Same textured finish, a set-up of 45 minutes, $32 of boards and dowels, $60 of flowers and gold leaf, and 13.5 labour hours in all (up from 11.5) for the bigger bake. The sheet gives $835.
- Three tiers plus a kitchen cake. Keep the display cake at $650 and add a plain cake in the same flavours, cut in the venue kitchen, for 48 more servings: 48 × $1.35 = $64.80 of ingredients, $6 of packaging and 1.5 hours at $30 = $45. That is $115.80 before the buffer and about $125 with it. Total $775 for 122 servings.
More useful than the $60 gap is that the couple can see both options on one page and choose on appearance rather than guesswork. Ask the venue whether it charges to cut and plate a cake before you promise the kitchen route, because some do, and that fee belongs on the couple's side of the quote.
Back-test the sheet on three past cakes
A sheet you have not tested is a guess in a nicer font. Enter three weddings you have already delivered, using the hours you actually worked, and compare the totals with what you charged. These figures are illustrative:
| Past order | You charged | Sheet total | Gap |
|---|---|---|---|
| 74 servings, textured, 24 miles away | $480 | $650 | $170 under |
| 36 servings, smooth finish, 6 miles away | $290 | $295 | $5 under |
| 130 servings, sugar flowers, 12 miles away | $850 | $1,010 | $160 under |
The pattern is the finding. On the plain cake close to home, the old habit was fine. The gaps open where design hours and delivery enter, which tells you to check the bands and the delivery block before touching the buffer. If every line is under by a similar percentage, the hourly rate is the culprit instead.
One slip to test for after an assistant has written the formulas: drive minutes added into the labour hours as well as the delivery block. The total still looks sensible and is quietly $45 too high on the main cake, before the buffer. Set the drive minutes to zero and only the delivery block should move, by $45; if the labour block moves too, the drive time is being charged twice.
Re-cost ingredients every quarter, and whenever butter, eggs or flour jump. Date-stamp the Rates tab so that an old quote can be reproduced. When a past order is nearly right, keep it as a saved copy, because a quote you can audit is also one you can defend when a couple asks why the price moved.
Questions bakers ask before sending a wedding quote
How should I price a dummy tier?
Run it through the same sheet: set that tier's ingredients to zero, cut its baking hours, and add the dummy itself as a material. Design hours stay, because a dummy is decorated like a real tier, and so do boards, dowels and delivery. The saving is ingredients and baking time only, usually smaller than couples expect, and the servings fall too, so show both figures side by side.
How many servings should a wedding cake have?
Match servings to what the couple will actually serve. If cake is the only dessert, plan one slice per guest. If there is another dessert, ask the couple what share of guests will take cake. State your slice size on the quote: Wilton's wedding servings assume slices of about 1 x 2 inches, so a smaller or larger slice changes the count.
Can AI price a cake from an inspiration photo?
It can describe what it sees, list the hand-made elements and flag questions to ask, which saves reading time. It cannot know how fast you work, so it should not set hours or a price. Let it sort the photo into one of your design bands, count the elements, and then apply your own timed hours.
Should the tasting fee be separate from the cake price?
That is a policy choice. One common approach is a small tasting fee that is credited against the cake if the couple books, which covers your time and ingredients without putting off serious enquiries. Whatever you decide, put it on the quote and in the booking terms, so nobody is surprised at the tasting.
Further reads
- Bakery Production Planning: Oven Slots and a Prep Timeline With AI — Fit a wedding bake into oven slots and a prep timeline.
- DJ Contract Template: Deposit, Overtime and Cancellation Terms With AI — See how another wedding supplier words deposit and cancellation terms.
- Can AI Qualify Wedding Leads by Date, Budget and Guest Count? — Filter enquiries by date, budget and guest count before quoting.
- Wedding Catering Proposals: Tastings, Quotes and Follow-Ups With AI — A caterer's approach to tastings, quotes and follow-ups.
- Bakery Pre-Order Form for Christmas and Easter With AI — Use the same quote logic for busy-season pre-orders.
- How Wedding Suppliers Can Reply to Enquiries in Minutes With AI — Reply to wedding enquiries in minutes without sounding automated.
- How Much Should a Bakery Spend on AI? A Monthly Budget by Job — A bakery AI budget by job: tool-by-tool monthly prices in USD, three spending tiers, which jobs to automate first and the set-up hours each needs.
- AI Marketing Automation Tools for a Bakery: Win-Back and Birthday Flows — Two bakery flows built step by step, a win-back email series and a birthday pre-order flow, with Mailchimp and ManyChat costs.
- Florist Wedding Quote Template: Price Stems, Labour and Hire With AI — A worked wedding quote in a sheet: stems, waste, labour hours, hire items and delivery, plus the ChatGPT prompts that build it.
- How to Price a Wedding Venue: Peak Dates, Midweek and Minimum Spend — A worked price grid for a 120-guest venue: four date tiers, food-and-drink minimums, a midweek discount test and three yearly scenarios modelled with AI.
- AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.
Sources: Wilton's cake serving guide (wedding servings are based on slices of about 1 x 2 inches for a four-inch-high cake; party servings on about 1.5 x 2 inches). Every price, rate and hour in the worked examples is illustrative.