Question

 Level the resource and schedule the activities based on the optimum resource usage. Then draw the S-curve knowing that the total cost of activities A, B, C, D, E, F and G is 2000$,3000$, 5000$, 6300$, 2500$, 4200$ and 1500$ respectively. Hint: you can use Excel to draw the histogram or S-curve.

• Level the resource and schedule the activities based on the optimum resource usage. Then draw the S-curve knowing that the total cost of activities A, B. C, D, E, F and G is 20005,3000$, 5000$, 6300$, 2500$, 4200$ and 1500$ respectively. Hint: you can use Excel to draw the histogram or S-curve. Activity Duration (Days) IPA Laborers A B с D E F G 2 4 6 9 5 7 3 А B B,C D,E,F 3 2 4 3 4 2 4 Note: the assignment shall be submitted no later than Friday 31/7/2020. Note: each student has to solve and submit the solution individually.

Answer 1

Book1 - Excel (Product Activation Failed) File Home Insert Page Layout Formulas Data Review View Office Tab Tell me what you want to do... Sign in 2. Share A11 Resource leveling and scheduling of activity Book1 * Book1 * X B M Activity Name 1 2 A 3 B 4 C C D E F G H K Activity Cost per day EST LST EFT LFT TE REMARK Cost ($) Duration ($) 2 0 0 2 2 0 Critical Activity 2000 1000 4 2 6 6 10 4 3000 750 6 2 2 8 8 0 Critical Activity 5000 833.333333 9 2 6 11 15 4 6300 700 5 6 10 11 15 4 2500 500 7 8 8 15 15 0 Critical Activity 4200 600 3 15 15 18 18 0 Critical Activity 1500 500 Note:- TF = LFT-EST and Cost per day = total cost of activity/ total duration of activity. 5 D 6 E 7 F G 8 9 10

9 Note:- TF = LFT-EST and Cost per day = total cost of activity/total duration of activity. 10 11 Resource leveling and scheduling of activity Days 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 12 Activity Name 13 14 A 15 B 16 с 3 3 2 2 2 2 4 4 4) 41 4 4 17 D 3 3 3 3 3 3 3 31 3 4 18 4 4 4 E F 41 21 19 2 2 21 2 2 2 20 G 4 41 4 Total labor 3 3 9 9 9 9 11 11 9 9 9 2 2. 2 2. 4 4 4 21 Cumulative labor 3 6 15 24 33 42 53 64 73 82 91 93 95 97) 99 103 107 111 22 23 24 25 Activity Name 26 A Utilizing the fully Total float of Activity B and activity E. and utilizing the partial total float of activity D. 3 4 5 6 7 8 9 10 11 12 1 2 13 14 15 16 17 18 3 3 Activate Windows Go to Settings to activate Windows Sheet1 + IP

Bě Book1 - Excel (Product Activation Failed) Х File Home Insert Page Layout Formulas Data Review View Office Tab Tell me what you want to do... Sign in & Share A24 fox Utilizing the fully Total float of Activity B and activity E. and utilizing the partial total float of activity D. Book1 * х A B с D E F L 0 R S T 17 Book1 * H. K M N O P Utilizing the fully Total float of Activity B and activity E. and utilizing the partial total float of activity D. 5 Activity Name 5 A 1 2 3 4 6 7 8 9 10 11 12 13 14 15 16 17 18 5 3 3 B 21 2 21 20 3 С 4 4 4 4 4 4 D 3 3 3 3 3 3 3 3 3 3 E 4 41 4 4 4 1 F 2 21 2 21 21 2 21 2 G 4 4 4 Total labor 6. 6 7 7 7 7 9 9 7 4 6 6 6 6 6 4 4 4 3 Cumulative labor 6 12 19 26 33 40 49 58 65 69 75 81 87 93 99 103 107 111

5 6 Resource leveling 7 Before resource levelling 8 12 9 11 10 9 0 8 1 Series "Before resource levelling" Point 6 Value: 9 2 labour requirment 6 3 5 4. 2 5 0 2 5 6 12 13 14 15 16 17 18 6 7 8 9 0 8 9 10 11 Progress of project ( in days) 1 2 Resource leveling Activate Windows Go to Settings to activate Windows Sheet1 + Leady Calculate + 100% 1:31 AM

