Ingredients & fillings
Use a known total or cost each ingredient from its package price and quantity used. Count the amount used for this order, not the whole bag.
Free cake costing worksheet
Cake Pricing Calculator
Put a price on your next cake order. Add ingredients, your time and other costs, choose your profit target, then save a private costing sheet.
All amounts are USD. No sign-up or uploads. Download your work before closing or reloading this tab.
Build the price from the order
What goes into your cake cost?
Your time
Enter the hours you want to include and your own hourly rate. Keep that labor separate from the profit you want above the order’s costs.
Finishing & delivery
Add decorations, boards, boxes and delivery expenses. Check that an item already in your ingredient total is not counted again.
A share of overhead
Allocate the portion of shared expenses that belongs to this order, using your records. Enter 0 where a cost does not apply; blanks stay incomplete.
A worked order
An $80 cost becomes a $100 price
These synthetic USD figures show the calculation, not recommended prices, wages or profit targets.
| Ingredients | $40 |
|---|---|
| Decorations | $5 |
| Packaging | $5 |
| Labor | $20 |
| Overhead | $10 |
| Delivery | $0 |
| Total cost | $80 |
With a 20% margin$100
$20 profit above the included costs.
For 20 entered servings: $5 per serving.
Margin is a share of the selling price. Markup is a percentage added to cost.
- 20% margin
- $80 ÷ (1 − 0.20) = $100
- 20% markup
- $80 × (1 + 0.20) = $96
The markup option leaves $16 profit and a 16.6667% margin.
Only charge for the flour used
A 3,000 g bag costing $12, with 375 g used, adds $1.50: $12 × 375 ÷ 3,000. Keep package and used quantities in the same unit; there is no cup-to-gram conversion.
Why a price may round up
At $80.01 cost and 20% margin, the exact price is $100.0125. $100.02 is the first whole-cent price that meets the target; $100.01 falls short.
Before you settle on a price
Cake pricing questions
How much should I charge for a homemade cake?
Start with what this order costs you, including your time, then choose your target. The result gives a cost-based price. It cannot tell you what customers will pay or account for expenses you leave out.
Is my pay included in the profit?
Entered labor is already a cost. Displayed profit is what remains above all included costs, including that labor. It is not business net income.
How should I split overhead between orders?
Choose an allocation method that fits your records and use it consistently. Enter only this order’s share. The worksheet does not estimate overhead or include it automatically.
Does it work out servings from cake size?
No. You enter the serving count. Price per serving is the order price divided by that count, rounded for display.
What if the price looks too high?
Check quantities, units, hours and duplicated costs first. Then check whether you selected margin or markup. Revisit the order scope and your own target; the calculator cannot validate a market price.
Can I save this or send it to a customer?
Download a PDF to read or print, or a CSV to edit in a spreadsheet. Both contain internal costs and rates, so they are costing sheets, not customer quotes. Entries are not saved automatically.
Calculation rules & sources
- Package allocations and labor round half-up to cents; the target price rounds upward to a whole cent.
- Up to 20 ingredient rows. No automatic unit conversion, tax, processing fee or waste allowance.
- Only the selected ingredient method contributes to the total. Private entries stay in this tab without analytics or automatic saving.
Supported targets: 0–99.99% margin or 0–100% markup. PDF supports basic Latin text; use CSV to retain unsupported characters.
AccountingCoach — Gross margin and markup — Definitions of margin as a share of selling price and markup as a share of cost. This worksheet applies those ratios to the costs you include.
NIST — SI units: mass — Mass measurement background. Package allocation here requires identical units and does not convert mass to volume.
Method and input rules checked: . Engineering validation; no professional specialist review is claimed.