NOTE: SHOW STEP-BY-STEP ANSWER IN MS EXCEL

a b 4. The following table provides the crash data for the network project described in Problem 2: Activity Time (weeks) Acrivity Cost Activity Normal Crash Normal Crash 9 7 $ 4,800 $ 6,300 11 9 9,100 15,000 7 5 3,000 4,000 d 10 8 3,600 5,000 1 0 0 5 3 1,500 2,000 g 6 5 1,800 2,000 h 3 3 0 0 0 2 2 0 0 k 8 6 5,000 7,000 e 1 f 1 1 0 The normal activity times are considered to be deterministic and not probabilistic. Using the computer, crash the network to 26 weeks. Indicate how much it would cost the bank and then indicate the critical path. 2. The accounts system. Bank management has determined the activities required to complete the Farmer's American Bank of Leesburg is planning to install a new computerized project, the precedence relationships of the activities, and activity time estimates, as shown in the following table: Activity a b e Activity Description Position recruiting System development System training Equipment training Manual system test Preliminary system changeover Computer-personnel interface Equipment modification Equipment testing System debugging and installation Equipment changeover Time Estimates (weeks) Predecessor a m b 5 8 17 3 12 15 a 4 7 10 a 5 8 23 b, c 1 b, c 4 13 d, e 3 6 9 d, e 2.5 7 h 1 2 2 2 g, i 5 8 11 1 1 OC 1 1 1 -. f, k Determine the expected project completion time and variance and determine the probability that the project will be completed in 40 weeks or less