Custom Cake Order Tracker & Pricing Calculator: Cake Pricing Spreadsheet for Home Bakers
Full description
For home bakers and small cake studios who take custom orders and want to charge for their time as well as their ingredients. You pick the tiers, sponge, filling, covering, decoration level and delivery. The calculator works out servings, ingredient cost from your own recipes, labour at your hourly rate, overhead and margin, then rounds the price and sets the deposit and balance date. Each booked order goes into a log that flags unpaid and overdue balances, feeds a month calendar of cakes due each day, and builds a monthly income summary.
Save with a bundle: this template is also in the Food & Leisure Business Startup Bundle, 14 templates for $35 instead of $103. All 141 templates are in the All-Access Hospitality Template Library for $79.
What is inside
- Custom_Cake_Order_Tracker_Pricing_Calculator.xlsx: 8 tabs, 2,465 formulas, 3 native charts, 15 drop-down or number rules. No macros.
- Settings: 15 pricing inputs (hourly rate, overhead, margin, minimum price per serving, deposit rule, production days, daily cake limit), 10 tier sizes with servings, 4 covering times, 4 decoration levels, 4 delivery options and 3 drop-down lists.
- Ingredient_Costs: room for 30 ingredients (20 sample) and 8 base recipes, with cost per batch and cost per serving.
- Price_Calculator: 16 inputs for up to 4 tiers, 27 cost and price lines, an earnings-per-hour check and a 17-line order summary for the client.
- Order_Log: room for 400 orders (92 sample rows) with balance due and 5 flag types: overdue balance, no deposit, collect balance, chase reply and due this week.
- Production_Calendar: a 6-week month grid with cakes and servings due each day, a daily limit flag, and a 12-line bake and decorate plan for the next 14 days.
- Monthly_Summary: one printable page with orders, servings, sales, cost, gross profit, average prices and unpaid balance for 12 months, plus a chart.
- Dashboard: 12 KPI tiles and 2 charts.
- README.txt and LICENSE-and-Terms.txt.
How it works
- Enter your hourly rate, overhead, margin and deposit rule on Settings.
- Enter your ingredient pack prices and check the base recipes.
- Price an enquiry on Price_Calculator and send the order summary.
- Log each booked order with its deposit, then record the balance when paid.
- Check the calendar each week and the dashboard for unpaid balances.
Details
- Format: Excel workbook (.xlsx). No macros.
- Language: English. Currency is a label you choose.
- Software: Excel 2016 or later, or a spreadsheet program that opens .xlsx files.
- Delivery: instant digital download. Nothing is shipped.
Good to know
- All sample recipes, prices and orders are illustrative. Replace them with your own figures.
- Servings per tier are a guide. Use your own serving chart if it differs.
- Selling food from home may need a licence, food safety training or allergen labels. Verify local requirements.
- Single-user license. Do not share or resell the files.
FAQ
How is the cake price set?
The full cake cost (ingredients, supplies, extras, your labour and overhead) plus your margin, or servings times your minimum price per serving, whichever is higher. It then rounds up.
Can I use my own recipes?
Yes. Rename the 8 recipe columns on Ingredient_Costs and enter your own quantities per batch.
Does it handle cupcakes?
Yes. Choose the cupcakes size on the calculator and the cupcakes cake type in the order log.
Does it work in Google Sheets?
It opens in Google Sheets and the formulas calculate. Check the drop-downs after import.
Is this a physical product?
No. It is a digital download. Refund terms follow the store policy at the time of purchase.
