On the tab labeled "Solutions", there are 5 questions about the problem that will require you to either make an input to the Excel file model or interpret the results of the model upon entering the required information. Each question is worth 20 points for producing the correct technical information and for a clear, concise, grammatically answer to the question. Questions should be answered on the "Solutions" tab and typed in unbolded print right after the statement of the question.
Question 1 On the tab labeled "CPM Network", you will find a skeleton AON network. The layout includes the activities required to COMPLETE
the project. Based on the list of activities and predecessors on the "CPM CALCULATION" tab, enter the arcs (lines) to connect the activities. In the model you will note I left a single arc (line) for you. You may copy/paste this as many times as required to assemble your model. You can adjust the slope and length of the line as required by clicking your mouse on the line itself. Do not change any other formatting in the CPM Network tab, just enter the arcs. In the network model I have provided on the "CPM Network" tab, what do the lines you entered represent?
Question 2 On the tab labeled "CPM Calculation" you will find a matrix where I have listed the activities for the project, the Predecessors, and the Days Required (duration) for each task as required. What is the definition of a predecessor?
Question 3 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 as part of the Forward Pass process. Make the entries in the spreadsheet on the "CPM Calculation" sheet to COMPLETE the Forward Pass. 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 4 After you have completed the Forward Pass, work backwards to complete the Backward Pass process. Make the entries in the spreadsheet on the "CPM Calculation" sheet to complete the Backward Pass. 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 5 After COMPLETING Questions 3 and 4, go back to the "CPM Calculation" tab and complete the Slack column. In the Critical Path column, put a "Y" in the cells that correspond to the activities that are on the critical path. In your response to this question here on this page, state the activities that are on the critical path and how you made the determination of the activities on the critical path.
