Can someone please help me? I've been asking for two days.

A B C D E F G H K L 1) Check your Topic 3 Baseline is set correctly 2) Utilize the status update function and update ALL Intitation and Planning tasks to be 100% complete and per Schedule 3) Update the Execution tasks with the Actuals in next tab 4) Revise the Project Manager and Software Engineer labor rates to fix prior accounting errors 5) Add Baseline Duration and Baseline Cost columns to Gannt View 1 6) Analyze the Project Overview Report, Cost Overview Report , and Earned Value Report. : 7) Add CPI, SPI, TCPI columns to the Earned Value table and save with the reports. 5 8) Write a progress report to your Sponsor ( 2 pages in Business Memo format) add relevant tables and graphs.You are a project manager on a project that uses earned yalue management. The project has the following budget and status: Project Duration (months): 14 Cu rreht Reporting Period (month): 9t. ofthe project completed through the reporting period:19% Estimate to Complete: $294.6? Part 1: Based on this information, determine the following: . Cumulative EV Schedule Variance (SW Schedule Performance Index (SPI) Cost Variance (CV1 Cost Performance Index (CPI) EAC [bottomu p) VAC {bottomup] TCPI WHP'WPWN\" Based on your calculations above. respond to the following: 1 . What is the status of project accomplishment performance through the current reporting period? Why? 2. What is the status of project cost performance through the current reporting period? Why? 3. Is the project projected to complete overbudget or underbudget? Why? 4. Interpret the TCPI metric. Part 2: Based on your calculations above. an inexperienced and arrogant project analyst from the project management ofce has computed an additional metric: Cost Schedule Index, which equals SPI * lCPI. He wants you to report this metric to the customer, instead of SPI ancl CPI separately. What should you do and why? The program manager doubts your numbers. In particular, he does not believe your EAC number and requests that you calculate the EAC not assuming future performance will behave like past performance. Part 3: You are having a hallway conversation with the same project analyst who is now realizing that he may not know as much about earned value management as he thought when he joined the company. Still, he is convinced that the following statements below are correct. How would you respond to him based on each statement (i.e., formulate a specific response and supporting rationale for each statement below)? 1. EAC becomes Cumulative AC at project completion. 2. Cumulative EV can be greater than BAC at project completion. 3. EAC can be smaller than BAC at project completion. 4. ETC can be greater than 0 at project completion. Submit an MS Excel file showing your completed calculations and including your responses to the indicated questions. Ensuring that your last name is included in the filename.DoI A B F G H Predecessor(s) ID Task Actual Duration (days) (ID) Resource Assignments 49 Load software onto pilot machines 3 45,46,48,43 Software Engineer 51 50 Validate functionality 49 Software Test Engineer 32 51 Deployment 53 52 Configure production hardware 23 26,50,67,63 Hardware Technician 54 53 Deploy production hardware 17 52 Hardware Technician 55 54 Load software to deployed hardware 23 53 Software Engineer 55 Testing 56 Validate startup on deployed hardware 54 Software Test Engineer 58 57 Perform OS testing 56 Software Test Engineer 19 58 Perform application testing 57 Systems Test Engineer 60 59 Obtain formal sign-off from users 18 58 Project Manager 31 32F14 X V A B C D E F G H K M N Project Manager Work P 100% $65.00/hr $0.00/hr $0.00 Prorated Standard Note: PM rates are $85/hr Project Analyst Work P 100% $35.00/hr $0.00/hr $0.00 Prorated Standard Senior Hardware Engineer Work S 100% $55.00/hr $0.00/hr $0.00 Prorated Standard Hardware Engineer Work H 100% $45.00/hr $0.00/hr $0.00 Prorated Standard Hardware Technician Work H 100% $35.00/hr $0.00/hr $0.00 Prorated Standard Requirements Analyst Work 100% $35.00/hr $0.00/hr $0.00 Prorated Standard Senior Software Engineer Work 100% $55.00/hr $0.00/hr $0.00 Prorated Standard Software Engineer Work 100% $45.00/hr $0.00/hr $0.00 Prorated Standard Note: Software engineer rates are $65/hr 10 Software Test Engineer Work 100% $45.00/hr $0.00/hr $0.00 Prorated Standard 11 Senior Systems Test Enginee Work 100% $55.00/hr $0.00/hr $0.00 Prorated Standard 12 Systems Test Engineer Work 100% $40.00/hr $0.00/hr $0.00 Prorated Standard 13 Contracts Analyst Work 100% $30.00/hr $0.00/hr $0.00 Prorated Standard 14 15 16View Themes Insert Report Page Setup PROJECT OVERVIEW COMPLETE Status for all top-level tasks. To see the status for subtasks, click on the chart and update the outline level in the Field List. 100% MON 1/4/16 - FRI 12/23/16 90% 80%% % COMPLETE 70% 60%% 0% 50% 40%% 30%% 20% MILESTONES DUE 10% Milestones that are coming soon. 0% PROJECT OVERVIEW Name Finish TECHNOLOGY REFRESH PROJECT LATE TASKS Tasks that are past due. Name Start Finish Duration % Complete Resource Names Meet with key Mon 1/4/16 Tue 1/5/16 2 days Project stakeholders Manager Report Tools MGT 640 Topic 3 Project Schedule SOLUTION.mpp - Project Professional File Task Resource Report Project View Design Tell me what you want to do. Aa Colors A Fonts Gantt Recent Themes Effects . Images Shapes Chart Table Text Manage Copy Page Margins Orientation Size Chart Box Report Breaks View Themes Insert Report Page Setup PROGRESS VERSUS COST COST OVERVIEW Progress made versus the cost spent over time. If % Complete line below the cumulative cost line, your project may be over budget. MON 1/4/16 - FRI 12/23/16 1% $200,000.00 COST 19% $150,000.00 16 MULATIVE COST COMPLETE $100,000.00 $166 000 00 Directions Execution Actual Durations Revised resource rates Reports +