For this simple six-by-six problem there are already 6!
= 720 possible assignments of assistants to book collections.
For example, if we assign Person 1 to Task 1, cell C10 equals 1. What is the overall measure of performance for these decisions? Explanation: The SUM functions calculate the number of tasks assigned to a person and the number of persons assigned to a task.
The overall measure of performance is the total cost of the assignment, so the objective is to minimize this quantity. To make the model easier to understand, name the following ranges. Total Cost equals the sumproduct of Cost and Assignment. The result should be consistent with the picture below.