How to Calculate Cake Cost and Profit
A step-by-step cake costing worksheet from ingredient packs to profit per order and monthly projection.
Calculate cake profit by subtracting every cost attached to the order from the net sales revenue. First cost the recipe and decorations, then add packaging, labour, utilities, marketing allocation, delivery support and selling fees. Revenue left after those items is profit per cake; divide that profit by net revenue to find the profit margin.
A cake can have an attractive selling price but weak profit when decorating time or custom purchases are missing from the worksheet. The aim is not to produce the lowest possible cost. It is to create a repeatable calculation that shows which flavours, sizes and designs reward the time and capacity they consume.
Create an ingredient cost sheet
List every component under the finished cake: sponge, filling, frosting, syrup, coating, decorations and supports. Record purchase quantity, purchase price and recipe quantity. A 1 kg bag of flour at RM4.50 used at 300 g costs RM1.35. Four eggs from a thirty-piece tray costing RM15 contribute RM2. Continue until even small repeat items are represented.
Use current replacement cost rather than an old promotional price that may not return. If a component makes several cakes, calculate the cost per usable batch and allocate the quantity used. Record ordinary waste from trimming, failed piping and leftover colour. Unusual one-off mistakes should be reviewed operationally rather than quietly added to every future customer.
Confirm the recipe yield
Define whether the calculation covers one whole cake, several sponges or a batch of cupcakes. If one frosting batch covers two standard cakes, half belongs to each only when that usage is reliable. For slices, divide by saleable portions after trimming and staff tasting. A wrong yield can distort every following percentage while leaving the worksheet looking neat.
Standardise tins, fill weights and portion guides. Weighing batter and frosting is not only about consistency for customers; it protects the costing assumption. When a decorator regularly adds more filling than the recipe card states, the practical recipe should be updated instead of blaming a mysterious monthly variance.
Add labour, packaging and overhead
Full cake cost = ingredients + packaging + labour + allocated overheadTime the complete workflow, including preparation, baking supervision, assembly, decoration, packing, messages and cleaning. Multiply active time by an hourly labour rate. Add the board, box and order-specific accessories. Utilities may be a fixed batch estimate based on typical oven use, while broader business costs can be allocated carefully across expected monthly orders.
Keep product cost and general business overhead visible even if you report them separately. The product must at least generate enough contribution to help cover equipment, licences, phone, software and workspace. If these costs never appear anywhere in pricing or monthly planning, accounting profit will remain lower than the order worksheet suggests.
Calculate profit per cake
Profit per cake = net revenue − total cake costAssume a cake sells for RM150. Ingredients are RM38, packaging RM12, labour RM45, utilities and marketing RM10, and a payment fee is RM4.50. Total cost is RM109.50 and profit is RM40.50. The profit margin is RM40.50 divided by RM150, which equals 27%. The markup on the RM105 base cost before the fee is a different percentage.
If delivery of RM15 is charged to the customer and costs you RM12, keep both revenue and cost in the order record rather than treating the whole delivery charge as product profit. When tax is included in the displayed price, separate the tax amount from business revenue before calculating margin. Use consistent definitions across every order.
Move from order profit to monthly profit
Multiply profit per cake by realistic sales volume, then subtract any monthly expenses not allocated into the cake cost. Ten orders earning RM40.50 each contribute RM405. If unallocated monthly software, equipment reserve and administrative costs total RM180, the remaining operating amount is RM225 before other accounting adjustments and owner drawings.
Also check capacity. Ten simple cakes may fit the month, while ten highly customised cakes may require far more labour hours. Track profit per active hour as a secondary measure. It helps reveal that a lower-priced standard product can sometimes contribute more reliably than a prestigious design that occupies several days.
Improve profit without weakening the cake
Focus first on waste, workflow and offer design. Standardise recipes, batch compatible tasks, reduce unused colour and filling, limit revisions, and buy frequently used items in sensible quantities. Raise prices when the value and cost justify it, but do not replace quality ingredients blindly. A saving that damages repeat orders can be more expensive than the ingredient removed.
Review profit by size, flavour and design category every month. Flag orders where actual time exceeded the quote, and update the costing template before accepting the next similar request. Profit improves when the business learns from completed work instead of treating each cake as an entirely new project.
Frequently asked questions
Is profit the money left in my bank account?
Not necessarily. Order profit is revenue minus the costs included in that order calculation. Cash in the bank also reflects timing, deposits, equipment purchases, owner withdrawals and other business expenses.
What if I use ingredients already in my pantry?
They still have a cost because they must be replaced. Use their current purchase price and the quantity consumed.
Should equipment be charged to one cake?
Normally, reusable equipment is spread across its useful production life through overhead or an equipment reserve, not charged fully to one ordinary order.
Examples are for education and planning, not tax or accounting advice.