Earned Value Assignment $-$ Fill in the yellow highlighted boxes on this spreadsheet.

'The following bar chart shows the activities $($A to J$)$ for a $6$ month project for $$1480.$

After $3$ months, A$,$ B$,$ C$,$ F are completed with an actual cost of $$500.$

Activity $D$ and $E$ have not yet started.

What is the status of the project in terms of the budget? Is it overbudget or underbudget?

How is the project schedule $($ahead or behind$)?$ Provide the variances in numbers and percentage.

$\backslash$table$[[$Activity$,$Budgeted Cost,Month $1,$Month $2,$Month $3,$Month $4,$Month $5,$Month $6],[,,,,,,,],[$A$,$$$100,$$$100,,,,,],[$B$,$$$200,,$$$200,,,,],[$C$,$$$60,$$$60,,,,,],[$D$,$$$80,,,$$$80,,,],[$F$,$$$40,,$$$40,,,,],[$G$,$$$150,,$$$150,,,,],[$H$,$$$300,,,$$$300,,,],[$I$,$$$100,,,,,,],[$J$,$$$50,,,,,,]]$

Find the budgeted cost of work performed, budgeted cost of work scheduled, and variances.

State whether the project is overbudget or underbudget, ahead or behind schedule.

Fill in the yellow boxes