Note: please solve it in excel and show all formulas.

please solve it fast pleaseeeeeee

Problem 1 Marcy Fetter, a staff analyst at the Los Angeles plant of Computer Products Corporation, is assigned to the team that is developing the process design for producing an RFID sensor. The corporate planning group in San Jose, California has contacted her and has asked how confident the design group is about completing the project in 30 days. She has developed these estimated time durations in days for the project: Activity Immediate Predecessor Activities Optimistic Time Most Likely Time Pessimistic Time 4.0 A B D E F G H 1 J B AC B B E E D G F, H = = 3.0 3.0 4.0 2.0 6.0 7.5 4.5 5.0 2.0 4.0 3.5 5.0 3.0 10.0 8.5 6.0 5.0 7.0 6.0 4.0 14.0 12.5 7.5 13.0 6.0 6.0 6.0 2.5 5.0 a. Compute the expected time and variance for each activity. (5 points) a. Compute the expected time and variance for each activity. (5 points) b. Draw the PERT/CPM network for this project and determine the critical path and the expected duration of the project. (12 points) c. What is the probability that the project will be completed so that the Computer Products Corporation may introduce the new product within 25 days? Within 30 days? (5 points) d. Top management would like to complete certain set of a tasks earlier to be able to test the quality and begin advertising for the product few days prior to releasing in the market. Compare the risk of overrunning a new deadline of 20 days for paths B-E-G-I and B-F-J? (8 points) AutoSave Ey 5 = Exam 3-Templa Home Insert Draw Page Layout Formulas Data Review View Tell me to Times New Roman 12 X (6 3 v 2. Wrap Text Paste B I U DA Merge & Center v G1 fx Variance B C D E F H 1 Activity Immediate Predecessor Activities Optimistic Time Most Likely Time Pessimistic Time Expected Time Variance 2 3 A B D 3 3 4 3.5 S 4 15 6 3 10 8.5 7 8 E F G H 1 J B AC B B E E D G F.H 4 2 6 7.5 4.5 S 2 4 7 6 4 14 12.5 7.5 13 6 9 6 6 2.5 s 6 11 12 13 16 ONS MOODEN A START 18 9