QUESTION 1 1) You are in charge of the Barrie Project. Given the following project baseline and status information, develop status reports for periods 1-8 and complete the performance indexes table. Calculate the EAC and VAC. Based on your data, what is the current status of the project? At completion? Budget ID ($000) 6 7 8 9 10 11 12 13 A 150 50 50 50 B 200 50 50 100 C 500 150 150 |200 D 200 100 100 E 250 100 100 50 F 300 100 50 150 G 300 150 100 50 H 200 100 100 Total 2100 50 50 250 200 300 100 100 200 150 350 100 150 100 Cumulative 50 100 350 550 850 950 1050 1250 1400 1750 1850 2000 2100 Status Reports Ending Period 1 (SOOO ) Task % Complete AC PV EV CV SV A 30% 55 Cumulative Totals 55 Ending Period 2 ($0OO) Task % Complete AC PV EV CV SV A 50% 120 Cumulative Totals 120Ending Period 2 ($000) Task % Complete AC PV EV CV SV A 50% 120 Cumulative Totals 120 Ending Period 3 ($0OO) Task % Complete AC PV EV CV SV A 100% 230 B 0% 0 C 0% 0 Cumulative Totals 230 PMPG 5013_Project Cost Management 1 Ending Period 4 ($OOO) Task % Complete AC PV EV CV SV A 100% 230 B 60% 100 C 50% 200 Cumulative Totals 530 Ending Period 5 ($0OO) Task % Complete AC PV EV CV SV A 100% 230 B 100% 200 C 100% 550 Cumulative Totals 980Ending Period 6 ($000) Task % Complete AC PV EV CV SV A 100% 230 B 100% 200 C 100% 550 D 75% 100 Cumulative Totals 1080 Ending Period 7 (sooo ) Task % Complete AC PV EV CV SV A 100% 230 B 100% 200 C 100% 550 D 100% 150 E 20% 100 5% 50 Cumulative Totals 1,280 Ending Period 8 ($000) Task % Complete AC PV EV CV SV A 100% 230 B 100% 200 C 100% 550 100% 150 m O 100% 350 20% 110 Cumulative Totals 1,590Performance Indexes Summary Period AC PV EV CPI SPI PCIB 2 3 4 8 EAC = ? VAC = ? 2) You have met with your Barrie project team and they have provided you with the following revised estimates for the remainder of the project; a. Activity F will be completed at the end of period 12 at a cost of 450. b. Activity G will be completed at the end of period 11 at a cost of 200. c. Activity H will be completed at the end of period 14 at a cost of 200. Calculate the revised EAC and VAC. Based on the revised estimates, what is the expected status of the project in terms of cost and schedule? Between the initial VAC and revised VAC, which one would you have the greatest confidence in?QUESTION 2 You need a loan in the amount of $10,000 with a repayment period of 7 years. You did some market research, and it seems that you have two options as follows: PMPG 5013_Project Cost Management 3 . Pay $2,500 per year at BMO or . Pay 17,500 at the end of the 7-year period at RBC. What option is better. The discount rate is 12% at both banks