Quantitive Network Diagram
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 | 8-10 points | 6-7 points | 1-5 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 Turn-it-in 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. |
