Pharmacy, Health Sciences & Exercise Science
Utilization of Microsoft Excel for Inventory Management and Process at Underserved Clinics
Document Type
Oral Presentation
Location
Indianapolis, IN
Subject Area
Pharmacy, Health Sciences & Exercise Science
Start Date
10-4-2015 11:00 AM
End Date
10-4-2015 12:00 PM
Sponsor
Jeanne VanTyle (Butler University)
Description
Utilization of Microsoft Excel for Inventory Management and Process at Underserved Clinics
Stevan Tomich II and Mitchell Streck PharmD Candidates. JH VanTyle, PharmD
Background: Inventory management is vital to the success of pharmacy operations. Due to lack of proper inventory tracking and processing, many underserved clinics operate at a less than optimal capacity.
Project Objective: Created a universally operational inventory management process which:
Improved accuracy of on hand inventory count
Granted the ability to order medications in bulk
Facilitated data analysis for clinic managers
Procedure: A novel Microsoft Excel program was created and implemented at the Butler University Community Outreach Pharmacy. The previous inventory system in place had been analyzed based on the accuracy of inventory, bulk ordering, and timing of the label making and inventory tracking station. Our Microsoft Excel inventory system utilized three linked components: label making, data collection, and data analysis. Furthermore, we compiled averages and trends with the new inventory system creating features which were not available in the previous system.
Results: Before installation of the inventory system, we calculated percent error for the assumed balance on hand medication inventory. The average and median errors were 37% and 30% respectively. The current percent error will be determined within the coming weeks.
Discussion: The goal of the Microsoft Excel inventory tracking system and data analysis is to provide an accurate balance on hand inventory count which facilitates medication ordering by cutting down on limited resources spent on medication. All of this will improve work flow to allow more time for pharmacists and pharmacy student volunteers to provide patients' the appropriate clinical care, education, and attention they deserve.
Utilization of Microsoft Excel for Inventory Management and Process at Underserved Clinics
Indianapolis, IN
Utilization of Microsoft Excel for Inventory Management and Process at Underserved Clinics
Stevan Tomich II and Mitchell Streck PharmD Candidates. JH VanTyle, PharmD
Background: Inventory management is vital to the success of pharmacy operations. Due to lack of proper inventory tracking and processing, many underserved clinics operate at a less than optimal capacity.
Project Objective: Created a universally operational inventory management process which:
Improved accuracy of on hand inventory count
Granted the ability to order medications in bulk
Facilitated data analysis for clinic managers
Procedure: A novel Microsoft Excel program was created and implemented at the Butler University Community Outreach Pharmacy. The previous inventory system in place had been analyzed based on the accuracy of inventory, bulk ordering, and timing of the label making and inventory tracking station. Our Microsoft Excel inventory system utilized three linked components: label making, data collection, and data analysis. Furthermore, we compiled averages and trends with the new inventory system creating features which were not available in the previous system.
Results: Before installation of the inventory system, we calculated percent error for the assumed balance on hand medication inventory. The average and median errors were 37% and 30% respectively. The current percent error will be determined within the coming weeks.
Discussion: The goal of the Microsoft Excel inventory tracking system and data analysis is to provide an accurate balance on hand inventory count which facilitates medication ordering by cutting down on limited resources spent on medication. All of this will improve work flow to allow more time for pharmacists and pharmacy student volunteers to provide patients' the appropriate clinical care, education, and attention they deserve.