3. (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 28 4 8 1000 2000 500 500 12 3000 5000 0 800 400 16 3000 0 1000 20 3000 0 24 1000 5000 800 Activity Lay foundation Routplumbing Frame Finished Install HVAC Routh electric Sheet rock Install cabinets Paint Yunal plumbing Final sectie Installin Total Cumulative Actual Cumulative 800 400 200 Total 13000 10500 1500 800 2000 1400 7200 4400 3000 5500 8000 6000 1000 5000 % Complete 90% 100% 100% 100% 100% 20% 30% 10% 20% 20% 30% 40% 2000 400 4000 500 500 1000 1000 500 500 1000 2000 2000 3500 6000 4000 2500 5100 12700 6400 10600 9000 0 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