ACC4100 Project Cost Management and Finance Exercise 3 VAC Tables Exercise 3: Earned Value This is an Exercise about understanding Earned Value. There are 3 Projects and you have to calculate the VAC. This is worth 5% of your final grade. Project A (3 pts.) You are given the following data. Calculate the VAC (Variance at Completion) for two scenarios as listed below Project A Budget $400,000 Duration 90 days Status 60 days EV $140,000 PV $150,000 AC $178,000 BAC = 1. Assume future budget estimates do not change ETC = EAC = VAC = 2. Assume future costs continue at the same spending rate ETC = EAC = VAC = Project B (3 pts.) You are given the following data. Calculate the VAC (Variance at Completion). Project B Budget $220,000 Duration 200 Status 140 EV $180,000 PV $180,000 AC $174,000 BAC = 1. Assume future budget estimates do not change ETC = EAC = VAC = 2. Assume future costs continue at the same spending rate ETC = EAC = VAC = Project C (4 pts.) You are given the following data. Calculate the VAC (Variance at Completion). Project C Budget $3,500,000 Duration 450 Status 80 EV $600,000 PV $580,000 AC $923,000 BAC = 1. Assume future budget estimates do not change ETC = EAC = VAC = 2. Assume future costs continue at the same spending rate ETC = EAC = VAC = 3. Look at the VAC results for Project C. Make a comment or recommendation regarding the ETC, EAC, and VAC.