Question: 5. CALCULATIONS USING SPREADSHEET A F G K M 5 Task Duration Preceding | (DAYS) Activities ES E F S LF Float Activities 15 None

5. CALCULATIONS USING SPREADSHEET A F G K M 5

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 MIN101131 KB-GB =K9-09 MIN(11,113) K9-G9 -10-10 14 K10-610 0 =C6-F6 =C7-F7 G -C8F8 5,8 66 09+F9 6,8 -G8 - 10-F10 -69 -C11-F119 =MAX(G6,671-C12F129 -MAX(68,69, C13-513 9 615) K11-611 1,2 K12-12 3,4,10 -K11-C11 -K12-C12 = 13-C13 =K14-C14 KIS-C1 K13-13 5,6,7,8 MAX G20,611,64 - 14-F24 =G14 =K14-614 32 None 1 -C15+F1S . 13 K15-G1S Project Management Course Page: 25 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!

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...

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...

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...

Just steps 3, 4 and 6 Section: In-class exercise #9: PERT Analysis Name: Complete PERT steps 3, 4 and 6 for the following project (should you have time, you're welcome to complete step 2 as well just...

.Masood, the project manager has been producing a network diagram for a programming project. Note that the number of staff required each day for each activity is given in the table. Masood has...

Can you help me with this problem? EXERCISE 7 CPCM NETWORK CONSTRUCTION Shown on the following pos are the activities you would expect to complete in the development of project schedule. The...

The following Table 2 contains information related to the major activities of a conveyor belt project. Use the information to do the following: Table 2 : Project schedule Activity Description...

PJM6000 - Project Management Practices Class Exercise Week 4 - Critical Path 1. Forward Pass 2. Backward Pass 3. LSES = ? Identify Critical Path: 4. LSES = ? Find Slack time management Figure out the...

can i get a solution to this question please. Value: Document (include your file name) 15% of final grade How to complete: 1. Read the following Anniversary Party scheduling problem: As the project...

I WANT THE SOLUTION OF THE TWO SELECTED POINTS ONLY ( XIII & XVI ) YOU CAN FIND THE ANSWERS OF ALL OTHER POINTS BELOW THE QUESTION . Most Time Cost 15 2 3 1 2 B D E F G 1 14 8 1 3 8 18 4 2 11 4 1 17...

Find a basis for the Null Space and a basis for the Column Space of |1 A 3 2 5 1 3 2 6

Why do we fall forward, when a moving bus stops suddenly?

Extend your program design (from page 120) to store each name and nickname in a two-dimensional array, the age in another array and the choice in another array. The index of the array will identify...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...