Question: [ 2 0 ] Consider a company that needs to assign 6 tasks ( T 1 , . . . , T 6 ) to

[20] Consider a company that needs to assign 6 tasks (T1,..., T6) to 4 workers (W1,..., W4). 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 task-worker pair due to different skill levels and efficiencies. The cost of assigning a task to a worker also varies depending on the task-worker 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 W1 W2 W3 W4 T15465 T27657 T34534 T46756 T58798 T63423 Table 1: Time (number of hours) it takes for each worker to finish each task. Task W1 W2 W3 W4 T1 $10 $15 $20 $18 T2 $20 $10 $25 $22 T3 $30 $25 $15 $28 T4 $25 $30 $15 $28 T5 $18 $22 $28 $15 T6 $22 $18 $24 $20 Table 2: Costs for each worker to do each task. W1 W2 W3 W4 Capacity (in hours)78109 Table 3: Capacity (total time in hours) of each worker
(a) Formulate this problem as an integer program, defining the decision variables, objective function, and constraints.
(b)(Excel) 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 $15 if we assign T3 and T4 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 Task-d). 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!