(20 points) Lightner Construction is a general contracting company specializing in the construction of single-family residences and small office buildings. The company is evaluating the performance of one of its project managers who is currently at the conclusion of month 24 of a critical construction project. The planned termination date was at the end of the 28th month. Using the time phased baseline project budget and comparing it against the actual, a time phased earned value table for the project is constructed. 3. Activity Lay foundation Rough plumbing 4 8. 12 16 20 24 28 Total Complete 1000 2000 3000 3000 3000 1000 13000 90% 500 5000 5000 10500 100% Frame 500 1000 1500 100% Finish exterior 800 800 100% Install HVAC Rough electric Sheet rock Install cabinets 400 800 800 2000 100% 400 1000 1400 20% 200 2000 5000 7200 30% 400 4000 4400 10% 1000 2000 3000 20% Paint Final plumbing Final electric Install flooring 500 500 500 500 3500 5500 20% 1000 1000 6000 8000 30% 2000 4000 6000 40% Total Cumulative 2500 5100 6400 Actual Cumulative 12700 10600 9000 Actual At the conclusion of month 24, a. Complete the above table for "total", "Cumulative" and "Cumulative Actual" rows. b. What is the earned value of the project? c. Calculate the schedule and cost performance indexes (SPI and CPI). d. Estimate a completion time and budget (Estimated-Time-to-Completion (ETC) and Estimated-Cost-to-Completion (ECC)) for the project.