Free expiring inventory calculator

This free calculator shows how much of an item will reach its expiry date before it sells at your current rate, and the largest new order that can sell before it expires. It runs in your browser.

Expiring inventory calculator

Estimates for planning only. Results depend entirely on the numbers you enter. Nothing you enter is stored or sent.

The formulas

Sellable before the date = min( units in stock , units a day × ( days to expiry − days customers need ) )
Will expire unsold = units in stock − sellable
Largest order that sells in time = units a day × ( shelf life − days customers need − max( 0 , sellable ÷ units a day − lead time ) )

A worked example

You hold 400 units that expire in 30 days and sell 10 a day. You can sell 300 before the date, so 100 units (25%) will expire unsold. A new delivery has a 30-day shelf life and arrives in 7 days. Today’s sellable stock lasts 30 days, so the new stock waits 23 days before it starts selling, and only 70 units of it can sell in time. A planned order of 500 is 430 units too large. For more detail, read FEFO vs FIFO.

Frequently asked questions

Why does the new order have to wait?

It is sold after the stock you already hold. The longer today’s stock lasts, the less of a new delivery’s shelf life is left when it starts selling.

What are days of life customers need?

Many buyers reject stock with less than a set number of days left. Enter that number and the calculator treats those last days as unsellable.

What if I hold several lots with different dates?

Check each lot in date order, earliest first, and take the units each one sells off the sales left for the next. The Optimization Lab’s Expiry risk page does this for every lot.

Related

Want every lot and every suggested order checked against its date? The Optimization Lab’s Expiry risk page does it from your own data, on the Planner and Growth plans.

Try the live demoSee plans and pricing
Scroll to Top