Thecritical path
Table1.1
Thecritical path is
A>C>E>I
4. The expectedduration time for each of the nine project activities
I.e. the resultin the end box which is given by the value of preceding value of taskI. =47.73
Slack for projectactivity E
S of E= lateststart –earliest start
E=43.4-43.4
=0
C.slack forproject activity C
=16.9-16.9
=0
D.Earliest starttime for project F
Project F ispreceding from project A, therefore, the latest finish for project Fwill be the earliest start for project F
=3
Latest finish G
Project G is apreceding activity to H, therefore the relationship between G and His that project activity H latest start is the latest finishofproject G
=36.4
5. Probability ofcompleting project in time.
Using Z score,
Z=(X-µ)/SD
Z-score
X-days inquestion
µ-days in
SD-standarddeviation
µ=48
X=48.033
Sd =8.35
48.0333-48)/8.35
=0.004
Using Z squaretable, we have
0.5160,
Therefore, theprobability is
51.60%
PERT CHART
3 11.25 14.25
B
7.15 4.12 18.4
16.9 12 28.9
D
18.4 1.530.4
28.9 6 34.9
G
30.4 1.5 36.4
34.9 741.9
H
36.4 1.5 43.4
033
A
0 03
3 3.916.9
C
3 016.9
16.9 26.5 43.4
E
16.9 0 43.4
43.4 4.63 48.03
I
43.4 0 48
48.033
3 3336
F
10.4 7 43.4
The critical path isA C E I
Table 1.2
QuestionC
1.
Paths time
LOPSU 2+2+3+5.5+2=14.5
MPSU 10+3+5.5+2=20.5
MQSU 10+6+5.5+2=23.5
NRTU 1.5+3+7+2=13.5
The critical pathis M Q S U
=23.5
In our criticalpath, activity S has the lowest cost to crash. Therefore we take S .
Normal time foractivity S is 5.5, we reduce it to 4.5 and the cost is 988.
The total sum inour critical value reduces to 22.5 from 23.5.the time for crashingactivity S is one, therefore, since our goal is to complete the taskWITHIN the 22 weeks, hence achieved.
Achievement ofthelowest cost possible is
1*988
=$988
QuestionC2
The number ofweeks each activity would be crashed is
For activity Scrash by one week
The rest ofactivities were not to be crashed since our goal was to complete thetask within 22 weeks.
But their crashtime was
L 1.5
M 4
N 0.5
O 0.5
P 1
Q 3
R 2
S 1
T 1
U 1.5
QUESTIONC3
The sum cost is
3000*1.5+1000*0.5+2291.667*4+1775*1+988*1+5350*3+23800*1.5+12500*0.5+6475*2+291*1
=$ 88170.668
WorkCited
Ragsdale, C. T. (2001). Spreadsheetmodelling and decision analysis: A practical introduction tomanagement science (3rd ed.)South-Western College Publishing.