Sě X Book1 - Excel (Product Activation Failed) Office Tab Tell me what you want to do... File Home Insert Page Layout Formulas Data Review View Sign in Share -24 fi Utilizing the fully Total float of Activity B and activity E. and utilizing the partial total float of activity D. Book1 * x Book1 * х A B с D E F G H J K L Μ Ν o P Q R S T U V Progress of project (in days) Resource leveling After resource levelling 10 9 8 7 6 Labor distribution Series "After resource levelling" Point 6 Value: 7 2 1 0 1 2 3 4 5 6 7 12 13 14 15 16 17 18 8 9 10 11 Progress of project (in days

Ss Book1 - Excel (Product Activation Failed) Chart Tools o X File Home Insert Page Layout Formulas Data Review View Office Tab Design Format Tell me what you want to do... Sign in & Share Chart 7 foc Book1 * 11 Book1 * х A B C D E F G H J к L M N O P Q R S T U Z AB AC AD AE AF AG AH S curve for lobor 120 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 110 100 90 80 83 70 85 86 87 88 60 O 50 90 91 92 40 30 94 95 96 20 10 0 1 2 99 100 101 102 103 104 105 106 107 108 109 3 4 5 6 7 8 12 13 14 15 16 17 18 --Before levelling 9 10 11 -after resource levelling o Activate Windows Go to Settings to activate Windows Sheet1 + Ready Calculate + 62% Type here to search j e x] 1:36 AM 7/30/2020

Book1 - Excel (Product Activation Failed) File Home Insert Page Layout Formulas Data Review View Office Tab Tell me what you want to do... Sign in 2 Share A34 fax day vise Distribution of money Book1 * Book1 * х A B с D E F G H | J K L M N O P Q R S T Activity Name Days 1 2 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 3 A 1000 1000 4 B 5 6 750 750 750 750 833.3333 833.3333 833.3333 833.3333 833.3333 833.3333 700 700 700 700 700 700 500 500 D 700 7 E 700 500 600 500 600 700 500 600 600 6000 6001 600) 500 500 500 1000 1000 2283 2283 2283 2283 2033 2033 2033 1800 1800 1800 600 600 600 600 500 500 500 8 F 9 day vise Distribution 10 of money Cumulative Distribution 11 of money 1000 2000 4283.333 6566.667 8850 11133.33 13166.67 15200 17000 18800 20600 21200 21800 22400 23000 23500 24000 24500

of money + resource (money) distribution day vise $2,400.00 $2,200.00 $2,000.00 $1,800.00 $1,600.00 Plot Area $1,400.00 Money distribution $1,200.00 $1,000.00 O $800.00 $600.00 $400.00 $200.00 $0.00 1 2 3 4 5 6 8 12 13 14 15 16 17 Progres of projet (in days, 10 before resource leveling 18 0-0-0 Activate Windows Go to Settings to activate Windows Sheet1 + dy + HI 1:36 AM Tunn horn to march A A A E

Book1 Book1 * х A B D E F H - J K L M N O P Q R S T :1 2 after resource levelling Days 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 1000 1000 750 750 750 750 833.3333 833.3333 833.3333 833.3333 833.3333 833.3333 700 700 700 700 700 700 700 700 700) 500 500 500 500 500 6001 600 600 600 600 600 600 3 Activity Name -4 5 A 6 B 7 C -8 D =9 E -0 F -1 G day vise Distribution 2 of money Cumulative Distribution -3 of money 14 500 500 500 1700 1700 1533 1533 1533 1533 2283 2283 2050 1350 1100 1100 1100 1100 1100 500 500 500 1700 3400 4933.333 6466.667 8000 9533.333 11816.67 14100 16150 17500 18600 19700 19700 20800 21900 23000 23500 24000 24500

Ss Book1 - Excel (Product Activation Failed) o X File Home Insert Page Layout Formulas Data Review View Office Tab Tell me what you want to do... Sign in & Share 039 500 Book1 * Book1 * X А B C D E F Н. - K L M N 0 Р Q R S T 44 45 46 after resource leveling 47 Oday vise Distribution of money 48 49 $2,400.00 50 $2,200.00 51 52 53 $2,000.00 $1,800.00 54 55 $1,600.00 56 $1,400.00 57 58 $1,200.00 59 $1,000.00 60 61 $800.00 62 $600.00 63 64 $400.00 65 66 $200.00 67 $0.00 68 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 18 69 Activate Windows Go to Settings to activate Windows Sheet1 + Ready @ + 100% Type here to search j e x] 4 ) 1:38 AM 7/30/2020

Ss Book1 - Excel (Product Activation Failed) Chart Tools o X File Home Insert Page Layout Formulas Data Review View Office Tab Design Format Tell me what you want to do... Sign in & Share Chart 4 foc Book1 * X Book1 * A C D E F G Н. J к L N 0 - P Q R s T U Z 98 AB AC o O o S curve for money + 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 26000 25000 24000 23000 22000 21000 20000 19000 18000 17000 16000 15000 14000 13000 012000 11000 10000 9000 8000 7000 6000 5000 4000 3000 2000 1000 0 O Plot Area 97 98 99 100 101 102 103 104 105 106 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 -after resource leveling -before resource leveling Activate Windows Go to Settings te activate Windows. Sheet1 + Ready + 71% Type here to search o j e x] 1:40 AM 7/30/2020 =