(TCO 5) You work for a local construction firm DeVryEngineering Group and your s

(TCO 5) You work for a local construction firm DeVryEngineering Group and your supervisor Jessica needs an updatedearned value analysis index of the prior month for an existingcapital project (0000001) that has a current Budget at Completion(BAC) of $1500.00 a current earned value of (EV) of $300 acurrent actual cost (AC) of $500.00 and a current planned value(PV) of $350.00. In order to calculate the current average indexassume the following variables and standard formulas below: CostVariance (CV) EVAC Cost Performance Index (CPI) EV/AC ScheduleVariance (SV) EVPV Schedule Performance Index (SPI) EV/PV Estimateto Completion (ETC) EACAC Estimate at Completion (EAC) BAC/CPIVariance at Completion (VAC) BACEAC Status (Earned Value Index)(EVI) (CPI+SPI)/2 Also assume that a final calculated average indexof 1.00 or greater represents a project being on track and in goodstanding. In addition there could be several options for thedescriptive methods to design this worksheet and below is aworksheet setup with the following 3 columns including any otherneeded top labels like for the existing Month alreadycalculated.