EVM Worksheet Package

By

Format: Evaluation Assessment / Log / Evaluation Form

Every project needs to answer the question: How much work was accomplished?  Earned value management (EVM) is a quantitative technique methodology for controlling a project; it relies on measuring the performance of work using a work breakdown structure (WBS) and includes an integrated schedule and budget based on the project WBS. However, we must keep in mind that this methodology provides an “estimate,” not an exact number. This estimate varies according the performance of the project.

Earned value management is used in project management to measure progress of a project with respect to cost. This template runs a basic earned value analysis and monitors spending over the life of a project. This EVM worksheet is used for planning and tracking of your spending.

Start by adding tasks to the EVM table and entering the amounts that will be spent on the tasks each period.

After you are done defining the tasks and the budget, enter the same set of tasks in the PV (Planned Value), EV (Earned Value) and AC (Actual Cost) worksheets.

At the end of each period, you'll enter a percentage complete for each task in the % PV+EV worksheet, and the amount spent on each task during the period in the AC worksheet.

Update the pivot table on Graphic worksheet and analyze the graph, comparing the EV and AC to the Planned Value.

This zip file contains a user manual and sheets with English and Spanish samples; adapt to your own needs.

People who downloaded this item also downloaded . . .

Premium Content
PMI Membership
$129 /year
(plus $10 application fee)
Sign up to download this deliverable and get unlimited access to our library of webinars, time-saving templates and more.
PMI Membership perks include job opportunities, local chapters, respected publications, and standards.   Learn more
Already a PMI Member? Log in now.

ADVERTISEMENT

169
Downloads
ADVERTISEMENTS

"If you must play, decide on three things at the start: the rules of the game, the stakes and the quitting time."

- Chinese Proverb

ADVERTISEMENT

Sponsors