Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

You are a project manager in a company. You are asked to compute the \"Earned Va

ID: 3626737 • Letter: Y

Question

You are a project manager in a company. You are asked to compute the "Earned Value Analysis" of a software project. The Project has 80 planned work tasks that are estimated to require 690 person-days to complete. At the time you have been asked to do the earned value analysis, 12 tasks have been completed. However, the project schedule indicates that 17 tasks should have been completed. The following scheduling data in person-days are available:

        Task

   Planned Effort

 Actual Effort

1

14

12.5

2

12

13

3

11

11

4

10

9.5

5

9

9

6

8

9

7

12

12

8

4

5

9

7

7.5

10

13

12.5

11

6

6

12

8

8

13

9

 

14

15

 

15

11

 

16

5

 

17

6

 

 

 

 

Compute the following

SPI

Schedule variance

Percent scheduled for completion

Percent complete

CPI

Cost variance for the project.


        Task



   Planned Effort



 Actual Effort



1



14



12.5



2



12



13



3



11



11



4



10



9.5



5



9



9



6



8



9



7



12



12



8



4



5



9



7



7.5



10



13



12.5



11



6



6



12



8



8



13



9



 



14



15



 



15



11



 



16



5



 



17



6



 




 



 


Explanation / Answer

Budgeted Cost of Work Scheduled (BCWS)

14 + 12 + 11 + 10 + 9 + 8 + 12 + 4 + 7 + 13 + 6 + 8 + 9 + 15 + 11 + 5 + 6 = 160

Budgeted Cost of Work Performed (BCWP)

14 + 12 + 11 + 10 + 9 + 8 + 12 + 4 + 7 + 13 + 6 + 8 = 114

Budget at completion (BAC)

690

Schedule performance index, SPI = BCWP/BCWS = 114/160 = 0.7125

Schedule variance, SV = BCWP – BCWS = 114 - 160 = -46 (negative sign shows that we are behind the schedule)

Percent scheduled for completion = BCWS/BAC = 160/690 = 0.2319

Percent Complete = BCWP/BAC = 114/690 = 0.6

Actual Cost of Work Performed (ACWP) = 12.5 + 13 + 11 + 9.5 + 9 + 9 + 12 + 5 + 7.5 + 12.5 + 6 + 8 = 115

Cost performance index, CPI = BCWP/ACWP = 114/115 = 0.9913

Cost variance, CV = BCWP – ACWP = 114 – 115 = –1