The Earned Value Management Macros: Cost Estimates :: SAS/OR(R) 9.2 User's Guide: Project Management

The Earned Value Management Macros

Cost Estimates

The ETC, or Estimate to Complete, and the EAC, or Estimate at Completion, are two metrics that are central to Earned Value Analysis. The ETC is a projection of the additional funds needed to finish the project. The EAC can be derived as follows (where AC represents the actual costs to date):

$\hspace*{0.35in}eac = ac + etc.$

For the purposes of this document, each of these two cost estimates takes four forms, illustrated by the following table for ETC:

Table 9.13: ETC Formulas

Acronym	Description	Formula
ETC $_{\rm rev}$	Revised	EAC $_{\rm rev}$ - AC
ETC $_{\rm otd}$	Overrun to date	BAC - EV = WR
ETC $_{\rm cpi}$	CPI	$\frac{\rm wr}{\rm cpi}$
ETC $_{\rm cpix spi}$	CPI times SPI	$\frac{\rm wr}{\rm cpi x spi}$

The ETC $_{\rm rev}$ is derived directly from the revised schedule, revised costs, and actual costs to date. This form does not make allowances for past performance. It is assumed that this information has already been factored into the updated schedule and costs. Analogous to the ETC $_{\rm rev}$ , the ETC $_{\rm otd}$ is taken to be the remaining planned value (Budget at Completion less Earned Value), also known as Work Remaining (WR). This form can be thought of as having a performance factor of 1.

The ETC $_{\rm cpi}$ form is the remaining planned value divided by the CPI. In this way favorable cost performance (CPI greater than 1) forces the estimate downward. The performance factor in this case is the inverse of the CPI. Similarly, the ETC $_{\rm cpix spi}$ form employs the inverse of the product of the CPI and SPI as the performance factor. In this case, both cost and schedule performance affect the estimate. For example, if both CPI and SPI are favorable (greater than 1), the estimate is lower.

Top of Page