Someone asks what a cake for 100 guests costs. What happens next?
Pricing a custom cake tends to happen in three places at once. The servings chart is often a picture somebody saved from the internet. The costing is a calculator or a notebook. The quote is a message typed from scratch, and by the third one this week the deposit terms have quietly changed.
This workbook is all three in one file. Type the guest count and the portion style on the Quote Builder, and it resolves the tier stack, prices the cake per serving, prices the design by the minute, adds the boards and boxes and the drive, checks the total against what the order actually costs you, and fills in the page you send the customer.
The servings chart lives inside the pricing engine
Type 100 guests on wedding portions and the Servings & Tier Guide returns a 6 + 9 + 12 three-tier stack, 101 servings, one spare — and the Quote Builder prices that stack.
Those serving counts are not a chart somebody else drew. Each of the 19 round, square and sheet sizes divides its own top area by a slice size you can change (party slices default to 3 square inches, wedding to 2), and each of the 14 standard stacks sums its own tiers back out of that table. Change one slice size and every size and every stack in the file re-counts itself.
Design complexity is minutes, not a multiplier
Decorating time is one of the hardest things about a cake to estimate, and a single complexity multiplier cannot tell a plain buttercream finish from a hand-painted tier covered in sugar flowers.
The Decoration Library holds 28 design elements — fondant cover, buttercream sharp edge, Lambeth piping, ruffles, stencil work, isomalt shards, metallic leaf, modeling-chocolate figurines, tier assembly and doweling — each with its own preset labor minutes and its own material cost. Add an element to a quote — up to ten lines — and it brings its minutes with it: the quote shows the labor, the materials and the total for that line alone, so you can see which part of a design is expensive and say so in a consultation.
The presets are a starting estimate. Time yourself doing a technique once, type your number over the preset, and the library gets more accurate every order.
A floor, checked before you send
A price only clears if it carries what the business actually costs to run. So the same order is costed from the other end on Cost Floor & Overhead: ingredients, decoration materials, boards and boxes, every production minute paid at your hourly rate, overhead charged on those hours from a ten-line monthly worksheet, the admin minutes the inquiry took whether or not it books, and the delivery.
On the worked example that floor is $744.55 against a $1,015.11 quote — $10.05 per serving delivered, a 26.7% margin against a 25% target — so the verdict reads OK. Price the same cake too low and the same cell reads BELOW FLOOR — or THIN, when it clears the floor but misses your target margin — with the price that would hit that target sitting just below it and the gap spelled out.
The quote the customer actually receives
The Customer Quote tab fills itself from the same order: the tier stack and what it serves, the flavor, filling and finish, every design element listed by name so nothing is assumed, the investment lines, the total, the deposit due to book, the balance and the date it falls due — plus terms you set once. Print it or send it as a PDF.
Then you copy each inquiry into the Quote Log, won or lost — the quote you just built is already laid out in the log’s own columns, so nothing is re-derived — with its cost floor and margin beside it, and a booking rate across 5 price bands with a tally of why quotes were lost. After a season, a price ceiling stops being a feeling and starts having evidence.
Set twelve numbers once, and the workbook computes the thirteenth
The Setup tab is the only place your business lives: hourly rate, admin minutes per inquiry, target profit margin, delivery rate per mile and the miles you absorb, on-site setup fee, rush surcharge, deposit percentage, balance lead time, per-tier bake minutes, prep and cleanup minutes, and your minimum order. The overhead worksheet underneath turns your monthly rent, utilities, insurance, permit, equipment fund, packaging and software into an overhead per production hour figure the floor uses — the thirteenth number, and the only one of the thirteen you don’t type.
Own it, don’t rent it
It is one file you buy once and keep. Nothing is locked, password-protected or hidden — every formula is visible and editable, and there are no seats, no renewals and no monthly fee. It opens in Excel, and a one-click link makes a ready-made native Google Sheets copy with all ten tabs, no import and nothing to repair afterwards. It works in LibreOffice Calc too.
Five PDFs, 37 pages, ship alongside it: a 17-page Start Here guide in seven sections, the pricing method worked end to end, a printable servings and tier reference for the kitchen wall, and a consultation and order form with the full design checklist to take to a tasting — plus the one-page sheet carrying the one-click Google Sheets link.
What this cake workbook does, and what it doesn’t
This is a pricing and quoting workbook, not order-management or accounting software. It sizes the cake, prices the decoration, checks the quote against your cost floor, prints the customer’s quote and gives you a log to keep them in — it does not invoice, chase payments or track your ingredient inventory.
Just want the servings chart? That part is free
The servings and tier table this workbook computes is also a free one-page printable. The Cake Servings Chart gives you party and wedding servings for all 19 round, square and sheet sizes, and the guest count each of the 14 standard stacks covers — pinned above the bench, no email and no signup. It answers how big the cake has to be. What a chart cannot do is tell you what to charge for it, and that is the half this workbook is for.
Already taking orders? Pair it with a free order book
This workbook quotes the cake. Once the customer says yes, the Home Baker’s Order & Delivery Tracker is a free order book that works backwards from the delivery date — one row per order with the deposit, the balance and the allergens, and a production calendar that computes bake and decorate days. It is free, hosted on Ardent Seller, and needs no signup.
When the quoting and the order book start to outgrow a spreadsheet, Ardent Seller (opens in new tab) is our software for small makers — the same kind of record-keeping, with the tracking done for you.
