Automated Workforce Scheduling System

Business Challenge

The client, a healthcare provider, faced significant challenges in efficiently scheduling nursing staff while considering shift preferences, skill-based allocation, and regulatory constraints.

• Managing shifts manually led to inefficiencies, excessive overtime, and difficulties in maintaining fair workloads.

• The objective was to develop an automated scheduling system that ensured optimal workforce utilization while adhering to various constraints.nts.

Approach & Solution

We developed an Excel-based scheduling tool leveraging OpenSolver and linear programming to create optimal nurse rosters. The solution efficiently assigns shifts over a six-week period while considering multiple constraints:

• Shift Preferences & Skill-Based Allocation: Ensuring that nurses are scheduled in roles matching their expertise and preferences.

• Workload Balancing: Enforcing minimum and maximum working days per week, consecutive weekly offs, and leave considerations.

• Pre-Defined Shift Allocations: Allowing fixed shift assignments where necessary while optimizing the remaining schedules.

• Automated Optimization: The tool generates the most balanced schedule at the click of a button, reducing the need for manual intervention.

Impact

• Reduced Overtime: Optimized shift allocations significantly lowered unnecessary overtime hours.

• Enhanced Efficiency: Automating scheduling saved time and minimized human errors.

• Improved Workforce Satisfaction: Consideration of preferences and fair distribution of workload increased staff morale.

• Seamless Implementation: The Excel-based system ensured quick adoption without additional software investments.