Earned Value

Given the following budgeted and accomplished work as of week $16,$ calculate earned value for each activity, and for the project. There is a penalty of $$500,000$ if the project takes over $25$ weeks.

Actual costs are Actual weeks times Pay rate.

Calculate efficiency based on dollars for each activity and overall project efficiency at this stage.

Activity Budget Actual $\%$ complete Pay rate Earned value

Grading $6$ weeks $5$ weeks $100$ $$40,000/$week

Prepare base $3$ weeks $4$ weeks $100$ $$20,000/$week

Culverts $8$ weeks $10$ weeks $100$ $$30,000/$week

Bridge $20$ weeks $16$ weeks $50$ $$80,000/$week

Surface $3$ weeks $1$ week $33$ $$100,000/$week

Painting $1$ week $0$ $$55,000/$week

Budget estimates are obtained from pre$-$bid estimates.

Actual expenses are obtained from accounting as moneys are spent.

The sequential relationships are:

Grading precedes Prepare base and Culverts

Prepare base and Culverts precedes Surface

Bridge and Surface precede Painting

Some overlap of activities is present, as you don$$t have to have $100\%$ completion of a predecessor to start some activities. Predecessor relationships really aren$$t needed for the accounting side of the assignment.

Give a short analysis of current status by activity and for the overall project.Earned Value

Given the following budgeted and accomplished work as of week $16,$ calculate earned value for each activity, and for the project. There is a penalty of $$500,000$ if the project takes over $25$ weeks.

Actual costs are Actual weeks times Pay rate.

Calculate efficiency based on dollars for each activity and overall project efficiency at this stage.

$\backslash$table$[[$Activity$,$Budget,Actual,$\%$ complete,Pay rate,$\backslash$table$[[$Earned$],[$value$]]],[$Grading$,6$ weeks,$5$ weeks,$100,$$$40,000/$ week,$],[\backslash$table$[[$Prepare$],[$base$]],3$ weeks,$4$ weeks,$100,$$$20,000/$ week,$],[$Culverts$,8$ weeks,$10$ weeks,$100,$$$30,000/$ week,$],[$Bridge$,20$ weeks,$16$ weeks,$50,$$$80,000/$ week,$],[$Surface$,3$ weeks,$1$ week,$33,$$$100,000/$ week,$],[$Painting$,1$ week,$0,,$$$55,000/$ week,$]]$

Budget estimates are obtained from pre$-$bid estimates.

Actual expenses are obtained from accounting as moneys are spent.

The sequential relationships are:

Grading precedes Prepare base and Culverts

Prepare base and Culverts precedes Surface

Bridge and Surface precede Painting

Some overlap of activities is present, as you don't have to have $100\%$ completion of a predecessor to start some activities. Predecessor relationships really aren't needed for the accounting side of the assignment.

Give a short analysis of current status by activity and for the overall project.