Question: [ 2 0 ] Consider a company that needs to assign 6 tasks ( T 1 , . . . , T 6 ) to
Consider a company that needs to assign tasks T T to workers W W Each task must be assigned to exactly one worker, and each worker has a limited capacity in terms of the total time they can dedicate to tasks. The time it takes for a worker to complete a task varies depending on the taskworker pair due to different skill levels and efficiencies. The cost of assigning a task to a worker also varies depending on the taskworker pair. The objective is to minimize the total assignment cost while ensuring that all tasks are assigned and no worker exceeds their capacity in terms of total time. Use the following data:
Task W W W W T T T T T T Table : Time number of hours it takes for each worker to finish each task. Task W W W W T $ $ $ $ T $ $ $ $ T $ $ $ $ T $ $ $ $ T $ $ $ $ T $ $ $ $ Table : Costs for each worker to do each task. W W W W Capacity in hours Table : Capacity total time in hours of each worker
a Formulate this problem as an integer program, defining the decision variables, objective function, and constraints.
bExcel Set up and solve the integer program in part a in the Excel workbook Sheet Taskb What is the optimal assignment of the tasks? What is the optimal total cost? Write down the answers here and save the Answer report in Excel.
Suppose that due to the nature of the tasks, there is an additional penalty of $ if we assign T and T to the same worker. How will this change your model formulation? Hint: the objective function may become nonlinear
Set up and solve the nonlinear program in part c in the Excel workbook Sheet Taskd What is the optimal assignment of the tasks? What is the optimal total cost? Write down the answers here and save the Answer report in Excel.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
