Please answer question 27 A-e in excel and graph. Show all excel information

PV, AC, and EV). . In the LOGON Project, suppose the status as of week 22 is as follows (note usage of the longer acronyms, some project management books and software packages use these and not the shorter acro BCWS = $628,000 ACWP = $640,000 BCWP = $590,000 Answer the following questions a. What is the earned value of the project as of week 22? b. Compute SV and CV. c. Draw a status graph similar to Figure 13.13 and plot BCWS, ACWP, and BCWP. Show SV and CV. Determine TV from the graph. d. Compute SPI and CPL Has the project performance improved or worsened since week 20? e. Using BAC - $990,000, compute ETC and EAC. How does EAC compare to the week 20 estimate of $1,222,593? From your status chart, determine the revised completion date. How does it compare to the revised date (week 48-49) as of week 20? f. Are the results from Part (e) consistent with the results from Part (d) regarding improvemy r deterioration of project performance since week 20? 1,200 Status date (SD) Forecast AC EAC 1,100 1,000 -BCAC PV 900 ETC BOO EV 700 Cost ($1,000s) 600 500 400 300 AC Initial Revised target date completion 200 EV date 100 0 2 4 6 8 10 12 14 16 18 20) 22 24 26 26 30 32 34 36 38 40 42 44 46 48 50 52 Week