# The Bakery Business Owner: companion files

Julian R. Sterling

## What is here

- BKBO_1_Counter_and_Prices.xlsx (Chapters 3 and 4; Counter and Prices workbook of Appendix A): sheets Inputs, Tickets by month, Value of 100 tickets, Average ticket, then Checks. Tickets by month and open days (106,668 then 105,528 tickets), the value of a fixed set of 100 tickets under each price list ($1,039.25 then $1,125.75) and the average ticket ($10.39 then $11.26).
- BKBO_2_Costing_and_Waste.xlsx (Chapters 5 and 6; Costing and Waste workbook): sheets Inputs, Costing cards, Unit cost, Close sheet, then Checks. The costing cards priced at each year's ingredient prices, unit costs after production loss (a croissant at $0.93 then $1.01), the ingredient share of each FY2026 price, and the close sheet (17,235 then 9,640 units unsold at close).
- BKBO_3_Wholesale_and_Route.xlsx (Chapters 9 and 10; Wholesale and Route workbook): sheets Inputs, Route, Accounts, Offer test, then Checks. The route by stops ($21.31 then $20.76 a stop), what each account left after ingredients, standard labor and delivery (Mallowen Coffee 15.4 percent, Osbrey Market 44.8 percent, the two restaurants 24.9 percent in FY2026), and the grocer's offer tested loaf by loaf ($0.50 left).
- BKBO_4_Special_Orders.xlsx (Chapter 11; Special Orders workbook): sheets Inputs, Celebration cakes, Wedding cakes, Holiday and deposits, then Checks. Celebration cakes per pastry hour ($28.01 then $31.77), each wedding cake at the price per serving of its booking date (average $893 in FY2026), holiday preorders ($18,630 in FY2026) and the customer deposits held.
- BKBO_5_People_and_Oven.xlsx (Chapters 7 and 8; People and Oven workbook): sheets Inputs, Payroll, Oven loads, Second oven, then Checks. Payroll by group ($716,648 then $780,786 of labor), December overtime, oven loads by month against the 44 a night, and a second oven bought with a loan or leased ($93,600 of lease payments over five years).
- BKBO_6_Cash_Lease_and_Value.xlsx (Chapters 12, 13, 14 and 16; Cash, Lease and Value workbook): sheets Inputs, Income statement, Cash and rent, SDE, then Checks. Both income statements ($99,231 then $132,049 of net income) and prime cost, month-end cash, the rent test, seller's discretionary earnings ($207,904 then $246,277) and the founder's planning range ($467,926 to $615,693).
- BKBO_Bakery_Owner_Checklists.docx: the 8 checklists of Appendix B, editable (Costing a product; Opening a wholesale account; A special order and its deposit; Closing the day and the unsold; The production plan; The monthly review; Renewing the lease; Preparing a sale).

## How to use the workbooks

The first tab of each workbook, Inputs, holds every input in two input columns, followed by a Used column: the case's figures in blue on a light blue background, and an empty yellow column for yours. The Used column takes your figure when you type one and the case figure otherwise, and every other sheet reads the Used column. Black type is a formula, green type a link to another sheet. Rebuild the case first: the Checks sheet of each workbook compares the live cells with the figures printed in the book and reads ALL CHECKS OK while the yellow column is empty. Each of the 18 exercises of Appendix A is done in the workbook it names.

The arithmetic is plain: add, subtract, multiply, divide and round. When a figure is rounded, the note at the top of the sheet says how.

Two inputs to try first:

1. In BKBO_2_Costing_and_Waste.xlsx, on Inputs, type the butter price on your latest invoice: every costing card that carries butter, and every unit cost after it, moves at once.
2. In BKBO_3_Wholesale_and_Route.xlsx, on Inputs, type the units and sales of your own largest wholesale account: the Accounts sheet shows what it leaves against the 25 percent rule.

To use a workbook on your own bakery, fill the yellow column from your point-of-sale system, your mill and supplier invoices, your own costing cards and close sheets, payroll reports, the route log, the order book, the bank statements and the lease, in the order Appendix A gives, and keep a copy with the case column for comparison. Set your conventions with your outside CPA first: when a sale becomes revenue, and how money received before the goods is shown. The workbooks are separate files with no link between them.

## A word of caution

Ambervane Bakehouse, LLC, the town of Corrowick, its founder, head baker and staff, its wholesale accounts, the venue, the mill and the regional grocer are fictional. Prices, ingredient prices, quantities, wages, hours, counts, rents, rates and multiples are teaching assumptions, not market norms or recommendations. A costing card prices a product; it is never a recipe. Whether overtime is owed and at what rate, what a food label must say, whether a bakery item carries sales tax, and how a lease clause holds in your state are questions for counsel, your health department, your outside CPA and your state's agencies. No real bakery, chain, mill, venue, platform, software or supplier is described or recommended. Nothing here is legal, tax, food safety, insurance or accounting advice.
