Business

Milk and curd returns: tracking spoilage in a dairy shop

A daily returns and spoilage log for a dairy shop: packets and loose milk, cost per litre after spoilage, and what unsold curd cups cost you over a month.

Editorial illustration for Milk and curd returns: tracking spoilage in a dairy shop

A dairy shop needs one daily log with five numbers per product: received, sold, returned to the supplier, spoiled at the shop and left over. Once you have it, spoilage turns into a cost per litre and a cost per cup that you can set against your margin. Even a few unsold curd cups a day add up faster than most owners expect.

What goes into the daily log?

DateProductReceivedSoldReturned to supplierSpoiled at shopReason
12 OctToned milk packet12011442Leak, short date
12 OctCurd cup 200 g605703Unsold, warm fridge
12 OctLoose milk (litres)807703Curdled

The rows are made up. A line is correct when received equals sold plus returned plus spoiled, adjusted for any stock left over from yesterday. If the line does not balance, find the difference before you close the book. Check with your supplier on how returns and credit notes work, and write down every credit note amount as it comes.

How do you convert loose-milk loss into a cost per litre?

Say you buy 80 litres of loose milk at ₹52 per litre. That is ₹4,160. You sell 77 litres and 3 litres curdle. Your cost per sold litre is 4,160 / 77 = ₹54.03, not ₹52.

If you sell at ₹60 per litre, your margin per sold litre is 60 - 54.03 = ₹5.97, instead of the ₹8 you thought you were earning. Over the day you took in 77 x 60 = ₹4,620 and paid ₹4,160, leaving ₹460. Had all 80 litres sold, the figure would have been 4,800 - 4,160 = ₹640. Three curdled litres cost you ₹180 that day.

What do a few unsold curd cups cost over a month?

Say a curd cup costs you ₹14 and sells for ₹20, so the margin is ₹6. Over a made-up week the unsold cups were: Monday 3, Tuesday 2, Wednesday 4, Thursday 2, Friday 3, Saturday 5, Sunday 6. That is 3 + 2 + 4 + 2 + 3 + 5 + 6 = 25 cups.

  • Cost of the week's unsold cups: 25 x ₹14 = ₹350.
  • Cost over four weeks at the same pace: ₹350 x 4 = ₹1,400.
  • Extra cups you must sell to earn that back at a ₹6 margin: 350 / 6 is about 58 cups a week.

That is nearly a full day's cup sales just to cover waste. Looked at this way, ordering four fewer cups on the slow days is worth testing.

How do you decide how much to order tomorrow?

Look at the last two weeks of the same weekday, not the last two days. If curd sells out by evening on Saturdays and Sundays but leaves 2 or 3 cups on weekdays, order the weekday numbers lower and keep weekends as they are. Move by small steps, and write the change in the log.

What can you do with near-date packets?

  • Move them to the front and put the later dates behind.
  • Offer them first to regular customers who buy daily and use milk the same day.
  • Keep a separate line in the log for items sold at a reduced rate, with the amount recovered.
  • Write off what is unsafe to sell; do not sell dairy that you are unsure about.

A weekly review in five minutes

  1. Total each product's returned and spoiled quantities for the week.
  2. Multiply by cost per piece or per litre to get the rupee loss.
  3. Divide by what you received to see the share lost, so you can compare this week with last.
  4. Pick the one product with the largest loss and change its order for the coming week.

Supplier payments made by UPI or bank transfer show up on your statement, and an import into SpendixAI lets you categorise them as dairy purchases and see them month by month.

SPENDIXAI JOURNAL

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

Explore your reports