Business

Wastage percentage in plain words: how to calculate it for your shop

Wastage percentage is unsold or spoiled quantity divided by quantity bought or made. See a made-up bakery week and how to use the number to price and plan.

Editorial illustration for Wastage percentage in plain words: how to calculate it for your shop

Wastage percentage is the quantity you threw away or could not sell, divided by the quantity you bought or made, multiplied by 100. If you baked 460 buns in a week and 55 went unsold, the wastage is 55 / 460 x 100, which is about 12 percent. It is one number that tells you how much of your effort and money never reached a customer.

What is the formula, step by step?

  1. Count the quantity you bought or made in the period: a day, a week or a month.
  2. Count the quantity that was spoiled, unsold or thrown away in the same period.
  3. Divide the second number by the first.
  4. Multiply by 100 to get a percentage.

In a spreadsheet, if made quantities are in B2:B8 and unsold in C2:C8, the formula is =SUM(C2:C8)/SUM(B2:B8), formatted as a percent. Use the same unit on both sides, either pieces or kilos or litres, never a mix.

What does a made-up bakery week look like?

DayBuns madeUnsoldWastage %
Mon60610%
Tue6035%
Wed60915%
Thu6035%
Fri60610%
Sat801215%
Sun801620%
Week4605512%

The week's wastage is 55 / 460 = 0.1196, which rounds to 12 percent. A common slip is to average the seven daily percentages instead. That would give (10 + 5 + 15 + 5 + 10 + 15 + 20) / 7 = 11.4 percent, which is wrong because Saturday and Sunday are bigger batches and should count for more. Always add the quantities first and divide once.

How do you turn it into rupees?

Say each bun costs ₹8 to make. Made: 460 x 8 = ₹3,680. Wastage: 55 x 8 = ₹440. You only had 405 buns to sell (460 - 55), so the cost of each bun you actually sold is 3,680 / 405 = ₹9.09, not ₹8.

This is the number to remember when pricing. If you charge ₹10 thinking you earn ₹2 on each bun, you really earn about ₹0.91 on those you sell. Wastage is a cost that every sold bun has to carry.

How do you use it to decide how much to prepare?

Look at the daily percentages, not only the weekly one. In the table above, Sunday leaves 20 percent unsold (16 out of 80), and Tuesday and Thursday leave only 5. That suggests Sunday's batch is too big and the weekday batch is about right.

Try a small change, such as 70 buns on Sunday instead of 80, and keep a note of whether you sold out early. If you run out by mid-afternoon, you lost sales and the batch was cut too far. Wastage is one side of the balance; running out is the other side.

Is there a good or bad percentage?

There is no number that is right for every shop. A flower seller, a dairy counter and a bakery have very different shelf lives, so compare with your own past weeks, with the same item a month ago, and with the same weekday in other weeks. If your figure is falling, your changes are working.

What to do with the number this week

  • Pick one item and work out its wastage percentage for the last seven days.
  • Work out its true cost per sold piece, using total cost divided by pieces sold.
  • Compare that with your price to see the real gain per piece.
  • Change the order or batch size by a small step and measure again next week.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports