IWht Caercise Worimheet 2022 Name: bolicalsse Gutman instructions: Usitizing the EVM cheat sheet provided by the instructor, complete the calculationa: formblas and functions to attain your answers. Phase do not simply plug in numbers. This exerci ability to use Excel. Finally, answer the questions below to explain your anwers. Question 1: What do your SV numbers tell you about the project schedule and how? Answer 1: Question 2: What do your Spi numbers teli you about the project schedule and how? Answer.2; n the cells above. You are expecred to fully utilite the cakculation abulies of cicei trroefh se is not oniy to demonstrate your enderstanding of EVM, but alse to demonctate your EVM Exercise Worksheet 2022 Project Duration = Planning on spending per month = Project Budget (BAC)= Percent complete per month= 5 months $300,000.00 $1,500,000.00 20% \% Complete Planned Value (PV) Actual Cost (AC) Earned Value (EV) Schedule Variance (SV) Schedule Performance Index (SPI) Cost Variance (CV) Cost Performance Index (CPI) Estimate at Completion (EAC) Estimate to Complete (ETC) Variance at Completion (VAC) Instructions: Utilizing the EVM cheat sheet provided by the instructor, complete the calculations I formulas and functions to attain your answers. Please do not simply plug in numbers. This exerci ability to use Excel. Finally, answer the questions below to explain your answers. Question 1: What do your SV numbers tell you about the project schedule and how? Answer 1: Question 2: What do your SPI numbers tell you about the project schedule and how? Answer 2: n the cells above. You are expected to fully utilize the calculation abilities of Excel through ise is not only to demonstrate your understanding of EVM, but also to demonstrate your IWht Caercise Worimheet 2022 Name: bolicalsse Gutman instructions: Usitizing the EVM cheat sheet provided by the instructor, complete the calculationa: formblas and functions to attain your answers. Phase do not simply plug in numbers. This exerci ability to use Excel. Finally, answer the questions below to explain your anwers. Question 1: What do your SV numbers tell you about the project schedule and how? Answer 1: Question 2: What do your Spi numbers teli you about the project schedule and how? Answer.2; n the cells above. You are expecred to fully utilite the cakculation abulies of cicei trroefh se is not oniy to demonstrate your enderstanding of EVM, but alse to demonctate your EVM Exercise Worksheet 2022 Project Duration = Planning on spending per month = Project Budget (BAC)= Percent complete per month= 5 months $300,000.00 $1,500,000.00 20% \% Complete Planned Value (PV) Actual Cost (AC) Earned Value (EV) Schedule Variance (SV) Schedule Performance Index (SPI) Cost Variance (CV) Cost Performance Index (CPI) Estimate at Completion (EAC) Estimate to Complete (ETC) Variance at Completion (VAC) Instructions: Utilizing the EVM cheat sheet provided by the instructor, complete the calculations I formulas and functions to attain your answers. Please do not simply plug in numbers. This exerci ability to use Excel. Finally, answer the questions below to explain your answers. Question 1: What do your SV numbers tell you about the project schedule and how? Answer 1: Question 2: What do your SPI numbers tell you about the project schedule and how? Answer 2: n the cells above. You are expected to fully utilize the calculation abilities of Excel through ise is not only to demonstrate your understanding of EVM, but also to demonstrate your
