Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How can this be input into excel to create a graph similar to the one below? PV, AC, and EV). In the LOGON Project, suppose
How can this be input into excel to create a graph similar to the one below?
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 sh 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 com revised date (week 48-49) as of week 20? f. Are the results from Part (c) consistent with the results from Part (d) regarding improvem deterioration of project performance since week 20? 1,200 Status date (SD) Forecast AC -EAC 1,100 1,000 -BCAC PV 900 ETC 800 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 WeekStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started