Problem 1-13 (Question (Labeled 11-13), and reference question (Labeled 11-12) | Solution

Requirements: Must use Microsoft Excel to complete each problem and submit a single Excel spreadsheet that contains a separate worksheet (i.e., separate tab) for each problem.Complete the following problems. Requirements:

    Have each worksheet be clearly labeled to identify the associated problem.
    Must show all calculations or other work performed to derive your answer(s) for each problem.
    Spreadsheet must be fully functional (i.e., configured to allow the reader to not only see all numerical values, but also be able to see the underlying formula associated with each calculated value).
    To label your work in each worksheet to clearly identify the nature of each piece of data or calculated value.

No credit will be granted for problems that are not completed using Excel, for which your Excel worksheet is not fully functional, or for which you have not shown all of the calculations or other work performed to derive your answer(s).

Problem 1-13

(Question (Labeled 11-13), and reference question (Labeled 11-12) attached in the word doc.  Please only complete the item labeled question number 11-13 on the attachment.

Problem 2-17 (Please reference attachment titled "Prelude to problem 2-17")

After consulting with Butch Radner, George Monohan was able to determine the activity times for constructing the weed-harvesting machine to be used on narrow rivers. George would like to determine ES, EF, LS, LF, and slack for each activity. The total project completion time and the critical path should also be determined. (See Problem 13-16 for details). The activity times are shown in the following table:

ACTIVITIES
    

TIME (WEEKS)

A
    

6

B
    

5

C
    

3

D
    

2

E
    

4

F
    

6

G
    

10

H
    

7

Problem 3-19

Tom Schriber, a director of personnel of Management Resources, Inc., is in the process of designing a program that its customers can use in the job-finding process. Some of the activities include preparing resumes, writing letters, making appointments to see prospective employers, researching companies and industries, and so on. Some of the information on the activities is shown in the following table:

Days
    

Activity
    

a
    

m
    

b
    

Immediate
Predecessors

A
    

8
    

10
    

12
    

-

B
    

6
    

7
    

9
    

-

C
    

3
    

3
    

4
    

-

D
    

10
    

20
    

30
    

A

E
    

6
    

7
    

8
    

C

F
    

9
    

10
    

11
    

B,D,E

G
    

6
    

7
    

10
    

B,D,E

H
    

14
    

15
    

16
    

F

I
    

10
    

11
    

13
    

F

J
    

6
    

7
    

8
    

G,H

K
    

4
    

7
    

8
    

I,J

L
    

1
    

2
    

4
    

G,H

a) Construct a network for this problem.

(b) Determine the expected time and variance for each activity.
(c) Determine ES, EF, LS, LF, and slack for each activity.
(d) Determine the critical path and project completion time.
(e) Determine the probability that the project will be finished in 70 days or less.
(f) Determine the probability that the project will be finished in 80 days or less.
(g) Determine the probability that the project will be finished in 90 days or less.

Problem 4-21 (Please see table 11.8 on the attachment "Table 11.8 for Problem 4-21")

The air pollution project discussed in the chapter has progressed over the past several weeks, and it is now the end of week 8. Lester Harky would like to know the value of the work completed, the amount of any cost overruns or underruns for the project, and the extent to which the project is ahead of or behind schedule by developing a table like Table 11.8. The revised cost figures are shown in the following table:

Activity
    

Percent of Completion
    

Actual Cost ($)

A
    

100
    

20,000

B
    

100
    

36,000

C
    

100
    

26,000

D
    

100
    

44,000

E
    

50
    

25,000

F
    

60
    

15,000

G
    

10
    

5,000

H
    

10
    

1,000

Problem 5-23 (Please reference attachment titled "Table 12.9 for Problem 5-23" for Problem and associated table)