Question: Could you please provide the answer step by step Problem #2 Hint: the calculations and plots for this assignment are easily done in Excel Table


Could you please provide the answer step by step
Problem #2 Hint: the calculations and plots for this assignment are easily done in Excel Table 1 below describes reported project status data in week 8 for the Beta project. The Beta project has a total budget of $460,000 and is expected to be completed in 15 weeks Using the data below create a table that shows A) The BCWS (entire project), BCWP (through week 8), and the ACWP (through week 8) B) The Cost Variance and the Schedule Variance (both through week 8) C) The Schedule Performance Index (SPI) and the Cost Performance index (CPI) (both through week 8) Using the data you calculated for parts A-C above D) On a single set of axes, plot the BCWS, BCWP, and ACWP for the project E) On a single set of axes, plot the SPI and CPI for the project In one or two paragraphs, describe both the current and historic performance of the project in terms of budget and schedule. Reference the two plots you created above in your text description. For example, "Project Beta is currently under budget by $X,000 as evidenced by the ACWP being~SX,000 less then the BCWP for the current week in Figure 1. Historically the project has been....." Also note in your description whether the project budget and schedule performance is getting better, worse, or staying the same Why
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
