Pharmacy Inventory Operations: Par Levels, Expiry & Turnover

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn 30 days of issues into usage per day and set a par level for ten products, then value the stock that the par levels tie up.
• Calculate this week's order for ten products: the gap to par after stock on hand and on order, rounded up to whole packs, and its value.
• Classify ten products twice: ABC by the money they tie up and XYZ by how steady their monthly usage is, so each product gets a combined class such as AX or CZ.
• Check ten lots against the stock report date: days to expiry, how much of each lot will be used in time once earlier lots go first, and which lots to remove, use first or hold.
• Value a quarter's write-off log, total it by reason, measure waste against purchases and chart where the money goes.
• Measure how fast each stock category turns over, convert it into days on hand and find how much stock sits above a 30-day target.
• Measure how well the pharmacy served the wards in September: unit and line fill rates, in-stock days, and the products that missed the service target.
• Reconcile the month's register for eight controlled products: expected balance, counted vs expected, discrepancy flags and a variance chart.