Question $1(10$ points$)$:

Using the excel sheet provided, for the mortgage application problem discussed in class, do the following for each of the cases outlined in tabs$/$sheets $2,3,4,5$ and $6,$ draw the diagram and calculate all the metrics outlined in the $$original$$ sheet in the excel file. In other words, follow the steps of the original problem discussed in class and complete tabs $2,3,4,5,6.$

Question $2(10$ Points$)$:

For the Ocean World Theme Park problem discussed in class, provide a layout that maximizes the visitor$$s total distance between attractions. It may take you several iterations to do it $[$Hint: The optimal flow distance will be $210].$ Please show all the steps and explain the iterations clearly. Without providing all the steps you will not be given credit for this problem