please use excel and provide step by step formula for answers.

Project SPOC included the following tasks. Duration TASK Predecessors (weeks) Budget Pct of Completion 6 6 6 A B D E F 12 $ 900.0 $ 1,200.0 $ 1,200.0 $ 1,800.0 $ 1,400.0 $ 1,500.0 $ 800.0 100% 100% 100% 100% 100% 40% A A B, C B,C,D D, E 14 10 16 0% Before the end of the project, at week 24 the project expenses were $7,500. a) (8pt) Create a PERT Chart of this project Mark on the chart the Budget planned per task b) (8pt) Create a Gantt Chart of this project Include the budget/cost per task c) (10pt) Compute the following for the 24th week PV EV AC d) (4pt) Is the project progressing well or there is a problem? Use a quatitative metrics and explain your answer. Project SPOC included the following tasks. Duration TASK Predecessors (weeks) Budget Pct of Completion 6 6 6 A B D E F 12 $ 900.0 $ 1,200.0 $ 1,200.0 $ 1,800.0 $ 1,400.0 $ 1,500.0 $ 800.0 100% 100% 100% 100% 100% 40% A A B, C B,C,D D, E 14 10 16 0% Before the end of the project, at week 24 the project expenses were $7,500. a) (8pt) Create a PERT Chart of this project Mark on the chart the Budget planned per task b) (8pt) Create a Gantt Chart of this project Include the budget/cost per task c) (10pt) Compute the following for the 24th week PV EV AC d) (4pt) Is the project progressing well or there is a problem? Use a quatitative metrics and explain your