I have done all of tmost of the homework but im having a hard time doing part D.

Your project team is constructing 6 additional rooms on an office building. Each of the rooms is identical. The projected cost (and budget at completion) for the project is $100,000, and construction is expected to take 5 weeks. At the end of the 2nd week, your team has spent $17,500 per room and has finished 2 rooms. You are ready to begin working on the 3rd room. a. (24 points) Based on the information provided above, fill in the values and the Calculations for the table below (1 point per value * 24 Values = 24 points) Parameter Budgeted at Completion (BAC) Value $100,000 Calculations Total of PV at completion i. ii. Planned Value (PV) $40,000 BAC * (2 weeks / 5 weeks) iii. Earned Value (EV) $33,333.30 5 weeks for 6 rooms 2 weeks for 2.4 rooms 2 rooms have been made so EV = PV * (2/2.4) iv. Actual Cost (AC) $17,500 Given v. Cost Variance (CV) $15,833.30 EV - AC vi. Schedule Variance (SV) -$6,666.70 EV - PV vii. Cost Performance Index (CPI) 1.905 EV / AC viii. Schedule Performance Index (SPI) 0.833 EV/PC ix. Estimate at Completion (EAC) $52,500 AC + ETC x. Estimate to Complete (ETC) $35,000 (BAC - EV)/CPI xi. Variance at Completion (VAC) $47,500 BAC - EAC xii. 0.808 (BAC - EV)/(BAC - AC) To-Complete Performance Index [TCPI (EAC) b. (4 points) Is the project ahead of or behind schedule? Mark (with an ) only one of the choices shown below. (2 points for the correct schedule choice below + 2 points for the correct explanation = 4 points) Ahead of schedule Behind schedule Neither Explain the schedule status that you selected above: Explanation for project Schedule status Since SV is negative and less than 1, it means the project is behind schedule c. (4 points) Is the project going to be completed over or under budget? Mark (with an) only one of the choices shown below. (2 points for correct budget choice + 2 points for the correct explanation = 4 points) Over budget Under budget Neither Explain the budget status that you selected above: Explanation for project budget status Since CV is positive and is greater than 1, it means that the project will be completed under budget d. (4 points) At the current cost and schedule efficiency, calculate the anticipated Estimate to Complete (ETC) at the end of 3 weeks. (2 points for correct ETC value + 2 point for the correct calculations = 4 points) Anticipated ETC at the end of 3 weeks Calculations