Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 WhyStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started