I already have the answers! I just need help making the graph in Excel!! Sending an Excel sheet would be great!Given the following information for a one-year project, answer the following questions. Recall that PV is the planned value. EV is the earned value, AC is the actual cost, and BAC is the budget at completion.PV = $23,000EV = $20,000AC = $25,000BAC = $120,000a. What is the cost variance, schedule variance, cost performance index (CPI), and schedule performance index (SPI) for the project?Cost Variance is calculated as EV-AC and indicates the difference between the budgeted cost and the actual cost of completed work.Cost Variance = EV-AC = $20,000 – $25,000 = - $ 5,000Schedule Variance is calculated as EV-PV and indicates the degree to which the value of completed work differs from that planned.Schedule Variance = EV-PV = $20,000 - $23,000 = -$ 3,000Cost Performance Index (CPI) = EV/AC = 20,000/25,000 = 0.8 or 80%Schedule Performance Index = EV/PV = 20,000 / 23,000 = 0.87 or 87%b. How is the project doing? Is it ahead or schedule or behind schedule? Is it under budget or over budget?The project is not doing well. Because the Cost variance and Schedule variance are negative. A negative Schedule variance means the project is behind schedule and a negative Cost variance means the project is over cost.c. Use the CPI to calculate the estimate at completion (EAC) for this project. Is the project performing better or worse than planned?EAC = BAC/CPI = $ 120,000/.8 = $ 150,000The project is performing worse than planned because the new estimate is $150,000 which is $30,000 more than initial estimate.d. Use the schedule performance index (SPI) to estimate how long it will take to finish this project.Estimated time to complete = Time estimate / SPI = 12 months / .87 = 13.8The project is projected to take 13.8 months to complete so it is estimated that it will take 1.8 months more than planned.e. Sketch the earned value chart based for this project (THIS IS WHAT I NEED HELP ON!!!!)If someone could show me what I need to plug in on excel and what the graph needs to look like, that would be great!