1. In a status report, executives want to know not only where we are today, but also where we will end up. Calculating where we will end up financially is not as easy as it sounds. Selecting the wrong formula can leave the executives and customers with a faulty impression.

There are several formulas available for calculation of the estimated cost at completion (EAC). For simplicity, consider the following three formulas:

• EAC = (AC(Total)/EV(Total)) x (budget at completion)
• EAC = ((AC(Total)/EV(Total)) x (PV for work completed and in progress)) +(planned or revised planned costs of work packages not yet begun)
• EAC = (actual to date) + (all remaining work, including work in progress, to be completed at the planned or budgeted costs)

1. Using the table below, determine the value of EAC for each of the three formulas.

Assume that A, B, and C are the only work packages in the project, and PV(Total) is the total value for PV for each work package rather than PV for the reporting period. Similar to PV(Total), calculate AC(Total). Use the following formula for calculating EV(Total):

EV(Total) = Sum of all EV(X), where X = A,B,C. EV(X)=% Complete * PV(X).

Activity	% Complete	PV	AC
A	100	1000	1100
B	50	1000	800
C	0	1000	0

2. Considering only activity B, if the reason for the cost overrun is attributed to a one-time occurrence, which of the three formulas would be best to use?

3. If the reason for the overrun in activity B is because of the higher than expected salaries of the assigned employees and these same employees will be assigned to activity C as well, which of the three formulas would be best to use?

4. Considering only activity B, if the reason for the overrun is attributed to overtime and the overtime will continue but only through the completion of activity B, which of the three formulas would be best to use?

5. Considering your answers to the above four parts, should a company be willing to change the formula for calculating EAC during the execution of the project as well as at each reporting period or gate review meeting?

2nd question- The data identified below was listed in a project's latest status report:

1. PV = $36,000
2. EV = $30,000
3. AC = $33,000
4. BAC = $120,000
5. Original length of the project 10 months

Using these data, calculate the following:

1. What are the values for CPI and SPI?
2. What is the expected cost at completion (EAC)?
3. How much money will be needed from the time of the report to complete the project?
4. What is the cost variance at completion (VAC)?

Using SPI, what is the new expected length of the project?