No products in the cart.
Module 12: Supply Chain Management & Inventory Control
Section 2: PAR Level Setting, ABC/XYZ Analysis, and Demand Forecasting
A deep dive into the science of inventory optimization. Learn how to set data-driven PAR levels, segment your inventory using ABC/XYZ analysis for targeted management, and begin to forecast future demand to move from a reactive to a proactive ordering model.
SECTION 12.2
Par Level Setting, ABC/XYZ Analysis, and Demand Forecasting
The Science of Knowing What You Need, Before You Need It.
12.2.1 The “Why”: From “Eyeballing” to Evidence-Based Ordering
In every pharmacy, there is a seasoned pharmacist or technician who possesses a seemingly magical ability to “feel” when the inventory is right. They walk the aisles, glance at the shelves, and instinctively know that it’s time to order more lisinopril or that the supply of ondansetron is running low. This intuition, born from years of experience, is an invaluable asset. It is also, however, a significant liability. This “eyeball method” of inventory management is not scalable, it is not transferable, and it is not precise. It is a reactive process that works until it doesn’t—often with a stockout of a critical medication at the worst possible time.
This section is about replacing that intuition with a systematic, data-driven science. The goal is not to eliminate the invaluable experience of your team, but to augment it with powerful analytical tools that allow you to manage your pharmacy’s multi-million dollar inventory with the same rigor you apply to clinical decision-making. We will move from setting “PAR levels” based on what feels right to calculating them based on historical usage, lead times, and desired safety stock. We will introduce sophisticated methods like ABC/XYZ analysis to segment your inventory, allowing you to focus your limited time and resources on the items that matter most, both financially and clinically.
Mastering these concepts represents a fundamental shift in mindset: from a reactive order-placer to a proactive inventory strategist. When you can confidently justify why you are stocking 10 vials of a high-cost biologic instead of 20, you are no longer just managing a shelf—you are managing a significant financial asset for the hospital. You are minimizing the capital that is tied up in inventory (holding costs), reducing the risk of waste from expiration, and, most importantly, ensuring that the right medication is always available for the right patient. This is the science of optimization, and it is a core competency for every modern pharmacy leader.
Retail Pharmacist Analogy: Managing the Cough & Cold Aisle
Think about managing the cough and cold aisle in your retail pharmacy. In the summer, your “PAR level” for cough drops is probably one or two boxes on the shelf. You “eyeball” it; when it’s empty, you order more. It’s a low-stakes, reactive process.
Now, it’s late October. The local news is forecasting a major cold front and the first flu cases are appearing. Your approach must change completely. You can’t just eyeball it anymore. You need to become a data scientist.
- Demand Forecasting: You look at your sales data from last November. You see that sales of cough drops, tissues, and decongestants typically triple in the first two weeks of the month. You are no longer guessing; you are using historical data to forecast future demand.
- PAR Level Setting: Based on this forecast, you don’t just order one box of cough drops. You calculate a new, seasonal PAR level. You know it takes your wholesaler one day to deliver (lead time), and you want an extra two days’ worth on the shelf just in case of a rush (safety stock). You use this formula to set a new, evidence-based PAR.
- ABC Analysis: You know that not all items are created equal. High-margin, high-volume products like the big brand-name cough syrups are your “A” items. You watch them like a hawk. Generic saline spray is a “C” item; you make sure it’s in stock, but you don’t obsess over it. You focus your energy on the products that drive the most revenue.
- XYZ Analysis: You also know that some items are critical, regardless of sales. The children’s fever reducer is a prime example. Even if it doesn’t sell as much as adult products, being out of stock would be a major failure of patient care. This is a “Z” item due to its clinical criticality. You will carry extra safety stock of this, even if the data says demand is low, because the cost of a stockout is too high.
This sophisticated, data-driven approach to managing your OTC aisle is the exact same methodology you will apply to your entire hospital drug inventory. You will learn to replace the summer “eyeballing” with a year-round, scientific process of forecasting, calculating, and stratifying your inventory to meet patient demand with maximum financial efficiency.
12.2.2 The Foundation: Data-Driven PAR Level Management
The most fundamental concept in inventory control is the PAR level. PAR stands for “Periodic Automatic Replenishment,” and it simply means the target quantity you want to have on hand for a specific item after an order is received. In many systems, an order is automatically generated when the quantity on hand drops below a certain reorder point, with the goal of bringing the stock back up to the PAR level.
The problem is not the concept, but the execution. In many pharmacies, PAR levels are “legacy” numbers, set years ago by someone based on their best guess. They are rarely updated and do not reflect changes in prescribing patterns, patient volume, or even the addition of new service lines. This leads to chronic understocking of some items and massive overstocking of others. The modern approach requires calculating PAR levels dynamically using a simple but powerful formula.
The Core PAR Level Formula
PAR = (Avg Daily Use × Lead Time) + Safety Stock
Masterclass Table: Deconstructing the PAR Level Formula
| Component | Definition | How to Determine It | Managerial Deep Dive & “Gotchas” |
|---|---|---|---|
| Average Daily Use (ADU) | The average number of units (tablets, vials, etc.) of a drug dispensed or administered per day. | This is a historical data pull. You need to extract dispensing/administration data from your pharmacy information system or ADC vendor software for a defined period (e.g., the last 90 or 180 days). $$ ADU = \frac{\text{Total Units Used}}{\text{Number of Days}} $$ |
The “Gotcha”: Data quality is everything. Are you capturing ALL usage? Does your data include waste? Does it exclude credits for returned doses? You must ensure your data source is accurate. Also, be wary of outliers. A single month of unusually high usage (e.g., for a specific research patient) can skew the average. You may need to “clean” your data by removing extreme outliers before calculating the true ADU. |
| Lead Time | The time, in days, from when you place an order with your supplier to when the product is checked in and available on your shelf. | This is typically defined by your wholesaler contract. For your primary wholesaler, this is almost always 1 day (order today, receive tomorrow). For drop-shipments from a manufacturer, this could be 2-5 days. | The “Gotcha”: You must account for the entire lead time, not just the delivery time. Does your order go out at 5 PM? Does it arrive at 8 AM but not get checked in by your staff until 3 PM? The true lead time is the full cycle. Also, consider weekends and holidays. If you don’t get a delivery on Sunday, the lead time for an order placed on Friday is actually 3 days, not 1. Your formula must account for the longest likely lead time. |
| Safety Stock | A buffer quantity of inventory held to mitigate the risk of a stockout caused by fluctuations in demand or delays in delivery. | This is the most strategic part of the formula. It is typically calculated as a certain number of days’ worth of ADU. A common starting point is 2-3 days of safety stock. $$ \text{Safety Stock} = ADU \times \text{Desired Days of Buffer} $$ |
The “Gotcha”: Safety stock is a balancing act. Too little, and you risk stockouts. Too much, and you have cash tied up in inventory that could be used elsewhere (this is called holding cost). The amount of safety stock should be strategic. For a critical, life-sustaining drug with a volatile supply chain, you might want 7 days of safety stock. For a non-critical, easily acquired generic, 1-2 days might be sufficient. This is where the ABC/XYZ analysis we discuss next becomes critical for setting safety stock levels intelligently. |
Putting It All Together: A Worked Example
Let’s calculate the PAR level for IV Acetaminophen 1000 mg vials in the Emergency Department ADC.
- Data Pull: You analyze the last 90 days of usage data from the ED ADC and find that 450 vials were dispensed.
- Calculate ADU: $$ ADU = \frac{450 \text{ vials}}{90 \text{ days}} = 5 \text{ vials/day} $$
- Determine Lead Time: Your wholesaler delivery arrives daily. However, the pharmacy tech only fills the ED ADC in the morning. So, the effective lead time to get a drug from the wholesaler into this specific machine is 1 day.
- Set Safety Stock: IV acetaminophen is important for pain/fever control and is used frequently. You decide on a 3-day buffer to prevent stockouts during busy weekends. $$ \text{Safety Stock} = 5 \text{ vials/day} \times 3 \text{ days} = 15 \text{ vials} $$
- Calculate PAR: $$ \text{PAR} = (5 \text{ vials/day} \times 1 \text{ day}) + 15 \text{ vials} = 5 + 15 = 20 \text{ vials} $$
Your new, data-driven PAR level for IV Acetaminophen in the ED ADC is 20 vials.
12.2.3 Strategic Segmentation: The ABC/XYZ Inventory Matrix
Calculating PAR levels for every single one of the thousands of line items in your pharmacy is impractical and inefficient. A core principle of strategic management is to focus your resources on the areas that will yield the greatest return. In inventory, this is achieved through segmentation. The ABC/XYZ analysis is the most powerful framework for doing this. It allows you to move beyond treating all drugs equally and to apply a tailored management strategy based on an item’s financial value and its usage predictability.
Part 1: ABC Analysis – Segmenting by Value
ABC analysis is an application of the Pareto Principle, also known as the 80/20 rule. In inventory terms, this means that a small percentage of your items will account for a large percentage of your total drug spend.
- “A” Items: The vital few. These are typically the top 10-20% of your inventory items that account for 70-80% of your annual drug spend. These are your high-cost biologics, oncology agents, and brand-name drugs.
- “B” Items: The moderately important. These are the next 20-30% of items that account for another 15-20% of spend. These are often your workhorse IV antibiotics, anesthetics, and higher-cost generics.
- “C” Items: The trivial many. These are the remaining 50-70% of your inventory items that only account for 5-10% of your total spend. These are your low-cost generics, oral solutions, and creams.
ABC Inventory Segmentation
80%
of Spend
A Items
~20% of Items
15%
of Spend
B Items
~30% of Items
5%
of Spend
C Items
~50% of Items
The A/B/C Management Philosophy
The entire point of this analysis is to tailor your management intensity.
- You manage A Items with extreme prejudice. You review their usage weekly or even daily. You keep safety stocks tight. You explore every opportunity to reduce inventory (e.g., consignment). Wasting a single vial of an “A” item can be a major financial hit.
- You manage B Items with standard diligence. You review them monthly. You use your calculated PAR levels and trust the system.
- You manage C Items with minimal effort. You might set very high PAR levels and only review them quarterly. The cost of carrying extra inventory of a “C” item is negligible compared to the labor cost of constantly managing it. Automate their ordering as much as possible.
Part 2: XYZ Analysis – Segmenting by Criticality & Velocity
ABC analysis is powerful, but it’s one-dimensional—it only considers financial value. A $5 vial of life-saving epinephrine is a “C” item financially, but a stockout would be a clinical catastrophe. XYZ analysis adds a second, crucial dimension: usage velocity or, more broadly, criticality.
- “X” Items: High velocity, predictable usage. These are the drugs with stable, consistent demand. Their usage pattern is easy to forecast. Examples include lisinopril, metformin, and saline flushes.
- “Y” Items: Medium velocity, variable usage. These items show some fluctuation in demand. Usage may be seasonal or follow less predictable patterns. Examples include oseltamivir (seasonal) or certain antibiotics.
- “Z” Items: Low velocity, erratic usage OR clinically critical. This is the most complex category. It includes drugs that are used rarely and unpredictably (e.g., CroFab for a snakebite) AND drugs that are absolutely essential and must be on hand regardless of usage frequency (e.g., code cart drugs like epinephrine, calcium chloride). The cost of a stockout for a Z item is exceptionally high, either clinically or reputationally.
The Power of the Matrix: Combining ABC and XYZ
When you combine these two analyses, you create a 9-box matrix that provides a sophisticated, nuanced playbook for managing every drug in your formulary. This matrix is the pinnacle of strategic inventory control.
The ABC/XYZ Inventory Management Matrix
A Items (Top 80% Spend)
B Items (Next 15% Spend)
C Items (Bottom 5% Spend)
X Items
(High Velocity)
AX: The Golden Quadrant. High value, steady use. Manage with Just-in-Time, low safety stock, daily monitoring. (e.g., a key formulary biologic)
BX: Workhorses. Moderate value, steady use. Use automated ordering with calculated PARs. Review monthly. (e.g., enoxaparin)
CX: Automated Zone. Low value, high use. Set high PARs, use automated systems, review quarterly. (e.g., saline flushes)
Y Items
(Variable Velocity)
AY: Forecast & Monitor. High value, variable use. Requires active forecasting and slightly higher safety stock. (e.g., seasonal IVIG use)
BY: Standard Management. The bulk of your inventory. Calculated PARs and standard safety stock are key. (e.g., common antibiotics)
CY: Buffer Up. Low value, variable use. Carry slightly more inventory to avoid nuisance stockouts. (e.g., potassium chloride oral solution)
Z Items
(Low Velocity / Critical)
AZ: The Danger Zone. High value, critical, rarely used. Strategy: Minimize stock (consignment?), have emergency plans. (e.g., Digifab, specific chemo agents)
BZ: Critical & Costly. Moderate value, must have. Maintain robust safety stock. Track expirations closely. (e.g., alteplase for stroke)
CZ: Antidotes & Necessities. Low value, absolutely critical. Stock to cover worst-case scenario, regardless of usage data. (e.g., Epinephrine, naloxone)
12.2.4 The Next Frontier: Introduction to Demand Forecasting
PAR levels and ABC/XYZ analysis are based on historical data. They provide a robust snapshot of what has happened. The next level of sophistication is demand forecasting—using historical data to predict what will happen. While complex algorithmic forecasting is typically handled by advanced software, understanding the basic concepts is essential for a manager.
- Moving Average: This is the simplest forecasting method. A 3-month moving average, for example, would forecast next month’s demand based on the average usage of the prior three months. It helps to smooth out random fluctuations but can be slow to react to trends.
- Weighted Moving Average: This method gives more weight to more recent data. For example, in a 3-month weighted average, you might apply a 50% weight to last month’s data, 30% to the month before, and 20% to the month before that. This allows the forecast to be more responsive to recent changes in usage.
- Seasonality: This involves identifying and planning for predictable, seasonal spikes in demand. Your oseltamivir ordering should not be based on usage in July. A good forecasting model will analyze year-over-year data to predict the timing and magnitude of flu season and adjust PAR levels accordingly.
Your Role as Manager: Partner with Technology
You do not need to calculate weighted moving averages on a spreadsheet for 3,000 line items. Your role is to understand these concepts so you can effectively manage and evaluate the technology platforms that do. Modern inventory management systems (from your wholesaler or third-party vendors) have these forecasting tools built in. Your job is to:
- Ensure the data feeding the system is clean and accurate.
- Understand the forecasting model the system is using.
- Review the system’s recommendations and apply your clinical and operational judgment. The system might not know that a new surgeon who uses a lot of a specific antibiotic has just started, but you do. You can override and adjust the forecast based on this “soft” intelligence.
