Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
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
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 finishedStep by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started