Question

1. Make a pert chart out the data Table #1: Patio Deck Re-Build Project Activity Time Activity Identity Milestones Activity's Immediate Predecessor (What activity must occur before this one...) (davs) ZA None A в 3c B D B JE B B E GG B 1н B 91 B 20 A 2K B B Bidding Phase Complete Estimate w/Plans Receive City Biddine Permits Receive Bid from Excavator 1 Receive Bid from Excavator 2 Receive Bid from Excavator 3 Receive Bid for Concrete (Mason) Receive Bid from Carpenter 1 Receive Bid from Carpenter 2 Receive Bid from Carpenter 3 Receive Bid from Plumber 1 Receive Bid from Mechanical Contractor 1 Receive Bid from Mechanical Contractor 2 Approval Phase Approve Excavator 2 Rid Approve Concrete Bid Approve Carpenter 1 Bid Approve Plumber Bid Approve Mechanical Contractor Bid 1 Work Phase Excavate Patio Foundation (Excavator) Pour Concrete Footings (Mason) Concrete Cure Time (Mason Construct Patio (Except Railing) (Carpenter) Install Spa (Mechanical Contractor) Install Plumbing (Plumber) Wire Electrical (Mechanical Contractor) Complete Patio (Railing Completed), Landscape (Me) Ordering/Order Acceptance Phase CDE EM IN F 20 GHI T 1P 20 KL ER MN S R T IS 4U 0,T V U W Р IX 10 4Y TU

Answer 1

Project Schedule:

Excel Formulation is as follows,

Yello Highlight: MIlestone

Orange: Critical path

