9.2 Managing the Budget

Learning Objectives

1. Describe methods to manage cash flow.
2. Describe the terms and relationships of budget factors used in earned value analysis.
3. Calculate and interpret budget and schedule variances.
4. Calculate and interpret the schedule performance index and the cost performance index.
5. Calculate and interpret estimates to complete the project.
6. Calculate the revised final budget.

Projects seldom go according to plan in every detail. It is necessary for the project manager to be able to identify when costs are varying from the budget and to manage those variations.

Managing Cash Flow

If the total amount spent on a project is equal to or less than the amount budgeted, the project can still be in trouble if the funding for the project is not available when it is needed. There is a natural tension between the financial people in an organization, who do not want to pay for the use of money that is just sitting in a checking account, and the project manager, who wants to be sure that there is enough money available to pay for project expenses. The financial people prefer to keep the company’s money working in other investments until the last moment before transferring it to the project account. The contractors and vendors have similar concerns, and they want to get paid as soon as possible so they can put the money to work in their own organizations. The project manager would like to have as much cash available as possible to use if activities exceed budget expectations.

Contingency Reserves

Most projects have something unexpected occur that increases costs above the original estimates. If estimates are rarely exceeded, the estimating method should be reviewed because the estimates are too high. It is not possible to predict which activities cost more than expected, but it is reasonable to assume that some of them will be. Estimating the likelihood of such events is part of risk analysis, which is discussed in more detail in a later chapter.

Instead of overestimating each cost, money is budgeted for dealing with unplanned but statistically predictable cost increases. Funds allocated for this purpose are called contingency reserves (Project Management Institute, Inc., 2008). Because it is likely that this money will be spent, it is part of the total budget for the project. If this fund is adequate to meet the unplanned expenses, then the project will complete within the budget.

Management Reserves

If something occurs during the project that requires a change in the project scope, money may be needed to deal with the situation before a change in scope can be negotiated with the project sponsor or client. It could be an opportunity as well as a challenge. Money can be made available to the project to be used at the discretion of the manager to meet needs that would change the scope of the project. These funds are called management reserves. Unlike contingency reserves, they are not likely to be spent and are not part of the project’s budget baseline, but they can be included in the total project budget (Project Management Institute, Inc., 2008).

Evaluating the Budget During the Project

A project manager must regularly compare the amount of money spent with the budgeted amount and report this information to managers and stakeholders. It is necessary to establish an understanding of how this progress will be measured and reported.

Reporting Budget Progress on John’s Move

In the John’s move example, he estimated that the move would cost about \$1,500 and take about sixteen days. Eight days into the project, John has spent \$300. John tells his friends that the project is going well because he is halfway through the project but has only spent a fifth of his budget. John’s friend Carlita points out that his report is not sufficient because he did not compare the amount spent to the budgeted amount for the activities that should be done by the eighth day.

As John’s friend points out, a budget report must compare the amount spent with the amount that is expected to be spent by that point in the project. Basic measures such as percentage of activities completed, percentage of measurement units completed, and percentage of budget spent are adequate for less complex projects, but more sophisticated techniques are used for projects with higher complexity.

Earned Value Management

A method that is widely used for medium- and high-complexity projects is the earned value management (EVM) method. EVM is a method of comparing the budgeted and actual costs of a project periodically during the project. It combines the scheduled activities with detailed cost estimates of each activity. It allows for partial completion of an activity if some of the detailed costs associated with the activity have been paid but others have not. The earned value analysis method compares the anticipated cost of work that is scheduled to be done at a given point in time against what has been done and how much it actually cost.

The Budgeted Cost of Work and Planned Value

The budgeted cost of work scheduled (BCWS) comprises the detailed cost estimates for each activity in the project. The amount of work that should have been done by a particular date is the planned value (PV). These terms are used interchangeably by some sources, but the planned value term is used in formulas to refer to the sum of the budgeted cost of work up to a particular point in the project, so we will make that distinction in the definitions in this text for clarity.

