Question

Answer these questions for the following simple set of project tasks. Task times are shown in hours w a. What is the expected

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Ans a.=14 hours

Ans b=3 hour

Ans c= 2 hour

Activity Time Pred 1 Pred 2
A 1
B 3
C 3 A B
D 5 C
E 8 C
Results
Activity Early Start Early Finish Late Start Late Finish Slack
A 0 1 2 3 2
B 0 3 0 3 0
C 3 6 3 6 0
D 6 11 9 14 3
E 6 14 6 14 0
Project 14
Early start computations
A 0 0
B 0 0
C 1 3
D 6 0
E 6 0
Late finish computations
A B C D E
A 14 14 14 14 14
B 14 14 14 14 14
C 3 3 14 14 14
D 14 14 9 14 14
E 14 14 6 14 14
3 3 6 14 14

Formulas

Data Immediate Predecessors
Activity Time Pred 1 Pred 2
A 1 =IF(A6<>TRIM(A6),"WARNING: There are blank characters in the activity name","")
B 3 =IF(A7<>TRIM(A7),"WARNING: There are blank characters in the activity name","")
C 3 A B =IF(A8<>TRIM(A8),"WARNING: There are blank characters in the activity name","")
D 5 C =IF(A9<>TRIM(A9),"WARNING: There are blank characters in the activity name","")
E 8 C =IF(A10<>TRIM(A10),"WARNING: There are blank characters in the activity name","")
Results
Activity Early Start Early Finish Late Start Late Finish Slack
=A6 =MAX(C22:D22) =B6+B14 =E14-B6 =B35 =D14-B14
=A7 =MAX(C23:D23) =B7+B15 =E15-B7 =C35 =D15-B15
=A8 =MAX(C24:D24) =B8+B16 =E16-B8 =D35 =D16-B16
=A9 =MAX(C25:D25) =B9+B17 =E17-B9 =E35 =D17-B17
=A10 =MAX(C26:D26) =B10+B18 =E18-B10 =F35 =D18-B18
Project =MAX(C14:C18)
Early start computations
=A6 =IF(ISNUMBER(VLOOKUP(TRIM(C6),$A$14:$C$18,3,FALSE)),VLOOKUP(TRIM(C6),$A$14:$C$18,3,FALSE),0) =IF(ISNUMBER(VLOOKUP(TRIM(D6),$A$14:$C$18,3,FALSE)),VLOOKUP(TRIM(D6),$A$14:$C$18,3,FALSE),0)
=A7 =IF(ISNUMBER(VLOOKUP(TRIM(C7),$A$14:$C$18,3,FALSE)),VLOOKUP(TRIM(C7),$A$14:$C$18,3,FALSE),0) =IF(ISNUMBER(VLOOKUP(TRIM(D7),$A$14:$C$18,3,FALSE)),VLOOKUP(TRIM(D7),$A$14:$C$18,3,FALSE),0)
=A8 =IF(ISNUMBER(VLOOKUP(TRIM(C8),$A$14:$C$18,3,FALSE)),VLOOKUP(TRIM(C8),$A$14:$C$18,3,FALSE),0) =IF(ISNUMBER(VLOOKUP(TRIM(D8),$A$14:$C$18,3,FALSE)),VLOOKUP(TRIM(D8),$A$14:$C$18,3,FALSE),0)
=A9 =IF(ISNUMBER(VLOOKUP(TRIM(C9),$A$14:$C$18,3,FALSE)),VLOOKUP(TRIM(C9),$A$14:$C$18,3,FALSE),0) =IF(ISNUMBER(VLOOKUP(TRIM(D9),$A$14:$C$18,3,FALSE)),VLOOKUP(TRIM(D9),$A$14:$C$18,3,FALSE),0)
=A10 =IF(ISNUMBER(VLOOKUP(TRIM(C10),$A$14:$C$18,3,FALSE)),VLOOKUP(TRIM(C10),$A$14:$C$18,3,FALSE),0) =IF(ISNUMBER(VLOOKUP(TRIM(D10),$A$14:$C$18,3,FALSE)),VLOOKUP(TRIM(D10),$A$14:$C$18,3,FALSE),0)
Add a comment
Know the answer?
Add Answer to:
Answer these questions for the following simple set of project tasks. Task times are shown in...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • HW12: Project Mgmt。 Saved Problem 15-4 Answer these questions for the following simple set of project tasks. Task times are shown in hours. Skipped eBook Print References a. What is the length of th...

    HW12: Project Mgmt。 Saved Problem 15-4 Answer these questions for the following simple set of project tasks. Task times are shown in hours. Skipped eBook Print References a. What is the length of the critical path? 1hou Length of thecriticalpath「 b. What are the earliest start and latest start for E? points Earliest start th/nd hour Latest stat thind hour Sklpped eBook Print References c. What is the latest start for B? test stat th/nd hour d. If all other...

  • Please explain step by step because I do not understand this problem. Thank You! Problem 15-4...

    Please explain step by step because I do not understand this problem. Thank You! Problem 15-4 Answer these questions for the following simple set of project tasks. Task times are shown in hours. a. What is the length of the critical path? b. What are the earliest start and latest start for E? c, what is the latest start for B? d. If all other tasks are completed in their expected durations, will the project length be affected if task...

  • Boise Slale University - Logging S Connect C Gel Homework Help With Chegy X + 2...

    Boise Slale University - Logging S Connect C Gel Homework Help With Chegy X + 2 X 2 c ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fblackboard.boisestate.edu%252Fwebap... u s Apps M Gmail O YouTube Maps C 30 Healthy Pasta Re.... Q CH.11 (test 3) Flash... iMindTap - Cengage... S Micron Tech Project... Q Econ ch 19-22 Flas... 14 Non-invasive Meth.... Answer these questions for the following simple set of project tasks. Task times are shown in hours. A 6 B 4 wm a. What is the expected...

  • Answer the following questions based on the PERT chart below with task times given in hours....

    Answer the following questions based on the PERT chart below with task times given in hours. [All answer should be given as a single number only without units]. Answer the following questions based on the PERT chart below with task times given in hours [All answer should be given as a single number only without units] A(5) E(5) Start B1) D(8) H(4) End C(6) G(3) 1(7) a. The number of priority lists that can be created for this project is...

  • Assume that for this project to be completed, five independent tasks must be completed. These tasks...

    Assume that for this project to be completed, five independent tasks must be completed. These tasks are proceeding in parallel by five different subcontractors. To keep it simple, let's assume that each task takes between 1 and 5 months to complete (uniformly distributed, i.e. equally likely to take any amount of time between 1 and 5 months). So, the mean time to complete each task is 3 months and the probability of any given task taking 3 months or longer...

  • Consider a project having the following six activities:                                  

    Consider a project having the following six activities:                                                      Immediate                                                  Max        Crash cost             Activity                           Predecessors           Time (weeks)             Crash*    per week                   A                                none                                    6                          6                N/A                   B                                none                                    5                          2               $500                   C                                A                                       3                          2             $1000                   D                                A, B                                    4                          2             $2000                   E                                 C, D                                    5                          2             $1250                   F                                D                                       6                          2             $1000                                                                                                 *Shortest possible time for the task 1. Draw the project network and list...

  • Consider a project having the following six activities:                                  

    Consider a project having the following six activities:                                                      Immediate                                                  Max            Crash cost             Activity                           Predecessors          Time (weeks)             Crash*    per week                   A                                none                                    7                          7         N/A                   B                                none                                    3                          2        $500                   C                                A                                       5                          3      $1000                   D                                A, B                                    6                          4      $2000                   E                                 C, D                                    4                          3      $1250                   F                                D                                       3                          2      $1000                                                                                                 *Shortest possible time for the task 1. Draw the project network and list...

  • The following information is provided for the tasks on a project. Times are in days. Task...

    The following information is provided for the tasks on a project. Times are in days. Task Time Predecessor A 12 B 21 B, C F 15 G 5 F, G H 17 [Select ] The critical path is [Select ] The time to complete this project will be The slack for task G is Select ] If the duration on task A increases by three days, how long will the project take to complete? I Select ]

  • 39. Consider the following project, and answer the next 5 questions based on this data: Task...

    39. Consider the following project, and answer the next 5 questions based on this data: Task ID Duration (Days) Predecessors 2 70 - 3 30 2 4 120 3 5 120 2 6 120 5 7 120 3,6 8 150 3,6 9 115 3,6 10 130 7,9 11 90 7,9 12 30 7,9 13 120 7,9 14 75 10 15 30 14 16 85 6 17 165 16 18 90 16 19 90 17,18 20 20 8,11,13,15,19 What is the...

  • Consider the following set of activities: Time Predecessor Activity Required Activities A 5 None B 4...

    Consider the following set of activities: Time Predecessor Activity Required Activities A 5 None B 4 A C 5 B D 8 B E 9 C F 6 C,D G 8 D H 3 E,F,G a.     Draw the CPM network for this problem. b.     Calculate and summarize the earliest and latest start and finish times, the slack for each activity, and the critical activities. c.     What is the earliest time that the project can be completed? d.     If the project needed to be completed...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT