A company needs to hire workers to cover a 7 day work week. Employees work 5 consecutive days with 2 days off. The demand for workers by day of the week and the wages per shift are:
Based on this ILP formulation of the problem and the optimal solution (X₁, X₂, X₃, X₄, X₅, X₆) = (2, 10, 16, 6, 14, 8, 6) what values should go in cells B5:J13 of the following Excel spreadsheet?

Question

A company needs to hire workers to cover a 7 day work week. Employees work 5 consecutive days with 2 days off. The demand for workers by day of the week and the wages per shift are:

Based on this ILP formulation of the problem and the optimal solution (X₁, X₂, X₃, X₄, X₅, X₆) = (2, 10, 16, 6, 14, 8, 6) what values should go in cells B5:J13 of the following Excel spreadsheet?

Quizplus · Accepted Answer

The Answer of A company needs to hire workers to cover a 7 day work week. Employees work 5 consecutive days with 2 days off. The demand for workers by day of the week and the wages per shift are: Based on this ILP formulation of the problem and the optimal solution (X₁, X₂, X₃, X₄, X₅, X₆) = (2, 10, 16, 6, 14, 8, 6) what values should go in cells B5:J13 of the following Excel spreadsheet?

A Company Needs to Hire Workers to Cover a 7