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.
Attachment:- Exhibit.rar