Given the following project plan: ID Task Immediate Predecessor (*) Expected Duration (days) Budget ($) A Meet with client 5 500 B Write SW A 20 10000 B 5 1500 C Debug SW D Prepare draft manual B 5 1000 E Meet with clients D 5 1000 F Test SW CE 20 2000 G Make modifications F 10 8000 | Finalize manual G 10 5000 I Advertise CE 20 8000 (*) all dependencies are assumed to be FS - Finish to Start And the following progress status at week 13: ID Task Status Actual Start (days) Actual Duration (days) Actual costs ($) A Meet with client 100% 1500 B Write SW 100% +5 days +10 days 9000 Debug SW +5 days 2500 D Prepare draft manual 1000 E Meet with clients 1000 F Test SW 1000 100% +15 days 100% As per other delays 100% As per other delays 100% As per other delays 0% As per other delays 0% As per other delays 10% +5 on top of other delays G Make modifications 0 H Finalize manual 0 I Advertise 1000 Perform an analysis of the project status at the end of week 13 by hand (you can use Excel but don't use MS Project), using EVA. Assume standard 5 day work week. Calculate CV, SV, CPI and SPI to determine project efficiency. Calculate EAC using three methods discussed in class. What would the TCPI need to be if we wanted to meet the original budget? Hint: 1. Draw a network diagram first ( with ES, EF calculated) 2. Examine by the end of week 13th, what is the planned completed percentage and actual percentage of each task? You may prepare a table like below ( you have to deduce planned completion percentage by referring to the network diagram, actual completion% copied from Status' listed in the question, planned cost copied from budget' and actual cost copied from the question) Task Planned Cost Actual Cost Planned Actual Completion%) Completion(%) A B 3. Calculate Planned Value(PV) and Earned Value (EV) for each task Task Planned Actual Planned Actual Planned Earned Cost Cost Completion(%) Completion(%) Value(PV) Value(EV) A B *** For each task, planned value (PV) = Planned Cost x Planned Completion%; Earned Value = Planned Cost x Actual Completion% 4. Then calculate cumulative AC, PV and EV for the whole project at the end of week 13th 5. Then calculate CV, SV etc, and also EAC