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).
At Solution Essays, we are determined to deliver high-quality papers to our clients at a fair price. To ensure this happens effectively, we have developed 5 beneficial guarantees. This guarantees will ensure you enjoy using our website which is secure and easy to use.
Most companies do not offer a money-back guarantee but with Solution Essays, it’s either a quality paper or your money back. Our customers are assured of high-quality papers and thus there are very rare cases of refund requests due to quality concern.Read more
All our papers are written from scratch and according to your specific paper instructions. This minimizes any chance of plagiarism. The papers are also passed through a plagiarism-detecting software thus ruling out any chance of plagiarism.Read more
We offer free revisions in all orders delivered as long as there is no alteration in the initial order instruction. We will revise your paper until you are fully satisfied with the order delivered to you.Read more
All data on our website is stored as per international data protection rules. This ensures that any personal data you share with us is stored safely. We never share your personal data with third parties without your consent.Read more