Complete Earned Value Management Formulas: Actual Costs, Planned

Individual Assignment # 2 Class Name:Plan Cost Management Class Group:3 Names:Harpreet Kaur Group Member ID's:FC1007725 Complete Earned Value Management Formulas You are the project manager of the Dive11 Project for your company. This project is scheduled to last 18 months and has a budget at completion of $1,500,000. The project is currently 30 percent complete, though you were supposed to be 35 percent complete at this time. Due to some unforeseen errors, your project has been delayed and you've spent $485,230. (10 points) 1.Given this information, complete the following table of earned value management formulas: NameFormulaFormula Result Actual Costs (AC)Actual monies spent$485,230 Planned ValuePV = percent complete ofwhere the project should be $525,000 Earned ValueEV = percent complete xbudget at completion $450,000 Cost VarianceCV = EV - AC-$35230 Schedule VarianceSV = EV - PV-$75000 Cost Performance IndexCPI = EV/AC0.92739526 Schedule performance indexSPI = EV/PV0.86 Estimate at completionEAC = BAC/CPI$1617433.33 Estimate to completeETC = EAC - AC$1132203.33 To-complete performanceindex (BAC) (BAC - EV) / (BAC - AC)$ 1.0345 To- complete performanceindex (EAC) (BAC - EV) / (EAC - AC)$0.92739526 Variance at completionVAC = BAC - EAC- 117,433.33 The total project budgetBAC=$1,500,000 The project should have been 35% complete and hence the PV would have been$525,000 (% / 100 x BAC) (35% x 1,500,000) The project is currently 30% complete and hence the EV should have been$450,000(% / 100 x BAC) (30% x 1,500,000) Cost Value (cv)= CV= EV-AC CV =450,000-485,230 CV= 35230 Schedule VarianceSV = EV - PV = $450000 - $525000 SV=- $75000