FIFO and FEFO are two rules for deciding which stock to use or ship first. For most products they give the same answer. For anything with an expiry date they can give very different results, and the difference shows up as stock you throw away.
The two rules
| FIFO: first in, first out | FEFO: first expired, first out | |
|---|---|---|
| Picks first | The stock that arrived first | The stock that expires first |
| Best for | Products without expiry dates, or where every lot has the same shelf life | Food, beverage, pharmaceuticals, chemicals, cosmetics and adhesives |
| Needs | Receipt dates | Expiry dates for every lot |
| Goes wrong when | A newer delivery expires sooner than older stock | Expiry dates are missing or wrong in the system |
FIFO assumes older stock expires sooner. That is often true, but not when a supplier ships stock from an older production run, when lots have different shelf lives, or when returns come back with less life left.
A worked example
You sell 4 units a day. Today you hold two lots of 200 units each:
- Lot A arrived first and expires in 91 days.
- Lot B arrived 9 days later, but was made earlier, and expires in 44 days.
| FIFO | FEFO | |
|---|---|---|
| Sold first | Lot A, which takes 50 days | Lot B, until its date on day 44 |
| What happens to the other lot | Lot B reaches its date on day 44, while Lot A is still selling | Lot A sells from day 44 to day 91 |
| Units that expire unsold | 200, all of Lot B | 36: 24 of Lot B and 12 of Lot A |
Same stock, same sales, and 164 fewer units in the bin. FEFO cannot sell more than demand allows, but it makes sure the stock with the least time left goes first.
FEFO and accounting
FIFO is also a method for valuing inventory in your accounts. Picking by expiry date in the warehouse and valuing stock by FIFO in the books are separate decisions, and many companies do both. Ask your accountant before changing the costing method.
What FEFO needs
- An expiry date on every lot when it is received, not added later.
- Stock stored so the earliest-expiring lot can be reached, or a system that directs the pick.
- A rule for the life customers need. Many buyers reject stock with less than a set number of days left, which moves every date earlier.
FEFO is not enough on its own
FEFO decides the order stock leaves the shelf. It cannot help if you hold more than will sell before the dates arrive. That is a buying problem: an order sized for the best price or a supplier minimum can be more than the market will take within its shelf life. Check the stock you hold against its dates with the free expiring inventory calculator.
Seeing expiry risk across every item
The Expiry risk page in the Statadventure Optimization Lab applies FEFO to every lot you load, at the forecast rate of sale, and flags suggested orders that are too large for their shelf life. See expiry date tracking and shelf life management. For stock that has stopped selling altogether, read how to find dead stock.
See expiry risk on sample data
The live demo needs no account. Use the sample company or load your own files, which stay in your browser tab.
Frequently asked questions
What does FEFO stand for?
First expired, first out: the stock with the earliest expiry date is used or shipped first.
Is FEFO better than FIFO?
For products with expiry dates, usually yes, because it sends the stock with the least life left first. For products that do not expire, FIFO is simpler and does the job.
Can I use FEFO in the warehouse and FIFO in the accounts?
Yes. Picking order and inventory costing are separate decisions. Confirm the costing method with your accountant.
Try the Statadventure live tools
Inventory tools for US manufacturers: reorder point, safety stock, EOQ and landed cost, with the inputs and assumptions shown.
Open the live tools