Question: There is a competence in a particular tech company. There are five projects that need to be solved and seven teams have decided to participate.

There is a competence in a particular techThere is a competence in a particular tech

There is a competence in a particular tech company. There are five projects that need to be solved and seven teams have decided to participate. Each of the teams have ranked the projects according to their preference of participation, being ' 1 ' the top in the list and ' 5 ' the least on their selection list. The results of the ranking is shown in the following table. Please do the following: 1. Draw a network that depicts the problem ( 25 points). 2. Formulate a mathematical model for this problem utilizing the six-step process discussed in class ( 25 points). 3. Solve this problem utilizing Excel solver and provide the appropriate recommendations and expected cost ( 25 points). (Hint: it should be infeasible at this point) 4. As you can see, this problem cannot be solved without using dummy nodes. Please add dummy nodes wherever are necessary and find the optimal solution utilizing two methods: (i) using ' 0 ' as the arc costs for those arcs connected to the dummy nodes, and (ii) using ' 10 ' (or any number larger than 5) as the arc costs for those arcs connected to the dummy nodes. Which of the two options give you a better answer? ( 25 points)

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!