Next, for the same ten week projectwith four different work packages and a total cost, or budget-at-completion (BAC) of $170,000, complete an earned value management (EMV) analysis at the end of week six for Project-Y.pdf execution of the project using the Earned-Value-Management.xlsx template. Determine the (a) estimated-at-completion or EAC, (b) estimated-time-to-complete or ETC, and (c) discuss the Project Y execution of the project, i.e., what is happening.

Work Package A Work Package B Work Package C Work Package D Total for Week, or Planned Value (Pv Planned Value (PV) Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Total for Work Package 10.000 15.000 5.000 30,000 10,000 10,000 10,000 20,000 10,000 10,000 70.000 1 5,000 5,000 25.000 5.000 40,000 5.000 5.000 20.000 30.000 10,000 25,000 15,000 10,000 25,000 15,000 35,000 10,000 5,000 20,000 $170,000 Cumulative Percentage of Planned Work Complete Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Work Package A Hours Worked 240 535 300 Work Package B Hours Worked 45 45 6 0 60 220 220 475 475 200 200 220 Work Package C Hours Worked 125 160 1600 110 Work Package D Hours Worked 110 120 480 Total Hours Worked for Week 240 580 360 220 600 3 60 820 220 120 480 Cumulative Total Hours Worked for Week 240 820 1,180 1,400 2,000 2,360 3,180 3,400 3,520 4,000 Cumulative Percent of Planned Work Completed 6% 20.5% 29.5% 35% 50% 59% 79.5% 85% 88% 100% Project Y's Actual Cost (AC) Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Work Package A 10,000 16,000 8,000 Work Package B 10,000 10,000 12.000 24,000 12.000 Work Package C 5.000 5.000 Work Package D Total for Week, or Actual Cost (AC) 10,000 26,000 18,000 12,000 29,000 17,000 Project Y's Cumulative Percentage of Actual Work Complete Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Work Package A Hours Worked 160 340 100 Work Package B Hours Worked 2001200240500240 Work Package C Hours Worked 100 120 Work Package D Hours Worked Total Hours Worked for Week 160540300240600360 Cumulative Total Hours Worked for Week 160 7 00 1,000 1,240 1,840 2,200 Cumulative Percent of Actual Work Completed 4% 17.5% 25% 31% 46.% 55% Period Period 2 Period 3 Period 4 Period 5 Period 6 Budget at Completion (BAC) Planned Time to Complete Planned Value (PV) Cumulative Planned Value (PV) Actual Cost (AC) Cumulative Actual Cost (AC) % Actual Work Complete % Planned Work Complete Rate of Performance (RP) Earned Value (EV) - PVRP Cost Variance (CV) - EVAC Schedule Variance (SV) - EV-PV Cost Perf Indicator (CPI - EVIAC Schedule Pertind (SPN EVIPY Estimate at Completion (EAC) Estimated Time to Complete