The following questions refer to Tables 1–3 (all values are in thousands). Table
ID: 351079 • Letter: T
Question
The following questions refer to Tables 1–3 (all values are in thousands).
Table 1 Budgeted Costs
Week
TBC 1 2 3 4 5
Task 1 55 25 15 15
Task 2 75 25 40 10
Task 3 40 20 20
Task 4 30 15 15
Table 2 Actual Costs
Week
1 2 3 4 5
Task 1 20 30 10
Task 2 25 45 20
Task 3 25 5
Task 4 15 10
Table 3 Percentage of Work Complete
Week
1 2 3 4 5
Task 1 35 75 100
Task 2 25 40 90 100
Task 3 50 60 90
Task 4
a. What is the CBC at the end of week 3?
b. What is the CAC at the end of week 3?
c. What is the CEV at the end of week 3?
d. What are the CV and SV at the end of week 3?
e. What are the CPI, SPI and CSI at the end of week 3?
f. What is the FCAC? Show the two different calculations from the text.
g. What actions, if any, might be required to get this project on track?
Table 1 Budgeted Costs Week TBC 1 23 4 5 Task 1 Task 2 Task 3 Task 4 55 25 1515 75 25 410 40 30 20 20 15 15 Table 2 Actual Costs Week Task 1 Task 2 Task 3 Task 4 20 30 10 25 45 20 25 5 15 10 Table 3 Percentage of Work Complete Week 1 2 3 4 5 35 75 100 Task 1 Task 2 Task 3 Task 4 25 40 90 100 50 60 90 a What is the CBC at the end of week 3? b. What is the CAC at the end of week 3? e. What is the CEV at the end of week 3? d. What are the CV and SV at the end of week 3? e. What are the CPI, SPI and CSI at the end of week 3? What is the FCAC? Show the two different calculations from the text. What actions, if any, might be required to get this project on track?Explanation / Answer
a) CBC = 150 , (Task 1 = 55 , Task 2 = 75, Task = 20 till week 3 , Add all 3 )
b) CAC = 175 (Task 1 = 60 , Task 2 = 90, Task = 25 till week 3 , Add all 3 )
c) CEV = sum (Actual completion %* Budget at completion)
= 100% of 55 + 90% of 75 + 50% of 40 = 55+67.5+20 = 142.5
d) CV = CEV - CAC = 142.5-175 = (22.5) in thousands
The value of the work performed through week 3 is $22500 less than the amount actually expended.
SV = EV - PV = 142.5 - 150 = - 7.5 , This means wer are behind schedule.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.