Question

Your project to obtain charitable donations is now 43 days into a planned 53-day project. The project is divided into 3 activities. The first activity is designed to solicit individual donations. It is scheduled to run the first 37 days of the project and to bring in $25,900. Even though we are 43 days into the project, we still see that we have only 89% of this activity complete. The second activity relates to company donations and is scheduled to run for 43 days starting on day 6 and extending through day 49. We estimate that even though we should have (37/43) 86% of this activity complete, it is actually only 57% complete. This part of the project was scheduled to bring in $150,900 in donations. The final activity is for matching funds. This activity is scheduled to run the last 10 days of the project and has not started. It is scheduled to bring in an additional $51,800. So far $180,000 has actually been brought in on the project.

Calculate the schedule variance, schedule performance index, cost variance and cost (actually value in this case) performance index. (Negative values should be indicated by a minus sign. Do not round intermediate calculations. Round your dollar amounts to the nearest whole number. Round your "performance index" values to 3 decimal places.)

Schedule variance $ ???????

Schedule performance index ??????

Cost variance $ ??????

Cost performance index ?????

Answer 1

PLEASE LIKE THIS ANSWER, IT HELPS ME A LOT. THANK YOU!!!

+++ Planned Planned Start Start Date Date Expected Planned Revenue Duration 25,900 37 150,900 43 Actual Expected Actual % Rev to %Complete Complete Date 100% 86% 57% 0 Activity Solicit Donations Matching funds 37 89% 6 49 51,800 10 43 53 0% 0% Total 228,600 180,000 Budgeted cost of Work scheduled is explained as below: Solicit 25,900 100% of 25,900 86% of 150,900 0% of 51,800 129,774 Donations Matching funds Total 0 155,674

Budgeted cost of Work projected is explained as below: Solicit 23,051 89% of 25,900 86% of 150,900 0% of 51,800 Donations Matching funds Total 86,013 0 109,064 Schedule Variance (SV)= Earned value - Planned Value 109,064-155,674 = -46,610 Scheduled Performance Index(SPI)=Earned value / Planned Value = $109,064 / 155,674 =0.70

Cost Variance(CV)=Earned value - Actual cost 109,064-180,000 =-70,936 Cost Performance Index(CPI)=Earned value / Actual cost =109,064/180,000 =0.605

Schedule variance -46,610$ Schedule performance index 0.70 Cost variance -70,9368 Cost performance index 0.605