Chapter 28. Using Solver to Schedule Your Workforce
Many organizations (such as banks, restaurants, and postal service companies) know what their labor requirements will be at different times of the day, and need a method to efficiently schedule their workforce. You can use Microsoft Office Excel Solver to easily solve workforce scheduling problems.
How can I efficiently schedule my workforce to meet labor demands?
How can I efficiently schedule my workforce to meet labor demands?
Bank 24 processes checks 7 days a week. The number of workers needed each day to process checks is shown in row 14 of the file Bank24.xlsx, which is shown in Figure 28-1. For example, 13 workers are needed on Tuesday, 15 workers are needed on Wednesday, and so on. All bank ...
Get Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
