Skip to content

DEVELOPMENT OF A DYNAMIC STOCK MANAGEMENT TOOL: “ILIKECOMMANDS” (submitted in 2019)

European Statement

Selection, Procurement and Distribution

Author(s)

TRISTAN TERNEL, MELINDA PLACE, BERENICE GILLOTEAU, ELODIE DECHAMBENOIT, EMELINE DEVOS, FATEN ABOU-DAHER, ANAELLE DECOENE, THOMAS QUERUAU LAMERIE, FREDERIQUE DANICOURT

Why was it done?

The main purpose of developing this tool is the need to provide centralised product parameters through a unique summary screen that permits a regular monitoring of inventory, enabling us to identify the glitches before things get out of control, resolve issues the soonest to improve the stock control system (order threshold, market), maintaining compliance and documenting usage to prevent sudden shortages, in a harmonised way in order to reduce the time spent to order.

What was done?

Development of a dynamic stock management tool plugged into a computerised model (Excel©), to integrate all data needed for a stock forecast in terms of specialties, providers, therapeutic classes, last order date, supply disruptions, market, restocking time, turnover, stock, orders, security threshold, average daily consumption, average time of supply, and delivery estimated time for all pharmaceutical products in hospital.

How was it done?

It’s important to know how much you have from each product, and each dosage of the same product, through a dynamic database that’s collecting all data (product code and average daily consumption) and highlighting the order quantity threshold. This reliable inventory is updated on a daily basis with data extracted from our economic and financial management coupled with Business Object©. Using specific formulas and filters, and referring to the decision flowchart, such data allow adjusting and optimising our stock management in real time.

What has been achieved?

First, this tool has allowed us to gather all required data and, subsequently, reduced the need to another application (such as NEWAC© and MAGH2©). Second, it has allowed us to understand the mechanism of order suggestions by displaying characteristics of some sectors (such as expensive products and chemotherapy). Moreover, it improved the management of supply disruptions by showing the solution of each disrupted product in a summary table, which results in significant time saving along the drug supply chain.

What next?

An organised supply chain, a fast response to overcome and handle sudden supply shortages, as well as a huge time saving are the main reasons to rely on this efficient system, which lead to an optimised and secure patient care. Moreover, it fits any computer software, and its application is very friendly to be used in every hospital pharmacy.

×

EAHP Forum

All the EAHP team is working on providing a Forum that can help connect all the members in Conversations and Groups to talk about important matters for the European Hospital Pharmacist.

The Forum will be accessible for all the EAHP members, you don’t have to create a new account to browse and participate.

Conversations and groups

The Conversations will be moderated by our team to provide documents and relevant topics for the community.

The Groups will connect all members that share a category. Members who work on the same assocation, on the same hospital, that have the same role, etc.

Stay tuned for the realase of the forum. Soon on EAHP.