Is a Project Resources management question on Cost Management chapter 7 of PMBOK.

Question 1) The cost budget plan for a project's activities is as follow (the excel file in assignment section): 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. March April $ un S $ $ $ 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 S 9,345 S 8,200 $ 3,200 $ 600 $ 6,400 $ 3,200 $ 4,500 $ 7,200 $ 6,500 $ $ 2,250 $ $ 5,466 S $ 1,200 S S S $ $ $ $ $ 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 ga s lines 1.1.3.3 Install B/K fixtures 1.1.4.1 Install wiring 5 5 5 5 5 s s 5 5 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 PV 9,345 S 8,200 $ 3,800 $ 9,600 S 4.500 5 7,200 S 8,800 5 5,650 $ 8,966 5 5,000 $ 5 EV 9,345 S 8,200 $ 3,800 S 9,500 5 4 500 S 7.2005 8.500 5 5,500 5 8,700 5 4.800 S AC 9.150 8,650 3,950 10,050 4,200 6,800 9,200 5,500 9,100 5.100 2,300 3,400 3,500 3,800 9,260 2,250 5,466 5,422 $ 1,834 $ 2,445 S 3,200 S S S $ s $ S S $ 3,800 S 9,260 $ 2,250 $ 5,466 S 1,200 $ Question 3 April Each Month and Total $ 27,145 s 30,916 $ 42,877 un 21,976 $ 122,914 ETC Revision 1.1.4.2 Install outletsiswitches 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 11.6.2 Install shingles 1.1.6.3 Install ver $ $ $ $ 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. March 9,260 2,250 5,466 5,700 $ 1,834 $ 2,600 $ 3,300 $ $ $ $ 5,800 9,260 2,400 5,600 1200 $ 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 $ S PV 9,345 $ 8,200 $ 3,200 S 6,400 $ EV 9,345 S 7,100 $ 3,800 $ 4,400 $ AC 9,150 7,650 3,950 5,000 S S