Please solve the following problem for me:

For computations, use Excel.For drawing, you can utilize Excel or Word.for Windows to verify your answers.

Refer to the Solved Problemexample for some hints.Feel free to utilize Excel QM or QM

TomSchriber, a director ofpersonnelatManagementResources, Inc.,

is in the process ofdesigninga program that its customers can use in the job-findingprocess.

Some of theactivitiesinclude preparing resumes, writing letters, making appointments toseeprospective

employers, researchingcompanies, and industries, and so on.

Necessary informationon theactivitiesisshownin the following table:

DAYS

ACTIVITY o p m IMMEDIATE PREDECESSORS

(optimistic) (pessimistic) (most likely)

A 4 6 5 -

B 2 8 5 -

C 5 9 7 A

D 4 6 5 A

E 2 6 4 B

F 3 9 6 B

G 10 12 11 C, E

H 7 9 8 D, F

Required:

a.Construct a network for this problem.

b.Compute the expected time for each activity, also the variance.

Note:Expected time = (optimistic time + pessimistic time + 4 * most likely)/6.Variance = (pessimistic - optimistic)^2/36.

c.Determine ES, EF, LS, LF, and slack for each activity.

d.Determine the critical path and project completion time.Also the standard deviation for the completion time.

Note:To compute the standard deviation of the project completion time, you need to sum the variances of the the

critical path activities, andthen take the square root of that sum.

e.Determine the probability that the project will be finished in 23 days or less.

f.Determine the probability the the project willNOTbe finished in 26 days or less.

g.Determine the probability that the project will be finished in 25 days or less.

h.If a manager considers crashing any of the tasks to reduce the duration of the project completion time,

which tasks should he/she focus on? Why?