Common problems of Thai nurses are low quality of life, working long hours, and a high turnover rate. The workload imbalance among nurses also worsens the turnover rate. With careful schedule planning, nurses do not have to work in consecutive shifts and can rest more. We interviewed and collected data from an emergency department at a hospital administered by a Thai university, related to objectives and constraints of monthly nurse scheduling, and actual monthly schedules. A multi-objective mathematical model was developed using the open source “OpenSolver” software in MS-Excel for nurse schedulers to freely use. We tested the model using actual data collected from the department and found that the schedules created by the model tended to provide more balanced workloads and more days off compared to the schedules created manually by a real scheduler. The model also suggested an easy policy to increase the number of nurses for future expansion.
