Refer to the table 3-4 slide 3-5: Time estimates to the Project Paper. Complete ?the exercise using the provided formulas. Find the completion time ?using
Refer to the table 3-4 slide 3-5: Time estimates to the Project Paper.
Complete the exercise using the provided formulas. Find the completion time using PERT method as outlined on the slides. Use formulas NOT plugged-in numbers.
All necessary information and guidance are on attachments!
tutorial link
https://www.viddler.com/embed/ebd96754
3 – 1Copyright © 2017 Pearson Education, Inc.
► CPM assumes we know a fixed time estimate for each activity and there is no variability in activity times
► PERT uses a probability distribution for activity times to allow for variability
Variability in Activity Times
3 – 2Copyright © 2017 Pearson Education, Inc.
► Three time estimates are required
► Optimistic time (a) – if everything goes according to plan
► Pessimistic time (b) – assuming very unfavorable conditions
► Most likely time (m) – most realistic estimate
Variability in Activity Times
3 – 3Copyright © 2017 Pearson Education, Inc.
Estimate follows beta distribution
Variability in Activity Times
Expected activity time:
Variance of activity completion times:
t = (a + 4m + b)/6
v = [(b – a)/6]2
3 – 4Copyright © 2017 Pearson Education, Inc.
Expected activity time:
Variance of activity completion times:
t = (a + 4m + b)/6
v = [(b – a)/6]2
Estimate follows beta distribution
Variability in Activity Times
t = (a + 4m + b)/6
v = [(b − a)/6]2Probability of 1 in 100 of > b occurring
Probability of 1 in 100 of < a occurring
P ro
b a
b ili
ty
Optimistic Time (a)
Most Likely Time (m)
Pessimistic Time (b)
Activity Time
Figure 3.11
3 – 5Copyright © 2017 Pearson Education, Inc.
Computing Variance
TABLE 3.4 Time Estimates (in weeks) for Milwaukee Paper's Project
ACTIVITY OPTIMISTIC
a
MOST
LIKELY m
PESSIMISTIC b
EXPECTED TIME t = (a + 4m + b)/6
VARIANCE
[(b – a)/6]2
A 1 2 3 2 .11
B 2 3 4 3 .11
C 1 2 3 2 .11
D 2 4 6 4 .44
E 1 4 7 4 1.00
F 1 2 9 3 1.78
G 3 4 11 5 1.78
H 1 2 3 2 .11
3 – 6Copyright © 2017 Pearson Education, Inc.
Probability of Project
Completion
Project variance is computed by summing the variances of critical activities
s2 = Project variance
= (variances of activities on critical path)
p
3 – 7Copyright © 2017 Pearson Education, Inc.
Probability of Project
Completion
Project variance is computed by summing the variances of critical activitiesProject variance
s2 = .11 + .11 + 1.00 + 1.78 + .11 = 3.11
Project standard deviation
sp = Project variance
= 3.11 = 1.76 weeks
p
3 – 8Copyright © 2017 Pearson Education, Inc.
Probability of Project
Completion
PERT makes two more assumptions:
► Total project completion times follow a normal probability distribution
► Activity times are statistically independent
3 – 9Copyright © 2017 Pearson Education, Inc.
Probability of Project
Completion
Standard deviation = 1.76 weeks
15 Weeks
(Expected Completion Time)
Figure 3.12
3 – 10Copyright © 2017 Pearson Education, Inc.
Probability of Project
Completion
What is the probability this project can be completed on or before the 16 week deadline?
Z = – /sp
= (16 weeks – 15 weeks)/1.76
= 0.57
Due Expected date date of completion
Where Z is the number of standard deviations the due
date or target date lies from the mean or expected date
3 – 11Copyright © 2017 Pearson Education, Inc.
Probability of Project
Completion
What is the probability this project can be completed on or before the 16 week deadline?
Z = − /sp
= (16 wks − 15 wks)/1.76
= 0.57
due expected date date of completion
Where Z is the number of standard deviations the due
date or target date lies from the mean or expected date
.00 .01 .07 .08
.1 .50000 .50399 .52790 .53188
.2 .53983 .54380 .56749 .57142
.5 .69146 .69497 .71566 .71904
.6 .72575 .72907 .74857 .75175
From Appendix I
3 – 12Copyright © 2017 Pearson Education, Inc.
Probability of Project
Completion
Time
Probability
(T ≤ 16 weeks)
is 71.57%
Figure 3.13
0.57 Standard deviations
15 16
Weeks Weeks
3 – 13Copyright © 2017 Pearson Education, Inc.
Determining Project
Completion Time
Probability of 0.01
Z
Figure 3.14
From Appendix I
Probability of 0.99
2.33 Standard deviations
0 2.33
3 – 14Copyright © 2017 Pearson Education, Inc.
Variability of Completion Time
for Noncritical Paths
► Variability of times for activities on noncritical paths must be considered when finding the probability of finishing in a specified time
► Variation in noncritical activity may cause change in critical path
3 – 15Copyright © 2017 Pearson Education, Inc.
What Project Management Has
Provided So Far
1. The project’s expected completion time is 15 weeks
2. There is a 71.57% chance the equipment will be in place by the 16 week deadline
3. Five activities (A, C, E, G, and H) are on the critical path
4. Three activities (B, D, F) are not on the critical path and have slack time
5. A detailed schedule is available
,
Sheet1
Sample ex. | ||||||||
Example | Time Estimates (in weeks) for a Project / Cost estimates in $ | |||||||
ACTIVITY | OPTIMISTIC | MOST LIKELY | PESSIMISTIC | EXPECTED TIME | VARIANCE | |||
a | m | b | t = (a + 4m + b)/6 | [(b – a)/6]2 | ||||
A | 1 | 2 | 3 | 2 | 0.1111111111 | |||
Sheet2
3 pt estimates | PERT Method | Budget | average | variance | |||||||||
O | M | P | (O+4*M+P)/6 | (p-o)/6 | ((p-o)/6)^2 | ||||||||
rent | A | 1000 | 1300 | 2000 | 1366.6666666667 | 166.6666666667 | 27777.7777777778 | ||||||
utilities | B | 100 | 125 | 170 | 128.3333333333 | 11.6666666667 | 136.1111111111 | ||||||
parking spot | C | 40 | 50 | 75 | 52.5 | 5.8333333333 | 34.0277777778 | ||||||
1547.5 | 27947.9166666667 | Var | |||||||||||
167.1763041423 | St dev | σ | |||||||||||
estimated cost | 1547.5 | 27947.9166666667 | Variance | Sum of the errrors from the mean | |||||||||
Average | 167.1763041423 | Std Dev | z = x- u/sigma | ||||||||||
Z value | |||||||||||||
z = x-u/sigma | X | ||||||||||||
z*sigma = x- u | |||||||||||||
z= 1.64 | 2.7388 | x- 1547.5 | |||||||||||
1550.2388 | X |
Sheet4
Probabilities | ||||||
2200 | 5 | 0.1351351351 | ||||
A | 1200 | 7 | 0.1891891892 | |||
B | 1500 | 10 | 0.2702702703 | |||
C | 1800 | 15 | 0.4054054054 | |||
37 | 1 | 1 |
Sheet3
Rent | Rent | Rent | ||||||||
1500 | ||||||||||
2300 | Mean | 2193.75 | Mean | 2068.75 | ||||||
1850 | Standard Error | 200.5433467572 | Standard Error | 194.3251830971 | ||||||
3200 | Median | 2100 | Median | 1875 | ||||||
1700 | Mode | ERROR:#N/A | Mode | 1700 | ||||||
1900 | Standard Deviation | 567.2222416554 | Standard Deviation | 549.6346188931 | ||||||
2400 | Sample Variance | 321741.071428571 | Sample Variance | 302098.214285714 | ||||||
1700 | Kurtosis | -0.2454172284 | Kurtosis | 1.8521411061 | ||||||
Skewness | 0.6662596684 | Skewness | 1.3729851424 | |||||||
Range | 1700 | Range | 1700 | |||||||
Minimum | 1500 | Minimum | 1500 | |||||||
Maximum | 3200 | Maximum | 3200 | |||||||
Sum | 17550 | Sum | 16550 | |||||||
Count | 8 | Count | 8 | |||||||
Confidence Level(95.0%) | 474.2096612376 | Confidence Level(95.0%) | 459.5060406466 |
,
1 PERT Tutorial:
Suppose that you are a given the responsibility to manage a project and need to develop a budget forecast for the project, with the intention of submitting a budget request to your supervisor for approval. You have many line items in your forecast. These include deterministic items such as building rent, insurance, etc., and many probabilistic line items such as payroll, bonus payments, travel expenses, etc. Therefore, you must develop a budget based on a probabilistic approach and use statistics. Suppose your budget forecast is normally distributed, with a mean of $300,000, and a standard deviation of $10,000.
Figure 4-21
If you wanted to submit a budget for which you were 95% confident you would be able to make that budget, your calculations would be something like below.
zσ = x – μ
zσ + μ = x (1.645) ($10,000) + $300,000 = x
$16,450 + $300,000 = x $316,450 = x
Therefore, the budget submission would be for $316,450 – because there is a 95% probability that the project team will spend no more than that amount.
The question now becomes, “how did we get a normal distribution with a mean of $300,000 and a standard deviation of $10,000 in the first place?
Refer to the following spreadsheet. The first four columns show eight-line items of expenses (“Team
2
salaries,’ “Office rent,” “Travel expenses,” etc.). For each item, three forecasts are made for those expenses. The first, the “Optimistic” is the best-case scenario in terms of favorability of expenses (i.e., the least cost forecast if that situation arises). The second, “Most Likely,” is the realistic case scenario. The third, “Pessimistic,” represents the worst-case cost scenario. For “Team salaries,” the project manager believes that the size of the project team is probabilistic as some people may quit, the team may remain intact for the duration of the project, or unanticipated needs may arise and additional people may be hired. So, the least possible salary expense would be $222 thousand, the most probable expense would be $242 thousand, and the worst case situation would be $247 thousand.
Office rent is determined by contract, so it is deterministic. Each case of the three scenarios will be forecast at $9 thousand – the contracted amount.
All other line items are probabilistic, and their forecasts are so entered (in $thousands).
3
1 2 3 4 5 6 7
Expense Optimistic Most Likely Pessimistic (a + 4m + b)/6 (b-a)/6 Variance
Team salaries 222 242 247 239.50 4.17 17.36
Office rent 9 9 9 9.00 0.00 0.00
Travel expenses 8.4 18 17.9 16.38 1.58 2.51
Training expenses 0 6 9 5.50 1.50 2.25
IT maintenance share 3 4 4.7 3.95 0.28 0.08
Performance awards 0 19.6 49 21.23 8.17 66.69
Office supplies 0.1 1.27 1.4 1.10 0.22 0.05
Unplanned software 0 0 20 3.33 3.33 11.11
300.00
100.05 sum of the variances 10.00 square root of (sum of the variances)
Figure 4-22
PERT says that if the number of forecast line items is large (probably at least 30), then we are in the process of building a normal distribution curve of forecast costs. For this academic example, simulate that with just eight line items.
The next step is to calculate the mean of this curve. PERT says that the mean of each line item is the weighted average of the sum of the Optimistic value, 4 times the Most Likely value, and the Pessimistic value. This represents six weights, so divide that sum by 6 to obtain the weighted average. The formula is below.
(1*Optimistic + 4* Most Likely + 1 * Pessimistic) 6
This is often abbreviated as follows. (a + 4m + b)
6
For the first line item, “Team salaries,” the formula calculates as follows.
(1*222 + 4* 242 + 1 * 247) 6
or, 239.5. This is shown in the fifth column of Figure 4-22. All the rest of the calculations for the line items are in the fifth column. The total of these means is the mean of the budget normal distribution curve, or 300.00 – shown at the bottom of the fifth column.
To calculate the standard deviation of this curve, several steps are necessary. When forecasting the Optimistic and Pessimistic values for each line item, ensure that you are at least 99% sure that the final value will be within this range. In the “Team salaries” line item example, the forecaster is over 99%
4
certain that the actual amount spent on “Team salaries” will be within the range of $222 and $247 thous
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.