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 

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
Get step-by-step solutions from verified subject matter experts