Planned Value on Day Six of John’s Move

On day six of the project, John should have taken his friends to lunch and purchased the packing materials. The portion of the BCWS that should have been done by that date (the planned value) is listed in Figure 9.6 “Planned Value for Lunch and Packing Materials”. This is the planned value for day six of the project.

Figure 9.6 Planned Value for Lunch and Packing Materials

Description Quantity Cost
Lunch 3 \$45.00
Small Boxes 10 \$17.00
Medium Boxes 15 \$35.25
Large Boxes 7 \$21.00
Extra Large Boxes 7 \$26.25
Short Hanger Boxes 3 \$23.85
Box Tape 2 \$7.70
Markers 2 \$3.00
Mattress/Spring Bags 2 \$5.90
Lift Straps per Pair 1 \$24.95
Bubble Wrap 1 \$19.95
Total \$261.65

Budgeted Cost of Work Performed and Earned Value

The budgeted cost of work performed (BCWP) is the budgeted cost of work scheduled that has been done. If you sum the BCWP values up to that point in the project schedule, you have the earned value (EV).

Actual Cost

The amount spent on an item is often more or less than the estimated amount that was budgeted for that item. The actual cost (AC) is the sum of the amounts actually spent on the items.

Comparing PV, EV, and AC in John’s Move on Day Six

Dion and Carlita were both trying to lose weight and just wanted a nice salad. Consequently, the lunch cost less than expected. John makes a stop at a store that sells moving supplies at discount rates. They do not have all the items he needs, but the prices are lower than those quoted by the moving company. They have a very good price on lifting straps so he decides to buy an extra pair. He returns with some of the items on his list, but this phase of the job is not complete by the end of day six. John bought half of the small boxes, all of five other items, twice as many lifting straps, and none of four other items. John is only six days into his project, and his costs and performance are starting to vary from the plan. Earned value analysis gives us a method for reporting that progress. Refer to the figure below.

Figure 9.7 Planned Value, Earned Value, and Actual Cost

Project Earned Value Analysis–Day 6 Budgeted Cost of Work Scheduled (BCWS) Budgeted Cost of Work Performed (BCWP) Actual Cost (AC) Description Quantity Cost Lunch 3 \$45.00 3 \$45.00 3 \$35.00 Small Boxes 10 \$7.00 5 \$8.50 5 \$9.50 Medium Boxes 15 \$35.25 15 \$35.25 15 \$28.00 Large Boxes 7 \$21.00 Extra Large Boxes 7 \$26.25 Short Hanger Boxes 3 \$23.85 Box Tape 2 \$7.70 2 \$7.70 2 \$5.50 Markers 2 \$3.00 2 \$3.00 2 \$2.00 Mattress/Spring Bags 2 \$5.90 2 \$5.90 2 \$7.50 Lift Straps per Pair 1 \$24.95 1 \$24.95 2 \$38.50 Bubble Wrap 1 \$19.95 Furniture Pads 4 \$31.80 4 \$31.80 4 \$28.50

The original schedule called for spending \$261.65 (PV) by day six. The amount of work done was worth \$162.10 (EV) according to the estimates, but the actual cost was only \$154.50 (AC).

Schedule Variance

The project manager must know if the project is on schedule and within the budget. The difference between planned and actual progress is the variance. The schedule variance (SV) is the difference between the earned value (EV) and the planned value (PV). Expressed as a formula, SV = EV − PV. If less value has been earned than was planned, the schedule variance is negative, which means the project is behind schedule.

Schedule Variance on John’s Move

Planning for John’s move calls for spending \$261.65 by day six, which is the planned value (PV). The difference between the planned value and the earned value is the scheduled variance (SV). The formula is SV = EV − PV. In this example, SV = \$162.10 − \$261.65 = \$(99.55) A negative SV indicates the project is behind schedule.

The difference between the earned value (EV) and the actual cost (AC) is the cost variance (CV). Expressed as a formula, CV = EV − AC

