60.1K

Verified Solution

Link Copied!

Assume that you have completed three months of the project. The BAC was $200,000 for this six-month project. You can also make the following assumptions: PV = $120,000 EV = $100,000 AC = $90,000

Assumptions:

EAC: $180,180.00 in 7.2 Months

BAC: $200,000

Need help in plotting the figures for 6 Months in excel and formulas. Cumulative Planned Value (PV) is correct but I need random cost to make up or show accuracy that its going to be under budget and behind schedule. I have seen similar answers but no one broke down the cost.

Plot in excel an earned value chart using the preceding information.

Monthly Planned Value (PV)	$ 14,833.33	$ 22,833.33	$ 33,433.33	$ 31,333.33	$ 68,333.33	$ 29,233.33
Cumulative Planned Value (PV)	$ 14,833.33	$ 37,666.67	$ 71,100.00	$ 102,433.33	$ 170,766.67	$ 200,000.00
Monthly Actual Cost (AC)
Cumulative Actual Cost (AC)
Monthly Earned Value (EV)
Cumulative Earned Value (EV)
Assumptions:
PV	$ 120,000.00
EV	$ 100,000.00
AC	$ 90,000.00
CV=EV-AC	$ 10,000.00
SV=EV-PV	$ (20,000.00)
CPI=EV/AC	1.111111111
SPI=EV/PV	0.833333333
Estimate at Completion (EAC)	$180,180.00
Estimated time to complete	7.2

Answer & Explanation Solved by verified expert

See Answer