1. Minimizing Maintenance Task Labor Cost
Operations CoordinatorBackground
A facility supervisor needs to assign three technicians to three urgent equipment repair jobs based on varying quoted costs.
Problem
Determine the one-to-one assignment that achieves the lowest aggregate maintenance expense.
How to use
Enter the 3×3 cost matrix, choose 'Minimize total cost' under Goal, and generate the solution.
Matrix: 9, 2, 7
6, 4, 3
5, 8, 1
Goal: min
Decimal Places: 4Outcome
Worker 1 is assigned to Task 2 (cost 2), Worker 2 to Task 1 (cost 6), and Worker 3 to Task 3 (cost 1), yielding an optimal minimum total cost of 9.