Editable spreadsheets + coordinated planning pages
The Home Bakery Operations Kit
Recipe costs, orders, production and ingredient stock. Enter ingredient pack quantities and costs on Stock. Build each recipe with its yield, ingredients, batch labor and other costs.
Checking checkout availability…
One kit per checkout. Read the purchase and refund terms and use license before paying. Your card statement may show STORELEA.COM.
Inside your kit
- 7 visible workbook tabs with editable inputs, linked calculations and a summary chart
- A clean XLSX for your own records and a separate fictional worked example
- 18-page printable planning guide plus a 3-page quick start
- Recipes: Ingredient cost comes from Recipe ingredients.
- Recipe ingredients: Enter ingredient quantities for one recipe batch, using the exact unit from Stock.
- Orders: Store the agreed unit selling price as a historical record.
- 5-page editable DOCX and fillable PDF document set: order inquiry, order confirmation, production brief, order handoff record, customer messages
- Native Google Sheets blank and worked-example copy links
A simple place
to begin.
A solo baker organizing a small menu and direct customer orders.
- Enter ingredient pack quantities and costs on Stock. Build each recipe with its yield, ingredients, batch labor and other costs.
- Record orders using the actual agreed selling price. Enter payments against Order ID. Current recipe costs do not reprice earlier orders.
- Schedule production and enter completed units. Ingredient stock decreases from completed batches; record opening stock and receipts for the same tracking period.
The details
- Included files
- Home-Bakery-Guide.pdf
Bakery-Customer-Messages.txt
Home-Bakery-Workbook.xlsx
Home-Bakery-Workbook-Example.xlsx
Bakery-Editable-Order-Documents.docx
Bakery-Editable-Order-Documents.pdf
Quick-Start.pdf
Start-Here.txt
Google-Sheets.html
Google-Sheets.txt - Workbook tabs
- Bakery overview · Recipes · Recipe ingredients · Orders · Production · Stock · Payments
- File use
- Choose Google Sheets copy links or the included Excel-format files. Sign in to Google and choose Make a copy to save an editable workbook in your Drive. Use the clean workbook for your records and the separate fictional example to learn. Customize the DOCX prompts and save completed copies. Type into the fillable companion or print the main planning guide. PDF pages are US Letter; use Fit when printing on A4.
- Compatibility
- XLSX formulas were checked during authoring and independently recalculated in LibreOffice. Native Google Sheets blank and worked-example copies are included and were checked for formulas and visual layout. A Google account is required to save an editable copy. Native Microsoft Excel testing is not confirmed. DOCX opens in Word or a compatible document editor. Use a PDF reader that supports forms for the fillable companion. Save and reopen to check your entries. The main guide is printable.
- Use terms
- One purchaser may use this kit in one business. Customize and share completed client-facing forms and messages with your own clients. Do not redistribute, resell, publish, or sublicense the source workbook, guide, or blank templates.
- Important limits
- An operations kit, not a food-safety manual, recipe collection, legal agreement, or approval to sell food. Confirm permitted products, labeling, handling, and sales channels with your local authority. Costs and rates in the examples are fictional. No tax calculation or payment collection is included.
Ready for your details.
A clean workbook for you.
A separate filled example to follow.
Cream cells are editable. Formula cells calculate the results. These previews show fictional records in the included example file.
Open full preview ↗02 / Recipes
Open full preview ↗03 / Recipe ingredients
Open full preview ↗04 / Orders
Open full preview ↗05 / Production
Open full preview ↗06 / Stock
Open full preview ↗07 / Payments
Open full preview ↗Follow the example
A fictional cupcake batch costs 11.90. At a 40% margin and zero payment fees, its unit guide price rounds up to 1.66. Completed production reduces ingredient stock without repricing historical orders.
Your first session
Open the separate example workbook to follow the demonstration. Enter your own records in the clean workbook.
Recipes: 100 rows · Recipe ingredients: 200 rows · Orders: 100 rows · Production: 100 rows · Stock: 100 rows · Payments: 100 rows Rows added beyond the stated capacity are not automatically included in summaries. XLSX example calculations were checked in LibreOffice. Native Google Sheets editions were checked for formulas and visual layout. Native Microsoft Excel testing is not confirmed.
Ready to make your own.
Actual pages from the editable companion.
Look inside.
Actual pages from the guide.
