ࡱ> rq @\pMechanical Engineering Dept. Ba= =Z:"8X@"1.Times New Roman1.Times New Roman1.Times New Roman1.Times New Roman1.hTimes New Roman1.Times New Roman1.Times New Roman1.Times New Roman1.Times New Roman1.'Times New Roman1.Times New Roman1.ITimes New Roman1.ITimes New Roman1. Times New Roman1.ITimes New Roman1.Times New Roman1.Times New Roman"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *  "       @ @  !@ @  !@ @  !!@ @  @  !@ "0""@ @  @*     "8"@@ "8 " @ `R? Task ListCRelationship DiagramkTime Table-Forward Pass }Time Table Backward Pass%Time Table Find Critical PathӢ Gantt Chart`i .8C<#.b.$ZUYmJ^f$%%-n-$ZUYmJ^f$%%PNG  IHDRwcsBIT3 sRGB pHYs+-tIDATx^흿ypWt+ 23… Nei *!45J€΅BV;@(C×/g;䒳YXww~?|gH>\@FqO}Zw5|/ƽw !whG~~ty}mx1:QWŽ=~xyҽ>ʳܹܲʩ"se=.]A,_2/^H\`tH ɩKm0chx5b׍fvc#30ؗӭ'6y\<"Gȍescg~ȔgD-ddӎdWמML_&+\FryNmQ'}fsQ6׎AQ\ci,fh28akL|f3- fu(}mqrH\t|vQ߶`4`=ίʙ1Ѝ KF_#e0KzڜO>tTt#A49M/#EW!{j"WQ[kzݢG)^ CIⱚ{?o|ǽOy}q_W_W_飦zܗ/>G0q~ `=ίqүϲ׌v蚵_2zS7g}Mҕ? 2'A OT{{Yh<Ӟ1f5 ΐrӕ IwWkoh8"<{9\Q씫WB:o٩φY[|MvJ^+qlΟ!ri67*y\;ek:XwqU%=qٸ:OvیmY8ޢ3fszyYlN2Yl6"]It-,H6#f]V.ljYȺ *)c ׬vINGH75=cƥLWWWةzׄwJN7kz)]~{Dvݫ+^矸Zսw6g,g5HvGni^]|}Wj2G.som'ÿ6_u˟Pכnoݿ^E[FwHvd}]s 8s%!t5kb8}$U՜Inh}WHhzаu5WTe WTEmWr=?vWM&WWM6~a_%7!m+W;RǏJ~jNWML;w H/M݅,_|\x5'UsDT[}NZ⌷A4j+꿹n &9R4udp\lu.h2]ugF.}7^Z;E| |iJ?Ȣk?vN׺ʋ?ʵ Yn}G>iνqi;_ծVgͺqj_}f=w\knj#\2Qus{Ac ˿6D8/ZZ2u\WO5klM]GN\w9qlpdX$^DڬJvt=8H˷S𚩫V8)[ 7>;-qŭ#e?Ѵڲس=6Ӎ׸ƚ)ⰭTys.󲵱խȽ={8z+SN暳۪=84Ǚ<[;ze¨R9ݒr.Ȧ ] %/?uoU.LuO6rdpe*8]sGz\s[c=GQ2kWT5\=;Y }'}i`ߠ|D_oq%A>xj(iyKzh޽^kvͭ*^cy$xdK[&s0O;X7o o1vDm c^aLY)(骽] isn{+i?9%z;zb!na ly\#qyq8 ̓$=}dԊyqDO o1q[Y]&\7SoO8w#E4DR o syp\1ufw0bST~"<ڝ䂇x^ϫ=f5)`ZQUy^߷^Ie c@,IrWjw?f Uokj5.\bձX=jwm?l3e7ï۞?38}L?ަHY?^dgHVfn7{W=w>=hj{WqçVJ=sÝ?n~-^pQ8 >C!WRNC;M0XA[*iq B+q+Q8 44P@`4n4@!P=O}zp?yp/0 ףqN ᧿nD 5eGT$il# qpȉ4\vPݶwJ1S91 FN${^Gd#kzgc*yX;dN.Lwm97_r`^4V8y}z)BNYq/0벧 e,o-~},R}>׸E|i^QX;b:[R90)H"n^ԩfL9ǼŧSqYƩ'v$,MkvFYj/X@IEA>[}R&C[R'[>3l]}m9L;? % `1ML?|v$4)V@1\& [@8=tqi-X,-IVMdQwbpՉ#ak5k\ Eǭzq}4Ǟ},ɱe4-2{,npSzW;qlgX̪J˒Ki?1i֒LUl*' 4PϘb~b$PL),-< 4(mac֒C*Gd-/-?v2HoԞ Z1xOR?iK# OG#M4Mj{cj_.GJ%0w yb,s={/^秸p}985_s>/~ig\)Kи;&@wyTO>8&Pƍ=}b]sck4nڑDQN1C`5WØǀ2ۧ&Fl>ȳ*RQ_Y ڣY[àV`~eS}~60uXqc !g=Q[JFŠ}oDf8štPž$99 #PFd֓IIլ~4[;&c s v_$P@,I" 5X2+@[Hxv9yފÕc2Ui4WLBu qkz5F@`3{+%7,.[Յ*^ CQi+qn{\1@욣n&Ic`z@fYq\"pMn! 'Y[6W-e_3Ӝhrv e1@[,$t 'p+ BH@@иoj&]|8 P34 1 q5G 41L9q@fh\7@c @5(q7^15 ,8+C,is!+&]}颬W@i K6U!P 9dƗ,) &SGd_J*qwZW?T2dp"LTkUҟ]MT ۖ=: fM Ot?L),"LMeIq̒9L*f.MmF?eߑ;xܬmߑ ZĂ(3W .gX1 p:W㾛g]tUѸt?YFOe@"h݅!pWf5dqw<']ϐ @,']ϐ U>v\X܎2g") O`oߑ{!#G kn<7%p<dئRkbrW7ݔ0 Xq%rcfdH1@zk4.N宱czkZNfj)j2i2h\Y%|6*uЎe/qNk+5l*Z^Jl;\U4JMKxy27K=<9 p쭔gb &; ً ,7z8v ˝}͚(Wt{dYOKW`=Zx"?9x7\al&ƭFGE@и !иw ,@2W9)Sα~n*n5l]Iٓ@˱xC7)0dpU3KR !3w pL4nbI\7KʷMjG0م2.M RBۂə`c sb!PLt!gee` i'AA+g,/s_OQdíceUa{M ;'PLbq T =I|գY UnL0SD ,2,a}Mܩ{6Ըu;PƵֵ3Q$JL6>l]i'7ڔ\][8jtD$1mT7,`r0qu# 8YO&?ɩel+)dzͱ`uk"q5E/ns*=y){+pͱm˜s6+yܝ| yw㖄qh:YYZeU7{Ѹ!,Wj9 /4n_Kۗ7A@Moи}y /]5hWK #XqլExtK.|C zAS2RxZ~)1C`5.`æ3>~ӟh  Xfd~*DGa˅5.Gw{^uh(J"Ni0'R# '%PXNJ!Z jk"/@&h\M@ $1& q5G "cYDJ(́}Kņv x?bGuXqI"ӻȹ#PKV/{.mmiA&e4nVJB~cKgA1@Vj\>[IfqgAiʾʟ^Mk%^G% hK |av&R㜕}n;"hyU@Om-=ԃv6֌w^$ 縹# p[5NeνE.s,cJ&A[!y\fkVMU8Ss[?iLXef"N:ԸkNecԕga0W]˜ʼn29 fY)#Xqfp㬣pK_A%ɖ\XTxRVtMzSuF;X~+B0Q~LY \l^L`L`Dva Pr| Q)0}kp`{5ey5i`Yh wN9M܇F`VZ;@ 1$ q5G 41L`uU7 }gQ(E5.ځv fZ|OU\ؓ[dң<]~H@.ndg}ٿY(P+5\\#kW%KKf|c٧V۷%SGd_~%񈻳fkPJڨ2fؖ#5".,9f$([~,"/*G`s CmYN%mDKm/LkSg@ A> VPL#5ubF9֗jV˄ qcɑ`sbwH`sK2˒™%Ef\qkc'oktA#qu%ꙸ q̌rع4u^7и,) Q5~5IT U6:7{LYb ̺P0ʥljqEkf"Zr%^U%ŘlE:^ݴ(cF"SDOb>kܾ dNHvL0tIZA#kjݜAXkq U&"3MnH5wN`\7Xwb'rS3 >˵LnbSvo,d$Y}W=/E`Vnw.X wa< 0Cc@5@j.AhcWst @@иoj&]|8 P34 1 q5G 41L9q@fh\7@c @5@j.AhcWst @@иoj&]|8 P34 1 q5G 41L9q@fh\7@c @5@j.AhcWst @@иoj&]|8 P34 1 q5G 41L9q@fh\7@c @5@j.AhcWst @@иoj&]|8 P34 1 q5G 41L9q@fh\7@c @5@j.AhcWst @@иoj&]|8 P34 1 <5{o OIo{Քƽw Ը! P/X7x\.hWst @@иoj&]|8 P34 1 q5G 41L9LTF2;n/ v޳[2NeuPnYKn{l иPǕ9lh8299:\K !#@l@vҍU>po7pDZT#upa*h9W&M/wػ[7XSӱ4A @u&2E 5# n"lq|b?t@6K@9*mN@HuLH.Ձ,2DoE=4.34( dn v8qBQ/PЈF/i:(d?k)(3Mi9 ʲX=;?{cg!/x8F P34 zcz_>gdʆ4$4O|j9':?ĺ vO֎>]MUĪ}:%ۇ3@"9(lDY@иC# qY@иC# qY@иC# qY@иC# qY@}G# %P6 EA pV8 x YIENDB`3  @@  YActivity DescriptionTimeESTEFTLSTLFTSlack Criticality(days)ABCDEFGHIJKLMNegotiate contractPreliminary missile designFabricate guidance systemTest guidance systemDesign guidance systemDesign missile frameDesign missile fuel systemDesign rocket engineCPM Project Management Example0=+E7=+E8=+E10=MAX(E9,E11:E13)=+E14=+E15=+E16 =MAX(E17:E18)=D7+C7=D8+C8=D9+C9=D10+C10=D11+C11=D12+C12=D13+C13=D14+C14=D15+C15=D16+C16=D17+C17=D18+C18=D19+C19 Cell Formulas=G8-C8=G9-C9=G10-C10=G11-C11=G12-C12=G13-C13=G14-C14=G15-C15=G16-C16=G17-C17=G18-C18=G19-C19=G7-C7=E19=F19=F18=F17 =MIN(F15:F16)=F14=F8 =MIN(F11:F13) =MIN(F9:F10)-ABM Design Project - Time Table, Forward Pass.ABM Design Project - Time Table, Backward Pass:ABM Design Project - Time Table, Determining Critical Path/ABM Design Project - Basic Relationship DiagramABM Design Project - Task ListCPM Project Management Example11Ragsdale, Cliff T., Spreadsheet Modeling and Decision Analysis, A Practical Introduction to Management Science, Course Technology, Inc., Cambridge, MA, 1995Select missile configurationFinal missile design/Fabricate missile frame, fuel system and engine*Test missile frame, fuel system and engineAssemble completed missileb39 s9L9{9::D;;x;;<=> @ @vC  dMbP?_*+%;";??U} @$;;;;;; ; ; ; ; ;;;;;;@ R Q          T        U  V    W    X !S"""""""""(@T >@ 7 @ =II  dMbP?_*+%;M\\Dunnlab\HP LaserJet 8000 Seri?dXXLetter.HP LaserJet 8000 Series PCL 62(xe.DauC7\"-1",0<@/t:]hxK;W9EN hpSaId2q dvRمw+!$ lƣf}^*\+LCgQ"Te>L&>8_I#䃶^IIIH>I; !Q"iA[!C,r:;B4 bCM&ř؝{v9w-@"MfH %#_a{zE'ؼbnH^ >@b=k" P c뮲=*?6;8uC#?Nh LwNbA-^ j"dXX??Uw;  PD8;(  6^ Y # ] ` ^V2  S  @Y]`0 jj  s *v @"J]`v <C<n<^ F ##  ] #`l^V2  S  @F]`pp  0Lv @7]`Lv <H<n<^ R !# =z] !`^V2  S  @R]`pp  0v @C]`v <F<n<^ &mW "# U] "`^V2  S  @&mW]`@pp   0v @6#^H] `v <G<n<^   # ]  `^V2   S  @] `dpp   0v @] `v, <D<n<^ u7{ #  n ] ` ^V2   S  @u7{] `pp   0v @Gl] `vP <B<n<^ `_ # G z9 ] `0^V2  S  @`_]`pp  0pv @po]`pvt <A<n<^ r %# G 1 9 n] %`T^V2  S  @r]`pp  0v @]`v <J< n<^ xN &#  U GI] &`x^V2  S  @xN]`pp  0v @?]`v <K<n<^  '#   1  n] '`^V2  S  @]` pp  0Lv @]`Lv  <L<n<^ 0Jw (#  G 9 ] (`!^V2  S  @0Jw]`<"pp  0v @@Zh]`v# <M<n<^ N $# d UU] $`#^V2  S  @N]``$pp  0@7 @ Pqyz  dMbP?_*+%;M\\Dunnlab\HP LaserJet 8000 Seri?dXXLetter.HP LaserJet 8000 Series PCL 62(xe.DauC7\"-1",0<@/t:]hxK;W9EN hpSaId2q dvRمw+!$ lƣf}^*\+LCgQ"Te>L&>8_I#䃶^IIIH>I; !Q"iA[!C,r:;B4 bCM&ř؝{v9w-@"MfH %#_a{zE'ؼbnH^ >@b=k" P c뮲=*?6;8uC#?Nh LwNbA-^ j"dXX??U} } #} } } `}    w ; J  J  ; ; ; ; ; ; ; ; ; ; ; ; J  M       #6$  @@ LL  )  ~ F@@DH@ ! *  ~ O@H@D[@ " +  T~ (@ H@D N@ " ,  ~ Q@ N@ D  ``@  # -  ~ ^@ N@ D  f@  # .  ~ @X@ N@ D  c@  # /  U~ M@( f@ $% B @n@  $ 0  V~ c@@n@ D y@  % 1  ~ W@@n@D u@ % 2  W~ ?@y@D{@ & 3  ~ F@u@Dw@ ' 4  X~ @P@#{@ %B@ ( 5&@F& (  x  6Hv +@>'nI]`Hv3 <Key Points: The forward pass -- The earliest start time (EST) for the initial activity in a project is time zero. * The earliest start time of an activity is equal to the latest (or maximum) earliest finish time (EFT) of the activities directly preceding it. * The earliest finish time of an activity is equal to its earliest start time plus the time required to perform the activity.<>@ 7 @ Q~=  dMbP?_*+%;";?? TU} } #} } } } @} } @  w ; J  J  J  ; ; ; ; ; ; ; ; ; ; ; ; J  N         #6 $       @@ LL LL@D  C  J  ~ F@@DH@@#H@ % B  7  L  ~ O@H@D[@ @^@ f@D   8  I  T~ (@ H@D N@  H@# N@  % B 9 K  ~ Q@ N@ D  ``@  \@  f@ D  : I  ~ ^@ N@ D  f@  N@  f@ D  ; I  ~ @X@ N@ D  c@ U@  f@ D  < I  U~ M@( f@ $% B @n@  f@# @n@  %B = H  V~ c@@n@D y@ @n@y@D  >  G  ~ W@@n@D u@Pr@ @x@D  ?  F  W~ ?@y@D{@y@{@D  @  E  ~ F@u@Dw@@x@{@D  A  E  X~ @P@#{@ %B@{@@D  B  D(T Tz*0 (   ~  <4v +@>' %]`4v3 <Key Points: The backward pass * The latest finish time (LFT) for the final activity in a project is equal to its earliest finish time as determined by the forward pass. * The latest finish time for any other activity is equal to the earliest (or minimum) latest finish time of the activities directly following (or succeeding) it. * The latest start time of an activity is equal to its latest finish time minus the time required to perform the activity.<< >@  7 @ bU  dMbP?_*+%;";?? TU} } #} } } } @  w ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;  O            @@ LL LL@D LL + !L  ** B**  ~ F@@DH@@#H@ % B **  ~ O@H@D[@ @^@f@ D @R@   T~ (@ H@D N@  H@# N@  % B   **  ~ Q@ N@ D  ``@  \@  f@ D  J@      ~ ^@ N@ D  f@  N@  f@ D      **  ~ @X@ N@ D  c@ U@  f@ D  :@      U~ M@( f@ $% B @n@  f@ # @n@ %B     **  V~ c@@n@D y@ @n@ y@D   **  ~ W@@n@D u@Pr@@x@DI@(   W~ ?@y@D{@y@{@D, **  ~ F@u@Dw@@x@{@DI@4   X~ @P@#{@ %B@{@@D8 **&{@~QT@<(  ~  <v +@>' ]`v8 <Key Points: Determining the Critical Path * Critical activities have zero slack and cannot be delayed with delaying the completion of the project. * Non-critical activities have some positive amount of slack that represents the amount of time by which the start times of these activities can be delayed with delaying the completion of the entire project, assuming that all predecessor activities start at their earliest start times. <S)~~  <Ȍv +@>   ]`Ȍv8 68<7Calculating Slack: Slack for activity i = LSTi - ESTi <8- /%4 5 6>@7 @   dMbP?_*+%;";??4U} } #} } } } @  w ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;  O              @ @ LL LL@D LL@ + !L  ** B**   ~  F@ @DH@@#H@ % BH **   ~  O@ H@D[@ @^@f@ D @R@P    T~  (@  H@D N@  H@# N@  % B  T **   ~  Q@  N@ D  ``@  \@  f@ D  J@  \     ~  ^@  N@ D  f@  N@  f@ D    `  **   ~  @X@  N@ D  c@ U@  f@ D  :@  h     U~  M@(  f@ $% B @n@  f@ # @n@ %B   l  **   V~  c@ @n@D y@ @n@ y@D t  **   ~  W@ @n@D u@Pr@@x@DI@|    W~  ?@ y@D{@y@{@D **   ~  F@ u@Dw@@x@{@DI@    X~  @P@# {@ %B@{@@D **&{@~QP(  ~  < +@> (]`6 R<SCreating Gantt Charts in Excel This Gantt chart is a stacked horizontal bar chart that plots the EST and the time required to perform each activity. However, the bars for the EST for each activity are formatted so that they do not appear on the graph - giving the illusion that only the activity times are being graphed. To create a Gantt chart like this one: 1. Select the range covering the Description, Time and EST columns for all activities (shown in light green). 2. Click the Insert menu. 3. Click Chart. Excels ChartWizard then prompts for a number of selections concerning the type of chart and how it should be formatted. Select the icons to display a stacked horizontal bar chart. When finished with the ChartWizard, the order of the bars needs to be reversed. To do this: 1. Right Click on the Activities axis and select the Format Axis menu. 2. Select the Scale tab. 3. Click the Categories in reverse order checkbox. 4. Make certain the Number of categories between tick-mark labels value is set to 1. Finally, double click any of the bars representing the EST of any activity, select the Patterns option and select no borders and no area patterns. The basic Gantt chart is now complete. The chart can be further customized by clicking any element and specifying options in the resulting dialog boxes. < ,   ?    ^ 0 iP   F  h v  d x "  Rxp  6NMM? I]`;  @";??3` 34& `  `  ` @` t3d23 M NM4  3QQ ;Q ;Q3_ M NM  MM<4E4  3QQ ;Q ;Q3_4E4D $% MP+3O& Q4$% MP+3O& Q4FA 3O^ 3 bP P PZR R R RR RV Vd#M& SS43*@@#M& ! M4% )zMZ3O"S&Q  Activities'4% 8 IM3O."&Q  Days'4523  NM43" 4SS4% RM3O%-&Q 0ABM Design Gantt Chart'4SS 4 eee ~v  <A@AA? U1]&; >@7 Oh+'0@Hp Mechanical Engineering Dept.sofMechanical Engineering Dept.sofMicrosoft Excel@4sJ@U՜.+,0` PXx  :University of WyomingCh  Task ListRelationship DiagramTime Table-Forward PassTime Table Backward PassTime Table Find Critical Path Gantt Chart  Worksheets  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`bcdefghjklmnopRoot Entry F@kWorkbookSummaryInformation(aDocumentSummaryInformation8i