Your project to obtain charitable donations is now 41 days into a planned 51-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 34 days of the project and to bring in $25,700. Even though we are 41 days into the project, we still see that we have only 90% of this activity complete. The second activity relates to company donations and is scheduled to run for 41 days starting on day 7 and extending through day 48. We estimate that, even though we should have (34/41) 82.93% of this activity complete, it is actually only 54% complete. This part of the project was scheduled to bring in $150,700 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,400. So far $178,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

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

Your project to obtain charitable donations is now 41 days into a planned 51-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 34 days of the project and to bring in $25,700. Even though we are 41 days into the project, we still see that we have only 90% of this activity complete. The second activity relates to company donations and is scheduled to run for 41 days starting on day 7 and extending through day 48. We estimate that, even though we should have (34/41) 82.93% of this activity complete, it is actually only 54% complete. This part of the project was scheduled to bring in $150,700 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,400. So far $178,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.)