Cost Variance on John’s Move

The difference between the earned value of \$162.10 and the actual cost of \$154.50 is the cost variance (CV). The formula is CV = EV − AC. In this example, CV = \$162.10 − \$154.50 = \$7.60.

A positive CV indicates the project is under budget.

Variance Indexes for Schedule and Cost

The schedule variance and the cost variance provide the amount by which the spending is behind (or ahead of) schedule and the amount by which a project is exceeding (or less than) its budget. They do not give an idea of how these amounts compare with the total budget.

The ratio of earned value to planned value gives an indication of how much of the project is completed. This ratio is the schedule performance index (SPI). The formula is SPI = EV/PV. In the John’s move example, the SPI equals 0.62 (SPI = \$162.10/\$261.65 = 0.62) A SPI value less than one indicates the project is behind schedule.

The ratio of the earned value to the actual cost is the cost performance index (CPI). The formula is CPI = EV/AC.

Cost Performance Index of John’s Move

In the John’s move example, CPI = \$162.10/\$154.50 = 1.05 A value greater than 1 indicates the project is under budget.

Figure 9.8 Schedule Variance and Cost Variance on Day Six of the John’s Move Project

The cost variance of positive \$7.60 and the CPI value of 1.05 tell John that he is getting more value for his money than planned for the tasks scheduled by day six. The schedule variance (SV) of negative \$99.55 and the schedule performance index (SPI) of 0.62 tell him that he is behind schedule in adding value to the project.

During the project, the manager can evaluate the schedule using the schedule variance (SV) and the schedule performance index (SPI) and the budget using the cost variance (CV) and the cost performance index (CPI).

Estimated Cost to Complete the Project

Partway through the project, the manager evaluates the accuracy of the cost estimates for the activities that have taken place and uses that experience to predict how much money it will take to complete the unfinished activities of the project—the estimate to complete (ETC).

Atypical Cost Variance

To calculate the ETC, the manager must decide if the cost variance observed in the estimates to that point are representative of the future. For example, if unusually bad weather causes increased cost during the first part of the project, it is not likely to have the same effect on the rest of the project. If the manager decides that the cost variance up to this point in the project is atypical—not typical—then the estimate to complete is the difference between the original budget for the entire project—the budget at completion (BAC)—and the earned value (EV) up to that point. Expressed as a formula, ETC = BAC − EV

Estimate to Complete John’s Move

In John’s move, John was able to buy most of the items at a discount house that did not have a complete inventory and, he chose to buy an extra pair of lift straps. He knows that the planned values for packing materials were obtained from the price list at the moving company where he will have to buy the rest of the items, so those two factors are not likely to be typical of the remaining purchases. The reduced cost of lunch is unrelated to the future costs of packing materials, truck rentals, and hotel fees. John decides that the factors that caused the variances are atypical. He calculates that the estimate to complete (ETC) is the budget at completion (\$1,534) minus the earned value at that point (\$162.10), which equals \$1,371.90. Expressed as a formula, ETC = \$1,534 − \$162.10 = \$1,371.90.

Typical Cost Variance

If the manager decides that the cost variance is caused by factors that will affect the remaining activities, such as higher labor and material costs, then the estimate to complete (ETC) needs to be adjusted by dividing it by the cost performance index (CPI). For example, if labor costs on the first part of a project are estimated at \$80,000 (EV) and they actually cost \$85,000 (AC), the cost variance will be 0.94. (Recall that the cost variance = EV – AC).

To calculate the estimate to complete (ETC) assuming the cost variance on known activities is typical of future cost, the formula is ETC = (BAC – EV)/CPI. If the budget at completion (BAC) of the project is \$800,000, the estimate to complete is (\$800,000 – \$80,000)/0.94 = \$766,000.

Estimate Final Project Cost

