Question: Can this be solved in Excel? The following represents a project with known activity times. All times are in weeks. Activity Immediate Predecessor Time A

Can this be solved in Excel?

The following represents a project with known activity times. All times are in weeks.

Activity

Immediate

Predecessor

Time

A

-

6

B

-

3

C

A

5

D

-

2

E

C

4

F

D

3

G

B, C

2

H

G

3

I

F, G

5

J

H

4

K

E, H

2

L

K

3
  1. Create a CPM Network. (15 pts)
  2. What is the projects expected completion date? (5 pts)
  3. What activities are on the critical path? (10 pts)
  4. Compute the slack time for all non-critical activities. (15 pts)
  5. What is the latest possible start time for activity E? (5 pts)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

Kline Inc. purchases goods for 5,000 pounds on October 31, Year 1. The company pays for the goods three months later. The exchange rates are as follows: Date Exchange Rate Oct. 31, Yr. 1 $0.63 Dec....

Q:

complete every thing in excel The following represents a project with known activity times in weeks. Activity Immediate Predecessor Activity Time (wks) A - 4 B A 3 C - 2 D A 7 E C 3 F B, E 5 G D, E 4...

Q:

The following represents a project with known activity times in weeks. Activity Immediate Predecessor Activity Time (wks) A - 4 B A 3 C - 2 D A 7 E C 3 F B, E 5 G D, E 4 H F 5 Create a CPM Network....

Q:

The following represents a project with known activity times in weeks. 4 B 3 C 2 D 7 E 3 F B, E 5 G D, E 4 H F 5 a. Create a CPM Network and identify the total project time. (50 pts) b. What...

Q:

3 Answer Sheet Due by midnight December 3rd 2015. Copy and paste the part of this answer sheet below the dotted into a Course Message titled Assignment 3 Answer Sheet. Enter the letter of the best...

Q:

The following represents a project with known activity times. All times are in weeks. Immediate Time Activity Predecessor(weeks) What is the minimum possible time required for completing the project...

Q:

Question 16 (1 point) The following represents a project with known activity times. All times are in weeks. Immediate Time Activity Predecessor (weeks) A 4 B 3 2 D B 7 E C D N F B 5 What is the...

Q:

A local project being analyzed by PERT has 10 activities, 7 of which are on the critical path. If the estimated time along the critical path is 105 days with a project variance of 25, what is the...

Q:

Question 17 (1 point) The following represents a project with known activity times. All times are in weeks. Immediate Time Activity Predecessor (weeks) A - 5 CD B | 5 What is the minimum possible...

Q:

How do I solve these? Could you also explain how the network Question 16 (1 point) The following represents a project with known activity times. All times are in weeks. Immediate Time Activity...

Q:

The following represents a project with known activity times. All times are in weeks. Immediate Time Activity Predecessor(weeks) What is the minimum possible time required for completing the project...

Q:

On a certain day, the temperature and relative humidity of air over a large swimming pool are measured to be 25oC and 60 percent, respectively. Determine the water temperature of the pool when phase...

Q:

The Chebyshevs polynomials are defined by Tn(x) = cos (n arcos x) n = 0, 1, 2, 3,, . (a) What are the domain and range of these functions? (b) We know that T0(x) = 1 and T1 (x) = x. Express T2...

Q:

Richard Earley, President of Racing Swimwear, was examining the budget report presented by Arlie Guthrie, controller. I know that the bottom line looks good here, but I am a little concerned about...

Q:

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...