Do problem 17 in text using Excel Solver and obtain the answer and sensitivity report. Attach the Excel file if possible and answer the following question below....

Q1 - as you minimized time say which project leader is assigned to each client and mention the minimum time.

Q2 - say you are thinking about assigning Smith to 1, Ellis to 2, and Jackson to 3 instead of the best assignment. How much time is added with this assignment? Show the numbers you use from the adjusted table (say something like 2 + 7 + 0).

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: a. Develop a network representation of this problem. b. Formulate the problem as a linear program, and solve. What is the total time required? 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: a. Develop a network representation of this problem. b. Formulate the problem as a linear program, and solve. What is the total time required