You are the project manager for a process improvement project for Company XYZ.Prepare a figure like Exhibit 10.9 that illustrates the weekly and cumulative costs for the resource-leveled project.

Hint: To accomplish this exercise, you'll need to create a project schedule in MS Excel (or by hand), create resource assignments, assign costs to each resource, and assign the resources to each task.Some resource leveling will be required.

In this project, you have 3 employees: Ann, Becky and Clive.Each person is limited to the amount of time allocated to your project.Ann and Becky are available 30 hours/week; Clive is available 20 hours/week.There hourly rates are: Ann: $60/hour; Becky: $35/hour; and Clive: $50/hour.

WBS Activity Immediate Estimated Duration in Resource Predecessor weeks Process Improvement Project 1.1 Operational definition 1.1.1 Research literature Becky 1.1.2 Identify and define terms 1.1.1 Ann 1.1.3 |Obtain approval of definition |1.1.2 Clive Unit 10 1.2 Target Selection 1.2.1 Solicit partners for pilot Ann 1.2.2 Hold brainstorming meeting 1.2.1 Becky 1.2.3 Identify characteristics of targets 1.2.2, 1.3.1 Ann 1.2.4 Obtain approval of partners 1.2.3, 1. 1.2, 1.3.4 Clive 1.3 Question set 1.3.1 Identify process group members Clive 1.3.2 Develop question set 1.2.3 Ann 1.3.3 Prototype and validate question set 1.3.2 Becky 1.3.4 Add partners 1.3.1, 1.2.1 Becky 1.4 Pilot process 1.4.1 Schedule with target audience 1.2.4 Becky NN 1.4.2 Conduct beta test 1.3.4, 1.2.4 Clive 1.4.3 Process feedback from target 1.4.2 12 Ann audience 1.4.4 Conduct pilot 1.4.3 INT Clive 1.4.5 Analyze results 1.4.4 Clive