Using the network diagram below, enter the activities, their durations (in days), and their relationships in the spreadsheet template attached. Obtain the CPM results and Gantt chart. Then, complete the PERT worksheet.

Submit the completed Excel file through this assignment.

Using the network diagram below, enter the activities, their durations (in days), and their relationships in the spreadsheet template attached. Obtain the CPM results and Gantt chart. Then, complete the PERT worksheet. Submit the completed Excel file through this assignment. D = 4 A = 1 E = 5 H = 6 B = 2 F=4 J = 3 C = 3 1 = 2 7 G = 6 Note: Assume all durations are in days; A=1 means Activity A has a duration of 1 day. AutoSave Of H e File Home Insert Page Layout Formulas Data Review Arial BI U - 10 - - A^ ^ - A- ===> S E Paste X Cut LoCopy - Format Painter Clipboard x C Font D7 2 r D fix E A F G H I J K Spreadsheet Modeling Project 3 4 Activity Predecessor Time EST EFT LST LFT Slack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Description Chart 32 33 Project Pert + AutoSave Off H File Home Insert Page Layout Formulas Data Review View Help Search 1 X Cut [Copy - Paste 9 $ Format Painter Clipboard Arial - 10 BI U - B Font - A A to === ? 5 aba Wrap Text Merge & Center - 9 General $ - % 9 Number Alignment G H I C17 X fix C D E F 1 PERT Time Estimates (in Weeks) for Critical Path 2 Optimistic Most likely Pessimistic Expected Activity Description time (a) time (m) time (b) | time 2.0 5 E 4 5 6 6 H 4 5 12 2 Standard Variance deviation 0.11 0.33 3 vouw days 10 Project mean length = 11 Project variance = 12 Project standard deviation = 13 P(Finish 18 days) = 15 16 17 2.00 0.11 0.33 1.0000 0.0000 days Project Pert