MGMT8400: Project Planning & Control - EVM, Status Reports & Graphs

This assignment provides a detailed analysis of project planning and control using Earned Value Management (EVM) techniques. It includes status reports for six periods, calculating Earned Value (EV), Actual Cost (AC), Planned Value (PV), Cost Variance (CV), and Schedule Variance (SV). Each status report is accompanied by a commentary on the project's status, highlighting whether it is on schedule or over budget. The report also features graphs depicting AC and PV, as well as EV, SV, and CV over the duration of the project. Finally, it presents a summary table with SPI, CPI, and PCIB values, along with a graph representing this information. The calculations are performed in MS Excel, and the document includes a bibliography.

Running head: ADVANCED PROJECT PLANNING AND CONTROL
Advanced project planning and control
Student Name:
University Name:

1ADVANCED PROJECT PLANNING AND CONTROL
Table of Contents
1. Status Reports.........................................................................................................................2
Status Report: Ending Period 1..............................................................................................2
Status Report: Ending Period 2..............................................................................................2
Status Report: Ending Period 3..............................................................................................2
Status Report: Ending Period 4..............................................................................................2
Status Report: Ending Period 5..............................................................................................3
Status Report: Ending Period 6..............................................................................................3
2. Graphs....................................................................................................................................4
Graph depicting AC and PV over the duration of the status reports......................................4
Graph depicting EV, SV and CV over the duration of the status reports..............................4
3. Final Projected Values...........................................................................................................5
Summary Table......................................................................................................................5
Graph representing the information in summary table..........................................................5
Bibliography...............................................................................................................................6

2ADVANCED PROJECT PLANNING AND CONTROL
1. Status Reports
Status Report: Ending Period 1
Task % Complete EV AC PV CV SV
1 50% 500 500 1000 0 -500
Cumulative Totals 500 500 1000 0 -500
Period Commentary The project is behind schedule as the SV is
negative and on budget as the CV is 0.
Status Report: Ending Period 2
Task % Complete EV AC PV CV SV
1 100% 1000 1500 1000 -500 0
Cumulative Totals 1000 1500 1000 -500 0
Period Commentary The project is on schedule as the SV is 0 and over
budget as the CV is negative.
Status Report: Ending Period 3
Task % Complete EV AC PV CV SV
1 100% 1000 1500 1000 -500 0
2 0% 0 0 0 0 0
3 10% 200 200 2000 0 -1800
4 20% 500 500 2500 0 -2000
Cumulative Totals 1700 2200 5500 -500 -3800
Period Commentary Both the values of CV and SV are negative which
means the project is behind schedule and over budget.
Status Report: Ending Period 4
Task % Complete EV AC PV CV SV
1 100% 1000 1500 1000 -500 0
2 50% 1000 1000 2000 0 -1000
3 30% 800 800 2667 0 -1867
4 40% 1500 1500 3750 0 -2250
Cumulative Totals 4300 4800 9417 -500 -5117
Period Commentary Both the values of CV and SV are negative which

3ADVANCED PROJECT PLANNING AND CONTROL
means the project is behind schedule and over
budget.
Status Report: Ending Period 5
Task % Complete EV AC PV CV SV
1 100% 1000 1500 1000 -500 0
2 100% 2000 2000 2000 0 0
3 50% 800 800 1600 0 -800
4 60% 1500 1500 2500 0 -1000
5 25% 400 400 1600 0 -1200
Cumulative Totals 5700 6200 8700 -500 -3000
Period Commentary Both the values of CV and SV are negative which
means the project is behind schedule and over budget.
Status Report: Ending Period 6
Task % Complete EV AC PV CV SV
1 100% 1000 1500 1000 -500 0
2 100% 2000 2000 2000 0 0
3 80% 2100 2100 2625 0 -525
4 80% 1800 1800 2250 0 -450
5 50% 600 600 1200 0 -600
Cumulative Totals 7500 8000 9075 -500 -1575
Period Commentary Both the values of CV and SV are negative which
means the project is behind schedule and over budget.

4ADVANCED PROJECT PLANNING AND CONTROL
2. Graphs
Graph depicting AC and PV over the duration of the status reports
1 2 3 4 5 6
0
1000
2000
3000
4000
5000
6000
7000
8000
9000
10000
AC and PV Graph for Status Reports
AC PV
Period
Values
Graph depicting EV, SV and CV over the duration of the status reports
1 2 3 4 5 6
-6000
-4000
-2000
0
2000
4000
6000
8000
10000
EV, SV and CV Graph
EV SV CV

5ADVANCED PROJECT PLANNING AND CONTROL
3. Final Projected Values
Summary Table
Period SPI CPI PCIB
1 0.50 1 50%
2 1 0.67 100%
3 0.31 0.77 31%
4 0.46 0.90 46%
5 0.66 0.92 66%
6 0.83 0.94 83%
Graph representing the information in summary table
1 2 3 4 5 6
0.00
0.20
0.40
0.60
0.80
1.00
1.20
Summary Table
SPI CPI PCIB
Period
Values

6ADVANCED PROJECT PLANNING AND CONTROL
Bibliography
Colin, J., & Vanhoucke, M. (2015). A comparison of the performance of various project
control methods using earned value management systems. Expert Systems with
Applications, 42(6), 3159-3175.
Fleming, Q. W., & Koppelman, J. M. (2016, December). Earned value project management.
Project Management Institute.
Willems, L. L., & Vanhoucke, M. (2015). Classification of articles and journals on project
control and earned value management. International Journal of Project
Management, 33(7), 1610-1634.