![]() 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 |