Just solve Question No $4$

Question $1$: $50/50$ Rule

Based on the above Gantt chart, the data given below, and by using the $50/50$ rule $-$ complete the Earned Value table

for tasks A$,$ C$,$ F$,$ J$,$ K M and O$.$

Planned Value Actual Costs Earned Value

Notes.

Use the $50/50$ rule to determine how

much $$value$$ was earned.

Task A $$3,000$ $$1,000$

Task C $$10,000$ $$7,000$

Task F $$4,000$ $$2,500$

Task J $$6,000$ $$2,000$

Task K $$8,000$ $$7,000$

Task M $$3,000$ $$3,500$

Task O $$3,000$ $$0$

$4$

Question $2$: Calculate Earned Value Indicators

Based on the following data:

The Budget At Completion $($BAC$)$ cost of the project is estimated to be: $$52,250.$

$$ Earned value data is available for the first three weeks of the project $($see below$).$

$$ The project is due to end on week four $(4).$

Project Data Week $1$ Week $2$ Week $3$ Week $4$

Cumulative Actual Costs $$5,000$ $$16,000$ $$37,800$

Cumulative Planned Value $$11,750$ $$22,000$ $$43,000$ $$52,250$

Cumulative Earned Value $$7,000$ $$22,000$ $$47,000$

Based on the above data, calculate the following earned value indicators:

EVM Indicator Week $1$ Week $2$ Week $3$ Formula used

Cost Variance

Schedule Variance

Cost Performance Index

Schedule Performance Index

Estimated Cost At Completion

$($use the EAC $=$ BAC $/$ CPI formula$)$

Estimated Cost to Complete

For this question you need to:

$$ Identify which formulas you used for each indicator;

$$ Show an example of your calculations $($work$)$ for each indicator; and

$$ Calculate each indicator for each of the first three weeks.

Question $3$: Earned Value Management Dashboard

$$ Based on the question $2$ data, represent the project$$s

earned value status in a visual format.

$$ Your image need only include your AC$,$ EV$,$ and PV over

the four$-$week project $($see example chart at right$).$

$$ This chart can be done in Excel $($or equivalent$),$ or it can

be drawn by hand $($and then digitally scanned or

photographed, and included in your assignment$).$

Figure $1$: Sample EVM dashboard

$5$

Question $4$: Interpret the Project$$s Status

After reviewing your status report the boss asks you two follow$-$up questions.

Provide answers to each of the questions below:

$1.$ What is the current week three $(3)$ status of the project?

o Is the project on schedule, behind schedule or ahead of schedule?

o Is the project on budget, under budget or over budget?

Refer to your earned value findings to support your answer.

$2.$ If progress continues at its current rate $$ how much will the project likely cost?

o Ensure that you reference the earned value terms and findings in your answer