Earned Value Management - Excel Template - Tour

Описание

Earned Value Management (EVM) is a technique used in project management to measure progress of a project with respect to cost. In this video, we will cover the basics of EVM, why it is useful, terms used and their definitions.

Download Free Template:
https://indzara.com/2016/02/earned-value-management-free-excel-template/

I have followed the terminology as presented in the PMBOK (Project Management Body of Knowledge).

TERMS & DEFINITIONS

PLANNED VALUE (PV): Authorized Budget assigned to the scheduled work
EARNED VALUE (EV): Measure of actual work performed expressed as budget authorized for that work
ACTUAL COST (AC): Actual cost incurred for the work performed
SCHEDULE VARIANCE (SV): Amount by which project is ahead or behind plan = EV – PV
COST VARIANCE (CV): Amount by which actual cost is ahead or behind planned cost = EV – AC
BUDGET AT COMPLETION (BAC): Total Budget assigned to the entire plan
SCHEDULE PERFORMANCE INDEX (SPI): Measure of Schedule efficiency expressed as Earned Value to Planned Value = EV/PV
COST PERFORMANCE INDEX (CPI): Measure of Cost efficiency expressed as Earned Value to Actual Cost = EV/AC

We also cover forecasting terms.
Estimate at Completion, Estimate to Complete, To-Complete Performance Index.


Simple and Effective Excel Templates: http://www.indzara.com/
Free Excel Templates: http://www.indzara.com/free-excel-templates/
Premium Excel Templates: http://www.indzara.com/shop/
Project Management Templates: http://www.indzara.com/project-management-excel-templates/
Inventory Management Templates: http://www.indzara.com/inventory-management-excel-templates/
Free Excel Course: http://www.indzara.com/useful-excel-for-beginners/

Social:
Subscribe to YouTube: http://www.youtube.com/user/theindzara?sub_confirmation=1
Facebook: https://www.facebook.com/theindzara
YouTube: https://www.youtube.com/user/theindzara
LinkedIn: https://www.linkedin.com/company/indzara
Twitter: https://www.youtube.com/user/theindzara

-~-~~-~~~-~~-~-
Please watch my latest video: "Highlight events, weekends and holidays on calendar in Excel" https://www.youtube.com/watch?v=b0lWFlhAj3k
-~-~~-~~~-~~-~-