In: Math
The Laurenster Corporation needs to set up an assembly line to produce a new product. The fol- lowing table describes the relationships among the activities that need to be completed for this product to be manufactured.
DAYS IMMEDIATE
ACTIVITY a m b PREDECESSORS
A 3 6 6 —
B 5 8 11 A
C 5 6 10 A
D 1 2 6 B, C
E 7 11 15 D
F 7 9 14 D
G 6 8 10 D
H 3 4 8 F, G
I 3 5 7 E, F, H
a) Develop a project network for this problem.
b) Determine the expected duration and variance for each activity.
c) Determine the ES, EF, LS, LF, and slack time for each activity. Also determine the total
project completion time and the critical path(s).
d) Determine the probability that the project will be completed in 34 days or less.
e) Determine the probability that the project will take longer than 29 days.
*****PLEASE SHOW ME HOW TO CALCULATE IN EXCEL QM...FORMULAS' INCLUDED****