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
Part 1 (time Planning)
1- Use Excel to develop
a. Gantt chart
b. AoN network
c. Use the AoN calculation to find the total and free slacks. (please summarize your answer in a table format)
2- Use project plan 360 to confirm your Excel calculations
Part 2(resource planning)
1- Use Excel to develop resource histogram for each resource
2- 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.
Sample Solution