AutoSave Off Wk6_Assignment 9 Resource Leveling Problem (1) Search (Alt+Q) sai ganganaboyina SG File Home Insert Page Layout Formulas Data Review View Help Comments Share X General Arial ~ AA ! Insert 10 Y ab 47 @ IN e $ % ) 2X Delete Paste U A += = Conditional Formatting Format as Table Cell Styles Styles Sort & Find & Filter Select Analyze Sensitivity Data .00 Format o Number Undo Clipboard Font Alignment Cells Editing Analysis Sensitivity L M N Q R S T U V W X Y Z Z AA AB AC AD AE AF AG AH AL AJ AK A D 1M 2M, 1H E K B11 Vix fx are 5 masons and 2 helpers. A . B DE F G . 1 J K 1 EMO1511 Strategic Risk Management 2 1) Fill in yellow area using resource limits provided 3 2) Assign resources as soon as they are available so that 4 activities start as soon as possible. 5 3) Indicate Critical path in red in the bar chart area. 64) Managers/Consultants can't work independent than their Help/Labor/Associates 75) Activities can start and stop to best level resources 8 9 10 1. Solve the following. The resource limits 11 are 5 nhasons and 2 helpers B 12 13 14 2M, 1H 15 16 A c 17 1 1 18 2 -2 0 0 2 19 2M, 1H 2M, 1H 20 21 22 Activity 23 ES Duration LS 24 EF FF TF LF 25 Resources Sheet1 Sheet2 Sheet3 + 3M 2M, 1H M M 2M, 1H 3M G L 1M, 2H Ready Accessibility: Investigate 20 98% 61F Mostly cloudy DOLL F 4x O 7:37 PM 4/23/2022 5 AutoSave Off Wk6_Assignment 9 Resource Leveling Problem (1) Search (Alt+Q) sai ganganaboyina SG File Home Insert Page Layout Formulas Data Review View Help Comments Share X General Arial ! Insert - AA 10 Y ab 47 @ IN e LO $ % ) 3X Delete Paste U . A += = Conditional Formatting Format as Table Cell Styles Styles Sort & Find & Filter Select Analyze Sensitivity Data .00 o Format Y Undo Clipboard Font Alignment Number Cells Editing Analysis Sensitivity B11 VIX fx are 5 masons and 2 helpers. DE F F G H I J A B C K L M N O P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK A E H Max 4C, 3L 2C 1C, 1L 2C, 1L Activity Resource Dur TF Late Start / 1 2 2 3 3 4 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 0,0 1 1 2 4 3C, 2L 1C, 3L 3,2 3,2 1,3 1,3 1,3 1,3 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 A B D E F G H 1 J K L M Carp Labor 2C 2L 2C, 3L 1C, 1L 1L 2,0 2,0 0 0 0 12 10 0 0 10 11 3 2 3 2 3 6 2 6 2 2 1 1 2 4 14 12 8 11 14 13 1C, 2L 2C, 1L 1C 4 Max 0 3 Max 0 3 3 2 3 3 2 3 3 3 3 Sheet1 Sheet2 Sheet3 + Ready Accessibility: Investigate 3 98% DOLL 61F Mostly cloudy F 1x O 7:37 PM 4/23/2022 5 AutoSave Off Wk6_Assignment 9 Resource Leveling Problem (1) Search (Alt+Q) sai ganganaboyina SG File Home Insert Page Layout Formulas Data Review View Help Comments Share X General Conditional Formatting Arial . AA 10 ! Insert Y ab Y @ 47 e IN $ % ) Format as Table 2X Delete Paste U A += = Sort & Find & Filter Select Analyze Sensitivity Data .00 Cell Styles Format Undo Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity B11 Vix fx A 1 J J K L M N Q R S T U V W X Y Z Z AA AB AC AD AE AF AG AH AI AJ AK A B B J 2M, 1H K K 2M, 1H L L 3M, 1H M 2M, 1H Masons Helpers are 5 masons and 2 helpers. D E F F G H 1 1 0 1 0 2 1 1 0 5 5 Max 2 2 Max 1 4 2 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 ES EF Activity Duration FF TF Resources LS LF 1L D 2. Solve the following. The resource limits are 4 consultants and 3 laborers. B C F G K M M 1 1 2 1 2 -2 0 01 3C, 2L 1C, 3L 2L 2C, 3L 1C, 2L 1C E H Sheet1 Sheet2 Sheet3 + Ready Accessibility: Investigate 3 98% 61F Mostly cloudy DOLL F 4x O 7:37 PM 4/23/2022 5 AutoSave Off Wk6_Assignment 9 Resource Leveling Problem (1) Search (Alt+Q) sai ganganaboyina SG File Home Insert Page Layout Formulas Data Review View Help Comments Share X General Arial AA ~ 10 ! Insert Y ab @ Conditional Formatting Format as Table 47 IN e $ % ) 9X Delete Paste U A += = Sort & Find & Filter Select .00 Format Y Cell Styles Styles Analyze Sensitivity Data Analysis Sensitivity Undo Clipboard Font Alignment Number Cells Editing B11 A Vix fx are 5 masons and 2 helpers. B C D E F F G EF FF TF LF Resources H 1 J Q RS T K L M N O P 1M, 2H U V W X Y Z AA AB AC AD AA AB AC AD AE AF AG AH AI AJ AK A 3M, 1H . 1M, 1H Activity Resource Dur TF Late Start 1 1 2 3 4 5 6 7 8 9 10 11 12 2,1 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 1 4 1 0 0 1 0 1 2 2 3 6 2,1 2,1 2,1 2,1 2,1 A 2M, 1H B 2M, 1H C 2M, 1H D 1M E 3M F 3M G 1M, 2H H 1M, 1H J J 2M, 1H K 2M, 1H L 3M, 1H M M 2M, 1H Masons Helpers 1 1 2 2 3 2 1 1 2 1 0 2 1 2 0 0 1 0 5 Max 2 2 Max 1 4 2 Sheet1 Sheet2 Sheet3 Ready Accessibility: Investigate 3 98% 61F Mostly cloudy HH DOLL 1x O 7:37 PM 4/23/2022 5 AutoSave Off Wk6_Assignment 9 Resource Leveling Problem (1) Search (Alt+Q) sai ganganaboyina SG File Home Insert Page Layout Formulas Data Review View Help Comments Share X General Arial ~ AA ! Insert 10 Y ab 47 @ IN e $ % ) 2X Delete Paste U A += = Conditional Formatting Format as Table Cell Styles Styles Sort & Find & Filter Select Analyze Sensitivity Data .00 Format o Number Undo Clipboard Font Alignment Cells Editing Analysis Sensitivity L M N Q R S T U V W X Y Z Z AA AB AC AD AE AF AG AH AL AJ AK A D 1M 2M, 1H E K B11 Vix fx are 5 masons and 2 helpers. A . B DE F G . 1 J K 1 EMO1511 Strategic Risk Management 2 1) Fill in yellow area using resource limits provided 3 2) Assign resources as soon as they are available so that 4 activities start as soon as possible. 5 3) Indicate Critical path in red in the bar chart area. 64) Managers/Consultants can't work independent than their Help/Labor/Associates 75) Activities can start and stop to best level resources 8 9 10 1. Solve the following. The resource limits 11 are 5 nhasons and 2 helpers B 12 13 14 2M, 1H 15 16 A c 17 1 1 18 2 -2 0 0 2 19 2M, 1H 2M, 1H 20 21 22 Activity 23 ES Duration LS 24 EF FF TF LF 25 Resources Sheet1 Sheet2 Sheet3 + 3M 2M, 1H M M 2M, 1H 3M G L 1M, 2H Ready Accessibility: Investigate 20 98% 61F Mostly cloudy DOLL F 4x O 7:37 PM 4/23/2022 5 AutoSave Off Wk6_Assignment 9 Resource Leveling Problem (1) Search (Alt+Q) sai ganganaboyina SG File Home Insert Page Layout Formulas Data Review View Help Comments Share X General Arial ! Insert - AA 10 Y ab 47 @ IN e LO $ % ) 3X Delete Paste U . A += = Conditional Formatting Format as Table Cell Styles Styles Sort & Find & Filter Select Analyze Sensitivity Data .00 o Format Y Undo Clipboard Font Alignment Number Cells Editing Analysis Sensitivity B11 VIX fx are 5 masons and 2 helpers. DE F F G H I J A B C K L M N O P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK A E H Max 4C, 3L 2C 1C, 1L 2C, 1L Activity Resource Dur TF Late Start / 1 2 2 3 3 4 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 0,0 1 1 2 4 3C, 2L 1C, 3L 3,2 3,2 1,3 1,3 1,3 1,3 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 A B D E F G H 1 J K L M Carp Labor 2C 2L 2C, 3L 1C, 1L 1L 2,0 2,0 0 0 0 12 10 0 0 10 11 3 2 3 2 3 6 2 6 2 2 1 1 2 4 14 12 8 11 14 13 1C, 2L 2C, 1L 1C 4 Max 0 3 Max 0 3 3 2 3 3 2 3 3 3 3 Sheet1 Sheet2 Sheet3 + Ready Accessibility: Investigate 3 98% DOLL 61F Mostly cloudy F 1x O 7:37 PM 4/23/2022 5 AutoSave Off Wk6_Assignment 9 Resource Leveling Problem (1) Search (Alt+Q) sai ganganaboyina SG File Home Insert Page Layout Formulas Data Review View Help Comments Share X General Conditional Formatting Arial . AA 10 ! Insert Y ab Y @ 47 e IN $ % ) Format as Table 2X Delete Paste U A += = Sort & Find & Filter Select Analyze Sensitivity Data .00 Cell Styles Format Undo Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity B11 Vix fx A 1 J J K L M N Q R S T U V W X Y Z Z AA AB AC AD AE AF AG AH AI AJ AK A B B J 2M, 1H K K 2M, 1H L L 3M, 1H M 2M, 1H Masons Helpers are 5 masons and 2 helpers. D E F F G H 1 1 0 1 0 2 1 1 0 5 5 Max 2 2 Max 1 4 2 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 ES EF Activity Duration FF TF Resources LS LF 1L D 2. Solve the following. The resource limits are 4 consultants and 3 laborers. B C F G K M M 1 1 2 1 2 -2 0 01 3C, 2L 1C, 3L 2L 2C, 3L 1C, 2L 1C E H Sheet1 Sheet2 Sheet3 + Ready Accessibility: Investigate 3 98% 61F Mostly cloudy DOLL F 4x O 7:37 PM 4/23/2022 5 AutoSave Off Wk6_Assignment 9 Resource Leveling Problem (1) Search (Alt+Q) sai ganganaboyina SG File Home Insert Page Layout Formulas Data Review View Help Comments Share X General Arial AA ~ 10 ! Insert Y ab @ Conditional Formatting Format as Table 47 IN e $ % ) 9X Delete Paste U A += = Sort & Find & Filter Select .00 Format Y Cell Styles Styles Analyze Sensitivity Data Analysis Sensitivity Undo Clipboard Font Alignment Number Cells Editing B11 A Vix fx are 5 masons and 2 helpers. B C D E F F G EF FF TF LF Resources H 1 J Q RS T K L M N O P 1M, 2H U V W X Y Z AA AB AC AD AA AB AC AD AE AF AG AH AI AJ AK A 3M, 1H . 1M, 1H Activity Resource Dur TF Late Start 1 1 2 3 4 5 6 7 8 9 10 11 12 2,1 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 1 4 1 0 0 1 0 1 2 2 3 6 2,1 2,1 2,1 2,1 2,1 A 2M, 1H B 2M, 1H C 2M, 1H D 1M E 3M F 3M G 1M, 2H H 1M, 1H J J 2M, 1H K 2M, 1H L 3M, 1H M M 2M, 1H Masons Helpers 1 1 2 2 3 2 1 1 2 1 0 2 1 2 0 0 1 0 5 Max 2 2 Max 1 4 2 Sheet1 Sheet2 Sheet3 Ready Accessibility: Investigate 3 98% 61F Mostly cloudy HH DOLL 1x O 7:37 PM 4/23/2022 5