Guide, 2026-11-04

How to track food waste cost in a cafe or bakery

Most cafes and bakeries know they throw food away. Far fewer know what it costs, which items cause it or why it happens. Without those answers the usual fix is a vague plan to "bake a bit less", which is a guess. Tracking waste for a few weeks turns the guess into numbers you can act on.

What to record each day

For every item you make or prepare, write down five quantities for the day:

• Produced: how many you made or put out.
• Sold: sold at full price.
• Discounted: sold at a reduced price, for example end-of-day markdowns.
• Donated: given away.
• Binned: thrown away.

Add a reason for anything binned, such as overproduction, dropped, expired or returned. Choose a short fixed list of reasons and stick to it, otherwise you end up with twenty slightly different labels that cannot be added up. The five quantities should add up to what you produced. If they do not, something was miscounted, and it is better to catch that on the day.

Put a cost on it

Quantities alone do not show where the money goes. Give each item a unit cost: what one unit costs you to make or buy. If you have costed your recipes, use the cost per portion. Then:

• Cost of binned and donated items = quantity x unit cost.
• Markdown given away = discounted quantity x (full price - discounted price).
• Cost of waste = both of the above added together.

Counting the markdown is optional but useful. A discounted pastry is not thrown away, yet you still gave up part of its price because it was not sold in time.

A worked example

A bakery makes 40 croissants. Each costs $0.60 to make and sells for $3.00. At closing time the day looks like this:

The quantities add up: 31 + 5 + 3 + 1 = 40. Two ratios are worth tracking:

• Waste % = (binned + donated) / produced = 4 / 40 = 10%.
• Sell-through = (sold + discounted) / produced = 36 / 40 = 90%.

One day tells you little. The pattern over weeks is what matters, so compare each item with a target waste % you choose yourself.

Find the main reason

After a few weeks, add up the cost for each reason. Suppose a cafe's binned items cost $30.00 over a month:

The shares add up: 18.00 / 30.00 = 60%, 7.50 / 30.00 = 25% and 4.50 / 30.00 = 15%. The figures are made up to show the method, but the lesson is general: the biggest reason is where to start. Here it points to batch sizes, not to staff training or storage.

Look at weekdays and top items

Group waste by weekday. Many shops find that one or two days produce most of the waste, and that is where production should be trimmed. Then rank items by cost of waste, not by number of units. A cheap item binned in large numbers can cost less than a few expensive ones, so the order by cost is the order to work through.

Common mistakes

• Logging only what is binned and forgetting what was produced, so no percentage can be worked out.
• Using the selling price instead of the unit cost for binned items, which overstates the loss.
• Leaving the reason blank, so the cost cannot be split by cause.
• Changing several things at once and then not knowing which change worked.
• Judging after one week. Quiet and busy weeks differ, so compare a trend.

When a ready-made log saves time

A sheet like the one above is quick for a handful of items. With a full counter, the totals, percentages and weekly trends take effort to maintain. WasteBook is an Excel log with produced, sold, discounted, donated and binned per item per day, cost of waste from your unit costs, waste % and sell-through by item, waste by reason, a 12-week trend, waste by weekday, a top 10 list and data checks for unknown items or missing reasons. It records quantities and costs only, with no food-safety or temperature records, and you enter the unit costs yourself.