Excel Training Videos

Staff scheduling solutions using Solver in Excel


Staff scheduling solutions using Solver in Excel - how to organize people so that customers are not left waiting in a Bank or when they call up or when students come to their class.
A computer training school has faculty with different responsibilities. Many of them work full-time and some work only part-time and a few are on holiday. The institute is open seven days a week. Fulltime faculty works 40 hours and the part-time faculty works 20 hours per week. Maximum working hours per day are 8. Some faculty is available Monday to Friday, some faculty is available on week-ends and other faculty is available only on certain days of the week. Now there is a specific requirement every day of the week and we have to schedule the staff in such a manner that the requisite faculty is always available. Not an easy task to perform manually but Solver finds a solution quickly. You need to organize your data properly with appropriate constraints depending on whether the faculty is full-time or part-time. The constraints also take into account whether a faculty is on holiday or unavailable on specific days of the week.

Watch the Excel training video to understand how this scheduling is done!






Reference

Staff scheduling solutions using Solver in Excel