Earned Value Management for Test Case Example

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29	Planned Test Cases Per Day	50
30	Number of People	5
31	Avrg TC per day	60
32		25.09	26.09	27.09	28.09	29.09	02.10	03.10	04.10	05.10	06.10	09.10	10.10	11.10	12.10
33	Planned Value	0	250	500	750	1000	1250	1500	1750	2000	2250	2500	2750	3000	3250
34	Earned Value	0	257	506	776	972	1398	1815	2083	2374	2479	2799	3167	3461	3548
35	Actual Cost	0	300	540	840	1140	1440	1740	1980	2280	2580	2880	3180	3480	3780
36	Actual Available People	0	5	4	5	5	5	5	4	5	5	5	5	5	5
37
38	Daily Report: Test Cases Passed		26.09	27.09	28.09	29.09	02.10	03.10	04.10	05.10	06.10	09.10	10.10	11.10	12.10
39	QA Engineer 1	0	58	70	64	85	117	102	109	74	20	151	109	85	21
40	QA Engineer 2	0	64	59	51	43	87	98	82	88	23	66	85	48	10
41	QA Engineer 3	0	112	87	101	0	110	115	0	60	25	85	76	47	31
42	QA Engineer 4	0	4	0	42	38	82	81	42	38	17	16	78	76	12
43	QA Engineer 5	0	19	33	12	30	30	21	35	31	20	2	20	38	13
44	QA Engineer 6
45
46
47
48	Commulative Value Calculation (Do not Edit)
49	QA Engineer 1	0	58	128	192	277	394	496	605	679	699	850	959	1044	1065
50	QA Engineer 2	0	64	123	174	217	304	402	484	572	595	661	746	794	804
51	QA Engineer 3	0	112	199	300	300	410	525	525	585	610	695	771	818	849
52	QA Engineer 4	0	4	4	46	84	166	247	289	327	344	360	438	514	526
53	QA Engineer 5	0	19	52	64	94	124	145	180	211	231	233	253	291	304
54	QA Engineer 6	0	0	0	0	0	0	0	0	0	0	0	0	0	0
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100