USE EXCEL

1. Your company recently bagged a 6-storey building project. You are tasked by your project manager to calculate the earned value for the project. From the given below, determine the following: Activities Fencing and Excavation Structural Works Basic Architectural Works Finishes Electrical Works Plumbing Works Mechanical Works Fire Protection Works Testing and Commissioning Start Month 1 Month 2 Month 4 Month 6 Month 3 Month 3 Month 5 Month 6 Month 14 TOTAL Finish Month 1 Month 8 Month 12 Month 16 Month 16 Month 16 Month 15 Month 16 Month 18 Contract Amount 1M 12M 10M 14M 6M 8M 4M ZM 2M 64M a. Monthly periodic cost b. Cumulative cost c. Monthly percentage d. Percentage of completion (cumulative percentage) e. Plot of the earned value curve f. When will the project be halfway finished? 1. Your company recently bagged a 6-storey building project. You are tasked by your project manager to calculate the earned value for the project. From the given below, determine the following: Activities Fencing and Excavation Structural Works Basic Architectural Works Finishes Electrical Works Plumbing Works Mechanical Works Fire Protection Works Testing and Commissioning Start Month 1 Month 2 Month 4 Month 6 Month 3 Month 3 Month 5 Month 6 Month 14 TOTAL Finish Month 1 Month 8 Month 12 Month 16 Month 16 Month 16 Month 15 Month 16 Month 18 Contract Amount 1M 12M 10M 14M 6M 8M 4M ZM 2M 64M a. Monthly periodic cost b. Cumulative cost c. Monthly percentage d. Percentage of completion (cumulative percentage) e. Plot of the earned value curve f. When will the project be halfway finished