For part (b) the program used is excel QM

Question 2 Scott and Associates is an accounting firm that has three new clients. Project leaders will be assigned to the three clients. Based on different backgrounds and experience of the leaders, the various leader-client assignments differ in terms of projected completion times. The possible assignments and estimated completion times (in days) are shown below. Client Leader A B Sheldon 10 16 32 Amy 14 22 40 Penny 22 24 34 Complete the following tasks. Part (a) Solve the problem by computer, present and briefly explain the results. Part (b) Assume an additional employee becomes available (Leonard). His estimated completion times are, Client A: 14 days, Client B: 18 days, Client C: 36 days. Solve the extended problem, present and briefly explain the solution. Part (c) Discuss how the solution in (b) differs from that in (a). Were there any savings associated with the introduction of Leonard? Which project leader remains unassigned? Part (d) Sheldon's lack of social skills have led to client A threatening to take their business to a competing accounting firm if Sheldon is assigned to them. Further develop the model created in part (b) to include a component where Sheldon is not permitted to work with client A. Present and briefly explain the solution and any differences in your new solution. Question 2 Scott and Associates is an accounting firm that has three new clients. Project leaders will be assigned to the three clients. Based on different backgrounds and experience of the leaders, the various leader-client assignments differ in terms of projected completion times. The possible assignments and estimated completion times (in days) are shown below. Client Leader A B Sheldon 10 16 32 Amy 14 22 40 Penny 22 24 34 Complete the following tasks. Part (a) Solve the problem by computer, present and briefly explain the results. Part (b) Assume an additional employee becomes available (Leonard). His estimated completion times are, Client A: 14 days, Client B: 18 days, Client C: 36 days. Solve the extended problem, present and briefly explain the solution. Part (c) Discuss how the solution in (b) differs from that in (a). Were there any savings associated with the introduction of Leonard? Which project leader remains unassigned? Part (d) Sheldon's lack of social skills have led to client A threatening to take their business to a competing accounting firm if Sheldon is assigned to them. Further develop the model created in part (b) to include a component where Sheldon is not permitted to work with client A. Present and briefly explain the solution and any differences in your new solution