Question: Please attach the excel sheet and explanations Problem 6-17 Scott and Associates, Inc., is an accounting firm that has three new clients. Project leaders will

Please attach the excel sheet and explanations  Please attach the excel sheet and explanations Problem 6-17 Scott andAssociates, Inc., is an accounting firm that has three new clients. Project

Problem 6-17 Scott and Associates, Inc., is an accounting firm that has three new clients. Project leaders will be assigned to the three clients. Based on the different backgrounds and experiences of the leaders, the various leader-client assignments differ in terms of projected completion times. The possible assignments and the estimated completion times in days are as follows: Client Project Leader 1 2 3 Jackson 10 16 32 Ellis 14 22 40 Smith 22 24 34 a. Choose the correct network representation of this problem. () 10 22 (ii) 10 32 14 16 1 1 Jackson 1 Client 1 1 1 1 1 Jackson Client 1 1 16 24 14 40 2 2 22 22 1 2 Ellis 1 2 Ellis 1 1 Client 2 Client 2 32 34 22 34 3 3 3 Smith 40 1 1 1 3 Smith 24 1 Client 3 Client 3 (iii) 10 (iv) 10 1 1 1 Jackson 1 Client 1 10 1 1 Jackson 1 14 Client 1 1 32 22 14 16 2 22 2 22 1 2 Client 2 7 1 1 1 2 Client 2 1 Ellis Ellis 24 40 22 32 24 40 3 3 1 34 1 1 3 Smith 34 3 Client 3 1 Smith Client 3 Model (iii) b. Formulate the problem as a linear program, and solve. What is the total time required? If the constant is "1" it must be entered in the box. If your answer is zero, enter "0". Min X X11 + 1 X X12 + 1 X X13+ 1 X X21+ 1 X X22+ 1 X X23+ 1 X X31 + 1 X X32 + 1 X X33 s.t. 1 X11 + 1 x12 + 1 X13 1 1 x21 + 1 X22 + 1 1 X23 s 1 1 x31+ 1 X32 + 1 x335 1 1 X11 + 1 X21 1 X31 1 1 X12 1 X22 + 1 X32 = 1 1 X13 1 X23 1 X33) = 1 Xij 2 0 for all i, j Problem 6-17 Scott and Associates, Inc., is an accounting firm that has three new clients. Project leaders will be assigned to the three clients. Based on the different backgrounds and experiences of the leaders, the various leader-client assignments differ in terms of projected completion times. The possible assignments and the estimated completion times in days are as follows: Client Project Leader 1 2 3 Jackson 10 16 32 Ellis 14 22 40 Smith 22 24 34 a. Choose the correct network representation of this problem. () 10 22 (ii) 10 32 14 16 1 1 Jackson 1 Client 1 1 1 1 1 Jackson Client 1 1 16 24 14 40 2 2 22 22 1 2 Ellis 1 2 Ellis 1 1 Client 2 Client 2 32 34 22 34 3 3 3 Smith 40 1 1 1 3 Smith 24 1 Client 3 Client 3 (iii) 10 (iv) 10 1 1 1 Jackson 1 Client 1 10 1 1 Jackson 1 14 Client 1 1 32 22 14 16 2 22 2 22 1 2 Client 2 7 1 1 1 2 Client 2 1 Ellis Ellis 24 40 22 32 24 40 3 3 1 34 1 1 3 Smith 34 3 Client 3 1 Smith Client 3 Model (iii) b. Formulate the problem as a linear program, and solve. What is the total time required? If the constant is "1" it must be entered in the box. If your answer is zero, enter "0". Min X X11 + 1 X X12 + 1 X X13+ 1 X X21+ 1 X X22+ 1 X X23+ 1 X X31 + 1 X X32 + 1 X X33 s.t. 1 X11 + 1 x12 + 1 X13 1 1 x21 + 1 X22 + 1 1 X23 s 1 1 x31+ 1 X32 + 1 x335 1 1 X11 + 1 X21 1 X31 1 1 X12 1 X22 + 1 X32 = 1 1 X13 1 X23 1 X33) = 1 Xij 2 0 for all i, j

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 Finance Questions!