find out slack of all activities

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

 find out slack of all activities.

8 E 11
11/314
2B8
26
8.
12H 14
8 D 10,
8/2/10
4 エ5
14/1/15
10/212
2/2
hl てて
2 CI6
214
2F4
12/24 14
Porsible Paths
A-3-E-Iこ2+6+3+l= 12.
A - B-D-G-H-I=1+6+2+2+2+1=15
A-C-D-GーH-Ie2+42+2+2+!= 13
A-F-エ- 2+2+1 =5
vritical Path = A -B-D-G-H- I
= 15 wueks.
Transcribed Image Text:8 E 11 11/314 2B8 26 8. 12H 14 8 D 10, 8/2/10 4 エ5 14/1/15 10/212 2/2 hl てて 2 CI6 214 2F4 12/24 14 Porsible Paths A-3-E-Iこ2+6+3+l= 12. A - B-D-G-H-I=1+6+2+2+2+1=15 A-C-D-GーH-Ie2+42+2+2+!= 13 A-F-エ- 2+2+1 =5 vritical Path = A -B-D-G-H- I = 15 wueks.
critical path - Excel
Insert
Q Tell me what you want to do.
File
Home
Page Layout
Formulas
Data
Review
View
2 Share
X Cut
Ee Copy
V Format Painter
E AutoSum -
- 11
A A
EWrap Text
General
Calibri
V Fill -
BI U
Sort & Find &
Filter- Select
Paste
-
E E E Merge & Center
+.0
00 0
Conditional Format as Cell
Insert Delete Format
A
Formatting - Table - Styles -
Clear
Clipboard
Font
Alignment
Number
Styles
Cells
Editing
P20
fx
A
B
F
H
K
L
M
N
1 Tasks
2 Choose location
3 Construction of building
4 Construction of surrounding lawns
5 Wood work
6 Painting
7 Funiture
8 Electronic fittings
9 Sanitary work
10 Painting
Activity
preceding event Duration
Te=(a+4"m+b)/6 S.D=(b-a)/6 Variance=S.D^2
Activity
Early start
Early finish
Late start Late finish Total Float(slack)=(Late start -Ea
A
2
2 0.333333
0.111111111 A
2
2
A
6
6 0.666667
0.444444444 B
2
2
A
4
4 0.666667
0.444444444 C
2
6
2
B,C
2
2 0.333333
0.111111111 D
8.
10
8
10
E
B.C
3 0.333333
0.111111111 E
8
11
11
14
0.111111111F
0.111111111 G
F
A
2 0.333333
2
4
12
14
G
D
2
2
0.333333
10
12
10
12
H
2 0.333333
0.111111111 H
12
14
12
14
1
01
14
15
14
15
11
A (Ctrl) -
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
30
Sheet1
Ready
+
86%
11:39 AM
P Type here to search
O E D G 4x ENG
03-12-2021
Transcribed Image Text:critical path - Excel Insert Q Tell me what you want to do. File Home Page Layout Formulas Data Review View 2 Share X Cut Ee Copy V Format Painter E AutoSum - - 11 A A EWrap Text General Calibri V Fill - BI U Sort & Find & Filter- Select Paste - E E E Merge & Center +.0 00 0 Conditional Format as Cell Insert Delete Format A Formatting - Table - Styles - Clear Clipboard Font Alignment Number Styles Cells Editing P20 fx A B F H K L M N 1 Tasks 2 Choose location 3 Construction of building 4 Construction of surrounding lawns 5 Wood work 6 Painting 7 Funiture 8 Electronic fittings 9 Sanitary work 10 Painting Activity preceding event Duration Te=(a+4"m+b)/6 S.D=(b-a)/6 Variance=S.D^2 Activity Early start Early finish Late start Late finish Total Float(slack)=(Late start -Ea A 2 2 0.333333 0.111111111 A 2 2 A 6 6 0.666667 0.444444444 B 2 2 A 4 4 0.666667 0.444444444 C 2 6 2 B,C 2 2 0.333333 0.111111111 D 8. 10 8 10 E B.C 3 0.333333 0.111111111 E 8 11 11 14 0.111111111F 0.111111111 G F A 2 0.333333 2 4 12 14 G D 2 2 0.333333 10 12 10 12 H 2 0.333333 0.111111111 H 12 14 12 14 1 01 14 15 14 15 11 A (Ctrl) - 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 30 Sheet1 Ready + 86% 11:39 AM P Type here to search O E D G 4x ENG 03-12-2021
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.