Need help with math question
Hi Everyone, I'm having trouble trying to figure out the solution to the following questions. Can someone please be kind enough to post the solutions to solving these? I think the main problem I'm having is that the information is given for activities in the project and not as a whole which is throwing me off.
All the questions are based on the below information.
Activity A is worth $300, is 100% complete, and actually cost $350. Activity B is worth $100, 95% complete, and actually cost $85. Activity C is worth $200, is 75% complete, and has cost $175 so far. The total budget is $1500.
First questions asks What is the estimate to complete for the project? Answer is $1075.39
Second question asks What is the cost variance for the project? Answer is -$65
Third question asks What is the schedule variance for the project? Answer is $-55
Fourth question asks What is the total earned value for the project? Answer is $545
Fifth question asks What is the estimate at completion for the project? Answer is $1685.39
Sixth question asks What is the cost performance index for the project? Answer is 0.89
Seventh question asks What is the variance at completion for the project? Answer is $-185.39
Thank you everyone in advance


pkpmp
Tue, 04/15/2014 - 07:09
Permalink
Problem analysis is as follow
Problem analysis is as follow :
1. PV(A)+PV(B)+PV(C) = 300+100+200 = 600
2. EV(A)+EV(B)+EV(C) = 300+95+150 = 545 (Ans of 4th Q)
3. AC(A)+AC(B)+AC(C) = 350+85+175 = 610
4. BAC =1500
Calculations :
EAC = BAC/CPI = BAC*AC/EV = 1500*610/545 = 1685 (Answer of 5th Q)
ETC = EAC - AC = 1685-610 = 1075 (Answer of 1st Q)
CV=EV-AC=545-610 = - 65 (Answer of 2nd Q)
SV = EV-PV = 545-600 = -55 (Ans of 3rd Q)
CPI = EV/AC = 545/610 = 0.89 (Ans of 6th Q)
VAC = BAC - EAC = 1500-1685 = -185 (Ans of 7th Q)
I hope its clear to you....
h.fazel
Tue, 04/15/2014 - 20:48
Permalink
Thank you!
Thank you very much pkpmp! You're solution is very clear and detailed. I fully understand it now. Thank you once again for your help!
mattR
Wed, 04/16/2014 - 03:32
Permalink
Am I crazy or is 1500*610/545
mattR
Wed, 04/16/2014 - 03:43
Permalink
Wrong math?
Am I crazy, or does 1500 * (610/545) = 1678.90?