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).
Approximate price: $22
We value our customers and so we ensure that what we do is 100% original..

With us you are guaranteed of quality work done by our qualified experts.Your information and everything that you do with us is kept completely confidential.You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.The Product ordered is guaranteed to be original. Orders are checked by the most advanced anti-plagiarism software in the market to assure that the Product is 100% original. The Company has a zero tolerance policy for plagiarism.The Free Revision policy is a courtesy service that the Company provides to help ensure Customer’s total satisfaction with the completed Order. To receive free revision the Company requires that the Customer provide the request within fourteen (14) days from the first completion date and within a period of thirty (30) days for dissertations.The Company is committed to protect the privacy of the Customer and it will never resell or share any of Customer’s personal information, including credit card data, with any third party. All the online transactions are processed through the secure and reliable online payment systems.By placing an order with us, you agree to the service we provide. We will endear to do all that it takes to deliver a comprehensive paper as per your requirements. We also count on your cooperation to ensure that we deliver on this mandate.