Problem #1

You have a construction project that requires 12,000 man-hours at a rate of $60 per hour. The estimated duration of the project is 7 months and the total cost of the materials was estimated at $250,000. The scheduled percent complete (PC) of the work and the material consumption for each month is as follows:

Month	1	2	3	4	5	6	7
Monthly Scheduled PC	10%	10%	20%	25%	15%	15%	5%

This means on month 1, 10% of the work and materials is supposed to be used, on month 2 another 10% and so on and on.

At the end of month #5, earned value analysis is performed and it is found that only 35% of the work has been completed. The other available information is as follows:

• 60% of the man-hours were spent by the end of the 5^th month.
• 40% of the materials were consumed by the end of the 5^th month.
• A change order estimated at $30,000 was issued and approved at the end of month # 6^.
• The material costs escalated by 35% after the 5^th month.
• 30% of the cost of material consumed by the end of the 4^th month was escalated by 20%.

Using the above-mentioned information, calculate the following:

1. Original BAC
2. BCWS
3. BCWP
4. ACWP
5. SV
6. CV
7. DCWP
8. Expenditure variance
9. SPI
10. EAC considering the same rate of progress