Question

-files from the merret Lulu Instructor: Philip Zopp! Problem #1 BCWS, BCWP, and ACWP represent CUMULATIVE TOTALS on a week by week basis. Complete SV, CV, CPI, SPI and EAC for each week. Also, plot plot CPI and SPI over time. BAC - 460 SPIEAC Week BCWS BCWP CV ACWP sv 70 Problem #2 Complete this table using the information below for the project AT THE END OF WEEK #4.

Answer 1

Problem #1

Week	BCWS	BCWP	ACWP	SV = BCWP - BCWS	CV = BCWP - ACWP	CPI = BCWP / ACWP	SPI = BCWP / BCWS	EAC = [ACWP + (BAC - BCWP) / CPI]
1	50	50	25	0	25	2	1	230
2	70	60	40	-10	20	1.5	0.86	306.67
3	90	80	67	-10	13	1.19	0.89	385.25
4	120	105	90	-15	15	1.17	0.88	394.29
5	130	120	115	-10	5	1.04	0.92	440.83
6	140	135	130	-5	5	1.04	0.96	442.96
7	165	150	155	-15	-5	0.97	0.91	475.33
8	200	175	190	-25	-15	0.92	0.88	499.43
9	250	220	230	-30	-10	0.96	0.88	480.91
10	270	260	270	-10	-10	0.96	0.96	477.69
11	300	295	305	-5	-10	0.97	0.98	475.59
12	350	340	340	-10	0	1	0.97	460
13	380	360	370	-20	-10	0.97	0.95	472.78
14	420	395	400	-25	-5	0.99	0.94	465.82
15	460	460	450	0	10	1.02	1	450

Graph-1:

Plot of CPI over Time CPI 1 2 3 4 5 6 7 9 10 11 12 13 14 15 8 Week

Graph-2:

Plot of SPI over Time 1 2 3 4 5 6 7 9 10 11 12 13 14 15 8 Week