Skip to content

Bread Production Sheet: From Orders to Dough to Trays

A free bread production sheet for a bakery: orders and retail by product, pieces to bake, dough needed by scaling weight, mixes, trays, baked against plan.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 20, 2026 · 6 min read

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.

Questions people also ask

What is a bakery production sheet?

A daily list of each product, how many to bake, the dough that takes, and the trays, built from wholesale orders and the retail number.

How do I calculate how much dough I need?

Multiply the pieces to bake by the scaling weight of one piece, then add up the products that share a dough.

What is scaling weight?

The weight of raw dough for one piece. It's more than the baked weight, because bread loses water in the oven.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.