4. Use a spreadsheet to calculate the PV and the progress indicators for the following project at…

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Order a Similar Paper HERE Order a Different Paper HERE

4.  Use a spreadsheet to calculate the PV and the progress indicators for the following project at half-month intervals from January 1 through September 1.

   

 

 

Work Task

Estimated Effort (programmer- days)

Actual Effort (programmer- days)  

 

Estimated Completion Date  

 

Actual Date Completed

1

30

37

1/1

2/1

2

25

24

2/15

2/15

3

30

41

3/1

3/15

4

50

47

4/15

4/1

5

60

63

5/1

4/15

6

35

31

5/15

6/1

7

55

58

6/1

6/1

8

30

28

6/15

6/15

9

45

43

7/1

7/15

10

25

29

8/1

8/15

11

45

49

8/15

9/1

 

 

bcw

pv

acw

sched

actual

1

30

0.070

37

1-Jan

1-Feb

2

25

0.058

24

15-Feb

15-Feb

3

30

0.070

41

1-Mar

15-Mar

4

50

0.116

47

15-Apr

1-Apr

5

60

0.140

63

1-May

15-Apr

6

35

0.081

31

15-May

1-Jun

7

55

0.128

58

1-Jun

1-Jun

8

30

0.070

28

15-Jun

15-Jun

9

45

0.105

43

1-Jul

15-Jul

10

25

0.058

29

1-Aug

15-Aug

11

45

0.105

49

15-Aug

1-Sep

BAC 430

 

 

 

bcws

bcwp

acwp

ev

spi

sv

cpi

cv

1-Jan

30

0

0

0.00

0

–30

0

0

15-Jan

30

0

0

0.00

0

–30

0

0

1-Feb

30

30

37

0.07

1.00

0

0.81

–7

15-Feb

55

55

61

0.13

1.00

0

0.90

–6

1-Mar

85

55

61

0.13

0.65

–30

0.90

–6

15-Mar

85

85

102

0.20

1.00

0

0.83

–17

1-Apr

85

135

149

0.31

1.59

50

0.91

–14

15-Apr

135

195

212

0.45

1.44

60

0.92

–17

1-May

195

195

212

0.45

1.00

0

0.92

–17

15-May

230

195

212

0.45

0.85

–35

0.92

–17

1-Jun

285

285

301

0.66

1.00

0

0.95

–16

15-Jun

315

315

329

0.73

1.00

0

0.96

–14

1-Jul

360

315

329

0.73

0.88

–45

0.96

–14

15-Jul

360

360

372

0.84

1.00

0

0.97

–12

1-Aug

385

360

372

0.84

0.94

–25

0.97

–12

15-Aug

430

385

401

0.90

0.90

–45

0.96

–16

1-Sep

430

430

450

1.00

1.00

0

0.96

–20