In: Accounting
Question 1
<Budget & Schedule>
Budget | Start Week | End Week | |
Task1 | 93,019 | 1 | 10 |
Task2 | 140,853 | 1 | 10 |
Task3 | 183,921 | 1 | 10 |
Task4 | 205,017 | 1 | 10 |
<Cost Loaded Schedule>
Week1 | Week2 | Week3 | Week4 | Week5 | |
Task1 | 10% of Budget | 10% of Budget | 10% of Budget | 10% of Budget | 10% of Budget |
Task2 | 10% of Budget | 10% of Budget | 10% of Budget | 15% of Budget | 15% of Budget |
Task3 | 10% of Budget | 10% of Budget | 10% of Budget | 15% of Budget | 15% of Budget |
Task4 | 15% of Budget | 15% of Budget | 5% of Budget | 5% of Budget | 5% of Budget |
<Percentage of Completion>
Week1 | Week2 | Week3 | Week4 | Week5 | |
Task1 | 8% of Budget | 10% of Budget | 10% of Budget | 15% of Budget | 15% of Budget |
Task2 | 10% of Budget | 10% of Budget | 10% of Budget | 15% of Budget | 15% of Budget |
Task3 | 10% of Budget | 10% of Budget | 10% of Budget | 20% of Budget | 20% of Budget |
Task4 | 20% of Budget | 20% of Budget | 10% of Budget | 10% of Budget | 10% of Budget |
<Actual Cost of Work Performed>
Week1 | Week2 | Week3 | Week4 | Week5 | |
Task1 | 8% of Budget | 12% of Budget | 14% of Budget | 18% of Budget | 30% of Budget |
Task2 | 9% of Budget | 10% of Budget | 9% of Budget | 15% of Budget | 14% of Budget |
Task3 | 10% of Budget | 10% of Budget | 10% of Budget | 20% of Budget | 15% of Budget |
Task4 | 20% of Budget | 25% of Budget | 15% of Budget | 20% of Budget | 20% of Budget |
What is BCWP of the project at the end of week 2 (BCWP accumulated from the beginning of the project)?
Working Notes :
Budgeted Cost Loaded -
Week 1 | Week 2 | |
Task 1 | 9,301.90 | 9,301.90 |
Task 2 | 14,085.30 | 14,085.30 |
Task 3 | 18,392.10 | 18,392.10 |
Task 4 | 30,752.55 | 30,752.55 |
Total | 72,531.85 | 72,531.85 |
Final Answer , i.e. BCWP of the project
Week 1 | Week 2 | |
Task 1 | 744.15 | 1,116.23 |
Task 2 | 1,267.68 | 1,408.53 |
Task 3 | 1,839.21 | 1,839.21 |
Task 4 | 6,150.51 | 7,688.14 |
Total | 10,001.55 | 12,052.11 |
BCWP of the project at the end of week 2 = 10,001.55+12,052.11 = 22,053.65