Assignment 4 (15% due Mar 30, 2023) 1. (7.5 point) Project manager Peter is currently executing a new phone system installation project. The project has a budget of $3, 000 and a duration of 11 months total. Peter just completed the 8th month of the project. The project team has completed 90% of the project work and has spent $2, 900. Summary : Budget:. $3, 000 Duration: months Now:. . 8th month completed Completed: . 90% Total Spent : . . $2, 900 Find the following values: (0. 5 point each) BAC : PV : EV : AC : CV : CPI : SV : SPI : EAC : ETC : VAC : TCPI : Based on the above values, comment on the project status (1.5 point) 2. (7.5 point) Project manager Mary is currently executing a network upgrade project. The project has a budget of $4, 000 and a duration of 4 years total. Mary just completed the 17th month of the project. The project team has completed 35% of the project work and has spent $1, 500. Summary : Budget:. . $4, 000 Duration:. . Years Now:. . 17th month completed Completed:. 35% Total Spent:. . $1, 500 Find the following values: (0. 5 point each) BAC : PV : EV : AC : CV : CPI : SV : SPI : EAC : ETC : VAC : TCPI : Based on the above values, comment on the project status (1.5 point) When calculating the number, round to the tenths place, since we are working with currency Don't worry if your calculations are slightly off, it might just be how you rounded the numbers. The main goal is to understand the formulas and how to calculate them