Inventory Control
Introduction
The advice presented in this post are solely based on my four-year experience in inventory management at my hospital. Hopefully, these will serve as some tips when you are new to inventory management.
As the rule of thumb, we should practice FEFO principle (i.e. First Expiry First Out).
- When receiving new stocks, remember to compare the expiry date of new and existing stocks.
- Storing medications with different expiry date at different location to avoid confusion is a handy measure. This is because humans are forgetful.
NOTE: For the details in inventory management in logistics pharmacy at government facilities, you may refer to Garis Panduan Pengurusan Farmasi Logistik Kementerian Kesihatan Malaysia, 2020 and Modul Latihan Farmasi Logistik, 2024.
Monthly Usage
As the rule of thumb, when comes to inventory management, the decision should not be based on one's intuition. The important parameter that we should always refer to will be monthly usage. However, monthly usage is a fluctuating figure, hence I usually tabulate the data to make informed decision.
- The average monthly usage of the past 3 months, and also
- Trying to identify if there is any noticeable trend in the 3 individual monthly usage (either has been fairly stable or on an increasing/decreasing trend) - possibly a change in clinical management or clinical practitioner at your facility?
The fluctuation in monthly usage will be seem as much larger when a slow-moving item suddenly has a surge in usage.
- In these cases, you should identify the cause where possible: Is it a once-off surge or a real increase in usage?
- Should we factor the increment into average monthly usage calculation?
In certain inventory software system, the average monthly usage can be auto-calculated, but it does not take into account seasonal fluctuations in demand or supply chain disruptions.
NOTE: In a manual inventory management system, bin card serves as a crucial tool for tracking stock levels and usage. Each time stock is received or issued, the bin card is updated immediately to reflect the change in quantity.
Minimum and Buffer Stock Level
For all items, we will establish minimum, buffer and maximum stock levels to guide stock ordering.
- Unlike the minimum stock level, the buffer stock represents additional inventory held to mitigate the risk of stockouts or shortages due to demand fluctuations, supply chain disruptions or lead time variability.
- When the stock level falls below the buffer stock level, a stock reorder will be initiated.
- Conversely, when the stock reaches the minimum level, we must be vigilant in expediting the order and managing the supply.
Several factors should be considered when setting the buffer stock level.
- How much does customer demand fluctuate?
- How quickly can we expect to receive stock after ordering?
- How much does it cost to store inventory?
- How frequently do we plan to place orders?
- How long can the product be stored before it expires?
- It is important to avoid excessively frequent ordering and restocking, as these processes consume valuable time (ordering, unpacking, and stocking).
In a community pharmacy setting, for slow-moving yet expensive items, it may be prudent to purchase only upon customer request (potentially requiring a deposit).
- Conversely, for inexpensive, slow-moving items, purchasing a quantity sufficient for several months' usage with each stock order may be advantageous.
NOTE: Stock reordering should not occur when the stock level is significantly above the buffer stock level, unless justified by specific circumstances (e.g., promotional pricing or a sudden increase in demand).
Maximum Stock Level
While theoretically stocking as much as possible might seem appealing, it is impractical and potentially detrimental in practice.
- Several key factors must be considered, including available cash, storage space, item turnover rate, and expiry dates.
- Limited shelf space in many community pharmacies makes it advantageous to stock a smaller quantity of each item, allowing for a broader selection of brands and products.
Stock at hand is ONLY stock at hand if it remains unsold and available for patients/customers.
- Resources should be prioritized and allocated to the most necessary and urgent needs.
- In a community pharmacy, maintaining consistent cash flow is paramount, and excessive stock is undesirable.
- Furthermore, customers often avoid purchasing medications with short expiry dates, and their definition of "short expiry" can be as long as six months.
For fast-moving items, purchasing a few months' supply (e.g., 2-3 months) in advance is often justifiable. However, caution is advised when setting maximum stock levels for slow-moving items.
- For slow-moving items, the maximum stock level could, if necessary, be equal to the minimum stock level.
- This implies that the stock is primarily held for a specific regular customer/patient.
Projecting Future
Inventory management involves projecting future item movement.
- We are trying to predict how much stocks we need for a certain period of time, based on current data.
- To better foresee the trend of medication usage, it is just as important for logistics pharmacist to be updated with latest clinical management and medical news.
Regardless, predicting is only an estimation and to have an accurate prediction, the monthly usage should always be recalculated based on the latest 3 months, NOT to use an old monthly usage data.
- You may be surprised to see how vastly different the monthly usage is compared to a year ago.
- In fact, the longer the period that you would like to project based on current usage, the higher the risk of variation in real usage in actual period later.
In short, staying alert with item movement in our daily work is important to pick up new trends.
- Once a trend is noticed, we should work on it if needed (e.g. ordering more stocks).
Inventory Decisions
In starting up a new pharmacy, we might keep a larger range of products but only restricting it at a later stage. To determine the range of products to be kept in a pharmacy (i.e. inventory catalogue), we should consider carefully
- Customer demographics such as gender, age distribution, socioeconomic status
- Trend of demands
- Seasonality (e.g. gifts, cough and cold products, influenza vaccines and sunscreen products)
- Sales promotion by manufacturers of specific products.
However, when deciding to discontinue a product, the decision should not be made solely on item movement.
- Bear in mind that if a product is always nil in stock, the item movement will be zero too because no purchasing by customers can occur.
NOTE: Different from government hospital and clinic, community pharmacy keeps a few brands for a single medication. Normally, proprietary brands will be kept along with few local population or pharmacist preferred generic brands.
Outliers
Life is never as rosy as we wished. There are quite a number of circumstances which are just as important but out of our control:
- Promotion price for a period of time or above certain quantity
- Minimum delivery order
- Stock disruption
- Change in practice management
However, the underlying principle remains the same: To order what you need, NOT to overstock.
Managing Stock Disruption
Medication stock disruption is a serious problem that pharmacists have to face from time to time. For patients, shortages can potentially lead to
- Harm
- A patient may be forced into noncompliance with their medication regimen, which could lead to their condition worsening.
- Inconvenience
- A patient may have to travel to multiple pharmacies in order to find the medication they need, or they have to return to his doctor to be prescribed with an alternative drug.
- Uncertainty
- Insufficient supplies of a medicine can cause anxiety about long-term management of a medical condition. Patients may worry about whether or not they will be able to get the medication they need in the future.
- Dissatisfaction
There are many potential reasons for shortage or unavailability of medicines.
- Local stock management issues
- e.g. Stock ordering levels are wrong, rarely used medicines have expired by the time they are needed.
- Regulatory
- e.g. Drug recall due to failure of quality assurance, new manufacturing standards being implemented.
- Manufacturing failure
- e.g. Catastrophes at factory, raw material shortage.
- Unexpected increased national or local demand
- e.g. Evidence-based changes in practice, sudden changes to the use of an infrequently used product due to shortage of the first-line choice.
- Distribution and logistical problems
- e.g. Delays in shipment, problems with the supply chain.
- Product discontinuation by manufacturer.
- Due to manufacturer going out of business or the product becoming unprofitable.
When this happens, government healthcare facilities have to take immediate actions to minimize the impact of the problem on patients' healthcare.
- First, estimate how long can the stocks at hand last based on current usage trend.
- If the stocks are insufficient, try to borrow medications from other healthcare facilities to bridge the gap until the stock is resumed.
- When the stock level is limited, start restricting the amounts of medications supplied to patients at each supply (e.g. every 1-2 weeks) to prevent medication wastage.
- If the stock disruption is prolonged, discuss with doctors to devise alternative medications plans.
- Stay in constant communication with suppliers to keep updated with medication arrival news.
NOTE: Beware there could be still further delays on stock resumption based on the earliest time arrival from the supplier.
Summary
Inventory management is the process of ordering, storing, and using a company's inventory.
- It is important to manage inventory effectively to avoid stockouts, overstock, and waste.
There are a number of factors to consider when managing inventory, such as:
- Demand: How much inventory is needed to meet demand?
- Cost: How much does it cost to store and carry inventory?
- Risk: What is the risk of stockouts or overstock?
Comments
Post a Comment