R - Critical Path =IF(Q9-0,"Y", "N") =IF(Q10=0,"Y", "N") =IF(Q11=0,"Y", "N") =IF(Q12=0,"Y", "N") ..... =IF(Q13=0,"Y", "N" ... =IF(Q14:0,"Y", "N" ... =IF(Q15-0,"Y", "N") =IF|Q16=0 "Y" "N" =IF(Q17=0,"Y", "N") =IF(Q18=0,"Y", "N") =IF(Q190,"Y", "N") =IF(Q20=0,"Y", "N") – 1 نيا 6 7 =IFQ22=0,"Y", "N") =IF(Q23-0,"Y", "N") =IF(Q24=0, "Y", "N") =IF(Q25=0,"Y", "N") =IF(Q26=0,"Y", "N") =45 A B C D E FL M N O P 6 Predecessors Dural 7 ID Task Name (Enter one ID per cell) ES EF LS LF Slack n 8 Bidding 0 =M8+L8 =IF(P8-L8<0,0,P8-L8) =IF(ROUND(P8-N8,5)<0,0,ROUND(P8-N8,5)) 9 1 A 7 =MAX( T9: Y9) =M9+L9 =IF(P9-LS<0,0,P9-L9) =010 =IF(ROUND(P9-N9,5)<0,0,ROUND(P9-N9.5)) 10 =A9+1 B 11 3 =MAX(T10:Y10 =M10+L10 =IF(P10-L 10<0,0,P10-L101 =MIN(O11:017,019:020) =IF(ROUND(P10-N10,5)<0,0,ROUND(P10-N10,5)) 11 = A10+1 2 3 =MAXI T11:Y11) =M11+L11 =IF(P11-L110,0,P11-L 11) =022 =IF(ROUND(P11-N11,5)<0,0,ROUND(P11-N11,5)) fum 12 =A11+1 D 2 4 =MAX(T12:Y12) =M12+L 12 =IF(P12-L12<0,0,P12-L12) =O22 =IF(ROUND(P12-N12,5)<0,0,ROUND(P12-N12,5)) - 13 = A12+1 E Грана 2 Hoa 5 24 =MAX(T13:Y13) =M13+L13 =IF/P13-L 13<0,0,P13-L 13) =022 =IF(ROUND(P13-N13,5)<0,0,ROUND(P13-N13,5)) 14 =A13+1 F 2 COMMON 7 =MAX(T14:Y14) -M14+L 14 =IF P14-L 14<0,0,P14-L14) =023 =IF(ROUND(P14-N14,5)<0,0,ROUND(P14-N14,5)) 15 =A14+1 G 2 6 =MAX( T15: Y15) =M15+L15 =IF/P15-L 15<0,0,P15-L15) =O24 =IF(ROUND(P15-N15,5)<0,0,ROUND(P15-N15,5)) 16 =A15+1 ce H 2 Hoon 7 =MAX(T16:Y16) =M16+L16 =IF(P16-L16<0,0,P16-L16) =O24 =IF(ROUND(P16-N16,5)<0,0,ROUND(P16-N16,5)) 17 = A 16+1 2012 2 F 5 =MAX(T17:Y17) -M17+L17 =IF(P17-L17<0,0,P17-L17) =MIN(O24,025 =IF(ROUND(P17-N17,5)<0,0,ROUND(P17-N17,5)) . 18 =A17+1 J Cro170.0000170 2 =MAX(T18:Y18) -M18+L18 =IF(P18-L18<0,0,P18-L18] I=MAXIN9:N20 =IF(ROUND(P18-N18,5)<0,0,ROUND(P18-N18,5)) 19 =A18+1 IK 2 2 40 =MAX(T19:Y19) =M19+L 19 =IF(P19-L 19<0,0,P19-L 19) =026 =IF(ROUND(P19-N19,5)<0,0,ROUND(P19-N19,5)) 20 =A19+1 L 2 3 =MAX(T20:Y20) =M20+L20 =IF(P20-L20<0,0,P20-L20) -026 =IF(ROUND(P20-N20,5)<0,0,ROUND(P20-N20,5)) 21 =A20+1 Approval =MAX(T21Y21) =M21+L21 =IF(P21-L2K0,0,P21-L21) =IF(ROUND(P21-N21,5)<0,0,ROUND(P21-N21,5)) 22 =A21+1 M 4 15 7 =MAX(T22:Y22) =M22+L22 =IF(P22-L22<0,0,P22-L22) =O28 =IF(ROUND(P22-N22,5)<0,0,ROUND(P22-N22,5)) 23 =A22+1 N 1 =MAX(T23:Y23) =M23+L23 =IF(P23-L230,0,P23-L23) =028 =IF(ROUND(P23-N23,5)<0,0,ROUND(P23-N23,5)) 24 = A23+1 8 9 2 =MAX(T24:Y24) =M24+L24 =IF(P24-L24<0,0,P24-L24) =MIN(O31,038 S =IF(ROUND(P24-N24,5)<0,0,ROUND(P24-N24,5)) 25 =A24+1 IP 19 1 =MAX(T25:Y25) =M25+L25 =IF(P25-L25<0,0,P25-L25) =O33 =IF(ROUND(P25-N25,5)<0,0,ROUND(P25-N25,5)) 26 =A25+1 Q 11 12 L! 2 =MAX(T26:Y26) -M26+L26 =IF(P26-L26<0,0,P26-L26) =MAX($N$22:$N$26) FOTOVO =IF(ROUND(P26-N26,5)<0,0,ROUND(P26-N26,5)) 27 = A26+1 Work Phase =MAX(T27:Y27) =M27+L27 =IF(ROUND(P27-N27,5)<0,0,ROUND(P27-N27.5)) 28 =A27+1 R 14 15 3 =MAX(T28:Y28) =M28+L28 =IF(P28-L28<0,0,P28-L28] =029 =IF(ROUND(P28-N28,5)<0,0,ROUND(P28-N28,5)) 29 =A28+1 S 20 1 no =MAX(T29: Y29) =M29+L29 =IF(P29-L29<0,0,P29-L29) -030 =IF(ROUND(P29-N29,5)<0,0,ROUND(P29-N29,5)) 30 =A29+1 T 21 7 =MAX(T30:Y30) -M30+L30 10 Ano =IF(P30-L30<0,0,P30-L30) =MAX($N$28:$N$35) =IF(ROUND(P30-N30,5)<0,0,ROUND(P30-N30.5)) 31 =430+1 U 16 22 4 =MAX(T31:Y31) -M31+L31 =IF(P31-L310,0,P31-L31) =MIN(O32,035,044) =IF(ROUND(P31-N31,5)<0,0,ROUND(P31-N31,5)) 32 =431+1 V 23 3 =MAX( T32:Y32) =M32+L32 =IF(P32-L32<0,0,P32-L32) =046 =IF(ROUND(P32-N32,5)<0,0,ROUND(P32-N32,5)) 33 - A32+1 -A32+! W 17 4 =MAX(T33:Y33) =M33+L33 4 =IF(P33-L33<0,0,P33-L33) =IF(ROUND(P33-N33,5)<0,0,ROUND(P33-N33,5)) 34 = 433+1 X ROOF 16 1 =MAX(T34:Y34) =M34+L34 =IFIP34-L34<0.0 P34-L34) EMAAL 134. 13! M3*-+ L000,F34134 35 A34+1 =O46 Гете =IF(ROUND(P34-N34,5)<0,0,ROUND(P34-N34,5)) Y 22 23 4 =MAX(T35:Y35) =M35+L35 =IFIP35-L 35<0.0.P35-L35 AAA WOULU LOOKUUF 30-L30 =MAX(N28:N35) 36 = A35+ =IF(ROUND(P35-N35,5)<0,0,ROUND(P35-N35,5)) VO ROU Ordering Order phase =MAX(T36:Y36) -M36+L36 =IF(P36-L36<0,0,P36-L36 OLOX00, 30-LJOJ =MAX($N$8:$N$49) =IF(ROUND(P36-N36,5)<0,0,ROUND(P36-N36,5)) 37 =436+1 2 1. 2 1 =MAX(T37:Y371 =M37+L37 =38 SHA! =IF(P37-L37<0,0,P37-L37) Hot! 38 = 4374 -U30 =IF(ROUND(P37-N37,5)<0,0,ROUND(P37-N37,5)) 0 PRO AA 2 16 1 =MAX( T38:Y38) =M38+L38 =IF(P38-L38<0,0,P38-L38) =040 =IF(ROUND(P38-N38,5)<0,0,ROUND(P38-N38,5)) 39 = 438+1 BB 29 Wor De 7 =MAX(T39:Y39) =M39+L39 FALA =IF(P39-L39<0,0,P39-L39) =MAX($N$8:$N$49) =IF(ROUND(P39-N39,5)<0,0,ROUND(P39-N39,5)) 40 = 439+1 CC 30 * 9 =MAXI T40:Y40) M40+L40 WAA 10.1 Norte =IF(P40-L40<0,0,P40-L40) =MAX(N37:N40) =IF(ROUND(P40-N40,5)<0,0,ROUND(P40-N40,5)) 41 = A40+1 107 Payment Phase =MAX(T41:Y41) =M41+L41 FIFTROUNDIP41-N41.5 0.0 ROUNDIP41-N41.511 42 =A41+1 DD DD 20 15 =MAX(T42:Y42) =M42+L42 |=IF(P42-L42<0,0,P42-L42] =MAX($N$8:$N$49) =IF(ROUND P42-N42,5 <0.0, ROUNDP42-N42,51) 43 = A4241 FE 1. PR147! CE 22 30 =MAXI T43:Y431-M43+L43 IMAN.COMPTICATER =IF(P43-L430,0,P43-L43) =MAX($N$8:$N$49) =IF(ROUNDP43-N43,5 <0,0 ROUNDP43-N43,5) 44 =A43+1 FF 17 10+ 23 15 =MAX(T44:Y44) -M44+L44 =IF(P44-L44<0,0,P44-L44) =MAX($N$8:$N$49) =IF(ROUNDP44-N44,5)<0,0 ROUND(P44-N44,5) Prin OD 44-44,0 UURUNDIP44-N44,3 45 = 444+1 GG LG 25 30 T! =MAXI T45:Y45) M45+L45 MAX 140: 1401 |=1145+243 =IF(P45-L45<0,0,P45-L45) =MAX($N$8:$N$49) =IF(ROUND(P45-N45,5)<0,0,ROUND(P45-N45,5)) 40 40+! 46 = 445+1 HH 24 26 30 =MAX(T46: Y46) =M46+L46 =IF(P46-L46<0,0,P46-L46) =MAX($N$8:$N$49) =IF(ROUND(P46-N46,5)<0,0,ROUND(P46-N46,5)) 47 =A46+1 Utilization Phase T! =MAX(T47:Y47) -M47+L47 =IF(P47-L47<0,0,P47-L47) =MIN(BS47:D147) =IF(ROUND(P47-N47,5)<0,0,ROUND(P47-N47.5)) 48 =A47+1 26 12 =MAX(T48:Y48) =M48+L48 =IF(P48-L48<0,0,P48-L48) =MIN(BS48:D148) =IF(ROUND(P48-N48,5)<0,0,ROUND(P48-N48,5) 49 =A48+1 JJ 40 =MAX(T49:Y49) =M49+L49 =IF(P49-L49<0,0,P49-L49) =MAX($N$8:$N$49) =IF(ROUND(P49-N49,5)<0,0,ROUND(P49-N49,5)) 50 TIT =IFQ28=0,"Y", "N") =IF(Q29-0,"Y", "N") =IF(Q30=0,"Y", "N") =IF(Q31=0,"Y", "N") =IF(Q32=0,"Y", "N") = IF(Q33=0"Y", "N") =IF(Q34-0,"Y", "N") =F34=U, 1.NT =IFIQ35-0 "Y", "N") QUIN =IF(Q36=0,"Y", "N") Fr[23-J. I , T ] =IFIQ37=0 "Y". "N") =IF(Q38=0."Y", "N") =IF(Q39=0,"Y", "N") =IF(Q40=0,"Y", "N") PITTIIN 1 1 =IFQ42-0,"Y", "N" =IF(Q43-0,"Y", "N") =IF(Q44:0,"Y", "N") =IF(Q45-0,"Y", "N") =IF(Q46=0,"Y", "N") II =IF(Q48=0,"Y", "N") =IF(Q49=0,"Y", "N")

