Please answer the following yellow highlighted blank spots and explain to the student to understand how to solve the problem. It is an earned value problem.

Earned Value Problem 1. After watching the YouTubes on Earned Value, try problem in groups. Group Marmbars Fill in the 18 yellow boxes on this spreadsheet. The following bar chartshows the acfivities ( A to J ) for a 6 month project for $1480. After 3 months, A, B, C, E, F are complete for $490. Ac fivity D has notstarted. What is the status of the project in terms of the budget(over or under) and the schedule (ahead or behind)? Find in percentvariance. \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline Activity & Cost & Month 1 & Month 2 & Month 3 & Month 4 & Month 5 & Month6 \\ \hline A & & $100 & & & & & \\ \hline AB & $100 & $100 & $200 & & & & \\ \hline C & $60 & & $60 & & & & \\ \hline D & $80 & & & $80 & & & \\ \hlineE & $40 & & & $40 & & & \\ \hline F & $150 & & & $150 & & & \\ \hline G & $300 & & & & $300 & & \\ \hline H & $100 & & & & $100 & & \\ \hline 1 & $50 & & & & & $50 & \\ \hline J & $400 & & & & & & $400 \\ \hline TOTAL & & $100 & $260 & $270 & $400 & $50 & $400 \\ \hline Eumulative & & $100 & $360 & $630 & $1,030 & $1,080 & $1,480 \\ \hline \end{tabular} Cummulative Project Cost Find the budgeted cost of work palamed, budgeted cast of work scheduled, and variances. Months Stale whether the project is overbudget, undarbudget, ahesd ar behind schadule. Fill in the yellow bowes 1st Marth ACWP= $100 BCWS= BCWP $100 CV(%)=[BCWPACWPy/BCWP= The project is SV(%)=[BCWPBCWS]BCWP= The projectis considerably 2nd Marth 3rd Marth $360 $360 $360 | Pencertaga $ amourt CV= schedule. (ahead or behind) Problem 2 After 2 months, A,B,C, and halfof D are complete for $200. Complete the yellow bowes. \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline Activity & Cost & Month 1 & Month 2 & Month 3 & Month 4 & Month 5 & Month 6 \\ \hline A & $100 & $100 & & & & & \\ \hline B & $30 & & $30 & & & & \\ \hline C & $40 & & $40 & & & & \\ \hline D & $80 & & & $80 & & & \\ \hlineE & $20 & & & $20 & & & \\ \hline F & $50 & & & $50 & & & \\ \hline G & $70 & & & & $70 & & \\ \hline H & $30 & & & & $30 & & \\ \hline J & $200 & & & & & $200 & \\ \hline K & $60 & & & & & $60 & \\ \hline L & $20 & & & & & & $20 \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline TOTAL & & $100 & $70 & $150 & $100 & $260 & $20 \\ \hline Sumulativ & & $100 & $170 & $320 & $420 & $680 & $700 \\ \hline \end{tabular} Cummulative Project Cost Find the budgeted cost of work palamed, budgeted cast of work scheduled, and variances. Stale whether the project is averbudget, undarbudget, ahesd ar behind schadule. ACWP= BCWP= BCWS = CV(%)=[BCWPACWP/BCWP= The project is SV (%)=[BCWPBCWS]/BCWP= The project is considerably 1st Marth 2nd Manth 100 100 Percertage SV= SV=