Please see attached excel question. All of the information to answer the question will be within that document. Please let me know if you have any additional questions in order to answer.

4) Delicious Sandwich has decided on locations to build the new sandwich shops. In the next phase, you are charged with e timeframes as to when the shops can be built. As per most building processes, there are certain events which must happen For example, sandwiches cannot be made until the oven is installed. The oven cannot be installed until the floors are done, on, and the hood has been installed. The main construction foreman has determined a list of activities, as well as the activiti proceed any activities wishing to be completed. The list is given below: Project to be Completed A B C D E F G H I J K The foreman has also established time estimates (in weeks) for each of the projects that needs to be completed. The inform table below: (a) When is the earliest that we can expect construction to be completed? How about the latest? What is the expected com (Report the answer using a 99.7% significance. Remember 99.7% significance represents +/- 3 standard deviations.) (b) Marketing would like to start promoting the opening of Delicious Sandwiches in Lima in 21 weeks. What is the liklihood will be open by then? Explain your response and show how you arrived at your response. ich shops. In the next phase, you are charged with establishing cesses, there are certain events which must happen before other events. e oven cannot be installed until the floors are done, electricity turned s determined a list of activities, as well as the activities that must Preceeding Projects to Project listed to the lef A A,B A B,C,D E C,D,F E,F,G D,F A,E,G,I D,F,G,H,J he projects that needs to be completed. The information is found in the Project to be Completed A B C D E F G H I J K d? How about the latest? What is the expected completion date? ance represents +/- 3 standard deviations.) ndwiches in Lima in 21 weeks. What is the liklihood that the new store at your response. Optimistic 1 1.75 0.5 3 2.5 1 3 1 2 1 4 Most Probable 1.5 2.25 1 4 2.75 2 3.5 3 3 1.3 5 Pessimistic 2 3 1.5 5 3.15 3 4.25 5 3.2 1.7 7 4) Delicious Sandwich has decided on locations to build the new sandwich shops. In the next phase, you are charged with e timeframes as to when the shops can be built. As per most building processes, there are certain events which must happen For example, sandwiches cannot be made until the oven is installed. The oven cannot be installed until the floors are done, on, and the hood has been installed. The main construction foreman has determined a list of activities, as well as the activiti proceed any activities wishing to be completed. The list is given below: Project to be Completed A B C D E F G H I J K The foreman has also established time estimates (in weeks) for each of the projects that needs to be completed. The inform table below: (a) When is the earliest that we can expect construction to be completed? How about the latest? What is the expected com (Report the answer using a 99.7% significance. Remember 99.7% significance represents +/- 3 standard deviations.) (b) Marketing would like to start promoting the opening of Delicious Sandwiches in Lima in 21 weeks. What is the liklihood will be open by then? Explain your response and show how you arrived at your response. ich shops. In the next phase, you are charged with establishing cesses, there are certain events which must happen before other events. e oven cannot be installed until the floors are done, electricity turned s determined a list of activities, as well as the activities that must Preceeding Projects to Project listed to the lef A A,B A B,C,D E C,D,F E,F,G D,F A,E,G,I D,F,G,H,J he projects that needs to be completed. The information is found in the Project to be Completed A B C D E F G H I J K d? How about the latest? What is the expected completion date? ance represents +/- 3 standard deviations.) ndwiches in Lima in 21 weeks. What is the liklihood that the new store at your response. Optimistic 1 1.75 0.5 3 2.5 1 3 1 2 1 4 Most Probable 1.5 2.25 1 4 2.75 2 3.5 3 3 1.3 5 Pessimistic 2 3 1.5 5 3.15 3 4.25 5 3.2 1.7 7 Project to be Completed Optimistic Most Probable Pessimistic A B C D E F G H I J K 1 1.75 0.5 3 2.5 1 3 1 2 1 4 1.5 2.25 1 4 2.75 2 3.5 3 3 1.3 5 2 3 1.5 5 3.15 3 4.25 5 3.2 1.7 7 Expected Variance 1.50 2.29 1.00 4.00 2.78 2.00 3.54 3.00 2.87 1.32 5.17 29.46 0.50 0.99 0.33 2.67 0.61 1.33 1.51 4.00 1.04 0.32 5.50 18.80 a) Expected completion date is in 29.46 weeks i.e., approx 30 weeks Therefore, earliest completion date at 99.7% significance is (29.46-3) = 26.46 weeks, i.e., approx 27 weeks Therefore, latest completion date at 99.7% significance is (29.46+3) = 32.46 weeks, i.e., approx 33 weeks b) Probablity that project will be completed by 21 weeks: Z = (29.46-21)/18.80 = 1.9507475 Therefore, probablity = 97.44% ks, i.e., approx 27 weeks s, i.e., approx 33 weeks