M2 PORTA-VAC

xlsx

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

Report
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