can you produce the EVM in MS projects using this data
Individual Project Assignment #1: Earned Value Management Instructions: 1) Project Name: (Use your project from MBA 6382 as a reference. 2) Select a random status date within the project schedule 3) Use MS Project to complete Earned Value Analysis using estimated data. You must use the same columns from the example below: Task Name VAC SPI ned Value. Earned Value. PV (BCws) EV (BCWP) $2,176.00 $1,622.00 AC (ACWP) S $1,872.00 (5554.00 5471.00 $132.00 CV 5250.000 (575.00 AC $2,511.39 $628.00 Kitchen Demolition Remove for BAC $2,176.00 5328.00 Cost 50.00 $335.39 50.00 0.75 0.25 and $160.00 $400.00 $160.00 $400.00 5435.00 $350.00 $0.00 $0.00 $75.00 $0.00 $435.00 S350.00 $350.00 $160.00 $400.00 (575.00) $50.00 $800.00 $400.00 $550.00 $400.00 $150.00 $1,100.00 $800.00 $300.00 0 5 S300.00 0.73 from site $66.00 $66.00 22.00 0.00 S 00 S AR.CO 50.000. 7 50.00 4) Interpret results of indexes Reference Materials: Larson Pg. 465-480; PMBOK 6 Ed. Pg. 261-269 2) Select a random status date within the project schedule 3) Use MS Project to complete Earned Value Analysis using estimated data. You must use the same columns from the example below: AC (ACWP) Svc EAC BACVAC SPI Task Name CPI Planned Value. Earned Value PV (BCWS) EV (OCWP) $2,176.00 $1,622.00 $528.00 $390.00 Fixed Cost $0.00 $100.00 $1,872.00 $471.00 (S554.00)|(5250.00) ($132.00) ($75.00) $2,511.39 $628.00 $2,176.00 $528.00 ($335.39) $100.00) 0.75 0.75 0.87 0.84 Kitchen Demolition Remove floor Remove counter tops/backsplash Remove island Remove wall to living area 1 $360.00 $400.00 $360.00 $400.00 $435.00 $350.00 $0.00 $0.00 $75.00) $50.00 $435.00 $350.00 $360.00 $400.00 ($75.00) 550.001 $75.00 (550.00) 0.83 1.14 $800.00 $400.00 $550.00 15.400.00||150.00 $1,100.00 SB00.00 $300.00) 0.5 $300.00 0.73 S88.00 $66.00 $66.00 $22.00 $0.00 $88.00 SR8.00 $0.00 0.75 50.00 1 4) Interpret results of indexes Individual Project Assignment #1: Earned Value Management Instructions: 1) Project Name: (Use your project from MBA 6382 as a reference. 2) Select a random status date within the project schedule 3) Use MS Project to complete Earned Value Analysis using estimated data. You must use the same columns from the example below: Task Name VAC SPI ned Value. Earned Value. PV (BCws) EV (BCWP) $2,176.00 $1,622.00 AC (ACWP) S $1,872.00 (5554.00 5471.00 $132.00 CV 5250.000 (575.00 AC $2,511.39 $628.00 Kitchen Demolition Remove for BAC $2,176.00 5328.00 Cost 50.00 $335.39 50.00 0.75 0.25 and $160.00 $400.00 $160.00 $400.00 5435.00 $350.00 $0.00 $0.00 $75.00 $0.00 $435.00 S350.00 $350.00 $160.00 $400.00 (575.00) $50.00 $800.00 $400.00 $550.00 $400.00 $150.00 $1,100.00 $800.00 $300.00 0 5 S300.00 0.73 from site $66.00 $66.00 22.00 0.00 S 00 S AR.CO 50.000. 7 50.00 4) Interpret results of indexes Reference Materials: Larson Pg. 465-480; PMBOK 6 Ed. Pg. 261-269 2) Select a random status date within the project schedule 3) Use MS Project to complete Earned Value Analysis using estimated data. You must use the same columns from the example below: AC (ACWP) Svc EAC BACVAC SPI Task Name CPI Planned Value. Earned Value PV (BCWS) EV (OCWP) $2,176.00 $1,622.00 $528.00 $390.00 Fixed Cost $0.00 $100.00 $1,872.00 $471.00 (S554.00)|(5250.00) ($132.00) ($75.00) $2,511.39 $628.00 $2,176.00 $528.00 ($335.39) $100.00) 0.75 0.75 0.87 0.84 Kitchen Demolition Remove floor Remove counter tops/backsplash Remove island Remove wall to living area 1 $360.00 $400.00 $360.00 $400.00 $435.00 $350.00 $0.00 $0.00 $75.00) $50.00 $435.00 $350.00 $360.00 $400.00 ($75.00) 550.001 $75.00 (550.00) 0.83 1.14 $800.00 $400.00 $550.00 15.400.00||150.00 $1,100.00 SB00.00 $300.00) 0.5 $300.00 0.73 S88.00 $66.00 $66.00 $22.00 $0.00 $88.00 SR8.00 $0.00 0.75 50.00 1 4) Interpret results of indexes