A bread production sheet turns tomorrow's orders into three numbers the bakers can work from: how many pieces of each product, how many kilos of each dough, and how many trays for the oven. Each row is a product. You type the wholesale orders and the retail number; the sheet adds them, multiplies by the scaling weight (the raw dough weight of one piece), and divides by pieces a tray. A second sheet adds the dough up by kind, because rolls and brioche buns come from the same enriched dough, and tells you how many mixes that is. At the end of the bake you type what came out, and the sheet shows short or over. Below is one day for a made-up bakery, and the file.
The short version
- One row a product: wholesale orders + retail = pieces to bake.
- Dough needed = pieces × scaling weight.
- Add dough by kind, not by product. Then divide by what the mixer holds.
- Trays = pieces ÷ pieces a tray, rounded up.
- Write what was actually baked. Short or over is tomorrow's lesson.
- TaroStack scales each dough's recipe to the day and takes the flour off stock. More below.
One day
| Product | Dough | Wholesale | Retail | To bake | Scaling weight | Dough needed | A tray | Trays |
|---|---|---|---|---|---|---|---|---|
| Country sourdough boule | Country sourdough | 36 | 24 | 60 | 900 g | 54.0 kg | 6 | 10 |
| Seeded sourdough boule | Seeded sourdough | 12 | 10 | 22 | 900 g | 19.8 kg | 6 | 4 |
| Baguette | Baguette | 48 | 30 | 78 | 350 g | 27.3 kg | 5 | 16 |
| Whole wheat pan loaf | Whole wheat | 20 | 12 | 32 | 800 g | 25.6 kg | 8 | 4 |
| Dinner rolls | Enriched | 240 | 60 | 300 | 60 g | 18.0 kg | 24 | 13 |
| Brioche buns | Enriched | 120 | 24 | 144 | 85 g | 12.2 kg | 15 | 10 |
That's 636 pieces, 157 kg of dough and 57 trays.
Dough by kind
| Dough | Kg needed | Mixer holds | Mixes |
|---|---|---|---|
| Country sourdough | 54.0 | 40 kg | 2 |
| Seeded sourdough | 19.8 | 40 kg | 1 |
| Baguette | 27.3 | 40 kg | 1 |
| Whole wheat | 25.6 | 40 kg | 1 |
| Enriched (rolls and buns) | 30.2 | 40 kg | 1 |
Six mixes. The country sourdough needs two, so its second mix has to be timed so both are ready to shape together, or the day's 60 boules come out of the oven an hour apart. That's what the mixes column is for: it turns a kilo figure into a schedule.
From kilos of dough to kilos of flour is one more step, through the recipe: see baker's percentage calculator. A dough at 75% water with 2% salt and 20% starter is about 51% flour by weight, so 54 kg of country dough starts with roughly 27 kg of flour.
Scaling weight is not the loaf's weight
Bread loses water in the oven. A boule scaled at 900 g comes out near 780 g. A baguette scaled at 350 g comes out near 290 g. If the label or the wholesale price list promises a weight, the scaling weight has to be set above it by your own bake loss, which depends on the shape, the oven and the time. Weigh ten loaves before and after and you have it.
Add a little for what sticks to the tub and the bench. This bakery mixes 2% over the sheet's figure.
Retail is a guess, so make it a good one
Wholesale orders are known the day before. Retail isn't. Keep a note of what sold and what was left for each weekday, and set the retail number from that, not from a feeling. The sheet's last columns help:
| Product | To bake | Baked | Short or over | Note |
|---|---|---|---|---|
| Baguette | 78 | 75 | -3 | 3 torn at loading |
| Everything else | 0 |
Three baguettes short. Wholesale gets filled first, so retail had 27 and not 30. If that happens most days, the answer is to scale three extra, not to hope.
Working back from the oven
The sheet says what to make. When to start is a second sum, worked backward from the time bread has to leave:
| For bread out at 5:30 AM | Country sourdough |
|---|---|
| Bake, 38 minutes, in two loads | Load 1 at 4:10 AM |
| Final proof, cold, overnight | Shaped by 4:00 PM the day before |
| Bulk ferment, 4 hours | Mixed by 11:30 AM |
| Starter fed | 7:00 AM |
Those times are this bakery's, for its dough and its room. Yours are different, and they change with the season. A week's plan across products is in bakery production planning.
Get the sheet
Download the bread production sheet. Two sheets and a read-me: the bake sheet, where pieces, dough and trays work themselves out, and the doughs sheet with kilos and mixes. Print it for the bench each afternoon. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. What a loaf costs is in bread cost calculator, and the orders this sheet starts from in bakery order form template.
Where this stops working
The sheet needs the orders typed in every afternoon, from emails, texts and a standing-order list. One cafe's change that arrives at 6 PM misses it. And the sheet says 27 kg of flour for the country dough without knowing there are 20 kg in the bin until the baker opens it at 11 AM.
How TaroStack does it
TaroStack starts from the orders and ends at the flour bin.
Each dough is a recipe, and each bread uses it. Recipes can contain other recipes: the boule's recipe is 900 g of country dough, and the dough's recipe is flour, water, salt and starter, with a scrap allowance.
Orders drive the plan. On Growth, planning turns the sales orders into what to make and what to buy, and says in plain words what will run short.
"What could I make right now" says how many boules the flour on hand allows.
Baking is a batch. Record 60 boules and the dough's ingredients come off stock from the lots used, noted on the batch record automatically.
Recipe truth. From your own batches, TaroStack shows whether a recipe yields what it claims, which is where a scaling weight that's a little off shows up.
| The job | Production sheet | In TaroStack |
|---|---|---|
| Pieces from orders | Typed in each afternoon | From the sales orders (Growth) |
| Flour for the day | Kilos of dough, then a sum | The recipes, scaled |
| Enough flour? | Open the bin | What could I make right now |
| Short every day by three | Noticed, eventually | Recipe truth |
Recipes and batches are on every plan, from $9.99 a month (5 recipes); planning is on Growth at $39 a month (50 recipes). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
