I need help with a Computer Science question. All explanations and answers will be used to help me learn.
Project Background and Description
In order to control costs in a project, you need to be able to take work performance information and compare it to the baselines to determine if the project is performing as planned. Being able to determine performance in a timely manner is critical to the success of the project. Having a tool to assist in the calculations, will assist in completing the performance reviews as needed.
2. ControlCosts
For this assignment, you will create a spreadsheet that will calculate the following:
3.
Cost Variance
Schedule Variance
Value at Completion
Cost Performance Index Schedule Performance Index Estimate at Completion Estimate to Complete
To Complete Performance Index
High-LevelRequirements
Create a MS Excel spreadsheet with the formulas to calculate each component listed above. The formulas to calculate each of the above can be found in table 7-1 on page 267 of PMBOK v6. The spreadsheet needs to contain the following sections:
- Input section for entering PV, EV, AC, and BAC
- Output section for CV, SV, VAC
- Output section for CPI and SPI
- Output sections for EAC, ETC, and TCPI. May require use of multiple formulas as per PMBOK
- Include tabs for two reports (week 3 and week 6)
4. Deliverables
An Excel spreadsheet containing the above sections on the first tab. Also include two additional tabs in your spreadsheet that will be used for reporting on the pier project at week 3 and week 6. You will use the planned values from your determine budget assignment as the baseline.
At week 3 your EV is 86% of PV, and AC is at 94% of PV
At week 6 your EV is at 96% of PV, and AC is at 104% of PV
0 comments