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. ORIGINAL PROBLEM Property Survey Credit Report Title Search Final Approval Time (Mins) 15 30 45 60 75 90 105 120 135 150 165 180 195 210 225 240 255 270 285 300 315 Bottleneck - Property Survey System Cycle Time = 90 minutes System Capacity = 1/90 * 60 = 2/3 applications per hour or 5.33 applications per day Capacity Utilization = Actual output/ System Capacity. E.g., 5/5.33 = 93.75% Throughput Time is Average Waiting Time in Intake + Property Survey (90 mins) + Average Waiting Time in Completed Applications + Final Approval (15 mins) Rush Order Flow Time is without any waiting time. 90 mins + 15 mins = 105 mins Total Direct Labor Content is sum of all operations time. 90 min+ 45 min + 30 min + 15 min = 180 minutes Direct Labor Utilization = Total direct labor Content /(Process Cycle Time * Number of Workers) = 180 / (90*4) = 50% PROPERTY SEARCH AND FINAL APPROVAL DONE BY A SINGLE PERSON Property Survey, Final Approval Credit Report Title Search Time (Mins) 15 30 45 60 75 90 105 120 135 150 165 180 195 210 225 240 255 270 285 300 315 CREDIT REPORT AND TITLE SEARCH DONE BY A SINGLE PERSON Property Survey Credit Report, Title Search Final Approval Time (Mins) 15 30 45 60 7590 105 120 135 150 165 180 195 210 225 240 255 270 28S 300 315 PROPERTY SEARCH AND FINAL APPROVAL DONE BY ONE PERSON; CREDIT REPORT AND TITLE SEARCH DONE BY ANOTHER PERSON Property Survey, Final Approval Credit Report, Title Search Time (Mins) 15 30 45 60 75 90 105 120 135 150 165 180 195 210 225 240 255 270 285 300 315 TITLE SEARCH TAKES 60 MINUTES INSTEAD OF 30 MINUTES; EVERYTHING SAME AS ORIGINAL PROBLEM Property Survey Credit Report Title Search Final Approval Time (Mins) 15 30 45 60 75 90 105 120 135 150 165 180 195 210 225 240 255 270 285 300 315 CREDIT REPORT TAKES 75 MINUTES INSTEAD OF 45, AND TITLE SEARCH TAKES 60 MINUTES INSTEAD OF 30 MINUTES. EVERYTHING ELSE SAME AS OIRGINAL PROBLEM Property Survey Credit Report Title Search Final Approval Time (Mins) 15 30 45 60 75 90 105 120 135 150 165 180 195 210 225 240 255 270 285 300 315 330 345 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. ORIGINAL PROBLEM Property Survey Credit Report Title Search Final Approval Time (Mins) 15 30 45 60 75 90 105 120 135 150 165 180 195 210 225 240 255 270 285 300 315 Bottleneck - Property Survey System Cycle Time = 90 minutes System Capacity = 1/90 * 60 = 2/3 applications per hour or 5.33 applications per day Capacity Utilization = Actual output/ System Capacity. E.g., 5/5.33 = 93.75% Throughput Time is Average Waiting Time in Intake + Property Survey (90 mins) + Average Waiting Time in Completed Applications + Final Approval (15 mins) Rush Order Flow Time is without any waiting time. 90 mins + 15 mins = 105 mins Total Direct Labor Content is sum of all operations time. 90 min+ 45 min + 30 min + 15 min = 180 minutes Direct Labor Utilization = Total direct labor Content /(Process Cycle Time * Number of Workers) = 180 / (90*4) = 50% PROPERTY SEARCH AND FINAL APPROVAL DONE BY A SINGLE PERSON Property Survey, Final Approval Credit Report Title Search Time (Mins) 15 30 45 60 75 90 105 120 135 150 165 180 195 210 225 240 255 270 285 300 315 CREDIT REPORT AND TITLE SEARCH DONE BY A SINGLE PERSON Property Survey Credit Report, Title Search Final Approval Time (Mins) 15 30 45 60 7590 105 120 135 150 165 180 195 210 225 240 255 270 28S 300 315 PROPERTY SEARCH AND FINAL APPROVAL DONE BY ONE PERSON; CREDIT REPORT AND TITLE SEARCH DONE BY ANOTHER PERSON Property Survey, Final Approval Credit Report, Title Search Time (Mins) 15 30 45 60 75 90 105 120 135 150 165 180 195 210 225 240 255 270 285 300 315 TITLE SEARCH TAKES 60 MINUTES INSTEAD OF 30 MINUTES; EVERYTHING SAME AS ORIGINAL PROBLEM Property Survey Credit Report Title Search Final Approval Time (Mins) 15 30 45 60 75 90 105 120 135 150 165 180 195 210 225 240 255 270 285 300 315 CREDIT REPORT TAKES 75 MINUTES INSTEAD OF 45, AND TITLE SEARCH TAKES 60 MINUTES INSTEAD OF 30 MINUTES. EVERYTHING ELSE SAME AS OIRGINAL PROBLEM Property Survey Credit Report Title Search Final Approval Time (Mins) 15 30 45 60 75 90 105 120 135 150 165 180 195 210 225 240 255 270 285 300 315 330 345