Design of an automated staff scheduling system for an independent pharmacy

In service industries, employee salaries and wages often constitute the largest portion of the costs to the company. This is very true in the case of an independent pharmacy, which employs pharmacists and pharmacy technicians. Thus, for pharmacies to cost effectively meet the increasing demand for pharmaceuticals, it is crucial that pharmacy managers efficiently allocate the pharmacy staff's time.

Through a case study, this paper demonstrates the use of an Excel VBA based on a mathematical model to schedule the staff of an independent pharmacy. The whole year data was used in this study. After collection of whole year's data, the number of prescriptions to be filled for each day by hour of hour of the day were sourced and classified.

It is indicated that the pharmacy employees' time could be more efficiently assigned to meet the demand of the pharmacy. The benefit of modeling the pharmacy employees at this pharmacy is based on the data (the number of total prescriptions filled on Friday in March) with the following results; 12 h shifts are covered where one employee must be between 04:00-16:00, two employees between 06:00-18:00, one employee between 07:00-19:00 and one employee between 15:00-03:00.

In this study a basic model was presented that can be used schedule pharmacy employees in an independent pharmacy and solved by Excel VBA. This model can be further extended to meet the needs of a specific pharmacy.