Individual assignment 3

 
read the intruction carefully, and finish the excel file that I sent you
Please dont do any extra stuff that a student wont know, keep it clear and easy to understand
Overview: Project  XYZ is a one-year project within your organization. When this project  began 9 months ago (May 2015), another person was the project manager.  After six months, as the project fell behind schedule and ran over  budget, it was apparent that this project manager was unable to lead the  project to a successful completion. You replaced this project manager  after the six month point of the project. Since then, for the past three  months, you have completed tasks on or slightly below budget, and  increased efficiency of the work completed.
Now, your manager  would like a report on the project status. He is especially interested  in how actual cost and earned value are tracking planned value, and how  the estimated cost at completion and the estimated time of completion  have changed since you took over as project manager. All data on monthly  planned value, monthly actual cost, and task completion are included  for the life of the project in the spreadsheet provided here:Assignment #3.xlsx
The Task: Complete an earned value analysis for the data provided. Your calculations should include:

PV,  Cumulative PV, AC, Cumulative AC, EV, and Cumulative EV for each month  of the project. These have been started in the Excel file provided.
CV,  CPI, SV, and SPI for the first six months of the project (the point up  to where you took over the project) and the last nine months of the  project (through April 2014).
Budget at completion (BAC), budget  estimate at completion (EAC) and the budget variance at complete (VAC)  given the data for the first six months of the project and after the  first nine months of the project.
Estimated revised project  duration given the data for the first six months of the project and  after the first nine months of the project.

Write a  short but detailed report explaining your earned value analysis of this  project. The report should include a graph that illustrates how actual  cost (AC) and earned value (EV) track to planned value (PV) (the first  set of required calculations), and an explanation of the interpretation  of the graph. It should also include the other calculated results with  an explanation of the importance of the values with respect to the  improvement in the project since you have taken over the project manager  role. You report should be written such that the person reading it does  not need to understand earned value analysis (meaning, do not use  terminology and acronyms unless you explain them).