Question: Please help. I would like to know all steps used to solve this problem and what equations were used. Thank you Activity Budget Planned Value

Please help. I would like to know all steps used to solve this problem and what equations were used. Thank you

Please help. I would like to know all steps used

Please help. I would like to know all steps usedPlease help. I would like to know all steps used

Activity Budget Planned Value ($1000) Week A B C DEFGH D E G H I J K 1 2 3 4 5 1 26 35747 5 6 467 27 4 7 8 9 10 11 12 13 14 15 73 287 2 5 3 4 7 7 1 6 7 3 8 7 8513 6 2 9 14 26 17 19 23 26 25 N WN 7 6 37 5 4 17 8 7 24 6 5 11 J K 5 Week 5 Week 6 Activity AC % Complete AC % Complete AC % Complete AC % Complete AC % Complete AC % Complete AC % Complete AC AC A 15 100% 15 100% B 25 100% 25 100% C 10 75% 18 100% Monum D 4 10% 10 20% E 1 10% 6 30% F G H | Note the AC is total to date. 4 Week 1 25% 25% 6 6 Week 2 50% 40% 9 Status Reports 15 Week 3 80% 75% 14 25 4 Week 4 90% 100% 25% 15 25 18 17 14 Week 7 100% 100% % Complete AC % Complete AC % Complete AC % Complete AC 100% 80% 50% 15 25 18 19 20 Week 8 5 100% 100% 100% 100% 70% 10% 15 25 18 19 22 14 1 Week 9 8 100% 100% 100% 100% 85% 40% 30% 40% 15 25 18 19 23 20 8 Week 10 15 100% 100% 100% 100% 100% 55% 70% 60% 15 25 18 19 23 28 21 20 Week 11 % Complete 100% 100% 100% 100% 100% 70% 75% 50% 2. (15 points) The provided Excel file provides two tables for a project. The first gives the planned budget schedule. The second provides weekly status updates for the project. a. For weeks 5 and 11 calculate the EV, SPI and CPI for each activity. b. For weeks 5 and 11 calculate the PV, AC, EV, SPI and CPI for the entire project. C. For week 11 calculate the estimate at Completion (EAC) for total time and total budget

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!