Free AuditEnterprise AIShelfSense
Back to Blog
ShelfSense by ShelfLifeProNov 17, 20267 min read

Case Pack Minimum Overstock: When Perishables Outlive Sales

Ordering a slow perishable by the full case means part of it expires. Compare units per case, daily sales and shelf life, then split, resize or drop the line.

SE

ShelfLifePro Editorial Team

Inventory management insights for retail and pharmacy

The case that never empties

You order one case of the oat-milk yogurt because that's the only way the distributor ships it. Part of it sells. The rest sits at the back of the dairy cooler until someone finds it on the date-check walk and drops it in the shrink bin.

Next week you reorder, because the shelf looked empty. The same thing happens again. The item isn't failing. It sells steadily, just slower than the case is big.

That's the case-pack problem in one line. The supplier's minimum order quantity decides how much you hold, not your customers.

Why case packs and slow sellers collide

A case pack is sized for the supplier's warehouse and truck, not for your shelf. A case that's gone in two days at a busy store can sit for two weeks at a small one, and the date on the pack doesn't care which store it ended up in.

Your reorder setup makes it worse. Picture a min/max rule that says "reorder at zero, order one case." Every order is a full case. The shelf only hits zero after the expired units get pulled. And the waste never looks like a reason to change the order. It shows up as a shrink line, and nobody connects it to the case size.

Then there's the receiving gap. The shelf life left when product reaches you is shorter than the shelf life printed on it, because it already spent days moving through the supplier's chain. The date on the package isn't the number that matters. What matters is how many days you get between the delivery truck and the day you'd pull the item.

The test: case size, daily sales, usable shelf life

You need three numbers per item, and you already have all of them somewhere:

  • Units per case. Off the invoice or the order guide.
  • Average daily sales. Units sold over a recent stretch of weeks, divided by the number of days in it. The sell-through method in reorder point calculation works here too.
  • Usable shelf life at receipt. Days between delivery and your pull date, not the printed date.

Divide units per case by daily sales and you get the number of days it takes to sell one case. Compare that with usable shelf life. If the case sells out first, you're fine. If it doesn't, part of every case is set up to expire, and better rotation won't fix it. FEFO gets the oldest unit out first, but it can't sell units nobody is buying.

Call the result the coverage ratio: days to sell a case divided by usable days. Below one, the case clears. Above one, the excess is waste you've built into the order.

A worked example across four lines

For example, picture four chilled lines at a small grocery (illustrative figures, not benchmarks):

  • Half-gallon whole milk: 6 per case, sells 3 a day, 10 usable days. A case clears in 2 days. Ratio 0.2. Nothing to do.
  • Fresh pasta: 8 per case, sells 0.6 a day, 12 usable days. A case takes about 13 days. About 7 sell and roughly 1 is at risk per case. Ratio about 1.1. Borderline.
  • Oat-milk yogurt: 12 per case, sells 0.5 a day, 14 usable days. A case takes 24 days. About 7 sell and 5 expire. Ratio about 1.7.
  • Specialty hummus: 12 per case, sells 0.25 a day, 10 usable days. A case takes 48 days. About 2–3 sell and 9–10 expire. Ratio 4.8.

Say you reorder the yogurt every two weeks all year. Five units per case expire, about 26 cases go out, so around 130 units hit the bin. And your reports log every one of them as shrink, not as an ordering decision.

For example, you might set your own thresholds like this: under 1.0, leave the line alone. Between 1.0 and 1.5, try a split case or an earlier markdown. Above 1.5, change the pack or the line. Those cut-offs are a starting point you'd tune, not a rule anyone published.

Option one: ask for a split case

Break-case ordering means the distributor ships less than a full case. Whether yours will do it is something only your rep can tell you. Some charge a handling fee, some only break cases on dry goods, and some say no to chilled product entirely. Ask anyway.

Go in with the arithmetic instead of a complaint. "This line sells about half a unit a day and I get two weeks of usable life. A full case means five units in the bin every time." A rep can take that to their buyer. "Can you split cases?" goes nowhere.

If the answer is no, there are a couple of workarounds. A sister store or a friendly neighbor carrying the same line can split cases with you. A cash-and-carry wholesaler may sell singles you can top up with between full orders.

Free template

Get the free expiry-tracking spreadsheet

Batch-level rows, days-left and status formulas, colour-coded alerts, and a live value-at-risk summary. Works in Excel and Google Sheets. See what's inside.

Instant download. No spam, unsubscribe in one click.

Option two: switch the pack size or format

Plenty of lines come in more than one configuration. Check the order guide for:

  • A smaller case pack. The per-unit cost may be higher, so compare it with the units you're currently throwing away.
  • A smaller consumer size. It sells faster per unit and might move better in a small store anyway.
  • A longer-dated format. Frozen, shelf-stable or extended-life versions of the same product keep a lot more usable days at receipt.
  • A different supplier. If one supplier keeps delivering with short dates left, that's worth tracking. A supplier shelf-life scorecard helps.

Each switch lowers the coverage ratio from a different side. A smaller case cuts days to sell. A longer-dated format adds usable days.

Option three: drop the line

When the ratio is well above your threshold and nobody will split a case, the honest answer may be to stop stocking it. That's hard when a few regulars ask for it by name.

The middle ground is special order. Bring it in for the customer who wants it, on their schedule, and stop carrying it on the shelf. If you're not sure whether a line is slow or actually dead, slow movers vs dead stock walks through how to tell them apart.

Markdowns as a bridge

While you wait on the rep's answer or a pack change, the units that won't clear can still bring in some money. Mark them down early, while there's still time for a discounted unit to sell, not on the last day. Dynamic markdown pricing for near-expiry products covers timing and discount depth.

Just don't let markdowns become the permanent fix. A line that needs a markdown on every single case is telling you the case is the wrong size.

Running the check by hand

You can do all of this in a spreadsheet. Add four columns next to each chilled or fresh line: units per case, daily sales, usable days, coverage ratio. Sort by ratio and work down the list. The expiry-tracking spreadsheet template gives you a starting layout.

Then close the loop with what actually got pulled. If your date-check walks write down item and quantity, as in the department date-check logs, you can check whether the lines with high ratios are the ones filling the shrink bin. What to log for grocery shrink goes into which fields make that comparison possible. The same thinking applies to produce, covered in fresh produce shrinkage.

What the spreadsheet won't do is stay current. Daily sales drift with seasons and promos, usable days change when a supplier's dates slip, and nobody recalculates every line every week. So you end up doing the check once, fixing the worst offenders, and missing the next one as it creeps over the line.

Where a daily agent fits

This is the gap ShelfSense by ShelfLifePro was built for. It's a daily inventory agent that works alongside the system you already have. Once a day it reads your stock, batch, cost and expiry records and flags at-risk batches days ahead. For each one it shows the units that won't clear, the projected loss and a recommended markdown. It also flags slow movers that are losing margin, and it sizes reorders from sell-through and cost basis. Every call shows its arithmetic, and a person approves it. It won't change a price or place an order on its own, and it can't make your distributor split a case. That conversation is still yours, but you'll have the numbers for it.

You can start with a CSV export of your stock and expiry dates from your POS. ShelfSense's free audit reads one CSV export, no account needed. The Watch tier is free forever at 30 SKUs β€” a daily scan and a health report. Start free on the ShelfSense page, or see how it reasons through a recommendation first.

SE

ShelfLifePro Editorial Team

The ShelfLifePro editorial team covers inventory management, expiry tracking, and waste reduction for pharmacies, supermarkets, and retail businesses worldwide.

One question, optional

What would stop you from trying ShelfLifePro?

See what batch-level tracking actually looks like

ShelfLifePro tracks expiry by batch, automates FEFO rotation, and sends markdown alerts before stock expires. 14-day free trial, no credit card required.

Prefer to talk it through? Book a 30-min call

Newsletter

The monthly expiry-tracking brief

One short email a month, only when there is something worth reading. FEFO tactics, markdown math, and real-world waste-reduction wins. Unsubscribe anytime.

No spam. Unsubscribe in one click.