Question

For the following table assume we are at the end of week 7, find the cost and schedule variances. Also find CPI and SPI. Finally, calculate the ETC and EAC for the project. Activity | Predecessors | Duration | Budget. S | Actual Cost. | % Complete | (weeks) 300 600 400 450 540 340 40020 20020 100 100 100 none none 400 b, c
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Please find below the response.

AB CDEFGHIJ Planned completion by Completed by Budget $ 2 Activity 1 23 45 6 3 A 9 Activity week 7 Week 7 100% 100% 100% 100% 100% 100% 300 6 D 600 D-80% by week 7 E-50% by week 7 2300 Solution, Calculations at week 7 PV PV at week 10 Activi Actual cost (AC| Earned val (EV) |SV-EV-PV) | SPI = EV/PV |CV = (EV-AC) | CPI= EV/AC | EAC 0.67 1.11 1.18 0.30 0.40 0.78 300 300 1.00 1.00 1.00 0.25 0.40 0.76 150 600 120 360 120 280 120 -430 16 17 18 1980 1930 There are two methods for calculating EAC, method 1 is when project has one time variance. Method 2 is used when you expect budget to continue with variance. I have used both methods as we do not know if variance will continue or if it is one time 19 2,730.00 S 2,959.33 $800.00 1 EAC actual costs (AC) +budget at completion (BAC)-earned value (EV) 21 EAC budget at completion (BAC) cost performance index (CPI) 3 ETC- estimate at completion (EAC)-actual costs (AC) $ 1,029.33 (Depends which method of EAC is considered)

Formulas

Add a comment
Know the answer?
Add Answer to:
For the following table assume we are at the end of week 7, find the cost...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 14. The following project is at the end of its sixth week. Find the cost and...

    14. The following project is at the end of its sixth week. Find the cost and schedule variances. Also find the CPI. SPI ETC, and EAC for the project. Duration Budget, Actual Cost, $ 400 180 decessors (weeks) Complete 100 100 100 20 20 250 600 400 200

  • please answer in details, thank you The Project below is currently at the end of Week...

    please answer in details, thank you The Project below is currently at the end of Week 6. Use the table below to find the PV, EV, CPI, SPI, and CSI. Use the % Complete column where applicable for these calculations. What conclusions can you make on the project given your calculated CPI, SPI, and CSI values? Activity Predecessors Duration (weeks) Budget, $ $350 $550 $250 $400 $450 $600 Actual Cost, $ $400 $550 $200 $300 $150 А % Complete 100%...

  • PLEASE SHOW ALL CALCULATIONS. PLEASE DRAW A NETWORK DIAGRAM AS WELL. The following project is at...

    PLEASE SHOW ALL CALCULATIONS. PLEASE DRAW A NETWORK DIAGRAM AS WELL. The following project is at the end of its 6th week. Find the cost and schedule variances. Also find the CPI and SPI. Then find the critical ratio of the project using earned value calculations. Finally, calculate the EAC for the project by at least two different methods. Activity Predecessor Duration (wks) Budget      ($) Actual Cost ($) %Complete a - 2 600 400 100 b - 3 150 180...

  • #1. A project in its 26th week has an actual cost of $270,000. It was scheduled...

    #1. A project in its 26th week has an actual cost of $270,000. It was scheduled to have spent $261,000. For the work performed to date, the budgeted value is $272,000. What are the cost and schedule variances for the project? What are the SPI and CPI? What is your assessment of the project from a cost and schedule perspective? #2. A project has just completed the 87th item in its plan. It was scheduled to have spent $168,000 at...

  • 8. For the following test marketing project at week 6: (a) Ignore the far right .%...

    8. For the following test marketing project at week 6: (a) Ignore the far right .% Complete" column and using the 50-50 percent completion rule for PV and EV calculate the cost, schedule, and time variances. Also calculate the CPI, SPI, CSI, and the ETC and EAC (b) Repeat the calculations in a, but now using the ..% Complete" column. Assume that the PV values are based on time propo values for EV are from the workers actually doing the...

  • At week 10 of a project below to improve distance learning platform, assume that the planned...

    At week 10 of a project below to improve distance learning platform, assume that the planned values (PV) are based on time proportionality but the “% Complete” values for earned values (EV) are from the workers actually doing the tasks. ACTIVITY PRE- DECESSORS DURATION (WEEKS) BUDGET ($) ACTUAL COST ($) % COMPLETE A - 5 500 640 100 B A 3 300 400 100 C B 4 320 310 80 D B 6 600 250 60 E C,D 3 300...

  • Question 1: The following data and table illustrate a small project: Activity A was completed on...

    Question 1: The following data and table illustrate a small project: Activity A was completed on schedule • Activity B started as planned but it is expected to take four weeks more Activity C started as planned but finished one week later • %age of completion of activity D is 60% ACWP at the end of week 10 = SR 90400 Activity Original Planned Start Time Original Planned Finish Time Wage Complete Amount Completed BCWP Amount Scheduled BCWS Amount Spent...

  • Earned value calculation Based on the following Project data, answer the questions a and b. Activity...

    Earned value calculation Based on the following Project data, answer the questions a and b. Activity Duration Predecessors Task Budget A 7 days -- $16,850 B 10 days -- $22,500 C 8 days B $16,000 D 10 days A $12,790 E 7 days B $8,500 F 4 days D $10,550 At the end of Day 10, the status of the project is as follows. Activity % Complete Actual Cost A 100% $18,000 B 100% $23,000 C 0% $0 D 10%...

  • Use a PERT network to establish the expected duration for the project described in the table...

    Use a PERT network to establish the expected duration for the project described in the table below:    (SHOW the PERT NETWORK) Activity Predecessors Duration a        m       b Exp. Duration Var. Crash Week 1 Crash Week 2 A - 3 6 9 700 100 B A 6 7 14 600 200 C A 4 6 14 400         600 D B, C 4 6 8 200                             600 E B, C 6 9 12 400 300 F C 4 6 14...

  • Project ABC Scope = 10 chairs @ $10.00 = $100.00 PV = Timeframe = 10 days...

    Project ABC Scope = 10 chairs @ $10.00 = $100.00 PV = Timeframe = 10 days AC = At the End of the 5th day 4 chairs were EV = Completed at a cost of $11.00 each CV = CPI= SV = SPI= CR = To install a 10,000 feet fence at a cost of $10.00/per foot. It is estimated that 500 feet of fence can be installed per week for a total of 20 weeks. After 12 weeks and...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT