Calculating values using network diagram, baseline, and status information, in excel

Individual Assignment #4 MGMT8400

· This assignment is to be completed on an individual basis. Do not complete as partners or groups!

· You must complete the assignment using MS Excel. The Excel spreadsheet must calculate the EVM values using formulae. The assignment must be handed in using MS Excel format. Assignments completed using PDF format or by copying the information into any other format WILL NOT be accepted. The instructor must be able to see the formulae within MS Excel cells.

· Graphs must be properly labelled including X and Y Axis and a Title

· Include title page information at the top of the MS Excel worksheet including your name and student number.

· If applicable, include a bibliography noting sources used.

Deliverables

Use the network diagram, baseline, and status information to developthe following information:

· Complete the status reports for periods 1 through 6 by computing the values for EV, PV, CV and SV. Calculations/formulae must be included.

· For each period, add a written commentary about the status of the project based on the computed values.

· Create a graph depicting (showing) AC and PV over the duration of the status reports.

· Create a graph depicting (showing) EV, SV and CV over the duration of the status reports.

· Complete the summary table by computing the values for SPI, CPI and PCIB.

· Create a third graph representing the information in the summary table.

· Provide a written assessment of the expected status of the project at completion.

Note the difference between how the values are represented Schedule Information table and the Status Reports.

Status Report: Ending Period 1

Task	% Complete	EV	AC	PV	CV	SV
1	50%		500	1000
Cumulative Totals		500	1000
Period Commentary

Status Report: Ending Period 2

Task	% Complete	EV	AC	PV	CV	SV
1	100		1500
Cumulative Totals		1500
Period Commentary

Status Report: Ending Period 3

Task	% Complete	EV	AC	PV	CV	SV
1	100		1500
2	0		0
3	10		200
4	20		500
Cumulative Totals		2200
Period Commentary

Status Report: Ending Period 4

Task	% Complete	EV	AC	PV	CV	SV
1	100		1500
2	50		1000
3	30		800
4	40		1500
Cumulative Totals		4800
Period Commentary

Status Report: Ending Period 5

Task	% Complete	EV	AC	PV	CV	SV
1	100		1500
2	100		2000
3	50		800
4	60		1500
5	25		400
Cumulative Totals		6200
Period Commentary

Status Report: Ending Period 6

Task	% Complete	EV	AC	PV	CV	SV
1	100		1500
2	100		2000
3	80		2100
4	80		1800
5	50		600
Cumulative Totals		8000
Period Commentary

Indexes

Period	SPI	CPI	PCIB
1
2
3
4
5
6

Formulae useful for this assignment