Chapter 30. Using Solver to Schedule Your Workforce
Question answered in this chapter:
How can I efficiently schedule my workforce 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 efficiently schedule their workforce. You can use the Microsoft Excel 2010 Solver to easily solve workforce scheduling problems.
Answers to This Chapter’s Question
How can I efficiently schedule my workforce 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 file Bank24.xlsx, which is shown in Figure 30-1. For example, 13 workers ...
Get Microsoft® Excel® 2010: 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.
