This part would help you to reinforce your understanding of the Little's Law. We have a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 Blackboard. 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 22. 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): Observed average inventory (number of customers in line) Observed average flow rate (number of through customers per minute) Value 3 Observed average flow time (number of minutes waiting in line) Value 1 Value 2 ? ? Value 4 Calculated average inventory (number of customers in line) ? (c) Calculate the percentage difference between Value 1 and Value 4, e.g. 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. The customers arrived at the line, got their paperwork checked, and exited 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 Exit Time Notes 9:00:17 This customer arrived carlier than 9:00OAM 9:01:16 This customer amived carlier than 9:00AM 9:01:55 9:02:07 3. 9:00:17 4 9:00:36 9:02:35 9:04:25 9:03:26 9:05:07 7. 9.03:27 9:05:04 9:0407 9:06:06 9:05:42 9:06:05 9.04:28 10 9:04:28 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 9:11:44 9:13:46 23 9:10:36 24 9:12:13 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:22:47 9:23:13 38 9:24:19 39 9:23:13 9:24:26 40 9:23:28 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:26:48 This customer exited later than 9:30 AM 48 9:27:27 9:28:57 49 9:27:27 9:28:55 50 9:27:27 9:28:43 51 9:29:22 This customer exited later than 9:30 AM 52 9:29 49 This customer exited later than 9:30 AM 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 Blackboard. 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 22. 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): Observed average inventory (number of customers in line) Observed average flow rate (number of through customers per minute) Value 3 Observed average flow time (number of minutes waiting in line) Value 1 Value 2 ? ? Value 4 Calculated average inventory (number of customers in line) ? (c) Calculate the percentage difference between Value 1 and Value 4, e.g. 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. The customers arrived at the line, got their paperwork checked, and exited 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 Exit Time Notes 9:00:17 This customer arrived carlier than 9:00OAM 9:01:16 This customer amived carlier than 9:00AM 9:01:55 9:02:07 3. 9:00:17 4 9:00:36 9:02:35 9:04:25 9:03:26 9:05:07 7. 9.03:27 9:05:04 9:0407 9:06:06 9:05:42 9:06:05 9.04:28 10 9:04:28 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 9:11:44 9:13:46 23 9:10:36 24 9:12:13 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:22:47 9:23:13 38 9:24:19 39 9:23:13 9:24:26 40 9:23:28 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:26:48 This customer exited later than 9:30 AM 48 9:27:27 9:28:57 49 9:27:27 9:28:55 50 9:27:27 9:28:43 51 9:29:22 This customer exited later than 9:30 AM 52 9:29 49 This customer exited later than 9:30 AM
Expert Answer:
Answer rating: 100% (QA)
a Then for every minute you calculate the difference between the number of customers who arrived and the number of customers who exited The values of ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
This problem is designed to reinforce your understanding of the simplex feasibility condition. In the first tableau in Example 3.3-1, we used the minimum (nonnegative) ratio test to determine the...
-
To show your understanding of the WARN notice, answer these questions: (a) Who are the covered employers? (b) What format is required for a WARN notice? (c) When must the WARN notice be given? (d) To...
-
This exercise tests your understanding of the four inventory methods. List the name of the inventory method that best fits the description. Assume that the cost of inventory is rising. 1....
-
One of Red Clay's employee handbook sections covers employee monitoring. An employee filed a complaint with the HR department stating he opposes this monitoring and chooses to opt out. What legal...
-
Interested in the possible relationship between the size of his tip versus the size of the check and the number of diners in the party, a food server has recorded the following for a sample of 8...
-
Find the cross product a b and verify that it is orthogonal to both a and b. 6, 0, 2, b = 0, 8, 0
-
Time value is the anticipation of intrinsic value being stronger than it is now. However, intrinsic value can drop. Why then can time value not be negative?
-
Andys Autobody Shop has the following balances at the beginning of September: Cash, $10,000; Accounts Receivable, $1,450; Equipment, $40,000; Accounts Payable, $2,000; Common Stock, $20,000; and...
-
A Solve for x. A= = C 3 6 R 3 D H E
-
The balance sheet provides a snapshot of the financial condition of a company. Investors and analysts use the information given on the balance sheet and other financial statements to make several...
-
Use the product-to-sum identities and the sum-to-product identities to prove the identity below. sin 40+ sin 60=cot 0(cos 40- cos 60) To verify the identity, start with the left side and transform it...
-
In a warehouse, safety is paramount. A safe warehouse helps you to protect your product, and more importantly your personnel. When a warehouse is unsafe or your staff is untrained it can lead to...
-
Do you think you have good time management skills? Provide two specific examples to support your answer. (4 marks) No one is only good or only bad at something at something like time management....
-
2) Water slowly evaporates from a circular shaped puddle. The radius of the puddle decreases at a rate of 8 in/hr. Assuming the puddle retains its circular shape, at what rate is the area of the...
-
A river narrows at a rapids from a width of 12 m to a width of only 5.6 m. The depth of the river before the rapids is 3.0 m; the depth in the rapids is 0.75 m. Part A Find the speed of water flowing...
-
What will be the correct balance of cash at May 31, 2025? In preparing its May 31, 2025 bank reconciliation, Metlock Co. has the following information available: Balance per bank statement, 5/31/25...
-
Raw Materials Bal. 1/1 23,000 Credits Debits 136,000 Selected T-accounts of Moore Company are given below for the just completed year. Manufacturing Overhead 204,720 Credits Debits Bal. 12/31 33,000...
-
Write a paper about the Working relationship in the organization- collaboration within and outside the organization
-
Solve the following LP in three different ways (use TORA for convenience). Which method appears to be the most efficient computationally? Minimize z = 6x1 + 7x2 + 3x3 + 5x4 Subject to 5x1 + 6x2 - 3x3...
-
Show that the 100% feasibility rule in Problem 12, Set 3.6c (Chapter 3) is based on the condition Optimum) orginal right-hand inverse side vector
-
An eccentric sheikh left a will to distribute a herd of camels among his three children: Tarek receives at least one-half of the herd, Sharif gets at least one third, and Maisa gets at least...
-
Which and how many methods would you recommend using prior to committing to a 1m development project?
-
The hotel has a maximum of 800,000 available for capital investment Note: these figures are cash flows; depreciation is straight-line over 4 years. a) Calculate the payback period, accounting rate of...
-
Using the data from question 6, calculate the IRR. How does this impact on your decision making?
Study smarter with the SolutionInn App