ATTENTION: I ONLY NEED HELP WITH QUESTION #3. I HAVE PROVIDED QUESTIONS 1 AND 2 FOR CONTEXT, BUT I ONLY NEED HELP WITH QUESTION #3 SO PLEASE ONLY PROVIDE THE ANSWER FOR #3. THANK YOU!

ATTENTION: I ONLY NEED HELP WITH QUESTION #3. I HAVE PROVIDED QUESTIONS 1 AND 2 FOR CONTEXT, BUT I ONLY NEED HELP WITH QUESTION #3 SO PLEASE ONLY PROVIDE THE ANSWER FOR #3. THANK YOU!

March April $ $ Question 1) The cost budget plan for a project's activities is as follow (the excel file in assignment section): (Green Table) What is the Bac? 4,500 Activity 1.1 1.1 Pour foundation 1.1.1.2 Install Patio 1.1 1.3 Pour stairway 1.1.2.1 Frame exterior walls 1.1.2.2 Frame interior walls 1.1.2.3 Install roofing trusse 1.1.3.1 Install waterlines 1.13.2 Installas lines 1.13.3 Install / fixtures 1.1.4.1 Install wiring 1.14.2 Install outlets/switches 1.1.4.3 Install fixtures 1.1 5.1 Install drywall 1.1.5.2 Install Carpeting 1.15.3 Painting 1.16.1 Installfelt 1.1.6.2 Install shingles 1.16.3 Installvents January February 5 5 9.345 $ 8,200 5 3.2005 600 $ 6,400 5 3,200 $ S $ 7.200 $ 6,500 $ $ 2.250 5 S 5,456 5 s s 1,200 $ 5 $ $ $ $ 5 $ BAC 9,345 8,200 3.800 9,600 4,500 7,200 8,800 5,650 8,965 5,000 9.260 TUTTI 2.250 2,300 3,400 3,500 3,800 9,260 2.250 5.466 5,422 1,834 $ 2.4455 3,200 $ $ After first month of project execution, the following data is collected. (Blue Table) Calculate the CV, SV, CPI, SPI for the 1 month and also for each activity? Then calculate EAC (cost) for the project with the fourth formula in page 43 of the DOE tutorial 3,800 $ 9,260 2,250 $ 5,466 1,200 $ 5,466 9,222 11,094 4,695 8,666 1,200 Each Month and Total $ $ 27,145 $30,916 $ S 42,877 $ 21,976 122,914 $ Question 2) After second month of project execution, the following data is collected. (Gray Table) As of Jan 31 1.1.1.1 Pour foundation 1.11.2 Install Patio 1.1.1.3 Pour stairway 1.1.2.1 Frame exterior walls PV 9,345 $ 8,200 $ 3,200 $ 6,400 $ $ 5 $ EV 9,845 $ 5,000 $ 3,000 $ 5,400 $ AC 8,500 7,500 4,000 5,000 Calculate the CV, SV, CPI, SPI for the 60days performance and also for each activity? Then calculate EAC (cost) for the project with the third formula in page 41 of the DOE tutorial Chr As of Feb 29 1.1.1.1 Pour foundation 1.1 1.2 Install Patio 1.1.1.3 Pour stairway 1.1.2.1 Frame exterior walls 1.1 2.2 Frame interior walls 1.1.2.3 Install roofing trusse 1.13.1 Install waterlines 1.1.3.2 Install gas lines 1.13.3 Install B/K fixtures 1.1.4.1 Install wiring $ 5 $ $ $ 5 $ 5 $ $ $ PV 9,245$ 8.2005 2,800 $ 9,600 $ 4,500 $ 7,200 $ 6.500 5 5 2,250 $ 5,466 1,200 $ EV 9,345 $ 8.2005 3,800 $ 9,600 $ 4,000 $ 7,000 $ 7,800 5 5,650 $ 5,000 $ 1,000 $ AC 8,500 9,000 5,000 10,000 4,200 7,000 8,600 6,000 5.100 1,100 Question 3) Assume that instead of using ratios or CPI, at the end of Feb, you want to review and revise the planned cost of March and April and update it and then calculate (ETC) with bottom up method. (method 1 in DOE) You talk with contractors and find the three activity 'cost estimates' need to change to new values as shown by (RED font). What is your EaC of project now? REVISED Planned Values 1.1.4.2 Install outlets/switches 1.1.4.3 Install fixtures 1.1.5.1 Install drywall 1.1.5.2 Install Carpeting 1.1.5.3 Painting 1.1.6.1 Install felt 1.1.6.2 Install shingles 1.1.6.3 Install vents nnnnn March April 9,260 2,250 $ 10,000 5,422 $ 3,800 3,000 $ 18,000 2,445 $ 2.250 2,500 $ 4,000 $ 1,200 March April $ $ Question 1) The cost budget plan for a project's activities is as follow (the excel file in assignment section): (Green Table) What is the Bac? 4,500 Activity 1.1 1.1 Pour foundation 1.1.1.2 Install Patio 1.1 1.3 Pour stairway 1.1.2.1 Frame exterior walls 1.1.2.2 Frame interior walls 1.1.2.3 Install roofing trusse 1.1.3.1 Install waterlines 1.13.2 Installas lines 1.13.3 Install / fixtures 1.1.4.1 Install wiring 1.14.2 Install outlets/switches 1.1.4.3 Install fixtures 1.1 5.1 Install drywall 1.1.5.2 Install Carpeting 1.15.3 Painting 1.16.1 Installfelt 1.1.6.2 Install shingles 1.16.3 Installvents January February 5 5 9.345 $ 8,200 5 3.2005 600 $ 6,400 5 3,200 $ S $ 7.200 $ 6,500 $ $ 2.250 5 S 5,456 5 s s 1,200 $ 5 $ $ $ $ 5 $ BAC 9,345 8,200 3.800 9,600 4,500 7,200 8,800 5,650 8,965 5,000 9.260 TUTTI 2.250 2,300 3,400 3,500 3,800 9,260 2.250 5.466 5,422 1,834 $ 2.4455 3,200 $ $ After first month of project execution, the following data is collected. (Blue Table) Calculate the CV, SV, CPI, SPI for the 1 month and also for each activity? Then calculate EAC (cost) for the project with the fourth formula in page 43 of the DOE tutorial 3,800 $ 9,260 2,250 $ 5,466 1,200 $ 5,466 9,222 11,094 4,695 8,666 1,200 Each Month and Total $ $ 27,145 $30,916 $ S 42,877 $ 21,976 122,914 $ Question 2) After second month of project execution, the following data is collected. (Gray Table) As of Jan 31 1.1.1.1 Pour foundation 1.11.2 Install Patio 1.1.1.3 Pour stairway 1.1.2.1 Frame exterior walls PV 9,345 $ 8,200 $ 3,200 $ 6,400 $ $ 5 $ EV 9,845 $ 5,000 $ 3,000 $ 5,400 $ AC 8,500 7,500 4,000 5,000 Calculate the CV, SV, CPI, SPI for the 60days performance and also for each activity? Then calculate EAC (cost) for the project with the third formula in page 41 of the DOE tutorial Chr As of Feb 29 1.1.1.1 Pour foundation 1.1 1.2 Install Patio 1.1.1.3 Pour stairway 1.1.2.1 Frame exterior walls 1.1 2.2 Frame interior walls 1.1.2.3 Install roofing trusse 1.13.1 Install waterlines 1.1.3.2 Install gas lines 1.13.3 Install B/K fixtures 1.1.4.1 Install wiring $ 5 $ $ $ 5 $ 5 $ $ $ PV 9,245$ 8.2005 2,800 $ 9,600 $ 4,500 $ 7,200 $ 6.500 5 5 2,250 $ 5,466 1,200 $ EV 9,345 $ 8.2005 3,800 $ 9,600 $ 4,000 $ 7,000 $ 7,800 5 5,650 $ 5,000 $ 1,000 $ AC 8,500 9,000 5,000 10,000 4,200 7,000 8,600 6,000 5.100 1,100 Question 3) Assume that instead of using ratios or CPI, at the end of Feb, you want to review and revise the planned cost of March and April and update it and then calculate (ETC) with bottom up method. (method 1 in DOE) You talk with contractors and find the three activity 'cost estimates' need to change to new values as shown by (RED font). What is your EaC of project now? REVISED Planned Values 1.1.4.2 Install outlets/switches 1.1.4.3 Install fixtures 1.1.5.1 Install drywall 1.1.5.2 Install Carpeting 1.1.5.3 Painting 1.1.6.1 Install felt 1.1.6.2 Install shingles 1.1.6.3 Install vents nnnnn March April 9,260 2,250 $ 10,000 5,422 $ 3,800 3,000 $ 18,000 2,445 $ 2.250 2,500 $ 4,000 $ 1,200