When Should You Use FIFO vs FILO? A Practical Guide to Warehouse Strategies

What are FIFO and FILO?

FIFO (First In First Out) : items that entered the warehouse first are shipped first, ensuring inventory turnover.

FILO (First In Last Out) : newer items are shipped first, older items stay longer.

Example: purchase A product on March 1 (3 units @ 8 ¥), March 5 (9 units @ 7 ¥), March 9 (2 units @ 10 ¥). Under FIFO, shipping 8 units costs 3×8 + 5×7 = 59 ¥. Under FILO, cost = 2×10 + 6×7 = 62 ¥. Different valuation methods lead to different cost of goods sold.

FIFO vs FILO – How to Choose?

1. FIFO: The survival rule for food stores

FIFO ensures the earliest goods are sold first, preventing expiration.

Suitable for:

Food & beverage (e.g., perishable dairy)

Pharmaceuticals & cosmetics

Electronics when rapid turnover is needed

Advantages: clear inventory flow, avoids holding expired stock.

2. FILO: The wisdom of hardware stores

FILO prioritizes newer items, keeping older stock longer.

Suitable for:

Hardware fasteners (nails, screws) that do not expire

Strategic reserves (e.g., grain storage)

Clearance of new products to free space

Advantages: easier warehouse management, fast promotion of new items.

Four key questions to select the right strategy

1. Does the product deteriorate?

Yes → default to FIFO

No → choose based on other factors

2. Does the owner need quick cash?

Urgent cash → prioritize selling new items

Stable cash flow → follow normal rotation

3. Is there an intelligent warehouse system?

WMS present → mix strategies per zone

Manual only → stick to one method

4. Are there regulatory constraints?

Food/medicine → must use FIFO

General goods → more flexibility

Real‑world case studies

1. Hema Fresh – automatic “night market discount” and smart price tags reduce waste by 60%.

2. IKEA – large furniture uses FILO, small items use FIFO, turning the warehouse into a showroom.

3. Xiaomi – “hungry marketing”: new products launched with FILO to create hype, older models switched to FIFO for rapid cash recovery.

Final takeaways

New batches do not have to follow FILO; FIFO remains the gold standard for most industries, especially regulated sectors like food and pharma. FILO serves as a complementary strategy for specific scenarios. Companies should base the choice on product characteristics, business goals, and technological capabilities, leveraging smart systems for dynamic management.