Earned Value Planning PV

Assignment Determine the Current PV for each month and the Cumulative PV at the end of each month (Use Excel or a Tool of your choice). Using this Gnatt chart and Task estimates -- I can't figure out to process the Gnatt chart to able make a Current PV and Cumulative PV. Can someone please explain this process?

Earned Value Planning Consider the project Gantt chart schedule and the task estimates provided. Spread all tasks that span multiple months with a level loading approach. Initiate an earned value analysis by determining the Current PV for each month and the Cumulative PV at the end of each month. No Filter No Sorting Name Feb 2014 02 09 116 Mar 2014 23 102 09 116 Apr 2014 30 106 113 20 123 May 2014 27 04 111 Jun 2014 01 108 115 Jul 2014 129 06 13 26 125 Aug 2014 20 27 03 110 118 122 117 124 1 2. 3 4 50/50% 5 6 7 8 50/50% 9 10 Task 1 Task 2 Task 3 Task 4 Task 5 Task 6 Task 7 Task 8 Task 9 Task 10 Task 11 Task 12 Task 13 Task 14 Task 15 Task 16 Task 17 Task 18 Task 19 Task 20 11 50750% 12 13 14 15 16 17 18 19 20 50/50% *50/50% = Task is even spit Earned Value Planning - PV Planned Value Exercise Task Feb Mar Apr May Jun Jul Aug 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Task Estimate $2,400 $6,400 $4,000 $100,800 $8,000 $353,600 $4,800 $16,800 $11,200 $57,200 $12,800 $19,200 $16,000 $24,800 $21,600 $30,000 $79,800 $12,000 $9,600 $6,400 $797,400 Current PV Cumulative PV 15 16 17 18 19 20 Total -Assignment - Determine the Current PV for each month and the Cumulative PV at the end of each month (Use Excel or a Tool of your choice). Earned Value Planning Consider the project Gantt chart schedule and the task estimates provided. Spread all tasks that span multiple months with a level loading approach. Initiate an earned value analysis by determining the Current PV for each month and the Cumulative PV at the end of each month. No Filter No Sorting Name Feb 2014 02 09 116 Mar 2014 23 102 09 116 Apr 2014 30 106 113 20 123 May 2014 27 04 111 Jun 2014 01 108 115 Jul 2014 129 06 13 26 125 Aug 2014 20 27 03 110 118 122 117 124 1 2. 3 4 50/50% 5 6 7 8 50/50% 9 10 Task 1 Task 2 Task 3 Task 4 Task 5 Task 6 Task 7 Task 8 Task 9 Task 10 Task 11 Task 12 Task 13 Task 14 Task 15 Task 16 Task 17 Task 18 Task 19 Task 20 11 50750% 12 13 14 15 16 17 18 19 20 50/50% *50/50% = Task is even spit Earned Value Planning - PV Planned Value Exercise Task Feb Mar Apr May Jun Jul Aug 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Task Estimate $2,400 $6,400 $4,000 $100,800 $8,000 $353,600 $4,800 $16,800 $11,200 $57,200 $12,800 $19,200 $16,000 $24,800 $21,600 $30,000 $79,800 $12,000 $9,600 $6,400 $797,400 Current PV Cumulative PV 15 16 17 18 19 20 Total -Assignment - Determine the Current PV for each month and the Cumulative PV at the end of each month (Use Excel or a Tool of your choice)