The TASK_ASSIGNMENT.xls Model

Task to Facility Assignment

View the model
Download the model

Each of several facilities, e.g., operating rooms, has a limited number of hours available,
Each task has a given number of hours required on/in whatever facility it is assigned,
Associated with each task & facility combination there is a value of doing this task
     on that facility.
Find an assignment of tasks to facilities so as to
   Maximize the value of the assignments,
     subject to
       The hours available for each facility are not exceeded,
       Each task is assigned to at most one facility.

Keywords:

Task Assignment | Assignment Problem | Generalized Assignment |