To track the number of employees working each day, enter a 1 or a 0 in each cell in the range C5:I11. Enter each day’s required workers in the range C14:I14. For example, in A5, enter 1 to indicate that 1 employee begins work on Monday and works Monday through Friday. Begin by entering trial values for the number of employees who start their five-day shift each day in the cell range A5:A11. To set up the model, you need to track the number of employees working each day. ( Number of employees working) >=( Needed employees) Each changing cell must be a non-negative integer.Ĭonstraints – For each day of the week, the number of employees who are working must be greater than or equal to the number of employees required. Objective cell – Minimize the total number of employees.Ĭhanging cells – Number of employees who start work (the first of five consecutive days) each day of the week. Note: The objective cell is called the target cell in Excel 2007. Start by identifying the objective cell, changing cells, and constraints for your Solver model. What is the minimum number of employees the bank can have and still meet its labor requirements? All bank employees work 5 consecutive days. For example, 13 workers are needed on Tuesday, 15 workers are needed on Wednesday, and so on. The number of workers needed each day to process checks is shown in row 14 of the Excel worksheet shown below. The following example demonstrates how you can use Solver to calculate staffing requirements.Ĭontoso bank processes checks 7 days a week. Schedule your workforce to meet labor demands (example) You can use Excel's Solver add-in to create a staffing schedule based on those requirements. Many businesses (such as banks, restaurants, and postal service companies) know what their labor requirements will be on different days of the week, and need a method to efficiently schedule their workforce. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More.

Ms excel solver examples