Pharmacy Inventory Operations: Par Levels, Expiry & Turnover
Run a pharmacy store room by the numbers: usage per day and par levels, reorder quantities to par, ABC by value and XYZ by variability, expiry risk with FEFO, waste and write-offs, turnover and days on hand, fill rates and stock-outs, and controlled-substance count reconciliation – 8 labs on one fictional hospital pharmacy, every cell checked instantly. Operations only, placeholder products, no dosing content.
The first lesson is free — no account needed.
About this course
A pharmacy inventory management course that runs one fictional hospital pharmacy store room by the numbers in a spreadsheet, for pharmacy technicians, pharmacists, buyers and healthcare operations students. You turn 30 days of issues into usage per day and par levels, calculate orders that top up to par in whole packs, classify products by value (ABC) and demand variability (XYZ), check lots for expiry risk with first-expiry-first-out, value write-offs and waste against purchases, measure inventory turnover and days on hand against a 30-day target, calculate unit and line fill rates and stock-outs and reconcile a controlled-substance register with discrepancy flags. Placeholder products and operations only, with no dosing content. Always follow local regulations and your organisation's procedures. The first lab is free.
Lessons
- Usage per Day & Par LevelsFree
- Reorder Quantities: Topping Up to Par Pro
- ABC by Value & XYZ by Demand Variability Pro
- Expiry Risk: Days to Expiry, Expected Usage & FEFO Pro
- Waste Cost & Expired Write-Offs Pro
- Inventory Turnover & Days on Hand Pro
- Stock-Outs, Fill Rates & Service Level Pro
- Controlled-Substance Count Reconciliation Pro