Chapter 27. Using Solver to Schedule Your Workforce

  • How can I efficiently schedule my workforce to meet labor demands?

Many organizations (banks, restaurants, postal services) know what their labor requirements will be at different times and need a method to efficiently schedule their workforce to meet their labor requirements. You can use the Excel Solver to easily address a problem such as this. Here’s an example.

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 given in row 14 of the file Bank24.xls, which is shown in Figure 27-1. For example, 13 workers are needed on Tuesday, 15 workers are needed on Wednesday, and so on. ...

Get Microsoft® Excel Data Analysis and Business Modeling 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.

Start your free trial