To track shrinkage, weigh each crate when it comes in, weigh what you throw away or cannot sell, and divide what is left by what you bought. That gives you the usable percentage. Divide what you paid by the usable kilos and you get the true cost per kg, which is the price you must beat before you earn anything.
Why is the buying price not your real cost?
If you buy 25 kg of tomatoes at ₹30 per kg you pay ₹750. If 4 kg turn soft and go into the bin, you can only sell 21 kg. Your cost is not ₹30 per kg any more: it is ₹750 divided by 21 kg, which is about ₹35.71 per kg. Pricing at ₹36 would leave you with nothing.
How do you record it, crate by crate?
- When a lot arrives, write the date, item, supplier or mandi trip, kilos and the amount you paid.
- Keep each lot separate on the counter, even if only with a chalk mark, so the rot can be matched to the lot.
- Each evening, weigh what you remove as rotten, crushed or unsellable, and note it against the lot.
- When the lot is finished, write the kilos thrown and work out the usable percentage and cost per usable kg.
The formulas for a row where B is kilos bought, C is amount paid and D is kilos thrown are: usable kilos =B2-D2, usable percentage =(B2-D2)/B2, and cost per usable kg =C2/(B2-D2). Format the percentage column as a percent.
What do three made-up lots look like?
| Item | Bought (kg) | Paid | Thrown (kg) | Usable (kg) | Usable % | Cost per usable kg |
|---|---|---|---|---|---|---|
| Tomatoes | 25 | ₹750 | 4 | 21 | 84% | ₹35.71 |
| Bananas | 20 | ₹800 | 2 | 18 | 90% | ₹44.44 |
| Coriander | 10 | ₹600 | 3 | 7 | 70% | ₹85.71 |
All of these numbers are made up. Notice that coriander, bought at ₹60 per kg, really costs ₹85.71 per kg once the wilted bunches go. A leafy item can need a much bigger markup than a hardy one, and you only see that when you measure.
How much should you add on top of the true cost?
Decide the rupee gain you want for each kilo, then add it to the true cost. For the tomato lot, if you want ₹8 per kg, the price is 35.71 + 8 = ₹43.71, so you would round to ₹44. If your shrinkage next week is worse, the price needed rises; if it is better, you can hold or lower it.
Do this per lot, not once a year. Shrinkage swings with the season, the supplier and how many days a lot sat in the heat.
What can you change once you see the numbers?
- Compare suppliers or mandi trips: if one source regularly gives 70 percent usable and another 85, the cheaper rate may not be cheaper.
- Buy less of the items that go bad fastest, and more often.
- Sort and remove spoiling pieces on the day they arrive so they do not damage the rest of the crate.
- Move soft fruit to a cheaper rack or bundle it before it becomes waste.
- Check storage: shade, airflow and not stacking heavy crates on top of soft ones.
What to keep after each week
At the end of the week, list each item with its usable percentage and cost per usable kg. Compare this week with last week for the same item. If an item shows a dip you cannot explain, check which lot it came from before you blame the weather.
Cash purchases at the market can be entered by hand in SpendixAI, several at once, so the amount in your cost column has a record behind it.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

