In the following project:
a. What is the project length and total budget? (Develop network diagram to help you out)(2)
b. Please load the network schedule with activity costs and develop monthly spend profile using
Excel. Please assume activity costs are equally distributed along the duration of each activity. (2)
c. It is the end of phase D in month 48 and the following table represents the actual progress of
the activities in the project. What are the values for CPI, SPI, EAC, ETC, CV, SV and VAC? (3)
N.B. For the forecasting model, assume the existing CPI and SPI work well for the remaining works
as well.
c. We are in month 48. Please calculate EACT, ETCt & VACt using both EV technique and network
diagram. Please note, for the calculation of ETCt, EACT & VACt, focus on the network critical path
and NOT only EVM calculations as EVM calculations may be misleading. Provide explanations. (2)
Fig: 1