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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!