please solve in excel with examples

supply chain issues, weather delays, etc.). The Program Evaluation \& Review Technique (PERT) takes into consideration the uncertainty of the duration of each event by incorporating 1) an optimistic estimate (a), 2) a pessimistic estimate (b), and 3) a best guess (considered most likely) estimate (m) to determine an expected completion time based on the formula: te=(a+4m+b)/6 The diagram below shows 5 construction phases and the arrows between indicate the duration of the activity associated with each. The table provides estimates of the duration (weeks) of the corresponding activities. Tasks 1) Using the PERT formula, calculate an estimate of the completion time for each activity (te). Using the individual values for each activity, determine the total completion time (TE). Note that you cannot simply sum the values together because there is a critical path as activity 3 depends on both 1 and 2 . Whichever path takes longest governs the total time