1. Make a LP problem as a network model;
2. Set up the LP problem in Excel;
3. Solve the problem using Excel Solver;
4. Interpret the solution provided by Solver.

Problems 273 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 2 Jackson 16 32 Ellis 22 40 Smith 24 34 a. Develop a network representation of this problem. b. Formulate the problem as a linear program, and solve. What is the total time required