Reference no: EM132128598
Case: Project Management
NOTE: Use Excel Spreadsheetto carry on this project. Only ONE file is needed for the project. You can use several sheets within the same file.
- (ODD GROUPS)Dream Team Productions, a firm hired to coordinate the release of the movie Paycheck (starring Uma Thurman and Ben Affleck), identified 16 activities to be completed before the release of the film.
The tasks (in time units of weeks) are as follows:
Activity
|
Immediate Predecessors
|
Optimistic Time
|
Most Likely Time
|
Pessimistic Time
|
A
|
-
|
1
|
2
|
4
|
B
|
-
|
3
|
3.5
|
4
|
C
|
-
|
10
|
12
|
13
|
D
|
-
|
4
|
5
|
7
|
E
|
-
|
2
|
4
|
5
|
F
|
A
|
6
|
7
|
8
|
G
|
B
|
2
|
4
|
5.5
|
H
|
C
|
5
|
7.7
|
9
|
I
|
C
|
9.9
|
10
|
12
|
J
|
C
|
2
|
4
|
5
|
K
|
D
|
2
|
4
|
6
|
L
|
E
|
2
|
4
|
6
|
M
|
F, G, H
|
5
|
6
|
6.5
|
N
|
J, K, L
|
1
|
1.1
|
2
|
O
|
I, M
|
5
|
7
|
8
|
P
|
N
|
5
|
1
|
9
|
a. For each activity, calculate the mean and variance of activity duration time
b. Draw(electronically) the AON project network (use excel spreadsheet).
c. Using the mean activity times, conduct a CPM analysis and develop an activity schedule for this project using early and late start and finish times, compute activity slack time, and define the critical activities. What is the expected (i.e. mean =Tavg) project completion time? The standard deviation of the completion time?
d. What is the probability the project will be completed in time for the company to release the film within Tavg +1 week?
e. What date results in a 97% probability of completion?
2. (EVEN GROUPS)Bill Fennema, a president of Fennema Construction, has developed the tasks, durations, and predecessor relationships in the following table for building new motels.
Activity
|
Immediate Predecessor(s)
|
Time Estimates (in weeks)
Optimistic Most Likely Pessimistic
|
A
|
-
|
4
|
8
|
10
|
B
|
A
|
2
|
8
|
24
|
C
|
A
|
8
|
12
|
16
|
D
|
A
|
4
|
6
|
10
|
E
|
B
|
1
|
2
|
3
|
F
|
E, C
|
6
|
8
|
20
|
G
|
E, C
|
2
|
3
|
4
|
H
|
F
|
2
|
2
|
2
|
I
|
F
|
6
|
6
|
6
|
J
|
D, G, H
|
4
|
6
|
12
|
K
|
I, J
|
2
|
2
|
3
|
a. What is the expected (estimated) time and variance for each activity?
b. Draw (electronically)and analyze the AON network for the project. Use excel Spreadsheet.
c. Identify the critical path(s).
d. What are the expected (mean) and variance of the time to complete the project?
e. What is the probability of completion of the project before week 37?
f. What date results in a 99% probability of completion?