For the following two problems, use the included excel spreadsheet and the formulas included to analyze the following problems. 1. You are constructing six additional rooms on an office building. Each of the six rooms is identical, the projected cost for the project is $100,000 and construction is expected to take five weeks. At the end of the second week, you have spent $17,500 per room and have finished two rooms; you are ready to begin on the 3rd room. a. Based on the information provided above, fill in the values in the table. b. Is the project ahead or behind schedule? c. Is the project going to be completed over or under budget? 2. You have planned for a project to write a software application to take one year. The costs on this project are budgeted at $12,500 per month. Six months into the project, you findat that the software application is 50% completed, and you have spent $70,000. a. Based on the information provided, fill in the values for the following table: b. Is the project ahead or behind schedule? c. Is the project going to be completed over or under budget? P B Formula Look at the contract and addendums Planned % Complete * BAC EV= Actual % Complete .BAC Sum of costs for given period Term 1 Budgeted at Completion (BAC) 2 Planned Value (PV) a/k/a Budgeted Cost of Work Scheduled (BCWS) 3 Earned Value (EV) a/k/a Budgeted Cost of Work Performed (BCWP) 4 Actual Cost (AC) a/k/a Actual Cost of Work Performed (ACWP) 5 Cost Variance (CV) 6 Scheduling Variance (SV) 7 Cost Performance Index (CPI) 8 Schedule Performance Index (SPI) 9 Estimate at Completion (EAC) 10 Estimate to Complete 11 Variance at Completion 12 To Complete Performance Index CV=EV - AC SV = EV - PV CPI = EV/AC SPIE EV/PV EAC = BAC *CPIC ETC = EAC - AC VAC = BAC - EAC TCPIC=(BAC - EV)/ remaining funds skip skip skip skip skip skip skip skip