PART 2: LITTLE'S LAW This part would help you to reinforce your understanding of the Little's Law. We have a hypothetical situation where customers arrived at a line, got their paperwork checked, and exited the line. In addition, we recorded this paperwork checking process from 9:00 to 9:30AM. The simulated data are in the Excel file TOM3010_OM_Project_Part2_Data.xlsx which can be found together with this Project Description on Canvas. Based on these data, you would need to calculate the three fundamental metrics of the process and check to what extent they follow the Little's Law. Essentially, you would practice with calculating averages. As how you would record processes in the reality, the simulated data include time stamps of arrivals and exits. With this recording method, you can deal with complications like some customers might arrive in groups and some customers might arriver earlier or exit later than the recording time window. Thus, this exercise can be applied to many real-life processes. In your report of this part, you need to present the following: (a) Based on the data, define and independently calculate the three fundamental metrics: observed average inventory (customers), observed average flow rate (customers per minute), and observed average flow time (minutes). Please show how you calculate these metrics and use 3 decimal places in the final results. You may copy work from Excel. These calculations were discussed in class. Just refer to the banking example in Module 03 - Slide 23. Especially, to find the observed average inventory, you would need to divide the recording time window into a grid of points in time, the finer the grid the better. The minimum is one point for every minute. (b) Using the Little's Law, calculate the predicted average inventory (customers). Then, present the following table with all four values (3 decimal places): Value 1 Observed average inventory (number of customers in line) ? Value 2 Observed average flow rate (nur ber of through customers per minute) Value 3 Observed average flow time (number of minutes waiting in line) ? Value 4 Predicted average inventory (number of customers in line) ? (c) Calculate the percentage difference between Value 1 and Value 4, i.e. 100%x(V1-V4)/V4. Then, make a statement on how close these two values are. If Value 1 and Value 4 differ by a large margin (more than 5%), discuss possible reasons for the difference and corresponding approaches to narrow the gap. Please feel free to discuss the difficulties that you find. ? Below are simulated data of a hypothetical line of customers from 9:00 to 9:30 AM The customers arrived at the line, got their paperwork checked, and excited the line Some of the customers arrived in groups of two, three or more and exited together, There were more than one agents who checked the paperwork. Customer ID Arrival Time Exdt Time Notes 1 9:00:17 This customer arrived earlier than 9-GAM 2 9:01:16 This customer arrived earlier than 9:00AM 3 9:00:17 9:01:55 4 9:00:36 9:02:07 5 9.02:35 9:04:25 6 9:03:26 9:05:07 7 9:03:27 9:05:04 8 9:04:07 9:06:06 9:04:28 9:05:42 10 9:04:28 9.06.05 11 9:05:06 9:06:44 12 9:05:49 9:07:43 13 9:06:18 9:07:47 14 9:06:51 9:08:12 15 9:07:19 9:08:31 16 9:07:41 9:08:52 17 9:08:05 9:09:37 18 9:08:50 9:10-18 19 9:09:00 9:10:12 20 9:09:34 9:10:00 21 9:09:43 9:11:35 22 9:10:36 9:11:47 23 9:10:36 9:11:44 24 9:12:13 9:13:46 25 9:12:26 9:13:38 26 9:12:49 9:15.02 27 9:13:12 9:14:35 28 9:14:42 9:15:40 29 9:15:44 9:17:21 30 9:17:38 9:19:00 31 9:19:35 9:21:04 32 9:19:35 9:20:40 33 9:19:35 9:20:48 34 9:21:02 9:22:48 35 9:21:18 9:23-19 36 9:21:33 9:22:54 37 9:22:09 9:23:13 38 9:22:47 9:24:19 39 9:23:13 9:24:26 40 9:23:29 9:25:01 41 9:23:33 9:25:05 42 9:24:05 9:24:45 43 9:24:14 9:24:52 44 9:25:17 9:27:17 45 9:26:11 9:27:57 46 9:26.44 9:27:53 47 9:25:48 This customer excited later than 9:30 AM 9:27:27 9:28:57 49 9:27:27 9.28.55 50 9.2727 9:28:43 51 9:29:22 This customer te later than 90AM 52 9:29:49 This customer sted later than 9:30 AM PART 2: LITTLE'S LAW This part would help you to reinforce your understanding of the Little's Law. We have a hypothetical situation where customers arrived at a line, got their paperwork checked, and exited the line. In addition, we recorded this paperwork checking process from 9:00 to 9:30AM. The simulated data are in the Excel file TOM3010_OM_Project_Part2_Data.xlsx which can be found together with this Project Description on Canvas. Based on these data, you would need to calculate the three fundamental metrics of the process and check to what extent they follow the Little's Law. Essentially, you would practice with calculating averages. As how you would record processes in the reality, the simulated data include time stamps of arrivals and exits. With this recording method, you can deal with complications like some customers might arrive in groups and some customers might arriver earlier or exit later than the recording time window. Thus, this exercise can be applied to many real-life processes. In your report of this part, you need to present the following: (a) Based on the data, define and independently calculate the three fundamental metrics: observed average inventory (customers), observed average flow rate (customers per minute), and observed average flow time (minutes). Please show how you calculate these metrics and use 3 decimal places in the final results. You may copy work from Excel. These calculations were discussed in class. Just refer to the banking example in Module 03 - Slide 23. Especially, to find the observed average inventory, you would need to divide the recording time window into a grid of points in time, the finer the grid the better. The minimum is one point for every minute. (b) Using the Little's Law, calculate the predicted average inventory (customers). Then, present the following table with all four values (3 decimal places): Value 1 Observed average inventory (number of customers in line) ? Value 2 Observed average flow rate (nur ber of through customers per minute) Value 3 Observed average flow time (number of minutes waiting in line) ? Value 4 Predicted average inventory (number of customers in line) ? (c) Calculate the percentage difference between Value 1 and Value 4, i.e. 100%x(V1-V4)/V4. Then, make a statement on how close these two values are. If Value 1 and Value 4 differ by a large margin (more than 5%), discuss possible reasons for the difference and corresponding approaches to narrow the gap. Please feel free to discuss the difficulties that you find. ? Below are simulated data of a hypothetical line of customers from 9:00 to 9:30 AM The customers arrived at the line, got their paperwork checked, and excited the line Some of the customers arrived in groups of two, three or more and exited together, There were more than one agents who checked the paperwork. Customer ID Arrival Time Exdt Time Notes 1 9:00:17 This customer arrived earlier than 9-GAM 2 9:01:16 This customer arrived earlier than 9:00AM 3 9:00:17 9:01:55 4 9:00:36 9:02:07 5 9.02:35 9:04:25 6 9:03:26 9:05:07 7 9:03:27 9:05:04 8 9:04:07 9:06:06 9:04:28 9:05:42 10 9:04:28 9.06.05 11 9:05:06 9:06:44 12 9:05:49 9:07:43 13 9:06:18 9:07:47 14 9:06:51 9:08:12 15 9:07:19 9:08:31 16 9:07:41 9:08:52 17 9:08:05 9:09:37 18 9:08:50 9:10-18 19 9:09:00 9:10:12 20 9:09:34 9:10:00 21 9:09:43 9:11:35 22 9:10:36 9:11:47 23 9:10:36 9:11:44 24 9:12:13 9:13:46 25 9:12:26 9:13:38 26 9:12:49 9:15.02 27 9:13:12 9:14:35 28 9:14:42 9:15:40 29 9:15:44 9:17:21 30 9:17:38 9:19:00 31 9:19:35 9:21:04 32 9:19:35 9:20:40 33 9:19:35 9:20:48 34 9:21:02 9:22:48 35 9:21:18 9:23-19 36 9:21:33 9:22:54 37 9:22:09 9:23:13 38 9:22:47 9:24:19 39 9:23:13 9:24:26 40 9:23:29 9:25:01 41 9:23:33 9:25:05 42 9:24:05 9:24:45 43 9:24:14 9:24:52 44 9:25:17 9:27:17 45 9:26:11 9:27:57 46 9:26.44 9:27:53 47 9:25:48 This customer excited later than 9:30 AM 9:27:27 9:28:57 49 9:27:27 9.28.55 50 9.2727 9:28:43 51 9:29:22 This customer te later than 90AM 52 9:29:49 This customer sted later than 9:30 AM