Answer:
Schedule variance = $1,105,910
Schedule performance index = 1.066
Cost performance index = 1.168
Explanation:
Note: The requirement of the question is not complete. The complete requirement is therefore provided before answering the question.
Calculate the schedule variance, schedule performance index, and cost performance index for the project to date. (Round your "performance index" values to 3 decimal places.)
The explanation of the answers is now provided as follows:
Budgeted cost of work schedule = Expected cost of first activity + Expected cost of second activity + (Expected cost third activity * Expected percentage of completion) = $1,427,000 + $10,507,000 + ($8,507,000 * 57%) = $16,782,990
Budgeted cost of work performed = Expected cost of first activity + Expected cost of second activity + (Expected cost third activity * Actual percentage completed) = $1,427,000 + $10,507,000 + ($8,507,000 * 70%) = $17,888,900
Actual cost to date = Actual cost of first activity + Actual cost of second activity + Actual amount spent on third activity to date = $1,307,000 + $9,007,000 + $5,007,000 = $15,321,000
Therefore, we have:
Schedule variance = Budgeted cost of work performed - Budgeted cost of work schedule = $17,888,900 - $16,782,990 = $1,105,910
Schedule performance index = Budgeted cost of work performed / Budgeted cost of work schedule = $17,888,900 / $16,782,990 = 1.066
Cost performance index = Budgeted cost of work performed / Actual cost to date = 1.168