Formula

2 of 100 Items Missing From the PMBoK

Missing VAC FormulaVariance At Completion (VAC) is the difference between what the project was originally expected (baselined) to cost, versus what it is now expected to cost. Every month, our vendor is required to report this total on the project as a whole and on key deliverables.  I'm used to seeing the numbers reported and how to calculate them.  I'm not asking for the Cost Performance Index (CPI).  I want to know how far over or under we're going to be compared to the budget.

The formula I memorized for the PMP exam and the same formula I use to calculate VAC today is: Variance At Completion = Budget At Completion - Estimate At Completion (VAC = BAC - EAC)

So, I ask myself, [1] why is there no VAC definition and [2] VAC formula in the PMBoK?

Calculating Variance of Activity the PMP way

Use this formula on the PMP exam to calculate the variance of an activity

When I was studying for the PMP exam, a few years ago, I remember memorizing a group of formulas.  One of those was the "Variance of Activity."  At this point, don't remember if it was even referenced in the exam.  There were no direct questions asking "what is the formula for..."  On my exam, I remember having numerous questions resulting from schedule variance calculations and cost variance calculations.  To my surprise, I went searching for the Variance of Activity formula in the PMBOK (4th Edition) and I can't find it!  So as not to lead people astray when giving PMP study advice, I'm now researching each formula I was once told to memorize.  I'm very surprised PMI didn't save us a lot of trouble and list known formulas in the back of the PMBOK.

Formulas To Remember For The PMP Exam

Use this formula on the PMP exam to calculate the variance of an activity
Use this formula on the PMP exam to calculate the variance of an activity

I think back to when I sat for the PMP exam and remember taking the first few minutes to quickly write down the following formulas.  It was my cheat sheet.  There was enough to think about for the next few hours and worrying if I could remember some key formulas was not one of them.  So, here is a bit of advice.  If you're preparing[1] to take the PMP exam, MEMORIZE these formulas.  The exam won't come right out and ask you to identify the correct formula for a variance of an activity. Rather, it will offer a question like:  Your current activity was pessimistically estimated at 65 hours and optimistically estimated at 40 hours.  What is the variance of the activity?  (you can use this formula for both time and cost) You can see how knowing the formula is going to make you or break you on this question.

Do yourself a favor.  Make flash cards, get a tattoo, it doesn't matter.  Commit these formulas to memory and you'll save yourself some pain and suffering (and a few points on the exam).

The Formulas

Acronym

Title

Formula

PERT

Program Evaluation and Review Technique

Use this formula on the PMP exam to calculate PERT
Use this formula on the PMP exam to calculate PERT

P = Pessimistic Estimate M = Most Likely Estimate O = Optimistic Estimate

Standard Deviation of Activity

Use this formula on the PMP exam to calculate standard deviation of an activity
Use this formula on the PMP exam to calculate standard deviation of an activity

Variance of an Activity

Use this formula on the PMP exam to calculate the variance of an activity
Use this formula on the PMP exam to calculate the variance of an activity

Total Float

LS - ES or LF - EF

Communications Channels

[N(N-1)] / 2

CV

Cost Variance

EV - AC

SV

Schedule Variance

EV - PV

CPI

Cost Performance Index

EV / AC

SPI

Schedule Performance Index

EV / PV

EAC

Estimate at Completion

BAC / CPI

AC + ETC

AC + (BAC - EV)

ETC

Estimate to Complete

ETC = EAC - AC

VAC

Variance at Completion

BAC - EAC

CPI

c

Cumulative Cost Performance Index

Σ

EV /

Σ

AC

TCPI

To-Complete Performance Index

Use this formula on the PMP exam to calculate TCPI
Use this formula on the PMP exam to calculate TCPI

Calculating Initial Velocity On Day Zero

velocity chart

While reviewing proposal documentation yesterday, I noticed the contractor's predicted velocity rate was pretty high.  Being they are not experienced in using Agile and they haven't even started the project, I was curious how they were able to calculate such a high velocity rate for the first iteration.  I know how many developers they intend to use and I know their proposed iteration durations.  I'm not going to get into the specifics as to how they estimated features (user stories, requirements, backlog items, etc.).  So, what did I expect? Velocity is a very simple method for accurately measuring the rate at which teams deliver business value. To calculate velocity, simply add up the estimates of the items successfully delivered in the last sprint or iteration.  What about the initial iteration?

