Exercise $3$: Scheduling Project

Instruction:

Below is information about a Consumer Market Study Project.

$\backslash$table$[[$Activity ID$,$Activity,Predecessor,Responsibility,$\backslash$table$[[$Estimated Duration$],[($Day$)]]],[1,$Identify Target Customers,,Susan,$3],[2,$Develop Draft Questionnaire,$1,$Susan,$10],[3,$Pilot$-$Test Questionnaire,$2,$Susan,$20],[4,\backslash$table$[[$Review Comments and Finalize$],[$Questionnaire$]],3,$Susan,$5],[5,$Prepare Mailing Labels,$4,$Steve,$2],[6,$Print Questionnaire,$4,$Steve,$10],[7,$Develop Data Analysis Software,$4,$Andy,$12],[8,$Develop Software Test Data,$4,$Susan,$2],[9,\backslash$table$[[$Mail Questionnaire and Get$],[$Responses$]],5,6,$Steve,$65],[10,$Test Software,$7,8,$Andy,$5],[11,$Input Response Date,$9,10,$Jim,$7],[12,$Analyze Results,$11,$Jim,$8],[13,$Prepare Report,$12,$Jim,$10]]$

Draw an activity$-$on$-$node $($AON$)$ network$\_$and copy into Word document or attach file. Please use the template. AON Template.xlsx

Identify the ES$,$ EF$,$ LS$,$ LF$,$ critical path, total float, and free float using the critical path algorithm. The SchedulingProjectExercise Excel file SchedulingProjectExercise.xls $($or found under Files$)$ contains the format for entering this information. Once you enter this information, cut and paste the Excel table on your word document.

Which of these tasks should the project manager track most closely?

What would happen if a new estimate for Activity $5,$ "Prepare Mailing Labels," increases its expected duration from two days to ten days? Would the project take longer? Would anything else change? Explain your answer.

Draw a ES$-$EF Gantt chart for the $($original$)$ project. You may use Excel to develop the chart. Do not forget to paste the Excel$-$based Gantt chart into your Word document.

Please put this in this format on excel. Activity on Node TemplateExercise $3$: Scheduling Project

Instruction:

Below is information about a Consumer Market Study Project.

$\backslash$table$[[$Activity ID$,$Activity,Predecessor,Responsibility,$\backslash$table$[[$Estimated Duration$],[($Day$)]]],[1,$Identify Target Customers,,Susan,$3],[2,$Develop Draft Questionnaire,$1,$Susan,$10],[3,$Pilot$-$Test Questionnaire,$2,$Susan,$20],[4,\backslash$table$[[$Review Comments and Finalize$],[$Questionnaire$]],3,$Susan,$5],[5,$Prepare Mailing Labels,$4,$Steve,$2],[6,$Print Questionnaire,$4,$Steve,$10],[7,$Develop Data Analysis Software,$4,$Andy,$12],[8,$Develop Software Test Data,$4,$Susan,$2],[9,\backslash$table$[[$Mail Questionnaire and Get$],[$Responses$]],5,6,$Steve,$65],[10,$Test Software,$7,8,$Andy,$5],[11,$Input Response Date,$9,10,$Jim,$7],[12,$Analyze Results,$11,$Jim,$8],[13,$Prepare Report,$12,$Jim,$10]]$

Draw an activity$-$on$-$node $($AON$)$ network$\_$and copy into Word document or attach file. Please use the template. AON Template.xlsx

Identify the ES$,$ EF$,$ LS$,$ LF$,$ critical path, total float, and free float using the critical path algorithm. The SchedulingProjectExercise Excel file SchedulingProjectExercise.xls $($or found under Files$)$ contains the format for entering this information. Once you enter this information, cut and paste the Excel table on your word document.

Which of these tasks should the project manager track most closely?

What would happen if a new estimate for Activity $5,$ "Prepare Mailing Labels," increases its expected duration from two days to ten days? Would the project take longer? Would anything else change? Explain your answer.

Draw a ES$-$EF Gantt chart for the $($original$)$ project. You may use Excel to develop the chart. Do not forget to paste the Excel$-$based Gantt chart into your Word document.

Please put it in this format on excel, thank you!