Please show clear steps and explanation.

Question : 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 C Debug SW B 5 1500 D Prepare draft manual B 5 1000 E Meet with clients D 5 1000 F Test Sw CE 20 2000 G Make modifications F 8000 H Finalize manual G 10 5000 20 8000 1 Advertise CE (*) 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) A Meet with client 100% Actual costs (S) 1500 B Write SW 9000 +10 days +5 days 2500 D 1000 E 1000 Debug SW Prepare draft manual Meet with clients Test SW Make modifications Finalize manual F 100% +5 days 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 1000 G 0 | 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(%) B .... 3. Calculate Planned Value(PV) and Earned Value (EV) for each task Task Planned Actual Planned Actual Planned Cost Cost Completion(%) Completion(%) Value(PV) A B Earned Value(EV) *** 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