Question: 5. CALCULATIONS USING SPREADSHEET E F G M 5 Task Duration Preceding (DAYS) Activities ES EF Successor Activities LS LF Float 6 1 15 None

5. CALCULATIONS USING SPREADSHEET E F G M 5 Task Duration Preceding (DAYS) Activities ES EF Successor Activities LS LF Float 6 1 15 None 0 =C6+F6 4,7 =k6-C6 =K6-G6 7 11 None 0 =C7+F7 3,7 =K7-C7 =K7-G7 wN =MIN(19,12) =MIN(18,J12) =MIN(J10,113) =MIN(J11,J13) 00 36 2 =G7 =C8+F8 5,8 =K8-C8 =K8-G8 9 4 20 1 =G6 =C9+F9 6,8 =K9-09 =K9-G9 10 5 22 3 =G8 =C10+F10 9 =K10-010 =)14 =K10-610 11 6 33 4 G9 =C11+F11 9 =K11-C11 =J14 =K11-11 12 7 21 1,2 =MAX(G6,G7) -C12+F12 9 =K12-C12 =J14 =K12-G12 13 8 25 3, 4, 10 9 =K13-C13 =J14 =K13-G13 =MAX(G8,69, =C13+F13 G15) EMAX(G10,611,412 =C14+F14 ,613) 14 9 16 5, 6, 7, 8 =K14-C14 =G14 =K14-G14 15 10 32 None 0 EC15+F15 8 =K15-C15 =J13 =K15-G15 5.1 Assignment For the project given in the previous slide: 1) Draw the AON diagram for the project. In the diagram all calculations for ES, EF, LS and LF should be performed 2) Calculate the total and free float for each activity and determine the critical path. 3) Re-perform all calculations using a spread sheet (MS Excel) and compare the calculations resulted from the AON diagram. 4) Draw a Gaunt Chart for the project plan (Activities versus Time)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Assignment 1.pdf kn For FC OG FOC FO ki cs Facil MA KULE . Ja MARLER FC KIS FECI FO De onderskei... how IWAND A Assignment 1.pdf kn For FC OG FOC FO ki cs Facil MA KULE . Ja MARLER FC KIS FECI FO De...

For the project given in the attached table; 1- Draw the AON diagram for the project. In the diagram all calculations for ES, EF, LS and LF should be performed 2- Calculate the total and free float...

5. CALCULATIONS USING SPREADSHEET A F G K M 5 Task Duration Preceding | (DAYS) Activities ES E F S LF Float Activities 15 None =k6-C6 56-G6 6 1 72 MINU9J12) MINUB12) 11 None 3,7 =K7-C7 K7-G7 K8-C8...

Duration (DAYS) Preceding Task ES EF Successor Activities LS LF Float Activities 1 30 30 0 30 0 None None 2 0 0 10 | | | 45 25 10 30 10 55 55 4,7 3,7 5,8 6,8 9 15 25 30 25 70 55 15 15 0 1 15 3 55 70...

E F G K M 5 Duration Preceding Task (DAYS) Activities ES EF Successor Activities LS LF Float 6 1 30 None 0 =C6+F6 4,7 =K6-C6 -MIN(J9.J12) =K6-G6 2 10 None 0 -C7+F7 3,7 =K7-G7 N00 3 45 2 -G7 -C8+F8...

Based on table below, do the following: 1. Draw the network diagram. Sequence the activities based on the dependency. 2. Using the forward pass, determine ES and EF 3. Using the backward pass,...

I am have trouble with questions 10-12 trying to figure out what the best approach is and how to solve it. Submitted earlier, but I don't know if there wasn't enough information. Activity B 10...

Time Estimate in weeks 4 1 Activity A B D E F G H I J K L M N o Q R S T 2 1 0 0 7 4 2 2 3 4 2 12 3 2 2 5 1 4 DIRECTIONS Use the data provided to fill in the Template worksheet attached. Show...

please attempt all 6 parts of this single question a1,2 b1,2 c1,2 thankyou For each of the problems listed below, determine the following values for each activity: the earliest start time, earliest...

Can you please solve this as soon as possible I have only 30 min for it, subject: engineering management drawing AOA 1. Draw the AOA chart. (sketch it on paper. Do the FP and BP calculations then...

In the article ''Using EDE, ANOVA and Regression to Optimize Some Microbiology Data'' (Journalof Statistics Education, Vol. 12, No. 2, online), N. Binnie analyzed bacteria-culture data collected by...

What happens to the variability of Wirco's profit if Wirco undertakes any strategy (buying calls, selling puts, collars, etc.) to lock in the price of copper next year? You can use your answer to the...

All of the following concerning extension of time to file are correct EXCEPT A . If the required payment is made by credit card by the regular due date for the return, the return can be filed any...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...