Problems 6-1: Forecasting project completion (Ungraded)
A project has been estimated to take six weeks and cost $130,000. Cost and percent complete data are provided in the table below through 3 weeks of the project. % scheduled data can be obtained from the Gantt chart following the table. Task | $/Task | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | A | $5,000 | 100% | 100% | 100% | | | | B | $10,000 | 50% | 70% | 100% | | | | C | $25,000 | | 40% | 80% | | | | D | $30,000 | | 20% | 45% | | | | E | $10,000 | | | | | | | F | $20,000 | | | | | | | G | $20,000 | | | 50% | | | | H | $10,000 | | 80% | 100% | | | | | ACWP | $12,000 | $38,000 | $66,000 | | | |

Task | BAC | % Comp | BCWP (EV) | BCWS (PV) | ACWP (AC) | cv | sv | cpi | svi | A | $5,000 | 100% | $5,000 | $5,000 | $5,500 | ($500) | $0 | 0.91 | 1.00 | B | $10,000 | 100% | $10,000 | $10,000 | $9,500 | $500 | $0 | 1.05 | 1.00 | C | $25,000 | 80% | $20,000 | $25,000 | $19,000 | $1,000 | ($5,000) | 1.05 | 0.80 | D | $30,000 | 45% | $13,500 | $20,000 | $12,500 | $1,000 | ($6,500) | 1.08 | 0.68 | E | $10,000 | | | | | | | | | F | $20,000 | | | | | | | | | G | $20,000 | 50% | $10,000 | $10,000 | $9,000 | $1,000 | $0 | 1.11 | 1.00 | H | $10,000 | 100% | $10,000 | $10,000 | $10,500 | ($500) | $0 | 0.95 | 1.00 | | $130,000 | | $68,500 | $80,000 | $66,000 | $2,500 | ($11,500) | 1.04 | 0.86 | 1) Calculate the EV, PV, and AC for the tasks through week 3 based on the project details provided.
See table above. 2) Calculate the CV, CPI, SV, and SPI as of week 3.
See table above.

3) Calculate the EAC using method 1 (on budget on all task started after this date) and 2 (Performance will continue