Question
A project requires 10 tasks to be completed (A-J), but some can only begin after others have been completed (see predecessors in table) and diagram.
A project requires 10 tasks to be completed (A-J), but some can only begin after others have been completed (see predecessors in table) and diagram.
The table provides three-time estimates for each task: the minimum possible time, the maximum possible time, and the most likely time to be used in the triangular distribution. It also provides the weighted mean of these three values given a triangular distribution.
Use the MEAN column to analyze the project completion time using the critical path method. Simulate the project using the triangular distribution to find a 95% confidence interval for completion time. The formula for the triangular distribution is provided in table below along with an example calculation.
Based on your thousand replications, what are the probabilities for each possible critical path in this project?
Example: | 5 | 8 | 15 | 8.7 | |
Task | Predecessor | Minimum | Most likely | Maximum | Mean |
A | 0.5 | 1 | 2 | 1.1 | |
B | 1 | 2 | 4 | 2.2 | |
C | 1.5 | 3 | 6 | 3.3 | |
D | A | 2 | 4 | 8 | 4.3 |
E | B | 2.5 | 5 | 10 | 5.4 |
F | B | 2 | 4 | 8 | 4.3 |
G | C | 3 | 6 | 12 | 6.5 |
H | D,E | 3 | 6 | 12 | 6.5 |
I | G | 1 | 2 | 4 | 2.2 |
J | F,H,I | 1.5 | 3 | 6 | 3.3 |
RN1 | Sample |
0.3105532849 | 8.05 |
**PLEASE SHOW ALL EXCEL WORK**
B C D E F F G H I J B C D E F F G H I J
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started