Companion files · The Private Markets Career Guides
How to Run a Profitable Bakery and Patisserie: Pricing, Costing Cards, Waste, Night Production, Wholesale Accounts, Cake Orders, Cash and Selling the Business.
These are the companion files of the book. Six workbooks follow Ambervane Bakehouse, the fictional bakery-patisserie of the case, across two fiscal years: the counter and prices, costing and waste, wholesale and the route, special orders, people and the oven, and cash, the lease and value. Each keeps the case’s figures in one column and an empty column for yours. A toolkit holds the checklists of Appendix B in editable form.
The archive holds the six workbooks, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links, no password. The workbooks recalculate in Excel, LibreOffice or Google Sheets.
Chapters 3 and 4
Tickets by month and open days, the value of a fixed set of 100 tickets under each price list, and the average ticket, for both years. Sheets: Inputs, Tickets by month, Value of 100 tickets, Average ticket. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 118 KBChapters 5 and 6
Costing cards priced at each year’s ingredient prices, unit costs after production loss, the ingredient share of each price, and the close sheet with where the unsold went. Sheets: Inputs, Costing cards, Unit cost, Close sheet. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 223 KBChapters 9 and 10
The delivery route stop by stop, what each wholesale account left after ingredients, standard labor and delivery against the 25 percent rule, and an offer tested before it is signed. Sheets: Inputs, Route, Accounts, Offer test. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 320 KBChapter 11
Celebration cakes per pastry hour, wedding cakes at the price per serving of their booking date, holiday preorders, and the customer deposits held. Sheets: Inputs, Celebration cakes, Wedding cakes, Holiday and deposits. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 422 KBChapters 7 and 8
Payroll by group and December overtime, oven loads by month against capacity, and a second oven bought with a loan or leased. Sheets: Inputs, Payroll, Oven loads, Second oven. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 519 KBChapters 12, 13, 14 and 16
Both income statements and prime cost, month-end cash, the rent test against net income, seller’s discretionary earnings and the founder’s planning range. Sheets: Inputs, Income statement, Cash and rent, SDE. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 621 KBAppendix B
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.
Download the toolkit41 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to change first.
Download the read-me5 KB| Average ticket | $1,188,007 of counter sales / 105,528 tickets = $11.26 in FY2026 |
| A croissant | costing card $0.99 / 0.98 sellable = $1.01 a unit, 21.3 percent of its $4.75 price |
| The largest account | Mallowen Coffee left $23,780 of $154,758, 15.4 percent, against a rule of 25 percent |
The files are provided as they are, without warranty of any kind. The model is illustrative: Ambervane Bakehouse, Corrowick, the accounts, the venue, the mill and every party are fictional, and the prices, ingredient prices, wages, hours, rents and multiples are the book’s assumptions, not market terms or the practice of any real bakery. A costing card prices a product; it is never a recipe. Overtime, food labels, sales tax and lease terms depend on your state and city: ask counsel, your health department and your outside CPA.