MGMT430 Columbia College Critical Path Method Network Worksheet On the tab labeled “Solutions”, there are 5 questions about the problem that will require y

MGMT430 Columbia College Critical Path Method Network Worksheet 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 will be evaluated 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.Be sure to properly format all tables.ALL FORMULAS SHOULD BE ENTERED IN EXCEL AND EDITABLE IN THE CELL THAT THEY ARE WITHIN. ONLY USE THE INFORMATION PROVIDED IN THE EXCEL SHEET TO ANSWER THE QUESTIONS. 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 will be
evaluated 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.
Good luck and as always…HAVE FUN!
s about the problem that
file model or interpret the
rmation. Each will be
ation and for a clear,
stions should be
ded print right after the
C
F
G
A
B
E
H
D
I
J
Activity
Description
A
Design
B
Ordr/Rec Materials
C
Construct Frame
D
Prepare Engine
E
Prepare Avionics
F
Cover Frame
G
Install Engine
H
Paint
I
Install Avionics
J
Test
Predecessors
None
A
B
B
B
C
E, F
F
D, G, H
I
Days Req’d
4
5
8
6
5
4
2
2
2
1
Forward Pass
EST
EFT
0
4
Backwards Pass
LST
LFT
Slack
Critical Path?
Question 1) On the tab labeled “CPM Network”, you will find a skeleton AON network. Th
includes the activities required to complete the project. Based on the list of activities an
predecessors on the “CPM Calculation” tab, enter the arcs (lines) to connect the activitie
model you will note I left a single arc (line) for you. You may copy/paste this as many tim
required to assemble your model. You can adjust the slope and length of the line as requ
clicking your mouse on the line itself. Do not change any other formatting in the CPM Ne
just enter the arcs. In the network model I have provided on the “CPM Network” tab, wha
you entered represent?
Question 2) On the tab labeled “CPM Calculation” you will find a matrix where I have liste
activities for the project, the Predecessors, and the Days Required (duration)
required. What is the definition of a predecessor?
Question 3) On the tab labeled “CPM Calculation” you will find a matrix where I have star
computation to find the critical path for the project by calculating the early start/finish as
Forward Pass process. Make the entries in the spreadsheet on the “CPM Calculation” s
complete the Forward Pass. What is the earliest time the project can be completed (# of
Please note the spreadsheet is not set up with formulas for calculations; you must manu
these calculations and enter the appropriate values in the spreadsheet.
Question 4) After you have completed the Forward Pass, work backwards to complete th
Pass process. Make the entries in the spreadsheet on the “CPM Calculation” sheet to co
Backward Pass. Please note the spreadsheet is not set up with formulas for calculations
manually complete these calculations and enter the appropriate values in the spreadshee
Question 5) After completing Questions 3 and 4, go back to the “CPM Calculation” tab an
the Slack column. In the Critical Path column, put a “Y” in the cells that correspond to th
that are on the critical path. In your response to this question here on this page, state th
that are on the critical path and how you made the determination of the activities on the c
skeleton AON network. The layout
d on the list of activities and
es) to connect the activities. In the
opy/paste this as many times as
nd length of the line as required by
er formatting in the CPM Network tab,
he “CPM Network” tab, what do the lines
d a matrix where I have listed the
uired (duration) for each task as
d a matrix where I have started the
ing the early start/finish as part of the
n the “CPM Calculation” sheet to
ect can be completed (# of days)?
lculations; you must manually complete
eadsheet.
backwards to complete the Backward
PM Calculation” sheet to complete the
h formulas for calculations; you must
te values in the spreadsheet
e “CPM Calculation” tab and complete
cells that correspond to the activities
here on this page, state the activities
on of the activities on the critical path.
C
F
4
A
0
4
B
E
4
D
LEGEND:
ES
EF
LS
LF
t
Early Start Time
Early Finish Time
Late Start Time
Late Finish Time
Duration Time or t
Activity
G
2
H
2
I
J
2
1

Purchase answer to see full
attachment