BUSI508 Week 7 Excel Exercise 6 SCORE 100 PERCENT

Question 1 (4 Points) On the tab labeled "CPM Network", you will find a skeleton AON network of Problem 10.  Enter the activities (A through I) in the cells highlighted in green according to the statement of the problem; there is only one solution based on the statement of the problem.  Do not change any of the formatting in the CPM Network tab, just enter the letters A through I, one per cell, according to the statement of the problem.  In the network model I have provided on the CPM Network tab, what do the green cells represent and what do the yellow lines represent?

 
Question 2 (4 Points) On the tab labeled "CPM Calculation" you will find a matrix where I have started the computation to find the critical path for the project by calculating the early start/finish and late start/finish times.  Discuss the calculations necessary to finish the early start (EST) and early finish (EFT) columns as part of the Forward Pass process.  For any blank cells in the forward pass, enter the correct value on the "CPM Calculation" sheet.  What is the earliest time the project can be completed (# of days)?  Please note the spreadsheet is not set up with formulas for calculations; you must manually complete these calculations and enter the appropriate values in the spreadsheet.    

Question 3 (4 Points) On the tab labeled "CPM Calculation" you will find a matrix where I have started the computation to find the critical path for the project by calculating the early start/finish and late start/finish.  Discuss the calculations necessary to finish the late finish (LFT) and late start (LST) columns as part of the Backward Pass process.  For any blank cells in the backward pass, enter the correct value on the "CPM Calculation" sheet.  Please note the spreadsheet is not set up with formulas for calculations; you must manually complete these calculations and enter the appropriate values in the spreadsheet.

Question 4 (4 Points) After completing Questions 2 and 3, go back to the "CPM Calculation" tab and compute the slack for each task then state (here) the activities on the critical path.

Question 5 (4 Points) After completing the Microsoft Project portion of this exercise, does the overall duration of the project and critical path agree with what you have calculated here?