Please don’t change the name of the file. When you create an Excel spreadsheet

| August 14, 2017

Please don’t change the name of the file. When you create an Excel spreadsheet, please name it same as the Word Doc with some random letters at the end.ThanksQuestionsFrom the data shown below, calculate the earned value of each control account as of 5/30/14. Assume all control account work is on schedule except as noted below.Control AccountScheduled StartScheduled CompletionBudgeted ValueEV Progress Rule13/3/20146/30/201410,000Percent Complete with Gates (Note 1)25/5/20146/6/20143,000Fixed Formula: 50/5035/26/20146/6/20141,000Fixed Formula: 0/10045/12/20145/30/20142,000Fixed Formula:30/7054/14/20147/11/201415,000Weighted Milestones (Note 2)Note (1): Five equally-valued gates have been established in this control account. Two of the five gates are complete as of 5/30/14.The Control Account Manager estimates that half of the work required for the third gate has also been completed.Note 2: Six milestones have been established in this control account with the following values: (1) milestone 1 – 20%; milestone 2- 15%; milestone 3 – 10%; milestone 4 – 25%; milestone 5 – 15%; milestone 6 – 15%. Three of the milestones are complete as of 5/30/14.Limit responses to 150 words.1. How does earned value give a clearer picture of project schedule and cost status than a simple plan versus actual system?2. Why is it important to resist changes to the cost baseline? Under what conditions would changes to the baseline be appropriate? When would changes to the baseline not be allowed?3. What is the cost of quality (COQ) and how is this cost represented in the project cost baseline?4. Identify and describe two methods used to determine the earned value credit for a work package in progress5. Cost Variance (CV) and Cost Performance Index (CPI) can both be used to determine whether a project is on budget, under budget, or over budget at a particular point in time. Why have two measures for the same thing?

Order your essay today and save 30% with the discount code: ESSAYHELPOrder Now