Perishable Inventory Planning for Indian Food Brands
Shelf life is not the same as sellable life. Every channel takes a cut of your shelf life before you get to sell a single unit, and most food brands only discover the gap when the write-off lands.
- FSSAI has directed e-commerce food operators to deliver stock with at least 30 percent of shelf life or 45 days remaining before expiry, so a 180 day product cannot reach a customer after roughly day 126.
- Platform inbound gates are stricter than the delivery floor and commonly sit between 50 and 70 percent remaining life, which can cut your usable selling window to under a third of nominal shelf life.
- Size the batch as daily depletion multiplied by the sellable window in days, then apply a 0.7 to 0.8 coverage factor; anything above that ceiling is a pre-bought markdown.
- Carry an expiry write-off line of 1 to 2 percent of revenue for ambient packaged food, higher for chilled, and report actuals against it every month.
Every food brand knows its shelf life. Very few know their sellable life. The gap between the two is where margin quietly disappears, and it is decided months before anyone notices, at the production planning meeting.
Shelf Life Is Not Sellable Life
Your declared shelf life is the number your stability study supports. It is printed on the pack. It is not the number you get to sell against.
Two gates sit inside it. The first is the consumer delivery floor. FSSAI has directed e-commerce food business operators to ensure that food delivered to a customer carries at least 30 percent of its shelf life or 45 days remaining before expiry. Amazon India’s grocery listing policy reflects the same standard: at least 45 days or 30 percent remaining at the point the order reaches the customer. On a 180 day product that means the last shippable day is around day 126.
The second gate is tighter and arrives much earlier. Platforms apply their own acceptance rule when your stock is inbounded at a dark store or fulfilment centre. Typical norms sit somewhere between 50 and 70 percent remaining life, with the strictest bands on dairy, bakery and other short-life categories. Confirm the exact figure in your vendor agreement, because it varies by platform, varies by category and gets revised.
Run both gates against that 180 day product with a 60 percent inbound rule. You can only deliver into the platform up to day 72. You can only sell out to a customer up to day 126. Your sellable window is 54 days. You built a six month product and you own a two month selling season.
Work the Window Backwards
Fifty-four days is a ceiling, not a plan. Real time is consumed before the stock is even yours to sell.
- Co-packer quality release and microbiological clearance: commonly 5 to 10 days after the manufacturing date printed on the pack.
- Transit from plant to your regional warehouse: 3 to 6 days on most India lanes.
- Platform appointment and inbound slot: 3 to 10 days depending on city and season.
- Inbound checks and put-away before the unit is actually live to sell.
That is routinely 15 to 25 days gone before a single unit is sellable. On the same example your real window is closer to 30 to 40 days. Plan against that number, not against 180.
Two habits fix most of the damage. First, treat the manufacturing date as the start of the clock and get stock out of the plant fast. A batch resting three weeks in the co-packer’s warehouse is a batch you have already discounted. Second, allocate by remaining life, not by demand alone. The freshest stock goes to the strictest gate. Older stock goes to channels with softer rules, which usually means your own website, general trade or institutional sale.
Size the Batch to the Window
Most expiry losses are created in production planning, not in the warehouse.
The useful batch ceiling is simple arithmetic. Take daily depletion across the channels that can actually accept the stock, multiply by the sellable window in days, then apply a coverage factor of 0.7 to 0.8 so you are not banking on perfect sell-through. A SKU moving 400 units a day with a 40 day window gives a ceiling of roughly 11,000 to 13,000 units. Everything above that is stock you will eventually discount or destroy.
This is where contract manufacturer minimum order quantities cause real damage. If the MOQ is 25,000 units and your window ceiling is 13,000, you have not saved money on conversion cost. You have pre-bought a markdown and paid for the privilege. The usual fixes are to pay a changeover fee for a shorter run, split the MOQ across two production dates, or cut variant count so volume concentrates on fewer SKUs.
Variant proliferation is the quiet killer. Four flavours at the same MOQ is four times the exposure spread across a quarter of the demand each.
Markdown Timing and the Write-Off Line
Discounting near-expiry stock late is expensive. Discounting it early is cheap. The trigger has to be a date, not a mood.
Set three triggers per SKU, all measured in remaining life rather than calendar days:
- Review trigger: when remaining life approaches the inbound gate of your largest channel. From that day the stock cannot go there, so it needs a destination.
- Action trigger: roughly 15 to 20 days above the consumer delivery floor. A 10 to 15 percent promotion here usually clears at a cost you can absorb.
- Exit trigger: at the delivery floor. Beyond this the only routes are employee sale, B2B or institutional bulk, and disposal. Price for speed, not for margin.
Run this off a remaining-life bucket report by SKU and by city, refreshed weekly. Stock value reporting hides the problem, because a healthy total can contain one dead flavour.
Then budget the loss properly. Food distribution in India commonly runs expiry and spoilage losses of 0.5 to 2 percent of revenue on ambient packaged goods, and organised retail shrinkage sits around 1 to 3 percent of net sales with grocery at the higher end. Chilled and short-life categories run above that. Put the line in the profit and loss statement, set a target, and report actuals against it monthly.
A brand that budgets 1.5 percent and delivers 1.2 percent is running a business. A brand that budgets nothing and finds 4 percent at year end has been running a lottery with its working capital.