design of an automated employee scheduling system

In this study a basic model was presented that can be used schedule pharmacy employees in an independent pharmacy and solved by Excel VBA. 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. It is indicated that the pharmacy employees' time could be more efficiently assigned to meet the demand of the pharmacy.

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. The whole year data was used in this study.

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. 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.

This is very true in the case of an independent pharmacy, which employs pharmacists and pharmacy technicians. In service industries, employee salaries and wages often constitute the largest portion of the costs to the company.

Design of an automated employee scheduling system