Question: A manager would like to assign 2 projects to 3 teams. A project needs to be assigned to one team, and one team only. To

A manager would like to assign 2 projects to 3

A manager would like to assign 2 projects to 3 teams. A project needs to be assigned to one team, and one team only. To ensure balance, no team could possibly be assigned more than one project. The following is a network representation of this assignment problem. 1 1 2 3 The times in working days) needed by the teams to execute the projects are given in the following table: Project/Team 1 2 3 1 64 70 47 2 40 39 41 The company would like to determine the assignment that would result in the minimal exe- cution time. (a) (4 points - Suggested completion time = 2 min) Express the decision variables needed for this assignment problem. (b) (4 points - Suggested completion time = 2 min) Express the problem's objective. CM 3301 - MT Exam 2 6 (c) (3 points - Suggested completion time = 1 min) Express the constraint corresponding to the need to assign project 2. (d) (3 points - Suggested completion time = 1 min) Express the constraint corresponding to the availability of team 3 to be assigned a project. (e) (8 points - Suggested completion time = 8 min) Solve the problem using Excel's Solver and report the optimal assignment found. (Note: You need to submit your Excel sheet with your answer!)

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!