We propose a new genetic algorithm (GA) to solve the problem. This is a new model to handle the staff scheduling problem, which is motivated by the operational requirements in some local service organizations.
We formulate the problem as a multi-criteria optimization model, where the primary objective is to minimize the total cost for assigning staff to meet the manpower demands over time, the secondary objective is to seek a solution with the maximum surplus of staff among the solutions with almost same level of assigning cost, and the tertiary objective is to reduce the variation of staff surplus over different scheduling periods. We consider the problem of scheduling staff with mixed skills. This model can be further extended to meet the needs of a specific pharmacy. 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.
0 kommentar(er)
