Letter Regarding Cassandra Project and Cumulative Data Charts Excel HW

You were asked to conduct an analysis of the Cassandra data (attached). You presented your analysis to the team and you said that the Cassandra project was late and over budget. Here’s what happened during and after the presentation:

The Mayor’s team did not believe you and reported their opinions to the Mayor. Also, the Mayor later heard a lot of rumors, innuendo, and complaints from constituents. Now you have been asked to write a letter to the Mayor making a convincing argument about the true status of the Cassandra project. – To help you make your case, you collected some more data on a previous city project that the team worked on (The Modus Project). The following file contains data on two projects. The first is called the “Modus” project and the second project is called the “Cassandra” project.

1. Use Excel to make both project’s AC,EV,PV, CPI,SPI (cumulative data) charts.

2. Analyzing the charts to prove Cassandra project is late and over budget.

3. Based on the charts and analyzing, write a letter to mayor to prove the Cassandra project is late and over budget.