Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

E connect anment 2 Save & Exit SubmR 10.00 points Problem 5-5 Your project to ob

ID: 385960 • Letter: E

Question

E connect anment 2 Save & Exit SubmR 10.00 points Problem 5-5 Your project to obtain charitable donations is now 30 days into a planned 40-day project. The frst 25 days of the project and to bring in $25,000. Even though we are 30 days into the donations and is scheduled to run for 30 days starting on day 5 and extending through day 35. We estrmate that even project is divided nto 3 actvites. The frst activity s designed to solicit individual donations It is scheduled to run the project, we still see that we have only 90 percent of this activity complete. The second activity relates to conpany o. This part of the project was scheduled to beng in $150000 in donations The faal ectivity is for matching funds. This acthity is scheduled to nun the laet 10 days of brought in on the project the project and has not started. It is scheduled to bring in an additional $50,000. So far $175,000 has actually beer Calculate the schedule varianoe, schedule performance index, cost (actually value in this case) varience, and cost performance index (Negative values should be indicated by a minus sign. Do not ound your intermedlate calculations or "variance" values. Round your "performance index" values to 3 decimal places Schedule performance index Cost variance Cost performance index Difficulty: 3 Challenge Worksheet MacBook Air

Explanation / Answer

Actual value earned in the project (AV) = $175000

The project value for first activity ( PV1)= $25000.

But we are in 30 days of the project and we see that first activity is only 90% completed.

The earned value of 1st activity( EV1) = 90%* $25000= $22500

2nd activity is supposed to bring to bring in $150000. So PV2 = $150000

It is 50% competed on 30th day. So the

Earned value of Activity 2 (EV2) = $150000*50% = $75000

Activity 3 is scheduled to bring in $ 50000

The PV3 = $50000

Since it has not started, the EV of Activity 3 is (EV3) = 0

The total project value = PV1 + PV2 + PV3

The total PV = $25000 + $150000+$50000 = $225000

The Earned value of project on 30th day = EV1 +EV2+EV3

EV = $22500 +$75000= $ 97500

The formula for schedule variance = EV-PV

The schedule variance = $97500-$225000= - $127500( -ve)

The schedule performance index ( SPI) = EV/PV = $97500/$225000= 43.33%

The Cost variance = EV -AV

The Cost variance = $97500-$150000= - $ 52500 ( - ve)

The Cost performance index= EV/ AV

CPI = $97500/$150000= $ 65%