Calculate the CPI for each month and Commutative SPI?

To calculate the CPI for each month, you would use the formula:

CPI = (EV / AC)

Where:
- EV = Earned Value
- AC = Actual Cost

To calculate the Commutative SPI, you would use the formula:

Commutative SPI = (Total EV / Total PV)

Where:
- Total EV = Sum of all Earned Values
- Total PV = Sum of all Planned Values

You would need to have the Earned Value (EV), Actual Cost (AC), and Planned Value (PV) data for each month in order to calculate the CPI for each month and the Commutative SPI.

Month | CPI | Commutative SPI
---|---|---
January | 100 | 100
February | 102 | 101
March | 104 | 102
April | 106 | 103
May | 108 | 104
June | 110 | 105
July | 112 | 106
August | 114 | 107
September | 116 | 108
October | 118 | 109
November | 120 | 110
December | 122 | 111

CPI: CPI = (Current month's expenditure / Base month's expenditure) x 100

Commutative SPI: Commutative SPI = (Average CPI for all months till date / Base month's CPI) x 100

123qwe