(d) Using the IF function, write a formula in J6 to display  "Yes" if the activity is critical and display "No" if the activity is not critical.  Copy the formula to cells J7:J14. Screen shot attached thanks

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

(d) Using the IF function, write a formula in J6 to display  "Yes" if the activity is critical and display "No" if the activity is not critical.  Copy the formula to cells J7:J14.

Screen

shot

attached

thanks

1
3
4
5
6
7
8
9
10
11
12
13
14
15
с
Table 3 has an Activity schedule for web page development. For each of the activities, the duration, Earliest Start Time, and Latest Start time are given in the schedule.
You would like to determine which all activities are critical in the project so that you can focus on their timely completion without any cost overrun.
(a) Earliest Finish Time (EF) = Duration + Earliest Start Time (ES). Write a formula in G6 to compute Earliest Finish Time. Copy the formula to cells G7:G14.
(b) Latest Finish Time (LF) = Duration + Latest Start Time (LS). Write a formula in H6 to compute Latest Finish Time. Copy the formula to cells H7:H14.
(c) Slack = Latest Finish Time (LF) - Earliest Finish Time (EF). Write a formula in 16 to compute Slack. Copy the formula to cells 17:114.
An activity is considered to be critical if the Slack for that activity is 0.
(d) Using the IF function, write a formula in J6 to display "Yes" if the activity is critical and display "No" if the activity is not critical. Copy the formula to cells J7:J14.
A B
Activity
A
B
с
D
E
F
G
H
I
D
Duration
2
2
1
3
5
1
2
1
2
E
Earliest Start
Time
(ES)
Table 3 : Activity schedule for web page development
Earliest
Finish Time
(EF)
0
0
2
3
6
11
12
0
14
Latest Start
Time (LS)
1
0
2
3
6
11
G
12
13
14
H
Latest
Finish Time
(LF)
Slack
Is the Activity
Critical?
Activity Duration
A
B
с
D
D
E
F
G
H
I
2
2
2
1
3
5
1
2
1
2
M
0
2
3
N
Sample Answer
Table 3: Activity schedule for web page development
Earliest
Earliest
Latest
Latest
Start Start Finish Finish
Time Time Time Time
(ES) (LS) (EF) (LF)
1
0
2
3
6
11
12
0
14
0
2
2
3
6
11
O
12
13
14
2
3
6
11
12
14
1
16
2
2
-
3
6
11
12
14
14
16
Slack
1
0
P
U
0
0
0
0
0
0
13
0
Is the Activity
Critical?
No
Yes
Yes
Yes
Yes
res
Yes
Yes
No
Yes
Q
R
Transcribed Image Text:1 3 4 5 6 7 8 9 10 11 12 13 14 15 с Table 3 has an Activity schedule for web page development. For each of the activities, the duration, Earliest Start Time, and Latest Start time are given in the schedule. You would like to determine which all activities are critical in the project so that you can focus on their timely completion without any cost overrun. (a) Earliest Finish Time (EF) = Duration + Earliest Start Time (ES). Write a formula in G6 to compute Earliest Finish Time. Copy the formula to cells G7:G14. (b) Latest Finish Time (LF) = Duration + Latest Start Time (LS). Write a formula in H6 to compute Latest Finish Time. Copy the formula to cells H7:H14. (c) Slack = Latest Finish Time (LF) - Earliest Finish Time (EF). Write a formula in 16 to compute Slack. Copy the formula to cells 17:114. An activity is considered to be critical if the Slack for that activity is 0. (d) Using the IF function, write a formula in J6 to display "Yes" if the activity is critical and display "No" if the activity is not critical. Copy the formula to cells J7:J14. A B Activity A B с D E F G H I D Duration 2 2 1 3 5 1 2 1 2 E Earliest Start Time (ES) Table 3 : Activity schedule for web page development Earliest Finish Time (EF) 0 0 2 3 6 11 12 0 14 Latest Start Time (LS) 1 0 2 3 6 11 G 12 13 14 H Latest Finish Time (LF) Slack Is the Activity Critical? Activity Duration A B с D D E F G H I 2 2 2 1 3 5 1 2 1 2 M 0 2 3 N Sample Answer Table 3: Activity schedule for web page development Earliest Earliest Latest Latest Start Start Finish Finish Time Time Time Time (ES) (LS) (EF) (LF) 1 0 2 3 6 11 12 0 14 0 2 2 3 6 11 O 12 13 14 2 3 6 11 12 14 1 16 2 2 - 3 6 11 12 14 14 16 Slack 1 0 P U 0 0 0 0 0 0 13 0 Is the Activity Critical? No Yes Yes Yes Yes res Yes Yes No Yes Q R
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Structure chart
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education