From a waste log to a shopping decision: a worked example

Start with three records you can check

For this demonstration, imagine a six-banana purchase costing $3.00. Two bananas were discarded because no snack was planned: the allocated cost is $3.00 × 2 ÷ 6 = $1.00. A second record is half of a $4.00 broccoli purchase, allocated at $2.00, because a planned dinner was cancelled. A third record is half of a $4.00 loaf, allocated at $2.00, because another loaf was opened first. These are synthetic records, not a report from our kitchen.

The downloadable CSV keeps the purchase quantity, discarded quantity, units, package price and reason on the same row. The arithmetic assumes the units within each purchase have equal value. If pieces have very different sizes, use measured weight instead. Do not quietly mix a count of bananas with a weight in grams. Mark uncertain prices as estimates and retain your receipt if you want to compare later.

Reproduce the calculator before interpreting it

Open the waste calculator from the Tools menu. Enter 3 in Produce, 2 in Bread & grains, and 0 in the other four categories. Leave People in household at 2. The weekly input is $5.00. The tool multiplies weekly cost by 52, so its annual scenario is $260. Monthly cost is $5.00 × 4.33 = $21.65, displayed as $22; the annual per-person value is $130. Produce is the largest entered category.

Export calculation downloads the six category totals as a CSV. It does not include the original food names, quantities or discard reasons, so keep the row-level worksheet as well. Reopen the exported file and confirm that Produce is 3 and Bread & grains is 2 before using the result elsewhere. A single annual headline without these inputs is difficult to check and easy to overinterpret.

Choose a change that matches the reason

In the example, the banana record suggests buying a smaller quantity or assigning the ripe fruit to specific snacks. The broccoli record points to a cancelled-meal backup plan. The bread record suggests keeping one clearly marked open package and checking it before opening another. These are different causes; buying new containers for everything would not directly address all three.

Choose just one change for the next shopping cycle and write it before starting. For example: “Check the open bread before adding a loaf to the list.” Record what actually happened, including exceptions. If guests arrive or the number of meals at home changes, note that context instead of attributing every difference to the new routine. A change in discard cost alone does not establish what caused it.

Separate waste prevention from food safety

The worksheet never decides whether an item should be eaten. Follow recalls, package instructions and applicable handling guidance first. Record food discarded for an uncertain history honestly; do not recover a number on the spreadsheet by eating questionable food. USDA’s leftovers guidance addresses cooling, refrigeration and storage conditions, while EPA’s household guidance helps with shopping and planning. They serve different purposes.

The calculator uses purchase cost only. It does not estimate nutrition, carbon emissions, illness risk or labour. The $260 scenario assumes the same $5 week repeats for 52 weeks, which this three-row example cannot demonstrate. Seasonal prices, household size and shopping patterns may change. To describe actual results, keep dated observations across comparable periods and report the range and missing data.

Keep the demonstration separate from your observations

Save the example file with “example” in its name. Start your own log with the blank worksheet from Downloads rather than overwriting the sample and later forgetting which rows were real. Record the event when it happens, not from memory at the end of a month. If you did not measure an amount, label it estimated. If a row is missing a price, leave that limitation visible rather than entering zero and calling the total complete.

At the end of the week, keep the original rows, your category totals and the calculator export together. Summarize one repeated reason and one change worth trying. You now have a record that another household member can inspect and a routine you can repeat. You do not yet have evidence of an annual saving, a general storage recommendation or a result that applies to every household.

Use the details you have

Questions that need a little more context