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

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

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images

Knowledge Booster
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
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON

Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education