To compute the number of employees working each day, copy the formula = SUMPRODUCT($A$5:$A$11,C5:C11) from C12 to D12:I12. For example, the 1 in cell G5 indicates that employees who started working on Monday are working on Friday the 0 in cell H5 indicates that the employees who started working on Monday are not working on Saturday. The value 1 in a cell indicates that the employees who started working on the day designated in the cell’s row are working on the day associated with the cell’s column. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |