The table below provides budgeted cost, duration, % completion and actual cost at day 25 for a sewer and water line project. Actual Cost Activity Number Budgeted Cost at Completion Description Duration Completion at day 25 at day 25 10 MOBILIZE 1400 100% 1300 SURVEY SEWER LINE 20 2700 4 100% 2700 30 EXCAVATE MH 3500 100% 3350 INSTALL MH FORMWORK 40 6000 100% PLACE CONC MH 50 4700 3200 TRENCH SEWER LINE 60 12600 10 50% 6300 STRIP MH FORMWORK 70 2100 50% 900 80 LAY SEWER PIPE 11250 15 50% 6000 90 INSPECT MH 800 40% 3500 REMOVE TRENCHING EQ 100 1400 20% 300 BACKFILL SEWER TRENCH 110 3600 10% 200 SEWER LINE COMPLETE 120 0 0 SURVEY WATER 130 4000 5% 250 LINE A SURVEY WATER LINE A 130 4000 5% 250 SURVEY WATER LINE B 140 5% 200 UNDERGROUND ELECT 150 2500 DRILL WATER WELL 160 12 TRENCH WATER 170 8800 LINE A LAY PIPE WATER LINE A 180 16800 TRENCH WATER 190 15600 16 LINE B BACKFILL WATER LINE A 200 LAY PIPE WATER LINE B 210 33600 BACKFILL WATER LINE B 220 2850 INSTALL WATER METERS 230 240 SET WATER 1400 PUMP PROJECT COMPLETE 250 0 Total Project Budget: $147,500, completed in 94 days, At 25 days: BCWS-$31,740; Given the information above, determine the (a) CPl, (b) SPI, (c) estimated cost to compete (ECTC), and (d) estimated cost at completion (ETAC) of this project at 25 days. (e) Does the EV analysis suggest a cost overrun or underrun at day 25 and at completion? By how much? (f) Is the project proceeding on schedule, ahead of schedule, or behind schedule? Show your work (calculations) in the excel template uploaded on CANVAS and clearly indicate your answer to each question above. Turn in the excel file. Note: Estimated cost to complete (ECTC) represents the remaining cost to complete the project based on the current cost performance-(BCAC - BCWP) CPI Estimated cost at completion (ECAC) - ACWP ECTC The table below provides budgeted cost, duration, % completion and actual cost at day 25 for a sewer and water line project. Actual Cost Activity Number Budgeted Cost at Completion Description Duration Completion at day 25 at day 25 10 MOBILIZE 1400 100% 1300 SURVEY SEWER LINE 20 2700 4 100% 2700 30 EXCAVATE MH 3500 100% 3350 INSTALL MH FORMWORK 40 6000 100% PLACE CONC MH 50 4700 3200 TRENCH SEWER LINE 60 12600 10 50% 6300 STRIP MH FORMWORK 70 2100 50% 900 80 LAY SEWER PIPE 11250 15 50% 6000 90 INSPECT MH 800 40% 3500 REMOVE TRENCHING EQ 100 1400 20% 300 BACKFILL SEWER TRENCH 110 3600 10% 200 SEWER LINE COMPLETE 120 0 0 SURVEY WATER 130 4000 5% 250 LINE A SURVEY WATER LINE A 130 4000 5% 250 SURVEY WATER LINE B 140 5% 200 UNDERGROUND ELECT 150 2500 DRILL WATER WELL 160 12 TRENCH WATER 170 8800 LINE A LAY PIPE WATER LINE A 180 16800 TRENCH WATER 190 15600 16 LINE B BACKFILL WATER LINE A 200 LAY PIPE WATER LINE B 210 33600 BACKFILL WATER LINE B 220 2850 INSTALL WATER METERS 230 240 SET WATER 1400 PUMP PROJECT COMPLETE 250 0 Total Project Budget: $147,500, completed in 94 days, At 25 days: BCWS-$31,740; Given the information above, determine the (a) CPl, (b) SPI, (c) estimated cost to compete (ECTC), and (d) estimated cost at completion (ETAC) of this project at 25 days. (e) Does the EV analysis suggest a cost overrun or underrun at day 25 and at completion? By how much? (f) Is the project proceeding on schedule, ahead of schedule, or behind schedule? Show your work (calculations) in the excel template uploaded on CANVAS and clearly indicate your answer to each question above. Turn in the excel file. Note: Estimated cost to complete (ECTC) represents the remaining cost to complete the project based on the current cost performance-(BCAC - BCWP) CPI Estimated cost at completion (ECAC) - ACWP ECTC