Computerized Scheduling - (10 pts) The following table displays eamed value data for a project. Please use MS Excel to create a project S-curve. Figure out and manually label the following items on and (2) SV, and write out the results of CV and SV by directly reading the curve 1. the curve: (1) CV C Hint: Highlighting the data and then select a Line Chart Type (with markers). Following the wizard instructions to create S-curve similar to the figure below. The S-curve figure is referred to the Textbook Mubarak, Chapter 7, p.202. Jul Jan Apr May $6,000 $15,000$30,000 $43,000 $50,000 $20,000 Aug Jun Feb Mar Palnned or BCWS $4,000$10,000 $8,000 $20,000 $40,000 Earned or BCWP Actual or ACWP Estimate at Comple tion $40,000 $55,000 $65,000$70,000 $75,000 Typical EVPM Chart 80 70 Forecast Cost Variance at Completion 60 Time Variance 50 Forecast Schedule Variance at Completion 40 Cost Variance to Date (EV-AC) Schedule Variance to Date (EV-PV) 30 20 10 Apr May Jul Aug Jan Feb Mar Jun Eamed - Planned ETC - Actual $1,000's Computerized Scheduling - (10 pts) The following table displays eamed value data for a project. Please use MS Excel to create a project S-curve. Figure out and manually label the following items on and (2) SV, and write out the results of CV and SV by directly reading the curve 1. the curve: (1) CV C Hint: Highlighting the data and then select a Line Chart Type (with markers). Following the wizard instructions to create S-curve similar to the figure below. The S-curve figure is referred to the Textbook Mubarak, Chapter 7, p.202. Jul Jan Apr May $6,000 $15,000$30,000 $43,000 $50,000 $20,000 Aug Jun Feb Mar Palnned or BCWS $4,000$10,000 $8,000 $20,000 $40,000 Earned or BCWP Actual or ACWP Estimate at Comple tion $40,000 $55,000 $65,000$70,000 $75,000 Typical EVPM Chart 80 70 Forecast Cost Variance at Completion 60 Time Variance 50 Forecast Schedule Variance at Completion 40 Cost Variance to Date (EV-AC) Schedule Variance to Date (EV-PV) 30 20 10 Apr May Jul Aug Jan Feb Mar Jun Eamed - Planned ETC - Actual $1,000's