Answered step by step
Verified Expert Solution
Link Copied!

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?

image text in transcribed 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 Week

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Great Boss Great Management

Authors: S. M. H. Gibson

1st Edition

9798842893430

More Books

Students also viewed these General Management questions

Question

define and assess job burnout, boredom at work and work engagement;

Answered: 1 week ago