Question: Earned Value Management (EVM) is a project cost control method that can be used to measure productivity. The objective of this assignment is to learn

Earned Value Management (EVM) is a project cost control method that can be used to measure productivity. The objective of this assignment is to learn how EVM calculations are performed.

1. The construction phase of a building project is at the end of its 6th month, while its total duration was estimated to be 12 months. At the beginning of the project, the progress was estimated to be as follows:

Month: 1 2 3 4 5 6 7 8 9 10 11 12

Scope: 3% 4% 6% 7% 10% 12% 13% 13% 10% 9% 7% 6%

The following tables show estimations of the trades and material required to complete the project, plus the person-hours spent and the material consumed at the end of the 6th month:

Trade Type

Person-hours

Rate ($/hr)

Spent (%)

Concrete & Masonry

1000

40

84

Painting & Finishes

500

50

3

Glass & Glazing

800

55

12

Floor Covering

2000

55

91

Communications

1500

90

22

Plumbing

1000

70

69

Metal Fabrication & Millwork

2400

65

59

Drywall & Acoustics

4000

70

79

Electrical

1400

75

38

Mechanical & HVAC

1200

85

68

Material

Price ($)

Consumed (%)

Concrete, Rebar & Masonry

300,000

88

Paint

70,000

4

Glass

27,000

6

Cable

40,000

96

Pipe

35,000

23

Wood

25,000

61

HVAC Units

124,000

10

Mechanical Equipment

32,000

52

According to the earned value analysis, 48% of the scope is completed at the end of the six months. During the first six months of the project, the price of pipe and paint were escalated by $5250. Further, half of the mechanical equipment was purchased at a 20% additional price because of inflation. At the end of the 4th month, a change order was issued and approved, which increased the total plumbing person-hours by 10%. The second change order was issued (yet to be approved) at the end of the 5th month that could increase the total floor covering workload by 20%. The third change order was issued and approved at the end of the 6th month, which adds an extra $10,000 to the metal fabrication & millwork. The rate of Drywall Acoustics and the price of all materials except pipe and paint will be escalated by 10% after the 6th month. Calculate the following items and show them (schematically if necessary) on a diagram:

  1. Original BAC
  2. Updated BAC at the end of the 6th month
  3. BCWS
  4. BCWP
  5. ACWP
  6. CV
  7. CPI
  8. SV
  9. SPI
  10. EAC (Cost) considering the same rate of progress

2. Based on all actual numbers at the end of month 6, extrapolate or project to the end of month 7 (7th month) what you believe will have been spent or consumed by then and re-calculate all EV values from above. Explain why you believe your new numbers should be credible.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!