Question 1) The cost budget plan for a project's activities is as follow the excel file in assignment section): March $ $ 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.1.3.2 Install gas lines 1.1.3.3 Install B/K fixtures 1.1.4.1 Install wiring 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 January February $ 9,345 $ 8,200 $ 3,200 $ 600 $ 6,400 $ 3,200 $ 4,500 $ 7,200 $ 6,500 $ $ 2,250 $ $ 5,466 $ $ 1,200 $ $ $ $ $ $ $ $ 2,300 3,400 3,500 3,800 9,260 2,250 5,466 5,422 $ 1,834 $ 2,445 $ 3,200 $ $ April $ $ $ $ $ $ $ $ $ $ $ $ $ 3,800 $ 9,260 $ 2,250 $ 5,466 $ 1,200 $ BAC 9,345 8,200 3,800 9,600 4,500 7,200 8,800 5,650 8,966 5,000 9,260 2,250 5,466 9,222 11,094 4,695 8,666 1,200 Each Month and Total $ 27,145 $ 30,916 $ 42,877 $ 21,976 $ 122,914 After first month of project execution, the following data is collected. Calculate the CV, SV, CPI, SPI, and then EAC with the fourth formula in page 43 of the DOE tutorial. As of Jan 31 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 $ $ $ $ PV 9,345 $ 8,200 $ 3,200 $ 6,400 $ EV 9,345 $ 7,100 $ 3,800 $ 4,400 $ AC 9,150 7,650 3,950 5,000 Assignment 2 -SYE 6010 Name: Question 2) After second month of project execution, the following data is collected. Calculate the CV, SV, CPI, SPI, and then EAC with the third formula in page 41 of the DOE tutorial. 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.1.3.1 Install waterlines 1.1.3.2 Install gas lines 1.1.3.3 Install B/K fixtures 1.1.4.1 Install wiring $ $ $ $ $ $ $ $ $ $ PV 9,345 $ 8,200 $ 3,800 $ 9,600 $ 4,500 $ 7,200 $ 8,800 $ 5,650 $ 8,966 $ 5,000 $ EV 9,345 $ 8,200 $ 3,800 $ 9,600 $ 4,500 $ 7,200 $ 8,500 $ 5,500 $ 8,700 $ 4,800 $ AC 9,150 8,650 3,950 10,050 4,200 6,800 9,200 5,500 9,100 5,100