# Use Excel to develop a Gantt chart

Use Excel to develop Gantt chart

The National Oceanic Research Institute is planning a research study on global warming in Antarctica. The major tasks and their durations and precedent activities are shown in Table 1 below. The Table also shows the budget expenditures of each activity. For example, activity A, preliminary plan, costs \$3,000 and lasts for 3 weeks, such that, each week, the cost is \$1,000. On the other hand, activity I, additional equipment, costs \$20,000, lasts for 3 weeks, but \$10,000 needs to be paid in the first week while \$5,000 is paid in the second and third week .

Solve all the questions using Excel

## How do you create a Gantt chart in Excel?

Part 1 (time Planning)

• Use Excel to develop
1. Gantt chart
2. AoN network
3. Use the AoN calculation to find the total and free slacks. (please summarize your answer in a table format)
• Use project plan 360 to confirm your Excel calculations

Part 2(resource planning)

• Use Excel to develop resource histogram for each resource
• Use project plan 360 to develop a resource histogra

Part 3(EVM)

Use Excel only for the required calculations

Q1 Scheduling:

• Calculate the project minimum duration.
• Calculate the slack time of each activity.
• Identify the critical path(s).

Q2 Costing:

• Develop a time-cost curve for the above project

Q3 Earned value management

• At the end of week 6, information about the project was collected as shown in Table 2. Calculate the missing information in the table: Earned Value (EV), Planned Value (PV) of each activity, Cost Variance (CV), and Schedule Variance (SV).
• Calculate the Cost Performance Index (CPI) and Schedule Performance Index (SPI).
• Predict the Estimated Cost at Completion (EAC) and the project expected duration.

NOTE: Kindly submit the excel sheet and project 360 with all solutions. 