You have recently joined as the project manager of ABC Company. Please refer to the Excel file to see the project information.

1. a) Complete status reports for periods 1 - 6.

Status Report: Ending Period 1
Task	% Complete	EV	AC	PV	CV	SV
A	25%		50
Cumulative Totals		50
Status Report: Ending Period 2
Task	% Complete	EV	AC	PV	CV	SV
A	50%		100
Cumulative Totals
Status Report: Ending Period 3
Task	% Complete	EV	AC	PV	CV	SV
A	100%		200
B	0%		0
C	0%		0
Cumulative Totals
Status Report: Ending Period 4
Task	% Complete	EV	AC	PV	CV	SV
A	100%		200
B	60%		100
C	50%		200
Cumulative Totals
Status Report: Ending Period 5
Task	% Complete	EV	AC	PV	CV	SV
A	100%		200
B	100%		200
C	100%		400
Cumulative Totals
Status Report: Ending Period 6
Task	% Complete	EV	AC	PV	CV	SV
A	100%		200
B	100%		200
C	100%		400
D	75%		100
Cumulative Totals

b) Complete the below performance indexes Summary Table

Period	EV	AC	PV	SPI	CPI	% Completion
1
2
3
4
5
6

c) Calculate the EAC, VAC, ETC, TCPI just for period 6. Assume CPI and SPI influence the remaining work.

d) Draw CPI and SPI graph; how this graph can help you to understand the project situation.

e) Based on your data, what is the project status at the end of period 6?