Hello, I just need help understanding how these solutions in the chart were done through excel for clarification. Below I posted the question along with the excel chart answers for guidance. Would someone be able to replicate the exact same chart but demonstrate the excel formulas for each cell to show how each cell came to an answer? I will leave a thumbs up!
QUESTION:
THE QUESTIONS BEING ASKED:
20. For the first status report, the CV for project is approximately:
a. 3,000
b. 3,000
c. 2,000
d. 2,000
e. None of the above
21. For the first status report, the CPI for project is approximately:
a. 1.00
b. 0.90
c. 1.11
d. 0.75
e. 1.20
22. For the first status report, the EAC for project is approximately;
a. $40,000
b. $45,000
c. $48,000
d. $53,000
e. None of the above
23. For the second status report, the EAC for project is approximately;
a. $40,000
b. $45,000
c. $48,000
d. $53,000
e. None of the above
24. For the third status report, the EAC for project is approximately;
a. $40,000
b. $45,000
c. $48,000
d. $53,000
e. None of the above
25. For the first status report, the SPI for project is?
a. 1.00
b. 0.90
c. 1.11
d. 0.75
e. 1.20
26. For the second status report, the SPI for project is?
a. 1.00
b. 0.83
c. 0.84
d. 0.87
e. 1.20
27. For the second status report, the CPI for project is?
a. 1.00
b. 0.83
c. 0.84
d. 0.87
e. 1.20
28. For the third status report, the SPI for project is?
a. 1.00
b. 0.83
c. 0.84
d. 0.87
e. 1.20
29. For the third status report, the CPI for project is?
a. 1.00
b. 0.83
c. 0.84
d. 0.87
e. 0.89
ANSWERS IN EXCEL CHART:
Just need a replica image of this ^ but with the formulas for each cell, please and thank you!
You are managing a small software development project with 10 modules. The project has 3 deliverables, Design, Code, and Test that are done sequentially with no overlap and each deliverable takes 10 days. The table below describes each of the deliverables: Deliverable Design Complete Code Complete Test Complete Total Quantity 10 10 50 Project Budget Rate Duration 1/day 10 1/day 10 5/day 10 30 Cost $ 10,000 $ 20,000 $ 10,000 $ 40,000 Design and Code are measured by the modules completed and Test is measured by test cases completed (of which there are 50 test cases). There is no learning curve on this project. The Project Sponsor has asked you to provide a status report every 10 days using Earned Value. Specifically, the Project Sponsor wants the CPI, SPI, and EAC for the project included in each status report. Status Report 1 10 days into the project, the design team has almost completed the 10 modules. The results are: Deliverable Design Complete Code Complete Test Complete Total After 10 days Quantity Cost 9 $ 10,000 0 $ 1,000 0 $ 1,000 $ 12,000 Status Report 2 20 days into the project, the design team is complete, but coding has fallen behind due to some technical problems. The results are: After 20 days Deliverable Quantity Cost Design Complete 10 $ 12,000 Code Complete 8 $ 18,000 Test Complete 0 $ 1,000 Total $ 31,000 Status Report 3 30 days into the project, the test team came through, thanks to overtime, and the project is done on time. The results are: After 30 days Deliverable Quantity Cost Design Complete 10 $ 13,000 Code Complete 10 $ 19,000 Test Complete 50 $ 13,000 Total $ 45,000 Questions 20 to 29 Deliverable CPI SPI ETC EAC 0.90 Design Complete Code Complete Test Complete Total 0.90 $ 1,111 $ 11,111 $ 20,000 $ 21,000 $ 10,000 $ 11,000 0.90 41,333 $ 53,333 0.75 PV EV AC SV After 10 days $ 10,000 $ 9,000 $ 10,000-$ 1,000-$ 1,000 $ $ $ 1,000-$ 1,000 $ $ $ $ 1,000-$ 1,000 $ $ 10,000 $ 9,000 $ 12,000 - $ 3,000 $ 1,000 After 20 days $ 10,000 $10,000 $ 12,000-$ 2,000 $ $ 20,000 $ 16,000 $ 18,000-$ 2,000-$ 4,000 $ $ $ 1,000 - $ 1,000 $ $ 30,000 $ 26,000 $ 31,000-$ 5,000-$ 4,000 After 30 days $ 10,000 $10,000 $ 13,000-$ 3,000 $ $ 20,000 $ 20,000 $ 19,000 $1,000 $ $ 10,000 $10,000 $ 13,000 - $ 3,000 $ $ 40,000 $ 40,000 $ 45,000-$ 5,000 $ Design Complete Code Complete Test Complete Total 0.83 0.89 1.00 $ $ 12,000 0.80 $ 4,500 $ 22,500 $ 10,000 $ 11,000 0.87 16,692 $ 47,692 0.84 Design Complete Code Complete Test Complete Total 0.77 1.05 0.77 0.89 1.00 1.00 1.00 1.00 $ 45,000 You are managing a small software development project with 10 modules. The project has 3 deliverables, Design, Code, and Test that are done sequentially with no overlap and each deliverable takes 10 days. The table below describes each of the deliverables: Deliverable Design Complete Code Complete Test Complete Total Quantity 10 10 50 Project Budget Rate Duration 1/day 10 1/day 10 5/day 10 30 Cost $ 10,000 $ 20,000 $ 10,000 $ 40,000 Design and Code are measured by the modules completed and Test is measured by test cases completed (of which there are 50 test cases). There is no learning curve on this project. The Project Sponsor has asked you to provide a status report every 10 days using Earned Value. Specifically, the Project Sponsor wants the CPI, SPI, and EAC for the project included in each status report. Status Report 1 10 days into the project, the design team has almost completed the 10 modules. The results are: Deliverable Design Complete Code Complete Test Complete Total After 10 days Quantity Cost 9 $ 10,000 0 $ 1,000 0 $ 1,000 $ 12,000 Status Report 2 20 days into the project, the design team is complete, but coding has fallen behind due to some technical problems. The results are: After 20 days Deliverable Quantity Cost Design Complete 10 $ 12,000 Code Complete 8 $ 18,000 Test Complete 0 $ 1,000 Total $ 31,000 Status Report 3 30 days into the project, the test team came through, thanks to overtime, and the project is done on time. The results are: After 30 days Deliverable Quantity Cost Design Complete 10 $ 13,000 Code Complete 10 $ 19,000 Test Complete 50 $ 13,000 Total $ 45,000 Questions 20 to 29 Deliverable CPI SPI ETC EAC 0.90 Design Complete Code Complete Test Complete Total 0.90 $ 1,111 $ 11,111 $ 20,000 $ 21,000 $ 10,000 $ 11,000 0.90 41,333 $ 53,333 0.75 PV EV AC SV After 10 days $ 10,000 $ 9,000 $ 10,000-$ 1,000-$ 1,000 $ $ $ 1,000-$ 1,000 $ $ $ $ 1,000-$ 1,000 $ $ 10,000 $ 9,000 $ 12,000 - $ 3,000 $ 1,000 After 20 days $ 10,000 $10,000 $ 12,000-$ 2,000 $ $ 20,000 $ 16,000 $ 18,000-$ 2,000-$ 4,000 $ $ $ 1,000 - $ 1,000 $ $ 30,000 $ 26,000 $ 31,000-$ 5,000-$ 4,000 After 30 days $ 10,000 $10,000 $ 13,000-$ 3,000 $ $ 20,000 $ 20,000 $ 19,000 $1,000 $ $ 10,000 $10,000 $ 13,000 - $ 3,000 $ $ 40,000 $ 40,000 $ 45,000-$ 5,000 $ Design Complete Code Complete Test Complete Total 0.83 0.89 1.00 $ $ 12,000 0.80 $ 4,500 $ 22,500 $ 10,000 $ 11,000 0.87 16,692 $ 47,692 0.84 Design Complete Code Complete Test Complete Total 0.77 1.05 0.77 0.89 1.00 1.00 1.00 1.00 $ 45,000
