Answer:
Scheduled Variance = $850,000.00
Schedule Performance Index = 1.05
Cost Performance Index = 1.11
Step-by-step explanation:
Note: See the attached excel file for the calculations of Total Actual Cost to Date, Budgeted Cost of Work Scheduled (BCWS), and Budgeted Cost of Work Performed (BCWP).
From the attached excel file, we have:
Total Actual Cost to Date = $15,300,000
Total BCWS = $16,170,000
Total BCWP = $17,020,000
Therefore, we have:
Scheduled Variance = Total BCWP - Total BCWS = $17,020,000 - $16,170,000 = $850,000.00
Schedule Performance Index = Total BCWP / Total BCWS = $17,020,000 / $16,170,000 = 1.05
Cost Variance = Total BCWP - Total actual cost to date = $17,020,000 - $15,300,000 = $1,720,000
Cost Performance Index = Total BCWP / Total actual cost to date = $17,020,000 / $15,300,000 = 1.11
