CD16-36
The initial public offering process is 27.5 weeks long. The critical path is:
b) We explore each change independently.
i) Negotiating the commitment (step C) is performed parallel to negotiating the spread
(step D). In part (a) above, negotiating the spread is on the critical path since it
The project duration is still 27.5 weeks.
ii) In part (a) above, calculating the issue price is not on the critical path. Thus,
decreasing the time to calculate the price does not change the solution found in part
iii) In part (a) above, the step to amend the statement and resubmit it to the SEC (step
iv) In part (a) above, the step to confirm that the new issue complies with “blue sky”
laws (step M) occurs in parallel to appointing a registrar (step N) and to appointing
a transfer agent (step O). Step M is not on the critical path since it only takes one
week while step O takes 3.5 weeks. When we increase the time to complete step M
c)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
A B C D E F G H I J K
Maximum Crash Cost Start Time Finish
Time Reduction per W eek Saved Time Reduction Time
Activity Description Normal Crash Normal Crash (weeks) ($thousand) (week) (weeks) (week)
A Evaluate prestige 3 1.5 8 14 1.5 4 0 1.5 1.5
B Select syndicate 1.5 0.5 4.5 8 1 3.5 1.5 1 2
C Negotiate commitment 2 2 9 9 0 0 3 0 5
D Negotiate spread 3 3 12 12 0 0 2 0 5
E Prepare registration 5 4 50 95 145 5 0 10
F Submit registration 1 1 1 1 0 0 10 011
G Present 6 4 25 60 2 17.5 11 017
H Distribute red herring 3 2 15 22 1 7 14 017
I Calculate price 5 3.5 12 31 1.5 12.67 12 017
J Receive deficiency 3 3 0 3 0 0 11 014
K Amend statement 1 0.5 6 9 0.5 6 14 0.5 14.5
L Receive registration 2 2 0 0 0 0 14.5 0 16.5
M Confirm blue sky 1 0.5 5 8.3 0.5 6.6 17 018
N Appoint registrar 3 1.5 12 19 1.5 4.67 16.5 1.5 18
O Appoint transfer 3.5 1.5 13 21 2 4 16.5 2 18
P Issue prospectus 4.5 2 40 99 2.5 23.6 18 0.5 22
Q Phone buyers 4 1.5 9 20 2.5 4.4 18 022
Max Time
Project Finish T ime (week) 22 <= 22
Total Cost 260.8
Time
(weeks)
Cost
($thousand)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Maximum Crash Cost Start Time Finish
Time Reduction per W eek Saved T ime Reduction Time
(weeks) ($thousand) (week) (weeks) (week)
= NormalTime-CrashT ime = (CrashCostNormalCost)/ MaxT imeReduct ion 0 1.5 = StartT ime+ NormalT ime-TimeReduct ion
= NormalT ime-CrashT ime = (CrashCostNormalCost )/MaxT imeReduct ion 1.5 1 = StartT ime+ NormalTime-TimeReduct ion
= NormalT ime-CrashT ime 0 3 0 = StartT ime+ NormalT ime-T imeReduct ion
= NormalT ime-CrashT ime 0 2 0 = StartT ime+ NormalT ime-T imeReduct ion
= NormalT ime-CrashT ime = (CrashCostNormalCost )/MaxT imeReduct ion 5 0 = StartT ime+ NormalTime-TimeReduct ion
= NormalT ime-CrashT ime 0 10 0 = StartT ime+ NormalTime-TimeReduct ion
= NormalT ime-CrashT ime = (CrashCostNormalCost )/MaxT imeReduct ion 11 0 = StartT ime+ NormalT ime-T imeReduct ion
= NormalT ime-CrashT ime = (CrashCostNormalCost )/MaxT imeReduct ion 14 0 = StartT ime+ NormalT ime-T imeReduct ion
= NormalT ime-CrashT ime = (CrashCostNormalCost )/MaxT imeReduct ion 12 0 = StartT ime+ NormalT ime-T imeReduct ion
= NormalT ime-CrashT ime 0 11 0 = StartT ime+ NormalTime-TimeReduct ion
= NormalT ime-CrashT ime = (CrashCostNormalCost )/MaxT imeReduct ion 14 0.5 = StartT ime+ NormalTime-TimeReduct ion
= NormalT ime-CrashT ime 0 14.5 0 = StartT ime+ NormalTime-TimeReduct ion
= NormalT ime-CrashT ime = (CrashCostNormalCost )/MaxT imeReduct ion 17 0 = StartT ime+ NormalT ime-T imeReduct ion
= NormalT ime-CrashT ime = (CrashCostNormalCost )/MaxT imeReduct ion 16.5 1. 5 = StartTime+ NormalT ime-TimeReduct ion
= NormalT ime-CrashT ime = (CrashCostNormalCost )/MaxT imeReduct ion 16.5 2 = StartT ime+ NormalT ime-T imeReduction
= NormalT ime-CrashT ime = (CrashCostNormalCost )/MaxT imeReduct ion 18 0.5 = StartT ime+ NormalTime-TimeReduct ion
= NormalT ime-CrashT ime = (CrashCostNormalCost )/MaxT imeReduct ion 18 0 = StartT ime+ NormalT ime-T imeReduct ion
25
H I
Total Cost =SUM(NormalCost)+SUMPRODUCT(CrashCostPerWeekSaved,TimeReduction
Range Name Cells
Activity A4:A20
CrashCost F4:F20
CrashCostPerW eekSaved H4:H20
CrashTime D4:D20
Description B4:B20
FinishTime K4:K20
MaxTime K23
MaxTimeReduction G4:G20
NormalCost E4:E20
NormalTime C4:C20
ProjectFinishTime I23
StartTime I4:I20
TimeReduction J4:J20
TotalCost I25
CD16-38
The constraints in the linear programming spreadsheet model were as follows:
TimeReduction ≤ MaxTimeReduction
ProjectFinishTime ≤ MaxTime
BStart ≥ AFinish
CStart ≥ BFinish
DStart ≥ BFinish
EStart ≥ CFinish
NStart ≥ LFinish
OStart ≥ LFinish
PStart ≥ MFinish
PStart ≥ NFinish
Janet and Gilbert should reduce the time for step A (evaluating the prestige of each
potential underwriter) by 1.5 weeks, the time for step B (selecting a syndicate of
d) We use the same model formulation that was used in part (c). We change one
constraint, however. The project duration now has to be less-than-or-equal to 24 weeks
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
A B C D E F G H I J K
Maximum Crash Cost Start Time Finish
Time Reduction per W eek Saved Time Reduction Time
Activity Description Normal Crash Normal Crash (weeks) ($thousand) (week) (weeks) (week)
A Evaluate prestige 3 1.5 8 14 1.5 4 0 1. 5 1.5
B Select syndicate 1. 5 0.5 4.5 8 1 3.5 1.5 1 2
C Negotiate commitment 2 2 9 9 0 0 3 0 5
D Negotiate spread 3 3 12 12 0 0 2 0 5
E Prepare registration 5 4 50 95 145 5 0 10
F Submit registration 1 1 1 1 0 0 10 011
G Present 6 4 25 60 2 17.5 12.5 0 18.5
H Distribute red herring 3 2 15 22 1 7 11 014
I Calculate price 5 3.5 12 31 1.5 12.67 13.5 0 18.5
J Receive deficiency 3 3 0 3 0 0 11 014
K Amend statement 1 0.5 6 9 0.5 6 14 0. 5 14.5
L Receive registration 2 2 0 0 0 0 14.5 0 16.5
M Confirm blue sky 1 0.5 5 8.3 0.5 6.6 18.5 0 19.5
N Appoint registrar 3 1.5 12 19 1.5 4.67 16.5 0 19.5
O Appoint transfer 3.5 1.5 13 21 2 4 16.5 0.5 19.5
P Issue prospectus 4.5 2 40 99 2.5 23.6 19.5 0 24
Q Phone buyers 4 1.5 9 20 2.5 4. 4 20 024
Max Time
Project Finish T ime (week) 24 <= 24
Time
(weeks)
Cost
($thousand)
Janet and Gilbert should reduce the time for step A (evaluating the prestige of each
potential underwriter) by 1.5 weeks, the time for step B (selecting a syndicate of
16.2 a) The project network appears below.
S TAR T
Register
onlin e
Attend
orientation
W rite initial
r esu me
Search
Intern et
Attend company
sessions
Review
industry
Attend mock
inter view
Sub mit
initial resu me
S earch
jobs
Meet resume
expert
Revise
resume
Attend
caree r fair
Re vise cover
letters
Drop Mail
FINIS H
0
2 5 7 10 25
472
1
4
1
5
4
26
0
A B C D E
G F H
I
J
KL
RS
To determine the project schedule and which activities are critical, we calculate the early
start, late start, early finish, late finish, and slack below.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
A B C D E F G H I
Time Slack
Activity Description (days) ES EF LS LF (days) Critical?
A Register online 2 0 2 8 10 8No
B Attend orientation 5 0 5 5 10 5No
C Write initial resume 7 0 7 7 14 7No
D Search internet 10 010 12 22 12 No
E
Attend company sessio
25 025 025 0 Yes
F Review industry, etc. 7 5 12 10 17 5No
G Attend mock interview 4 7 11 45 49 38 No
H Submit initial resume 2 7 9 14 16 7No
I Meet resume expert 1 9 10 16 17 7No
J Revise resume 4 10 14 17 21 7No
K Attend career fair 1 14 15 21 22 7No
L Search jobs 5 12 17 17 22 5No
M Decide jobs 3 17 20 22 25 5No
N Bid 3 20 23 46 49 26 No
O W rite cover letters 10 25 35 25 35 0 Yes
P Submit cover letters 4 35 39 35 39 0 Yes
Q Revise cover letters 4 39 43 39 43 0 Yes
R Mail 6 43 49 43 49 0 Yes
S Drop 2 43 45 47 49 4No
Project Duration (days) 49
W eek
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
A B C D E F G H I
Time Slack
Activity Description (days) ES EF LS LF (days) Critical?
A Register online 2 0 = ES+ Time =LFTime = MIN(F8,F9,F10) = LF-EF =IF(Slack=0,“Yes”,“No”)
B Attend orientation 5 0 = ES+Time = LFTime = MIN(F8,F9,F10) = LFEF =IF(Slack= 0,“Yes”,“No”)
C W rite initial resume 7 0 = ES+Time = LFTime = MIN(F9,F10) =LF-EF =IF(Slack=0,“Yes”,“No”)
D Search internet 10 0 = ES+ T im e = LF-T ime = MIN(F 15) = LF-EF = IF (Slack= 0,“Yes“,“No”)
E Attend company sessions 25 0 = ES+ T im e = LF-T ime = MIN(F 17) = LF-EF = IF (Slack= 0,“Yes“,“No”)
F Review industry, etc. 7 = MAX(E3,E4) =ES+ Time = LF-T ime = MIN(F14) = LF-EF =IF(Slack=0,“Yes”,“No”)
G Attend mock interview 4 = MAX(E3,E4,E5) = ES+ Time = LF-T ime = ProjectDuration = LF-EF =IF(Slack=0,“Yes”,“No”)
H Submit initial resume 2 =MAX(E3,E4,E5) = ES+ Time = LFTime = MIN(F11) = LF-EF =IF(Slack=0,“Yes“,“No”)
I Meet resume expert 1 = MAX(E10) =ES+ Time = LF-T ime = MIN(F12) = LF-EF =IF(Slack=0,“Yes”,“No”)
J Revise resume 4 = MAX(E11) =ES+ Time = LF-T ime = MIN(F13) = LF-EF =IF(Slack=0,“Yes“,“No”)
K Attend career fair 1 = MAX(E12) = ES+ T ime = LF-T ime =MIN(F15) = LF-EF =IF(Slack=0,“Yes”,“No”)
L Search jobs 5 = MAX(E8) = ES+ Time = LFTime =MIN(F15) = LF-EF =IF(Slack=0,“Yes”,“No”)
M Decide jobs 3 =MAX(E6,E13,E14) = ES+ Time = LF-Time =MIN(F16,F17) = LFEF = IF(Slack= 0,“Yes”,“No”)
N Bid 3 = MAX(E15) = ES+ T im e = LF-T ime = ProjectDuration = LF-EF = IF(Slack= 0,“Yes”,“No”)
O Write cover letters 10 = MAX(E7,E15) = ES+ T ime = LF -T ime = MI N(F 18) = LF-EF = IF (Slack= 0,“Yes“,“No”)
P Submit cover letters 4 = MAX(E17) = ES+ Time = LF-T ime =MIN(F19) = LF-EF =IF(Slack=0,“Yes”,“No”)
Q Revise cover letters 4 = MAX(E18) = ES+ T ime = LF-T ime =MIN(F20,F21) = LFEF =IF(Slack= 0,“Yes”,“No”)
R Mail 6 = MAX(E19) = ES+ T im e = LF-T ime = ProjectDuration = LF-EF = IF(Slack= 0,“Yes”,“No”)
S Drop 2 = MAX(E19) = ES+ T im e = LF-T ime = ProjectDuration = LF-EF = IF (Slack= 0,“Yes”, “No”)
W eek
Rang e Name Cells
Activity A3:A21
Critical? I3:I21
Brent can start the interviews in 49 days. The critical steps in the process are:
b) We substitute first the pessimistic and then the optimistic estimates for the time values
used in the part (a) spreadsheet.
The spreadsheet showing the project schedule with the pessimistic time estimates
appears below.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
A B C D E F G H I
Time Slack
Activity Description (days) ES EF LS LF (days) Critical?
A Register online 4 0 4 6 10 6No
B Attend orientation 10 010 010 0 Yes
C Write initial resume 14 014 418 4No
D Search internet 12 012 20 32 20 No
E Attend company sessions 30 030 636 6No
F Review industry, etc. 12 10 22 10 22 0 Yes
G Attend mock interview 8 14 22 66 74 52 No
H Submit initial resume 6 14 20 18 24 4No
I Meet resume expert 1 20 21 24 25 4No
J Revise resume 6 21 27 25 31 4No
K Attend career fair 1 27 28 31 32 4No
L Search jobs 10 22 32 22 32 0 Yes
M Decide jobs 4 32 36 32 36 0 Yes
N Bid 8 36 44 66 74 30 No
O W rite cover letters 12 36 48 36 48 0 Yes
P Submit cover letters 7 48 55 48 55 0 Yes
Q Revise cover letters 9 55 64 55 64 0 Yes
R Mail 10 64 74 64 74 0 Yes
S Drop 3 64 67 71 74 7No
Project Duration (days) 74
W eek
Under the worst-case scenario, Brent will require 74 days before he is ready to begin
interviewing. The critical path changes to:
The spreadsheet showing the project schedule with the optimistic time estimates
appears below.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
A B C D E F G H I
Time Slack
Activity Description (days) ES EF LS LF (days) Critical?
A Register online 1 0 1 9 10 9No
B Attend orientation 3 0 3 7 10 7No
C Write initial resume 5 0 5 7 12 7No
D Search internet 7 0 7 11 18 11 No
E Attend company sessions 20 020 020 0 Yes
F Review industry, etc. 5 3 8 10 15 7No
G Attend mock interview 3 5 8 29 32 24 No
H Submit initial resume 1 5 6 12 13 7No
I Meet resume expert 1 6 7 13 14 7No
J Revise resume 3 7 10 14 17 7No
K Attend career fair 1 10 11 17 18 7No
L Search jobs 3 8 11 15 18 7No
M Decide jobs 2 11 13 18 20 7No
N Bid 2 13 15 30 32 17 No
O W rite cover letters 3 20 23 20 23 0 Yes
P Submit cover letters 2 23 25 23 25 0 Yes
Q Revise cover letters 3 25 28 25 28 0 Yes
R Mail 4 28 32 28 32 0 Yes
S Drop 1 28 29 31 32 3No
Project Duration (days) 32
W eek
Under the best-case scenario, Brent will require 32 days before he is ready to begin
CD16-44
c) The mean critical path is the path through the project network that would be the critical
path if the duration of each activity equals its mean. We therefore first need to
determine the mean duration of each activity given the optimistic, most likely, and
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
B C D E G H
Time Estimates
Activity o m p
A 1 2 4 2.1667 0.25
B 3 5 10 5.5 1.3611
C 5 7 14 7.8333 2.25
D 7 10 12 9.8333 0.6944
E20 25 30 25 2.7778
F 5 7 12 7.5 1.3611
G 3 4 8 4.5 0.6944
H 1 2 6 2.5 0.6944
I 1 1 1 1 0
J 3 4 6 4.1667 0.25
K 1 1 1 1 0
L 3 5 10 5.5 1.3611
M 2 3 4 3 0.1111
N 2 3 8 3.6667 1
O 3 10 12 9.1667 2.25
P 2 4 7 4.1667 0.6944
Q 3 4 9 4.6667 1
R 4 6 10 6.3333 1
S 1 2 3 2 0.1111
We now substitute the mean duration for each activity for the time values used in the
part (a) spreadsheet. We obtain the following values:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
A B C D E F G H I
Time Slack
Activity Description (days) ES EF LS LF (days) Critical?
A Register online 2.167 0 2.167 6.833 9 6.833 No
B Attend orientation 5.5 0 5.5 3.5 9 3.5 No
C W rite initial resume 7.833 0 7.833 5.5 13.33 5.5 No
D Search internet 9.833 0 9.833 12.17 22 12.17 No
E Attend company sessions 25 025 025 0 Yes
F Review industry, etc. 7.5 5.5 13 9 16.5 3.5 No
G Attend mock interview 4.5 7.833 12.33 44.83 49.33 37 No
H Submit initial resume 2.5 7.833 10.33 13.33 15.83 5.5 No
I Meet resume expert 1 10.33 11.33 15.83 16.83 5.5 No
J Revise resume 4.167 11.33 15.5 16.83 21 5.5 No
K Attend career fair 1 15.5 16.5 21 22 5.5 No
L Search jobs 5.5 13 18.5 16.5 22 3.5 No
M Decide jobs 3 18.5 21.5 22 25 3.5 No
N Bid 3.667 21.5 25.17 45.67 49.33 24.17 No
O W rite cover letters 9.167 25 34.17 25 34.17 0 Yes
P Submit cover letters 4.167 34.17 38.33 34.17 38.33 0 Yes
Q Revise cover letters 4.667 38.33 43 38.33 43 0 Yes
R Mail 6.333 43 49.33 43 49.33 0 Yes
S Drop 2 43 45 47.33 49.33 4.333 No
Project Duration (days) 49.33
W eek
the critical path in part a.
CD16-46
To calculate the variance of the project duration, we turn back to the PERT template.
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
B C D E F G H I J K
Time Estimates On Mean
Activity o m p Critical Path
A 1 2 4 2.1667 0.25 Mean Critical
B 3 5 10 5.5 1.3611 Path
C 5 7 14 7.8333 2.25 = 49.333
D 7 10 12 9.8333 0.6944
= 7.722
E20 25 30 *25 2.7778
F 5 7 12 7.5 1.3611 P(T²d) = 0.99994
G 3 4 8 4.5 0.6944 where
H 1 2 6 2.5 0.6944 d = 60
I 1 1 1 1 0
J 3 4 6 4.1667 0.25
K 1 1 1 1 0
L 3 5 10 5.5 1.3611
M 2 3 4 3 0.1111
N 2 3 8 3.6667 1
O 3 10 12 * 9.1667 2.25
P 2 4 7 * 4.1667 0.6944
Q 3 4 9 * 4.6667 1
R 4 6 10 * 6.3333 1
S 1 2 3 2 0.1111
The variance of the mean critical path is 7.722.
d) We use the PERT template used in part (c). We substitute the value 60 for d in cell
e) Now the earliest start time for the career fair is day 24, and the career fair itself still
lasts one day. To ensure that the earliest start time for the career fair is day 24, we add
START
Regist er
online
A ttend
orientation
W rite initial
resume
Search
Inte rnet
Attend
company
sessions
Review
industry
Attend moc k
int erview
Submit
initial re sume
Decide
jobs
Bid W rite cove r
letters
Submit cover
letters
0
2 5 710 25
472
3
310
4
ABCDE
GFH
I
M
NO
P
Dum my 24
T
CD16-48
f) To obtain the mean critical path for the new network, we revise the part (a) spreadsheet
to account for the new dummy activity T.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
A B C D E F G H I
Time Slack
Activity Description (days) ES EF LS LF (days) Critical?
A Register online 2.167 0 2.167 9.833 12 9.833 No
B Attend orientation 5.5 0 5.5 6.5 12 6.5 No
C W rite initial resume 7.833 0 7.833 8.5 16.33 8.5 No
D Search internet 9.833 0 9.833 15.17 25 15.17 No
E Attend company sessions 25 025 328 3No
F Review industry, etc. 7.5 5.5 13 12 19.5 6.5 No
G Attend mock interview 4.5 7.833 12.33 47.83 52.33 40 No
H Submit initial resume 2.5 7.833 10.33 16.33 18.83 8.5 No
I Meet resume expert 1 10.33 11.33 18.83 19.83 8.5 No
J Revise resume 4.167 11.33 15.5 19.83 24 8.5 No
K Attend career fair 1 24 25 24 25 0 Yes
L Search jobs 5.5 13 18.5 19.5 25 6.5 No
M Decide jobs 3 25 28 25 28 0 Yes
N Bid 3.667 28 31.67 48.67 52.33 20.67 No
O W rite cover letters 9.167 28 37.17 28 37.17 0 Yes
P Submit cover letters 4.167 37.17 41.33 37.17 41.33 0 Yes
Q Revise cover letters 4.667 41.33 46 41.33 46 0 Yes
R Mail 6.333 46 52.33 46 52.33 0 Yes
S Drop 2 46 48 50.33 52.33 4.333 No
T Dummy 24 024 024 0 Yes
Project Duration (days) 52.33
W eek
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
4.16666
4.66666
6.33333
A B C D E F G H I
Time Slack
Activity Description (days) ES EF LS LF (days) Critical?
A Register online
2.16666
0 = ES+ Time = LF-T ime = MIN(F8,F9,F10) =LF-EF =IF(Slack= 0,“Yes”,“No“)
B Attend orientation 5.5 0 =ES+ Time = LFTime = MIN(F8,F9,F10) = LF-EF = IF(Slack=0,“Yes”,“No”)
C Write initial resume
7.83333
0 = ES+ Time = LF-T ime = MIN(F9,F10) =LF-EF = IF(Slack=0,“Yes”,“No“)
D Search internet
9.83333
0 = ES+ Time = LF-T ime = MIN(F15) =LF-EF = IF(Slack=0,“Yes”,“No“)
E Attend company sessions 25 0 =ES+ Time = LFTime = MIN(F17) =LF-EF = IF(Slack= 0,“Yes”,“No”)
F Review industry, etc. 7.5 = MAX(E3,E4) = ES+ Time = LF-Time =MIN(F14) = LFEF =IF(Slack=0,“Yes“,“No“)
G Attend mock interview 4.5 = MAX(E3,E4,E5) = ES+ Time = LF-Time = ProjectDuration =LFEF = IF(Slack=0,“Yes”,“No”)
H Submit initial resume 2.5 =MAX(E3,E4,E5) = ES+ Time = LF-Time = MIN(F11) = LF-EF = IF(Slack= 0,“Yes”,“No”)
I Meet resume expert 1 = MAX(E10) = ES+ Time = LF-Time = MIN(F12) = LF-EF = IF(Slack= 0,“Yes”,“No”)
J Revise resume
4.16666
=MAX(E11) = ES+Time = LFTime = MIN(F13) = LFEF = IF(Slack= 0,“Yes”,“No“)
K Attend career fair 1 = MAX(E12,E22) = ES+ Time = LF-Time = MIN(F15) = LF-EF = IF(Slack=0,“Yes”,“No“)
L Search jobs 5.5 =MAX(E8) =ES+ T ime = LFTime = MIN(F15) = LFEF = IF(Slack= 0,“Yes”,“No“)
M Decide jobs 3 = MAX(E6,E13,E14) = ES+ Time = LF-Time = MIN(F16,F17) = LF-EF = IF(Slack= 0,“Yes”,“No”)
N Bid
3.66666
=MAX(E15) = ES+Time = LFTime = ProjectDuration =LF-EF = IF(Slack=0,“Yes”,“No”)
O W rite cover letters
9.16666
=MAX(E7,E15) =ES+ T ime = LF-T ime = MIN(F18) =LF-EF = IF(Slack=0,“Yes”,“No”)
Week
CD16-49
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
B C D E F G H I J K
Time Estimates O n Mean
Activity o m p Critical Path
A 1 2 4 2.1667 0.25 Mean Critical
B 3 5 10 5.5 1.3611 Path
C 5 7 14 7.8333 2.25 = 52.333
D 7 10 12 9.8333 0.6944
= 5.056
E20 25 30 25 2.7778
F 5 7 12 7.5 1.3611 P(T²d) = 0.99967
G 3 4 8 4.5 0.6944 where
H 1 2 6 2.5 0.6944 d = 60
I 1 1 1 1 0
J 3 4 6 4.1667 0.25
K 1 1 1 * 1 0
L 3 5 10 5.5 1.3611
M 2 3 4 * 3 0.1111
N 2 3 8 3.6667 1
O 3 10 12 * 9.1667 2.25
P 2 4 7 * 4.1667 0.6944
Q 3 4 9 * 4.6667 1
R 4 6 10 * 6.3333 1
S 1 2 3 2 0.1111
T24 24 24 *24 0
Brent will be ready for his interviews within 60 days with 99.967 percent probability.
The probability that Brent will complete his project decreases slightly over the