Shelf Life & FIFO: Expiry Dates, Units Expiring Within N Days & What to Issue Next
This lesson is part of the course
In this lesson
You give every red-cell unit its expiry date and days left, count the units per group expiring within 7 days with COUNTIFS and find the next unit to issue under FIFO with MINIFS and INDEX/MATCH.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Demand by Blood Group vs Donor Supply Locked
- The Red-Cell Compatibility Matrix with IF, AND, OR & SUMPRODUCT Locked
- Days of Supply by Group & Red / Amber / Green Alerts Locked
- Shelf Life & FIFO: Expiry Dates, Units Expiring Within N Days & What to Issue Next Locked
- Outdate (Wastage) Rate, Its Cost & Months Above Target Locked
- Donor Collection Planning: Deferrals, No-Shows & Sessions Locked
- Platelets: a 5-Day Shelf Life, Order-Up-To Levels & Outdates Locked
- Blood Inventory Dashboard: Days of Supply vs Target with a Chart Locked