Solution:

Example of EF precedesor formula is as follows,

1 نيا - 1 2 Approval 1 1 M12+L12 IFIR 31-INDEVIEN$8.$$49.MATCH(C31$A$8:$4$49 m MAXIT32.7321 6 Predecessors Duration ID Task Name ES EF 7 (Enter one ID per cell) (exp. time) EF of Predecessors 8 Bidding 0 =M8+L8 =IF(C8="". O,INDEX($N$8:$N$49.MATCH(C8,$A$8:$A$49,0}]] 91 A 7 =MAX(T9:Y9) =M9+L9 =IF(C9=""OINDEX($N$8:$N$49, MATCH(C9,$A$8:$A$49,0}]] 10 10 - A9+1 B 3 =MAX( T10:10) =M10+L10 =IF(C10=""O,INDEX($N$8:$N$49.MATCH(C10,$A$8:$A$49,0}]] 11 =A10+1 C 2 =MAX(T11:Y11) =M11+L11 =IF(C11=""O,INDEX($N$8:$N$49.MATCH(C11,$A$8:$A$49,0}]] 12 = A11+1 D 2 4 =MAX(T12:Y12) MAVIT 127 128 =IF(C12=""OINDEX($N$8:$N$49,MATCH(C12,$A$8:$A$49,011) 13 =A12+1 E W211 13 2 MAYIT12.121 5 드 =M13+L13 =MAX(T13:Y13) =IF(C13=""O,INDEX($N$8:$N$49.MATCH(C13,$A$8:$A$49,0))) 10.- 14 |=A13+1 F 2 7 MAVITVA =MAX( T14:Y14) MA =M14+L14 =IF(C14="O,INDEX($N$8:$N$49.MATCH(C14,$A$8:$A$49,0))) 15 111 G 15 =A14+1 2 6 MHE. MAVIT 15.7161 =MAX(T15:Y15) =M15+L15 =IF(C15=""O,INDEX($N$8:$N$49.MATCH(C15,$A$8:$A$49,0))) 16 - A15+1 10 A 16. u MAVITAC4CM 101 H 2 7 =MAX(T16:16) =M16+L16 =IF(C16="O,INDEX($N$8:$N$49.MATCH(C16,$A$8:$A$49,0))) 17 A 10.1 17 = A 16+1 12 5 =MAX( T17:Y17) =M17+L17 =IF(C17="" OLINDEX($N$8:$N$49,MATCH(C17 $A$8:$A$49,0}]] 10 1 17.1 1 MAVITO, 401 18 |=A17+1 40.116 J 2 =M18+L18 =MAX(T18:Y18) =IF(C18="" OLINDEX($N$8:$N$49.MATCH(C18,$A$8:$A$49,0}]] 19 =A18+1 K MAVIT 10.101 MOI 10 2 2 =M19+L19 =MAX(T19:19) =IF(C19="" O,INDEX($N$8:$$49.MATCH(C19,$A$8:$A$49,0]]] 20140 IN 20 20 =A19+ L 3 =MAX(T20:Y20) =M20+L20 =IF(C20=""O,INDEX($N$8:$N$49.MATCH(C20,$A$8:$A$49,0}]] 200 wivu 21 = A20+1 =MAX(T21: Y21) =M21+L21 =IF(C21="O,INDEX($N$8:$N$49, MATCH(C21,$A$8:$A$49,0}]] MAVIT. von M21 22 221A 22 )=A21+1 M 3 4 5 7 =MAX(T22:Y22) =M22L22 =IF(C22=""O,INDEX($N$8:$N$49.MATCH(C22,$A$8:$A$49,0}]] 2. 23 = A22+1 N 6 b =MAX(T23:Y23) -M23+L23 =IF(C23=""OINDEX($N$8:$N$49.MATCH(C23,$A$8:$A$49,0))) 24 =A23+1 U 7 8 19 2 =MAX(T24:Y24) =M24+L24 =IF(C24=""O,INDEX($N$8:$N$49.MATCH(C24 $A$8:$A$49,0}]] . 25 =A24+1 P 9 =MAX(T25: Y25) =M25+L25 =IF(C25="OINDEX($N$8:$N$49.MATCH(C25,$A$8:$A$49,0))) A. 26 = A25+1 Q 11 12 2 =MAX(T26: Y26) M26+L26 =IF(C26=""O,INDEX($N$8:$N$49.MATCH(C26,$A$8:$A$49,0}]] 22 27=A26+1 Work Phase =MAX(T27:Y27) =M27+L27 =IF(C27=""O,INDEX($N$8:$N$49.MATCH(C27 $A$8:$A$49,0}]] 2017 B 28 = A27+1 14 15 3 =MAX(T28:Y28) =M28+L28 =IF(C28=""O,INDEX($N$8:$N$49.MATCH(C28,$A$8:$A$49,0}]] 29 = A28+1 S 20 =MAX(T29:Y29) -M29+L29 =IF(C29="OINDEX($N$8:$N$49.MATCH(C29,$A$8:$A$49,0))) 30 100. 30 = A29+1 T 21 7 =MAX(T30:Y30) -M30+L30 =IF(C30=""O,INDEX($N$8:$N$49.MATCH(C30,$A$8:$A$49,0}]] 100 31 =A30+1 U 16 22 4 =MAX(T31:Y31) =M31+L 31 w 22 32 =431+1 V 23 3 =IF(C32=""O,INDEX($N$8:$N$49.MATCH(C32,$A$8:$A$49,0}]] 17 33 = A32+1 W 17 4 =MAX(T33:Y33) =M33+L33 =IF(C33=""O,INDEX($N$8:$N$49.MATCH(C33,$A$8:$A$49,0}]] 34 =A33+1 X 16 =MAX(T34:Y34) =M34+L34 =IF(C34=""O,INDEX($N$8:$N$49.MATCH(C34$A$8:$A$49,0}]] 35=434+1 22 23 4 =MAX(T35:Y35) =M35+L35 =IF(C35=""O,INDEX($N$8:$N$49.MATCH(C35,$A$8:$A$49,0}]] 36 =435+1 Ordering Order phase ROUT! =MAX(T36:Y36) =M36+L36 =IF(C36=""O,INDEX($N$8:$N$49.MATCH(C36,$A$8:$A$49,0}]] 37 =A36+1 Z 2 =MAX(T37:Y37) =M37+L37 =IF(C37=""O,INDEX($N$8:$N$49.MATCH(C37 $A$8:$A$49,0}]] 38 = A37+1 AA 2 16 =MAX(T38:Y38) =M38+L38 =IF(C38=""O,INDEX($N$8:$N$49.MATCH(C38,$A$8:$A$49,0}]] 39 =438+1 BB 29 7 =MAX(T39:Y39) =M39+L39 =IF(C39=""O,INDEX($N$8:$N$49.MATCH(C39,$A$8:$A$49,0}]] oo 40 =439+1 CC 30 9 =MAX(T40:Y40) =M40+L40 =IF(C40=""O,INDEX($N$8:$N$49.MATCH(C40,$A$8:$A$49,0}]] Гm Prime 41 |=A40+1 Payment Phase =MAX( T41:Y41) =M41+L41 =IF(C41="O,INDEX($N$8:$N$49.MATCH(C41,$A$8:$A$49,01]) 42=A41+1 DD 20 15 =MAX(T42:Y42) =M42+L42 SAL..14 =IF(C42=""OINDEX($N$8:$N$49.MATCH(C42,$A$8:$A$49,0))) 43 =A42+1 EE 22 30 Sv. =MAX(T43:Y43) -M43+L43 =IF(C43=""OINDEX($N$8:$N$49.MATCH(C43,$A$8:$A$49,0))) 44 = A43+1 FF 23 15 =MAX(T44:Y44) FM44+L44 =IF(C44=""O,INDEX($N$8:$N$49.MATCH(C44,$A$8:$A$49,0}]] ΕΝΟ! 45=A44+1 GG 25 30 =MAX(T45:Y45) =M45+L45 =IF(C45=""OINDEX($N$8:$N$49,MATCH(C45,$A$8:$A$49,011) 46 - 445+1 HH 24 26 30 =MAX(T46:Y46) -M46+L46 =IF(C46=""OINDEX($N$8:$N$49,MATCH(C46,$A$8:$A$49,011) 47=446+1 Utilization Phase MAXI T47:Y47) =M47+L47 =IF(C47="" O,INDEX($N$8:$N$49.MATCH(C47 $A$8:$A$49,0}]] 48 =447+1 II 26 2 =MAX(T48:Y48) =M48+L48 =IF(C48="",0,INDEX($N$8:$N$49, MATCH(C48,$4$8:$A$49,0}]] 49 - A48+1 JJ 40 =MAX(T49:Y49) =M49+L49 =IF(C49=""OINDEX($N$8:$N$49,MATCH(C49,$A$8:$A$49,011) 1 1 1 1 1 ΕΠ

Critcal Path is as follow,

ID Task Name Dur atio n (exp. time ES EF LS LF Slack Critical Path Predecessors (Enter one ID per cell) 7 9 1 1 7 0 0 7 10 10 1 3 7 0 2 8 А B H O 2 7 17 10 0 16 7 8 9 2 19 0 0 7 10 17 33 37 37 19 U 22 4 37 0 16 23 22 16 24 31 32 35 38 40 46 50 17 33 37 37 7 10 17 19 37 40 41 20 29 70 3 Y Y Y Y Y Y Y Y Y Y 40 0 4 23 24 27 30 32 38 41 0 V Y AA CC |НН 23 2 1 16 1 20 0 19 20 9 20 0 30 24 29 70 26 30 40 40 0

The project duration is 70 days.

If you like the answer please give an up-vote, this will be quite encouraging for me, thank you.
If you have further suggestions in answer, please write below on the comment section, I will certainly look into it.