If the costs of the activities up to the present vary from the original estimates, it will affect the total estimate for the project cost. The new estimate of the project cost is the estimate at completion (EAC). To calculate the EAC, the estimate to complete (ETC) is added to the actual cost (AC) of the activities already performed. Expressed as a formula, EAC = AC + ETC.

Estimate at Completion for John’s Move

The revised estimate at completion (EAC) for John’s move at this point in the process is EAC = \$154.50 + \$1,371.90 = \$1,526.40.

Refer to Figure 9.9 “Summary of Terms and Formulas for Earned Value Analysis” for a summary of terms and formulas.

Figure 9.9 Summary of Terms and Formulas for Earned Value Analysis

Term Acronym Description Formula John’s Move
Actual Cost AC The money actually spent on projects up to the present \$154.50
Budget at Completion BAC Original budget for the project (same as BCWS) \$1,534.00
Cost Performance Index CPI Ratio of earned value to actual cost CPI = EV / AC 1.05
Cost Variance CV Difference between earned value and actual cost CV = EV – AC \$7.60
Earned Value EV Sum of estimates for work actually done up to the present \$162.10
Estimate at Completion EAC Revised estimate of total project cost EAC = AC + ETC \$1,526.40
Estimate to Complete ETC Money to complete the project if early cost variance is atypical ETC = BAC – EV \$1,371.90
Estimate to Complete ETC Money to complete the project if early cost variance is typical ETC – (BAC – EV) / CPI N/A
Planned Value PV Sum of the estimates for work done up to the present \$261.65
Schedule Performance Index SPI Ratio of earned value to planned value SPI = EV / PV .62
Schedule Variance SV Difference between earned value and planned value SV = EV – PV \$(99.55)

Key Takeaways

• Extra money is allocated in a contingency fund to deal with activities where costs exceed estimates. Funds are allocated in a management reserves in case a significant opportunity or challenge occurs that requires change of scope but funds are needed immediately before a scope change can typically be negotiated.
• Schedule variance is the difference between the part of the budget that has been done so far (EV) versus the part that was planned to be completed by now (PV). Similarly, the cost variance is the difference between the EV and the actual cost (AC).
• The schedule performance index (SPI) is the ratio of the earned value and the planned value. The cost performance index (CPI) is the ratio of the earned value (EV) to the actual cost (AC).
• The formula used to calculate the amount of money needed to complete the project (ETC) depends on whether or not the cost variance to this point is expected to continue (typical) or not (atypical). If the cost variance is atypical, the ETC is simply the original total budget (BAC) minus the earned value (EV). If they are typical of future cost variances, the ETC is adjusted by dividing the difference between BAC and EV by the CPI.
• The final budget is the actual cost (AC) to this point plus the estimate to complete (ETC).

Exercises

1. Money that is allocated for dealing with unplanned but predictable expenses is _________ reserve.
2. The formula used to calculate the cost performance index is ____________.
3. The formula used to calculate the estimate to complete for atypical cost variances is _________________________.
4. The sum of the budgeted amounts for the tasks that have been performed is the _______ _______ (two words).
5. Schedule variance is the ____ minus the _____ and cost variance is the ____ minus the _____ (use acronyms).
6. Schedule performance index is ____ / _____ and the cost performance index is _____ / ______ (use acronyms).
7. The revised final budget is the ____ plus the _____ (use acronyms).

Estimating Earned Value

Consider a project you are familiar with in which the contractor or service provider who was performing the work needed to be replaced before the job was completed. Describe how the value of the contractor’s efforts up to that point was determined and how that evaluation compared to an earned value analysis.

References

Project Management Institute, Inc., A Guide to the Project Management Body of Knowledge (PMBOK Guide), 4th ed. (Newtown Square, PA: Project Management Institute, Inc., 2008), 173.

This is a derivative of Project Management from Simple to Complex by a publisher who has requested that they and the original author not receive attribution, which was originally released and is used under CC BY-NC-SA. This work, unless otherwise expressly stated, is licensed under a Creative Commons [license_name] License.