Please answer the following questions using the excel sheet provided.

Example 4.1 - Single Time Estimate Immediate Predecessors P1 P2 Activity A B C D E F G Time 21 5 7 2 5 8 2 Path 1 2 3 4 1 A A A A 2 B B C C Path 1 2 3 4 1 21 21 21 21 2 5 5 7 7 A A B C C E In this example, each path through the network is identified and evaluated. The time for a path is the total time for all activities in the path. The path with the longest time is the "CRITICAL PATH." D D F In this example there are two critical pathes (AB-D-E-G) and (A-C-E-G). Activities in Path 3 4 D E D F E G F G Activity Times 3 2 2 8 5 4 8 5 2 2 5 G G 5 2 2 Total 38 35 38 35 = Critical Path = Critical Path In this example, each path through the network is identified and evaluated. The time for a path is the total time for all activities in the path. The path with the longest time is the "CRITICAL PATH." In this example there are two critical pathes (AB-D-E-G) and (A-C-E-G). = Critical Path = Critical Path Example 4.2 - Three Time Estimates Activity Time Estimates Activity Designation Expected Activity Time Variance a m b Immediate Predecessors P1 P2 Design A 10 22 28 21.0 9.00 Build prototype B 4 4 10 5.0 1.00 A Evaluate equipment C 4 6 14 7.0 2.78 A Test prototype D 1 2 3 2.0 0.11 B Write report E 1 5 9 5.0 1.78 C D Write methods report F 7 8 9 8.0 0.11 C D Write final report G 2 2 2 2.0 0.00 E F Exhibit 5.8 - Activity Estimated Times and Variances Activity Expected Designation Time Earliest Start Earliest Finish Latest Finish Latest Start Slack Time Activity Variance 9.0 A 21.0 0.0 21.0 21.0 0.0 0.0 B 5.0 21.0 26.0 26.0 21.0 0.0 C 7.0 21.0 28.0 28.0 21.0 0.0 D 2.0 26.0 28.0 28.0 26.0 0.0 E 5.0 28.0 33.0 36.0 31.0 3.0 F 8.0 28.0 36.0 36.0 28.0 0.0 0.1 G 2.0 36.0 38.0 38.0 36.0 0.0 0.0 11.9 = Variance of Critical Path 3.45 = Std. Deviation of Critical Path 35 = Project Due Date -0.87 = Calculated Z-value 0.192 = Probability of On-Time Completion 2.8 = indicates Critical path Exhibit 4.8 - Time-Cost Trade-off Example Activity Designation A B C D Normal Time 2 5 4 3 Crash Time 1 2 3 1 Normal Cost $6 $9 $6 $5 Crash Cost $10 .. $8 $9 Activity Designation Earliest Start Earliest Finish Latest Finish Latest Start A B C D 0 2 2 7 2 7 6 10 0 2 3 7 = Crashed = Critical Path Enter the number of days you would like to crash each activity below to see the impact on the total cost and project completion time. Slack Time 2 0 7 0 7 1 10 0 Total Project Cost = Time To Complete Project = Activity Cost $6 #VALUE! $6 $5 #VALUE! 10 Days Crashed 0 0 0 0 Enter the number of days you would like to crash each activity below to see the impact on the total cost and project completion time. \f\f\fAnalytics. Hercule 11-2 'Ibu mrlr hr Nolcia in 1heir global oell phone group. 'Ihu hare been made project manager hr 1he design of a newoell phone. 'Ihursupenrisors haie alreadjrsoopedre projeotso you ham-ea listshowirgreworlr brealodo'm sb'uolure and lis inoludes major projeao'uitiesjhu rmstplamhe projedsohedule and oaloula'e projeotdura'lion. 'Ihur boss warns 1he sohedule on his desk 'ornorrow rooming! 'Ibu have been given 1he irorrnaon in Eidlibit4.13. It inoludes all le aouities required in le projeotand 1heduraon ofeaohaoiuigmisoependenoies b-e'hwe-n'lheauiuies hate been identied. Rernerriaerlat 1he preoediradi'llyrmstbefulljroomlelad bebremrlr onrebllowing adi'l'groan b-esarIad. 'Ihur proje'otisdiuided inn'ie rnahrsubprojedsubprojeot'P' imahe-s deielopirspedfna'tions imhe newoell phone. Heredeoisions rela'Iadnsuoh'lirgsas baterjrliiasieeohe phone.andba1ures need!) be rn.ade.ThesedeIailsare basedon howamsbrner usesiheoell phone.These userspeoioationsare redened in Emisla'thame rneanirg'nmesub-oon'traobrs mat-Hillaomalljr rnaloe1he newoell phone in subprojeu'S' supplier speorfna'lions. These imohe engineering deaiis hr ho'mhe produotwill perbnn. The individual oorrponen'is 'lha't rnalre up ne produotare 1he bous o'fsubproject'D.' Subprojeot'r brings all'lheoorrponen'ls hgererandamrlcirg prouype is builtand'esled. Finally in subprojeot'U'.' suppliers are seleoed and oorltraois are negotiatd. Exhlblt 4.13:1II'I'Dl'l-t Breakdown Stu-nuns and AL'H'I'ltlE'S for the Cell Phone Deslgn P'I'OJECI mm mm "mm\" mm HITMTES mm [EEIEMTI' [TEENS] Produrxspecioa'tions {P} Market raearoh Pl 1 Dterall produsped'oations P2 P1 3 Hardware P3 P2 5 So'lirare P4 P3 5 Suppliermedrations {5} Hardware 51 P4 5 Sohare 52 P4 1' Produotdesignm} Eatery D1 31 1 Display D2 51 1 lDarnea D3 51 1 'Du'eroo'Le-r D4 D1. D2. D3 3 Produot inhalation {I} Hardware I1 D4 2 User in'erlaoe l2 D2 3 So'lh'are ooding l3- l2 3 Promype ling l4 l1. l3 3 Sub-oorrtraou'rgM Suppliers seleoon ".I'\"I 51.52 11] Comraot negoa'tion W H. 'U'I 1 - {Leave nobells blanlL- beoertain'boenlner'' wherever required} hilly EziHSIatTITI! EZ'IHFIHITIII! LatT-n: LFII TI'I'I! P2 _]I _I I P3 _I _EII I P4 EII _I I 51_I-EII I 52 _I \"I I D' _EII \"HI I 02 .3" \"HI I D3 .3" \"HI I D4 .431- _I I '1 .EII .EI I '2 mI -EI I l3.1".EII'ElI I *4 mI \"HI I W _I .III I W '3" .m- I l:|. Debml'ne're rrl'nirnum nurrberof'raelrs broomleng 1he project lliimnmn'herduaels E l o. l-'Indreao'uitieslatareon'meu'ioal pa'lioroormlerle projectinreshomst Q PI-PZP-PllSI-DZElrHw \"Inc PI-PZPJP-ll-SZ-UI-Wi- I P'I-P2P3-Pll-5'I-D'I-DllI'I-HW Q PI-PZP-Pll-SI-D-D'llI-HW SOLUTION a) Activity P1 P2 P3 P4 S1 S2 D1 D2 D3 D4 I1 I2 I3 I4 V1 V2 Duration 2 4 4 4 4 5 1 2 1 3 4 5 4 4 11 2 ES 0 2 6 10 14 14 18 18 18 20 23 20 25 29 19 33 EF 2 6 10 14 18 19 19 20 19 23 27 25 29 33 30 35 LS 0 2 6 10 14 17 24 18 21 22 25 20 25 29 22 33 b) Minimum number of weeks: 35 weeks c) Critical Path: P1 - P2 - P3 - P4 - S1 - D2 - I2 - I3 - I4 - V2 The slack for activities is zero as shown in the table LF 2 6 10 14 18 22 25 20 22 25 29 25 29 33 33 35 Slack 0 0 0 0 0 3 6 0 3 2 2 0 0 0 3 0 SOLUTION a) Activity P1 P2 P3 P4 S1 S2 D1 D2 D3 D4 I1 I2 I3 I4 V1 V2 Duration 2 4 4 4 4 5 1 2 1 3 4 5 4 4 11 2 ES 0 2 6 10 14 14 18 18 18 20 23 20 25 29 19 33 EF 2 6 10 14 18 19 19 20 19 23 27 25 29 33 30 35 LS 0 2 6 10 14 17 24 18 21 22 25 20 25 29 22 33 b) Minimum number of weeks: 35 weeks c) Critical Path: P1 - P2 - P3 - P4 - S1 - D2 - I2 - I3 - I4 - V2 The slack for activities is zero as shown in the table LF 2 6 10 14 18 22 25 20 22 25 29 25 29 33 33 35 Slack 0 0 0 0 0 3 6 0 3 2 2 0 0 0 3 0