How do you calculate dough yield?

Divide the usable dough weight by the total mixed batch weight. 2,380 lb usable from a 2,500 lb batch is 95.2%, 0.8 points under a 96% target; the 120 lb lost is about 107 pieces at 18 oz and 50.40 at 0.42 a pound, the Dough Yield Percentage calculator's own example.

What counts as usable dough?

The dough that reaches the divider, sheeter or depositor in a condition to run. Bowl and hopper scrapings, floor loss, trim that is not reworked and dough held past its floor time are not usable. Weigh it before any rework dough is added back.

Should water be in the mixed batch weight?

Yes. Count every ingredient scaled into the mixer, water and ice included, because all of it becomes dough. Leaving water out can push the yield above 100%.

How are pieces lost worked out?

Dough lost in pounds × 16 ÷ the scaling weight in ounces. At an 18 oz scaling weight every 9 lb of lost dough is eight fewer loaves; at 2.5 oz a bun, 79 lb is 506 buns.

What dough yield target should I set?

One from validated runs of that product on that line, not an aspiration. Trimmed and laminated products run well below straight doughs; the example sets 88% for croissants and 96% to 97% for bread and buns, as invented targets for a fictional bakery.

Does the workbook use macros?

No. It is a plain .xlsx with ordinary formulas, tables and native charts. The Verify sheet re-checks the formulas against fixed test batches and shows Self-check: PASS.

Industry Cost Kits

Dough Yield Tracker Excel Template

Dough yield = usable dough weight ÷ total mixed batch weight. Log every mixer batch and see its yield against the product's target, and the dough lost between the mixer and the divider in pounds, in pieces at your scaling weight and in ingredient cost, totalled by product.

Free, and a plain .xlsx with no macros to enable. A CSV with live formulas and a printed how-to guide come with it.

Overview

This dough yield template is a working Excel workbook for bakery production managers, process and R&D bakers, shift leads and plant controllers. Each mixer batch is one row with the product, the scaled weight of everything that went into the mixer, water included, and the weight of dough that reached the divider, sheeter or depositor in a condition to run; each product's scaling weight, target dough yield and ingredient cost per pound come from Setup. The workbook gives the dough yield, the points short of target with a status in words, and the dough lost as pounds, as pieces at the scaling weight and as ingredient cost, with the pieces the batch is short of target. It totals every product over its batches. It ships with twelve batches of four products at a fictional bakery, so every tile and chart is filled in when you open it.

In the example a white pan loaf batch made 2,380 lb of usable dough from 2,500 lb mixed: 95.2%, 0.8 points under its 96% target. The 120 lb lost is about 107 18 oz loaves and 50.40 of ingredients. A bun batch lost 79 lb to divider hopper scrapings, 95.6% against 97%: 506 buns, 160 of them below target. The croissants run at their 88% target, but trim at 1.15 a pound makes them the most expensive loss, 247.25 over three batches. Across the twelve batches the bakery kept 95.4% of what it mixed and lost 1,001 lb worth 587.80.

Dough yield ends at the divider: bake and cooling loss come later and are separate. The download is a plain .xlsx with no macros. A CSV with live formulas is also included for other tools; the dashboard, charts, dropdowns and self-check are in the .xlsx.

What this template includes

Setup sheet with your bakery, currency and near band, and the products with their scaling weight, target dough yield and dough cost per lb
Batches table, one row per mixer batch: batch, date, shift, product, mixed batch weight and usable dough weight, with a Check column
Per batch: dough yield, gap to target in points, a status in words, dough lost, pieces lost, cost of dough lost, pieces short of target and pieces the usable dough makes
Dashboard with four tiles (dough yield, dough lost, cost of dough lost, batches below target), yield against target by batch, cost of dough lost by product, and the batch and product tables
Method sheet with every formula, and a Verify sheet that re-checks the formulas against an independent reference and the Dough Yield Percentage calculator (Self-check: PASS)
CSV with live formulas for the Batches table; the dashboard, charts, dropdowns and self-check are in the .xlsx

Suggested use case

Use it for a daily yield review against standard, to price dough waste for the plant manager, or to check a divider setting or formula change over several batches.

How to use it

On Setup, type your bakery, currency and near band, and list your products with their scaling weight, target dough yield and dough cost per lb.
On Batches, give each mixer batch a row: batch, date, shift, product, mixed batch weight and usable dough weight.
Fix anything the Check column names.
Open the Dashboard: yield against target for every batch, and what the lost dough costs by product.

Frequently Asked Questions

How do you calculate dough yield?: Divide the usable dough weight by the total mixed batch weight. 2,380 lb usable from a 2,500 lb batch is 95.2%, 0.8 points under a 96% target; the 120 lb lost is about 107 pieces at 18 oz and 50.40 at 0.42 a pound, the Dough Yield Percentage calculator's own example.
What counts as usable dough?: The dough that reaches the divider, sheeter or depositor in a condition to run. Bowl and hopper scrapings, floor loss, trim that is not reworked and dough held past its floor time are not usable. Weigh it before any rework dough is added back.
Should water be in the mixed batch weight?: Yes. Count every ingredient scaled into the mixer, water and ice included, because all of it becomes dough. Leaving water out can push the yield above 100%.
How are pieces lost worked out?: Dough lost in pounds × 16 ÷ the scaling weight in ounces. At an 18 oz scaling weight every 9 lb of lost dough is eight fewer loaves; at 2.5 oz a bun, 79 lb is 506 buns.
What dough yield target should I set?: One from validated runs of that product on that line, not an aspiration. Trimmed and laminated products run well below straight doughs; the example sets 88% for croissants and 96% to 97% for bread and buns, as invented targets for a fictional bakery.
Does the workbook use macros?: No. It is a plain .xlsx with ordinary formulas, tables and native charts. The Verify sheet re-checks the formulas against fixed test batches and shows Self-check: PASS.