The problems for this week are 11.1, 11.2 and 11.3. This assignment must be in Excel QM (network diagrams can be in Excel or hand drawn and scanned) and submitted through the Assignment.
11.1) Consider the project with the following estimates for activity times and precedence relationships:
Activity 
Optimistic
Time 
Most
Likely Time 
Pessimistic
Time 
Immediate
Predecessor(s) 
A 
3 
4 
5 
— 
B 
5 
7 
9 
— 
C 
2 
3 
10 
A 
D 
2 
5 
8 
B 
E 
1 
7 
7 
B 
F 
3 
5 
7 
C, D 
G 
7 
8 
9 
D, E 
H 
2 
6 
10 
F 
(a) What is the expected duration of the project?
(b) What is the project variance?
(c) If the deadline of the project is 25 days, what is the probability of finishing the project on time?
11.2) A small software development project has five major activities. The times are estimated and provided in the table below.
Activity 
Immediate
Predecessor 
a 
m 
b 
A 
— 
2 
5 
8 
B 
— 
10 
10 
10 
C 
A 
4 
7 
10 
D 
B 
2 
5 
14 
E 
C 
3 
3 
3 
(a) What is the expected completion time for this project?
(b) What variance would be used in finding probabilities of finishing by a certain time?
(c) Draw a network diagram for the project.
11.3) Given (Time in weeks):
Activity 
Optimistic 
Most Likely 
Pessimistic 
A 
3 
4 
5 
B 
6 
7 
14 
C 
2 
3 
10 
D 
6 
9 
12 
E 
4 
5 
12 
F 
1 
3 
11 
G 
1 
2 
9 
H 
2 
5 
8 
I 
1 
4 
7 
Review the network diagram (see attached) to answer this question.
Determine:
(a) the critical path.
(b) the probability that the project will be completed in 22 weeks.
The rubric for problems is below:
Criteria 
Excellent 
Average 
Poor 
Points 
810 points 
67 points 
15 points 
Submission fully addresses questions listed in the problem. Answer is consistent and supported by Excel QM spreadsheets/results. 
Response fully answers all parts listed in the question. Answer is consistent and supported by Excel QM spreadsheets as a separate document. All calculations are shown. 
Response partially answers all parts listed in the question. Answer is consistent and supported by Excel QM spreadsheets as a separate document. Most calculations are shown. 
Response partially answers few parts listed in the question. Answer is not consistent with supporting Excel QM spreadsheets. Most or all calculations not provided. 
There must be a written response to each part of the question. This can be inside the corresponding Excel QM spreadsheet. 
Each part of each question is fully answered and explained. All Excel QM or additional calculations are shown if they required. 
Most questions are fully answered and explained. All Excel QM or additional calculations are shown if they required. 
Few question are answered and explained. Few to no Excel QM or additional calculations are shown if they required. 
Academic Integrity and Syntax:
Academic Integrity
Spelling and grammar 
Work is original.
Adheres to all spelling and grammar rules 
Work is original
Few grammar and spelling errors 
All or portions of the work are not original
Follows few or does not follow grammar and spelling rules 
Timely submission 
Entire assignment successfully submitted through Turnitin on or before due date. 
Most of the assignment submitted, on or before due date. 
Part or entire assignment submitted within 3 days after the due date. 
