2.1 In-Class Activity

Lab 4a - Using Z-Test to Estimate Activity Duration Question: What is the Probability that Project is completed before 67 weeks? Method: We will calculate a Z Score to determine this Probability! DATA Average 64 Standard D. Total Project 6.16 N 67 Step 1 - fill in Z Score = Te Critical Path Duration (Average) Ts Scheduled project duration Activity and Time Variances Activity a m b Optimistic Most Likely Pessimistic 1 17 29 47 2 6 12 24 3 16 19 28 Average step 2 - fill in -> SD of Total Project step 6 - write equat. Z Formula: N - Average 67 -64 3 SD of Total Project 6.16 6.16 Use Table to look up the Probability of your Answer! 8 Z Score = Probability of completing Project before (N) weeks.

Question: What is the Probability that Project is completed before 67 weeks? The Probability that we will complete this project before 67 weeks is 68.79%

Lab 4a - Using Z-Test to Estimate Activity Duration Directions: complete o Question: What is the Probability that Project is completed before 67 weeks? Method: We will calculate a Z Score to determine this Probability! DATA Average 64 Standard D. Total Project 6.16 N 67 Step 1 - fill in Z Score = Te Critical Path Duration (Average) Ts Scheduled project duration Activity and Time Variances Activity a m b Optimistic Most Likely Pessimistic 1 17 29 47 2 6 12 24 3 16 19 28 Average step 2 - fill in -> SD of Total Project step 6 - write equat. Z Formula: N - Average 67 -64 3 SD of Total Project 6.16 6.16 Use Table to look up the Probability of your Answer! 8 Z Score = Probability of completing Project before (N) weeks.

only the cells that are hilighted in yellow! Te SD for each activity Critical Path Duration ((b-a)/6}^2 30 25 step 3 - fill in 13 9 step 4 - fill in 21 4 step 5 - fill in 64 38 6.16 This number goes to formula below: Answer look up from table 0.49 68.79% Probability

Activity A Crash $ per Unit of Time $ COST $ 1,700.00 $ 40.00 $ 1,600.00 $ 10.00 $ 1,500.00 $ 33.00 $ 1,400.00 $ 40.00 $ 1,300.00 $ 36.00 $ 1,200.00 $ 170.00 $ 1,100.00 $ 200.00 $ 1,000.00 $ 70.00 $ 900.00 $ 20.00 $ 800.00 $ 700.00 Crash Point $ 600.00 Slope = $40 per Unit of Crash $ 500.00 $ 400.00 Normal Point $ 300.00 $ 200.00 5 10 15 20 25 30 35 40 TIME Activity E $ 1,700.00 $ 1,600.00 $ 1,500.00 $ 1,400.00 $ 1,300.00 $ 1,200.00 Crash Point $ 1,100.00 $ 1,000.00 $ 900.00 Slope = $ 800.00 $ 700.00 $ 600.00 $ 500.00 $ 400.00

$ 300.00 $ 200.00 5 10 15 20 25 30 35 40 Activity I $ 1,700.00 $ 1,600.00 $ 1,500.00 $ 1,400.00 Crash Point $ 1,300.00 $ 1,200.00 SLOPE = $ 1,100.00 $ 1,000.00 $ 900.00 $ 800.00 $ 700.00 $ 600.00 $ 500.00 $ 400.00 $ 300.00 $ 200.00 5 10 15 20 25 30 35 40

Normal Point 45 50 = $20 per unit of Time Normal Point 45 50

Lab4b - Crash Cost per Unit of Time Directions: first calculate the Crash $ per Unit of Time Column on Table. second, Graph Activities A, E and I. Activity A B C D Normal Cost Crash Cost Normal Time Crash Time A $ 400.00 $ 600.00 15 10 B $ 400.00 $ 450.00 10 5 C $ 600.00 $ 765.00 15 10 D $ 150.00 $ 350.00 20 15 E $ 300.00 $ 1,200.00 45 20 F $ 450.00 $ 1,300.00 30 25 G $ 700.00 $ 1,700.00 35 30 H $ 850.00 $ 1,200.00 40 35 I $ 1,000.00 $ 1,300.00 45 30 Crash $ Per Unit of Time (C - D) Formula: (B - A)

$ 300.00 $ 200.00 5 10 15 20 25 30 35 40 Activity I $ 1,700.00 $ 1,600.00 $ 1,500.00 $ 1,400.00 Crash Point $ 1,300.00 $ 1,200.00 $ 1,100.00 $ 1,000.00 $ 900.00 $ 800.00 $ 700.00 $ 600.00 $ 500.00 $ 400.00 $ 300.00 $ 200.00 5 10 15 20 25 30 35 40

Slope! SEE SAMPLE2 Tab! Time 45 50 Slope = $36 per unit of Crash Time

Lab 4c - Control Chart Mean 14.38 Standard Deviation 4.04 Mean+(3*SD) Mean-(3*SD) Upper Lower Date Measurement Mean UCL LCL 2/1/2014 17 14.38 26.49 2.27 2/2/2014 12 14.38 26.49 2.27 2/3/2014 20 14.38 26.49 2.27 2/4/2014 13 14.38 26.49 2.27 2/5/2014 13 14.38 26.49 2.27 2/6/2014 18 14.38 26.49 2.27 2/7/2014 16 14.38 26.49 2.27 2/8/2014 17 14.38 26.49 2.27 2/9/2014 17 14.38 26.49 2.27 2/10/2014 12 14.38 26.49 2.27 2/11/2014 11 14.38 26.49 2.27 2/12/2014 20 14.38 26.49 2.27 2/13/2014 12 14.38 26.49 2.27 2/14/2014 17 14.38 26.49 2.27 2/15/2014 19 14.38 26.49 2.27 2/16/2014 20 14.38 26.49 2.27 2/17/2014 10 14.38 26.49 2.27 2/18/2014 7 14.38 26.49 2.27 2/19/2014 15 14.38 26.49 2.27 2/20/2014 12 14.38 26.49 2.27 2/21/2014 6 14.38 26.49 2.27 2/22/2014 12 14.38 26.49 2.27

Directions: Complete the calculations in the yellow shaded cells. Step #1: calculate the mean in Cell E4 Step#2: calculate the standard deviation in Cell E5 Step #3: Apply the mean to all cells in the Mean column Step #4: Calculate the UCL using the formula (apply same value to all cells in column) Step #5: Calculate the LCL using the formula (apply same value to all cells in column) Step #6: hilight data in Measurements, Mean, UCL, LCL and thewn go to insert ---> insert a l Step#7: Feel free to change Chart Style, but make sure to add following title: Project Quality Sample Test Results Insert Line Graph here Answer the following questions: How would you interpret the results and why? The sample appears to be within the normal parameters of the UCL and LCL. Therefore, the sample shows no significant quality defects. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 0 5 10 15 20 25 30 Project Quality Sample Results Measurement Mean UCL LCL