last 3 screenshots are answers to question 1, i need question 2 completed please.
1. The construction phase of a building project is at the end of its 6 month, while its total duration was estimated to be 12 months. At the beginning of the project, the progress was estimated to be as follows: Month: 1 2 5 7 8 10 11 Scope: 3% 12 10% 12% 13% 13% 10% 9% 6% The following tables show estimations of the trades and material required to complete the project, plus the person hours spent and the material consumed at the end of the bih month: Person- hours Rate (Sthr) Spent 1000 Trade Type Concrete & Masonry Painting & Finishes Glass & Glazing Floor Covering Communications Plumbing Metal Fabrication & Millwork Drywall & Acoustics Electrical Mechanical & HVAC (8) 84 3 12 91 22 500 800 2000 1500 1000 2400 4000 1400 40 50 55 55 90 70 65 70 75 25 59 79 38 Material Concrete, Rebar & Masonry Paint Glass Cable Pipe Wood HVAC Units Mechanical Equipment Price 152 300,000 70,000 27,000 40,000 35,000 25 000 124,000 32.000 Consumed 88 4 6 96 23 61 10 According to the earned value analysis, 48% of the scope is completed at the end of the six months. During the first six months of the project, the price of pipe and paint were escalated by S5250. Further half of the mechanical equipment was purchased at a 20% additional price because of inflation. At the end of the 4th month, a change order was issued and approved, which increased the total plumbing person hours by 10%. The second change order was issued yet to be approved, at the end of the month that could increase the total floor covering workload by 20%. The third change order was issued and approved at the end of the month, which adds an extra $10,000 to the metal fabrication & millwork. The rate of Drywall Acoustics and the price of all materials except pipe and paint will be escalated by 10% after the 6 month Calculate the following items and show them (schematically necessary) on a diagram a. Original BAC b. Updated BAC at the end of the 6 month CBCWS d. BCWP e ACWP f. CV 9 h. SV SPI EAC (Cost) considering the same rate of progress 1 2. Based on all actual numbers at the end of month 6, extrapolate or project to the end of month 7(7h month) what you believe will have been spent or consumed by then and re-calculate all EV values from above. Explain why you believe your new numbers should be credible Planned Schedule 6 11 OLD SON Cum 1 3% 3% 2 4% 7% 3 6% 13% 4 7% 20% 5 10% 30% 12% 42% 7 13% 55% 8 13% 68% 9 10% 78% 10 9% 87% 65 100% 94% Trade Type Concrete & Masonry Painiting and Finishes Glass and Glazing Floor Covering Communications Plumbing Metal Fabrication & Milwork Drywall & Acoustics Electrical Mechanical & HVAC Person-Hours 1000 500 800 2000 1500 1000 2400 4000 1400 Rate ($/hr) 40 50 55 55 90 70 65 70 75 85 Total (5) Total ($) 40,000 25,000 44,000 110,000 135,000 70,000 156,000 280,000 105,000 102,000 1,067,000 Spent (%) Spent (5) 84 33,600 3 750 12 5,280 91 100,100 22 29,700 69 48,300 59 92,040 79 221,200 38 39,900 68 69,360 640,230 1200 88 Material Concrete, Rebar & Masonry Paint Glass Cable Pipe Wood HVAC Units Mechanical Equipment Total ($) Price ($) 300,000 70,000 27,000 40,000 35,000 25,000 124,000 32,000 653,000 Consumed (%) Consumed ($) 264,000 4 2,800 6 1,620 96 38,400 23 8,050 61 15,250 10 12,400 52 16,640 Remarks Material Concrete, Rebar & Masonry Paint & Pipe Glass Budgeted Price (5) 300,000 105,000 27,000 Actual Consumed ($) 264000 16100 1620 Price of Pipe and paint were escalaed by $5250 40,000 38400 Cable Wood HVAC Units Mechanical Equipment Total ($) 25,000 124,000 15250 12400 32,000 653,000 18304 366074 Half of the mechanical equipment was purchased at a 20% additional price Trade Type Total (5) Spent (5) Remarks Add Up Budget by the Budget by the Budget by the end of the end of sth end of 6th month (20%) month (30%) month (42) 3000 1.2000 16800 5000 7500 30500 8800 13200 40000 25000 44000 750 Concrete & Masonry Painting and Finishes Glass and Glazing Floor Covering Communications Plumbing 110000 22000 3.3000 46200 100100 15400 at the end of th month that could increase total covering workload by 20% Not Approved) 135000 ASOO 56700 25400 70000 14000 21000 5600 156000 31200 45800 65520 92040 10000 Metal Fabrication & Milwork Drywall & Acoustics at the end of 4th month total plumbing man hours increased by 30 Approved at the the end of 6th month extra $10000 ads up to the metal and fabrication Drywall Acoustics rate will be escalated by 10 after 6th month 280000 56000 34000 117600 221200 16240 Electrical Mechanical & HVAC 105000 102000 21000 20400 31500 20600 44100 42340 69350 Material Concrete, Rebar & Masonry Paint & Pipe Glass Cable Wood HVAC Units Mechanical Equipment Budgeted Price (5) 300,000 105,000 27,000 40,000 25,000 124,000 32,000 Budget by the Budget by the end of 4th end of sth month (20%) month (30%) 60000 90000 21000 31500 5400 8100 8000 12000 5000 7500 24800 37200 6400 9600 Budget by the end of 6th month (42%) 126000 44100 11340 16800 10500 52080 13440 Actual 10% Extra Consumed Adds Up due (5) to escalation 264000 17400 16100 1620 1566 38400 2320 15250 1450 12400 7192 18304 1856 Total 31784 1 2 3 4 = 1067000+653000 Original BAC = Total Manpower Cost + Total material Cost = $ 1,720,000 Updated BAC at the end of the 6th Month Original Budget 1720000+31784+1000+16240 + Extra Add up $ 1,778,024 BCWS -42% of the Original BAC 42%* $1720000 $ 722,400 BCWP = 48% of the Original BAC 48%* $1720000 $ 825,600 ACWP = Actual Manpower Cost +Actual material Cost = 640230+366074 $ 1,006,304 CV = BCWP-ACWP = 825600 - 1006304 $ (180,704 CPI = BCWP/ACWP = 825600/1006304 0.82 SV = BCWP-BCWS = 825600 - 722400 = $ 103,200 SPI = BCWP/BCWS = 825600/722400 = 1.14 EAC (Cost) considering the same rate of progress = BAC at 1778024-640230- 366074+15400+5600 the end of 6th Month - Already Spent + Extra Addup $ 792,720 5 = = 6 7 8 9 10 1. The construction phase of a building project is at the end of its 6 month, while its total duration was estimated to be 12 months. At the beginning of the project, the progress was estimated to be as follows: Month: 1 2 5 7 8 10 11 Scope: 3% 12 10% 12% 13% 13% 10% 9% 6% The following tables show estimations of the trades and material required to complete the project, plus the person hours spent and the material consumed at the end of the bih month: Person- hours Rate (Sthr) Spent 1000 Trade Type Concrete & Masonry Painting & Finishes Glass & Glazing Floor Covering Communications Plumbing Metal Fabrication & Millwork Drywall & Acoustics Electrical Mechanical & HVAC (8) 84 3 12 91 22 500 800 2000 1500 1000 2400 4000 1400 40 50 55 55 90 70 65 70 75 25 59 79 38 Material Concrete, Rebar & Masonry Paint Glass Cable Pipe Wood HVAC Units Mechanical Equipment Price 152 300,000 70,000 27,000 40,000 35,000 25 000 124,000 32.000 Consumed 88 4 6 96 23 61 10 According to the earned value analysis, 48% of the scope is completed at the end of the six months. During the first six months of the project, the price of pipe and paint were escalated by S5250. Further half of the mechanical equipment was purchased at a 20% additional price because of inflation. At the end of the 4th month, a change order was issued and approved, which increased the total plumbing person hours by 10%. The second change order was issued yet to be approved, at the end of the month that could increase the total floor covering workload by 20%. The third change order was issued and approved at the end of the month, which adds an extra $10,000 to the metal fabrication & millwork. The rate of Drywall Acoustics and the price of all materials except pipe and paint will be escalated by 10% after the 6 month Calculate the following items and show them (schematically necessary) on a diagram a. Original BAC b. Updated BAC at the end of the 6 month CBCWS d. BCWP e ACWP f. CV 9 h. SV SPI EAC (Cost) considering the same rate of progress 1 2. Based on all actual numbers at the end of month 6, extrapolate or project to the end of month 7(7h month) what you believe will have been spent or consumed by then and re-calculate all EV values from above. Explain why you believe your new numbers should be credible Planned Schedule 6 11 OLD SON Cum 1 3% 3% 2 4% 7% 3 6% 13% 4 7% 20% 5 10% 30% 12% 42% 7 13% 55% 8 13% 68% 9 10% 78% 10 9% 87% 65 100% 94% Trade Type Concrete & Masonry Painiting and Finishes Glass and Glazing Floor Covering Communications Plumbing Metal Fabrication & Milwork Drywall & Acoustics Electrical Mechanical & HVAC Person-Hours 1000 500 800 2000 1500 1000 2400 4000 1400 Rate ($/hr) 40 50 55 55 90 70 65 70 75 85 Total (5) Total ($) 40,000 25,000 44,000 110,000 135,000 70,000 156,000 280,000 105,000 102,000 1,067,000 Spent (%) Spent (5) 84 33,600 3 750 12 5,280 91 100,100 22 29,700 69 48,300 59 92,040 79 221,200 38 39,900 68 69,360 640,230 1200 88 Material Concrete, Rebar & Masonry Paint Glass Cable Pipe Wood HVAC Units Mechanical Equipment Total ($) Price ($) 300,000 70,000 27,000 40,000 35,000 25,000 124,000 32,000 653,000 Consumed (%) Consumed ($) 264,000 4 2,800 6 1,620 96 38,400 23 8,050 61 15,250 10 12,400 52 16,640 Remarks Material Concrete, Rebar & Masonry Paint & Pipe Glass Budgeted Price (5) 300,000 105,000 27,000 Actual Consumed ($) 264000 16100 1620 Price of Pipe and paint were escalaed by $5250 40,000 38400 Cable Wood HVAC Units Mechanical Equipment Total ($) 25,000 124,000 15250 12400 32,000 653,000 18304 366074 Half of the mechanical equipment was purchased at a 20% additional price Trade Type Total (5) Spent (5) Remarks Add Up Budget by the Budget by the Budget by the end of the end of sth end of 6th month (20%) month (30%) month (42) 3000 1.2000 16800 5000 7500 30500 8800 13200 40000 25000 44000 750 Concrete & Masonry Painting and Finishes Glass and Glazing Floor Covering Communications Plumbing 110000 22000 3.3000 46200 100100 15400 at the end of th month that could increase total covering workload by 20% Not Approved) 135000 ASOO 56700 25400 70000 14000 21000 5600 156000 31200 45800 65520 92040 10000 Metal Fabrication & Milwork Drywall & Acoustics at the end of 4th month total plumbing man hours increased by 30 Approved at the the end of 6th month extra $10000 ads up to the metal and fabrication Drywall Acoustics rate will be escalated by 10 after 6th month 280000 56000 34000 117600 221200 16240 Electrical Mechanical & HVAC 105000 102000 21000 20400 31500 20600 44100 42340 69350 Material Concrete, Rebar & Masonry Paint & Pipe Glass Cable Wood HVAC Units Mechanical Equipment Budgeted Price (5) 300,000 105,000 27,000 40,000 25,000 124,000 32,000 Budget by the Budget by the end of 4th end of sth month (20%) month (30%) 60000 90000 21000 31500 5400 8100 8000 12000 5000 7500 24800 37200 6400 9600 Budget by the end of 6th month (42%) 126000 44100 11340 16800 10500 52080 13440 Actual 10% Extra Consumed Adds Up due (5) to escalation 264000 17400 16100 1620 1566 38400 2320 15250 1450 12400 7192 18304 1856 Total 31784 1 2 3 4 = 1067000+653000 Original BAC = Total Manpower Cost + Total material Cost = $ 1,720,000 Updated BAC at the end of the 6th Month Original Budget 1720000+31784+1000+16240 + Extra Add up $ 1,778,024 BCWS -42% of the Original BAC 42%* $1720000 $ 722,400 BCWP = 48% of the Original BAC 48%* $1720000 $ 825,600 ACWP = Actual Manpower Cost +Actual material Cost = 640230+366074 $ 1,006,304 CV = BCWP-ACWP = 825600 - 1006304 $ (180,704 CPI = BCWP/ACWP = 825600/1006304 0.82 SV = BCWP-BCWS = 825600 - 722400 = $ 103,200 SPI = BCWP/BCWS = 825600/722400 = 1.14 EAC (Cost) considering the same rate of progress = BAC at 1778024-640230- 366074+15400+5600 the end of 6th Month - Already Spent + Extra Addup $ 792,720 5 = = 6 7 8 9 10