Terms to understand when calculating initial velocity:

  1. Number of Developers – How many developers will you have doing actual work?
  2. Capacity - What is the maximum amount of work one person can accomplish in an ideal situation during the iteration?
  3. Number of Iteration Days – How many work days are in the iteration?
  4. Load (Capacity) Factor - The ratio of the actual work output over a period of time and the output if the developer had operated at full capacity over that time period.  e.g. 1/3 = 2.66 Hours , 1/2 = 4 Hours, 1/1 = 8 Hours
  5. Velocity - How much Product Backlog value a team can deliver in one iteration.

Because you don’t know team velocity for the first iteration, plan initial velocity at one-third of total capacity in order to account for coffee breaks, design, email, meetings, rework, research, etc.  As an example, with seven (7) developers and at one-third (1/3) capacity, a total of 18.62 development hours are available per day.  Multiply the number by the number of work days in the sprint to arrive at the total of initial work hours.  These work hours will be applied against your estimated items, to arrive at an initial velocity.

(7 [Developers] * 1/3 [Load Capacity Factor]) * 21 [Work Days] = 44.1 [Ideal Work Days]

Ideally, the team should already be formed and stable, so that you can just forecast.  Unfortunately, this whole scenario is faulted. Not only are estimates for team capacity going to vary wildly, but what about the estimates for the deliverables themselves?  I can get pretty good at estimating a level of effort for work that could take a few days.  But the contractor that was noted in this post was estimating a 3-year project.  By the way, if you're curious, the contractor failed within 1 year. The federal agency then exercised their right to not renew their contract for the option years.  The agency then brought in a new contractor with more Agile experience.  

Communications Channels

I was at a vendor site yesterday, discussing how they were going to satisfy our needs on four upcoming projects.  There were four people in the meeting:  the technical lead from the vendor, the product manager from our organization, a director from our organization, and myself.  Since I am the project manager, I had to take into account each perspective of each participant.  Communications grows exponentially, every time you add another person to a meeting or project.  A project manager needs to realize the complexity and manage it accordingly. The situation reminded me of a few questions that were on the PMP exam.  Communication Channels  can be calculated by using the following formula:  [N (N-1)]/2 where N equals the number of people involved.  Do not just memorize the formula, UNDERSTAND it.  Below is an illustration of the formula that should help you visualize it.

If on the PMP exam, I had been asked how many channels of communications existed in the meeting, I could either draw a picture with lines between the people or I could just use the formula.  Take my word for it, just memorize the formula and understand when it applies.

Cost Variance and Project Management Terms

If you're looking to take the PMP exam, there are several definitions you need to know.  You MUST know and understand the definitions listed in the table below. The exam won't come right out and ask you "What does Actual Cost mean?"  The questions are more like:  "What kind of Variance do you have on a deliverable if the Earned Value is $75,000 and the Actual Cost is $77,000?� I won’t tell you the answer. I will, however, tell you how to figure it out. Cost Variance (CV) = Earned Value (EV) - Actual Cost (AC). A negative cost variance means you are over budget. A positive cost variance means you are under budget.

Term Acronym Definition
AC Actual Cost What is the actual cost realized from the work completed.
BAC Budget at Completion How much was budgeted for the total project?
EAC Estimate at Completion What is currently the expected TOTAL cost of the project?
ETC Estimate to Complete From this point on, how much MORE is it expected to cost to finish the project?
EV Earned Value What is the estimated value of the work actually completed?
PV Planned Value What is the estimated value of the work planned to be completed?
VAC Variance at Completion How much over or under budget is the project expected to be at the end?

PERT Formula

PERT - Program Evaluation and Review Technique.If you’re going to take the PMP exam, you MUST remember this formula.  I’ve used it countless times in the real world and it works with surprising accuracy.

Formula: (P+4M+O)/6

Optimistic time (O): the minimum possible time required to accomplish a task, assuming everything proceeds better than is normally expected. Pessimistic time (P): the maximum possible time required to accomplish a task, assuming everything goes wrong (excluding major catastrophes). Most likely time (M): the best estimate of the time required to accomplish a task, assuming everything proceeds as normal.

How does it work?

Obtain three time estimates (optimistic, pessimistic, and most likely) for every activity along the critical path.  Plug your numbers into the formula and then sum the totals.  Though people will challenge you, you WILL have a more accurate critical path estimate.

I will speak to “Standard Deviation of an Activity” and “Variance of an Activity” at a later time.   They both leverage the same values but in different formulas.