solution

EV Spreadsheet Template

One of the more common methods to compute EV parameters is through the use of a spreadsheet. The sample below contains a summary level project plan for a selected level of the WBS.

Percentage completion estimates for each activity are recorded in column “O.” The status point for EV evaluation is May as indicated by the vertical bar. AC data are recorded in rows 15 and 16. Answer the following questions using your knowledge of EV.

a. Translate these data to produce the project EV status.

b. What is the condition of the project based on these parameter values?

c. What is the estimated cost and schedule at completion?