M2 PORTA-VAC
xlsx
keyboard_arrow_up
School
National University College *
*We aren’t endorsed by this school
Course
608
Subject
Industrial Engineering
Date
Feb 20, 2024
Type
xlsx
Pages
9
Uploaded by DvS_soLDieR
Activity List for the PORTA-VAC Proje
Activity
Description
Immediate Predecessor
A
---
B
---
C
Prepare routing
A
D
Build prototype
A
E
A, B
F
C
G
D
H
B, E
I
H
J
F, G, I
Porta-Vac Project
Develop product design
Plan market research
Prepare marketing brochure
Prepare cost estimate
Do preliminary design testing
Complete Market survey
Prepare pricing and forecast report
Prepare final report
ect
Note: This 6
Instructions: 1. Draw the PERT Diagram on a separate sheet of paper based on this Activ
2
3
2. Check the next sheet ("Project Flow") for a solution and compare your wo
5
3
3. Continue to the "Project Flow" sheet for further instructions.
2
3
4
2
2
Estimated Completion Time (weeks)
is not the correct map…
vity List.
ork!
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Format
Example
Slack
1
Z
3
3
4
3
6
6
C
9
10
3
13
0
A
6
0
6
D
11
0
6
6
7
5
12
Start
6
E
9
6
3
9
0
B
2
4
4
2
6
Note: Activity Times are listed on the Activity List.
Step 1:: Insert the activity times under the activity names, "Actitivity Duration" as shown in the Form
Step 2: Perform a forward pass -- computing the Earilest Start and Earliest Finish times. Insert thes
Step 3: Perform a backward pass -- computing the Latest Finish and Latest Start times. Insert these
Step 4 Calculated the slack time for each activity. Insert this in the YELLOW box.
Step 5: Determine the Critical Path.
Then, proceed to the next sheet to determine the RISK of the project.
Porta-Vac Project
Earliest Start
Activity Name
Earliest Finish
Latest Start
Activity Duration
Latest Finish
Instructions: (see class notes for more details)
4
9
F
11
4
15
J
17
13
2
15
15
2
17
1
11
G
14
1
12
3
15
0
9
H
13
0
13
I
15
9
4
13
13
2
15
Questions:
1. What is the expected completion time?
mat example above.
se in the TOP row.
e in the BOTTOM row.
2. Where is the Critical Path? (describe by the series of letter for the activ
0
Finish
0
17
A-E-H-I-J
vities on the Crtical Path)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Instructions:
Complete the tables below to answer the questions to the right.
(see formulas and hints in green Activity
Pessimistic (b)
A
4
5
12
6
1.78
0.00
B
1
1.5
5
2
0.44
4.00
C
2
3
4
3
0.11
2.00
D
3
4
11
5
1.78
1.00
E
2
3
4
3
0.11
0.00
F
1.5
2
2.5
2
0.03
4.00
G
1.5
3
4.5
3
0.25
1.00
H
2.5
3.5
7.5
4
0.69
0.00
I
1.5
2
2.5
2
0.03
0.00
J
1
2
3
2
0.11
0.00
Expected
Goal to complete =
20
weeks
Probability to comp
Probability to complete Critic
Probability to complete all p
Porta-Vac Project
Data given by Porta-Vac Production Leaders
Optimistic (a)
Most Probable (m)
Expected Completion Time (weeks)
Variance (weeks^2)
Slack (weeks)
Questions:
to the right)
A-E-H-I-J
A-C-F-J
A-D-G-J
B-H-I-J
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
d completion time=
17
13
16
10
weeks
(Hint: Try =
Path variance=
2.720
2.030
3.920
1.270
weeks-squared
(Hint: Sam
Path StDev=
1.65
1.42
1.98
1.13
weeks
(Hint: take
z-score=
1.818
4.916
2.021
8.847
plete within Goal =
96.5%
100.0%
97.8%
100.0%
cal Path on-time =
96.5%
paths by the goal =
94.5%
Note: All tasks must be completed on time, not just the C
Hint: Change the goal in cell D21, then paste the answers
1. What is the probability that this project will be completed within the
2. What is the probability that this project will be completed faster, wit
On critical Path? (Yes=1 or No=blank)
Path 1 (Yes=1 or No=blank)
Path 2 (Yes=1 or No=blank)
Path 3 (Yes=1 or No=blank)
Path 4 (Yes=1 or No=blank)
Note: P = NORM.S.DI
Note: Standard-Norm
94.5%
83.0%
=SUMPRODUCT(Path,Expected Completion Time)
me =SUMPRODUCT as above)
e the square-root of the variance. =SQRT(x)
Critical Path. Therefore, P(all) = P1 * P2 * P3 * P4
s above.
e goal o
thin 19 IST(z-score,TRUE), with TRUE to use the Cumulative Distribution. mal Distribution has a Mean=0 and StDev=1.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help