Please Solve in a work or excel document. Thanks!

QUESTION #6: Norton industries is installing a new computer system. The activities, the immediate predecessor(s) of each activity, and the activity times of the project are given in the following table. Activity Immediate Predecessor Time (weeks)

a) Draw an AON diagram of the project, including activity times.

b) Determine ES, EF, LS, LF, and slack for each activity. Summarize your calculations in the form of a table giving the activity schedule.

c) What are the critical activities and what is the project completion time?

d) After viewing this information, management requested overtime be used to complete the project in 16 weeks. Thus, crashing of the project is necessary. The following information is relevant:

e) Formulate a linear programming model that can be used to make the crashing decisions (define the decision variable, the constraints, and the objective function).

f) Use the Excel Solver to solve the linear programming model and make the minimum crashing decisions. Which activities need to be crashed and by how much to complete the project in 16 weeks? What is the added cost of meeting the 16-week completion time?

g) Develop a complete activity schedule based on the crashed activity times. Summarize this activity schedule I the form of a table with appropriate headings. Which activities are critical in this case?

Immediate Predecessor Activity A Time (weeks) 3 B 6 A 2 D B, C 5 E D 4 F E 3 G 9 B, C F,G 3 Activity A Time (weeks) Normal Crash 3 1 Cost (S) Normal 900 Crash 1700 B 6 3 2 1 D 5 3 4000 1000 2400 1850 3900 9800 E 4 2000 500 1800 1500 3000 8000 1000 3 F 3 1 G 9 4 H 3 2 2 2000