Blood Bank Inventory Management: Blood Types, Shelf Life & Shortage Risk
Run the stock of a blood service by the numbers: demand by blood group vs donor supply, the simplified ABO/RhD red-cell compatibility matrix with IF, AND, OR and SUMPRODUCT, days of supply with red/amber/green alerts, shelf life and FIFO with COUNTIFS and MINIFS, outdate rates and their cost, donor collection planning with deferrals and no-shows, 5-day platelet ordering and an inventory dashboard with a chart – 8 labs at one fictional regional blood service, every cell checked instantly. Operations practice only, not clinical guidance.
The first lesson is free — no account needed.
About this course
A blood bank inventory management course that runs the stock of one fictional regional blood service by the numbers, for blood bank and transfusion lab staff, hospital supply chain planners and health operations students. You compare weekly red-cell collections by blood group with hospital demand, build the simplified ABO/RhD red-cell compatibility matrix with IF, AND, OR and SUMPRODUCT, turn units on hand into days of supply with red, amber and green alerts, track expiry dates and the next unit to issue under FIFO with COUNTIFS and MINIFS, calculate the outdate rate and its cost, plan donor sessions backwards from the units needed with deferrals and no-shows, set order-up-to levels for platelets with a 5-day shelf life and build a stock dashboard against target. Operations practice only with simplified compatibility rules, not clinical guidance. The first lab is free.
Lessons
- Demand by Blood Group vs Donor SupplyFree
- The Red-Cell Compatibility Matrix with IF, AND, OR & SUMPRODUCT Pro
- Days of Supply by Group & Red / Amber / Green Alerts Pro
- Shelf Life & FIFO: Expiry Dates, Units Expiring Within N Days & What to Issue Next Pro
- Outdate (Wastage) Rate, Its Cost & Months Above Target Pro
- Donor Collection Planning: Deferrals, No-Shows & Sessions Pro
- Platelets: a 5-Day Shelf Life, Order-Up-To Levels & Outdates Pro
- Blood Inventory Dashboard: Days of Supply vs Target with a Chart Pro