Sipho Mabitle and his team are working on the Recreation and Wellness Intranet Project. They have been asked to refine the existing cost estimate for the project so they can evaluate supplier bids and have a solid cost baseline for evaluating project performance. Recall that your schedule and cost goals are to complete the project in six months for under R500,000. Tasks 3.1 Prepare a one-page cost model for this project using spreadsheet (table). Use your WBS, and be sure to document your assumptions in preparing the cost mode for the six months. Assume a labor rate of R1000/hour for the project manager and R600/hour for other project team members. Assume that none of the work is outsourced, labor costs for users are not included, and there are no additional hardware costs. The total estimate should be R500,000. 3.2 After completion of the project the following must be taken into account. Sipho - completed all tasks on time. You - completed all tasks on time. Patrick all tasks were completed 50% below planned time. Nancy- completed all tasks on time Lesedi all tasks were completed 30% below planned time. Yusaff all tasks were completed 50% over planned time. Cassandra - completed all tasks on time

Use the cost model in Task 3.1 and create:

3.2.1 A Cost Baseline Table taking the above delays /early completions into account.

3.2.2 Create an Earned Value Chart. Draw by hand or use tools in WORD. No need to use additional software.

3.3 Given the updated Table in Task 3.2 indicate the following (calculations):

Planned value (PV)

Actual cost (AC)

Earned value (EV)

Cost variance (CV)

Schedule variance (SV)

Cost performance index (CPI)

Schedule performance Index (SPI)

Estimate at completion (EAG)

Budget at completion (BAC)

Estimate to completion (ETC) 3.4 Create a page close out report for the project.