Chapter 30. Using Solver to schedule your workforce

Question answered in this chapter:

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

Many organizations (such as banks, restaurants, and postal service companies) know what their labor requirements are at different times of the day, and they need a method to schedule their workforce efficiently. You can use Solver to solve workforce scheduling problems easily.

Answer to this chapter’s question

This section provides the answer to the question that is listed at the beginning of the chapter.

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

Bank 24 processes checks seven days a week. The number of workers needed each day to process checks is shown in row 14 of the Bank24.xlsx ...

Get Microsoft Excel 2013: 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.