QUESTION 16 20 points suve Answer You know the manager of a small low cream shop. During the summer months, customers arrive, according to an exponential distribution, overy 2 minutes. You have two workstations. At station 1. the customer's order and payment are taken and at station 2, the customer's ice cream is assembled and delivered Order and payment takes on average 15 minutes but it is not constant. Your best guess is that it happens according to a normal distribution with a standard deviation of 5 minutes. Similarly, the construction delivery workstation distribution is normal with a mean of 2 minutes and a standard deviation of 25 minutes. The shop is small so there is only room in the order line for 5 people and in the delivery line for 4 people. The shop owner wants to know a few things about the service process, so the owner hires an MBA student to run 100 simulations through SimQuick (the owner really cares about the evening rush, which is 180 minutes long). Oh, I forgot to mention, YOU are the MBA student. The owner asks you the following questions. You must provide evidence to go with your answers using the attached simulation results in this spreadsheet a. How often do customers try to enter the shop, but cannot because there is no room to do so? b. How many people are typically in line to place an order? c. How long does the average customer spend in line before getting to place their order? d. How long does the average customer spend in the system from waiting in line until they leave with their sweet treat? For the toolbar, press ALT+F10 (PC) or ALT+FNF10 (Mac), BIVS Paragraph Arial 10pt T. YAO y X . Click Save and Submit to and submit Click Save All Answers to see all answers Save All Answers Save and Submit Format F Formatting Table Styles Styles Clipboard Font Alignment Number Coille 043 E G H Statistics Objects entering process Objects unable to enter Service level Overall Means 86.57 3.03 0.97 B 1 Ice Cream Shop Simulation Results 2 Element Element 3 Types Names 4 Entrance(s) Door 5 6 7 8 Work Station(s) Order/Pay 9 10 11 2 3 4 5 6 Delivery 7 B 9 Final status Final inventory (int, buff.) Mean inventory (int. buff.) Mean cycle time (int. buff.) Work cycles started Fraction time working Fraction time blocked NA 0.09 0.06 0.13 85.12 0.70 0.06 Final status Final inventory (int, buff.) Mean inventory (int. buff.) Mean cycle time (int. buff.) Work cycles started NA 0.00 0.00 0.00 82.01 Sheet1 . Number 2 22 || lu .... : 28 Pite $ - % Condo Format C Primatting The Styles Sort - Antaly Det Ay 043 M 19 20 25 22 23 24 Buffert 25 Mean cyde timelint, bull) Work cycles started Fraction time working Fraction time blocked D 0.00 82.01 0.91 0.00 Order Queue Objects leaving Final inventory Minimum inventory Maximum inventory Mean inventory Mean cycle time 85.12 1.45 0.00 4.78 1.19 2.42 29 Delivery Queue Objects leaving Final inventory Minimum inventory Maximum inventory Mean inventory Mean cycle time 82.01 236 0.00 3.97 193 4.16 Served Customers Objects leaving Final inventory 0.00 81.00 Delivery Queue Objects leaving Final inventory Minimum inventory Maximum inventory Mean inventory Mean cycle time 82.01 2.36 0.00 3.97 1.93 4.16 Served Customers Objects leaving Final inventory Minimum inventory Maximum inventory Mean inventory Mean cycle time 0.00 81.09 0.00 81.09 38.83 Infinite + QUESTION 16 20 points suve Answer You know the manager of a small low cream shop. During the summer months, customers arrive, according to an exponential distribution, overy 2 minutes. You have two workstations. At station 1. the customer's order and payment are taken and at station 2, the customer's ice cream is assembled and delivered Order and payment takes on average 15 minutes but it is not constant. Your best guess is that it happens according to a normal distribution with a standard deviation of 5 minutes. Similarly, the construction delivery workstation distribution is normal with a mean of 2 minutes and a standard deviation of 25 minutes. The shop is small so there is only room in the order line for 5 people and in the delivery line for 4 people. The shop owner wants to know a few things about the service process, so the owner hires an MBA student to run 100 simulations through SimQuick (the owner really cares about the evening rush, which is 180 minutes long). Oh, I forgot to mention, YOU are the MBA student. The owner asks you the following questions. You must provide evidence to go with your answers using the attached simulation results in this spreadsheet a. How often do customers try to enter the shop, but cannot because there is no room to do so? b. How many people are typically in line to place an order? c. How long does the average customer spend in line before getting to place their order? d. How long does the average customer spend in the system from waiting in line until they leave with their sweet treat? For the toolbar, press ALT+F10 (PC) or ALT+FNF10 (Mac), BIVS Paragraph Arial 10pt T. YAO y X . Click Save and Submit to and submit Click Save All Answers to see all answers Save All Answers Save and Submit Format F Formatting Table Styles Styles Clipboard Font Alignment Number Coille 043 E G H Statistics Objects entering process Objects unable to enter Service level Overall Means 86.57 3.03 0.97 B 1 Ice Cream Shop Simulation Results 2 Element Element 3 Types Names 4 Entrance(s) Door 5 6 7 8 Work Station(s) Order/Pay 9 10 11 2 3 4 5 6 Delivery 7 B 9 Final status Final inventory (int, buff.) Mean inventory (int. buff.) Mean cycle time (int. buff.) Work cycles started Fraction time working Fraction time blocked NA 0.09 0.06 0.13 85.12 0.70 0.06 Final status Final inventory (int, buff.) Mean inventory (int. buff.) Mean cycle time (int. buff.) Work cycles started NA 0.00 0.00 0.00 82.01 Sheet1 . Number 2 22 || lu .... : 28 Pite $ - % Condo Format C Primatting The Styles Sort - Antaly Det Ay 043 M 19 20 25 22 23 24 Buffert 25 Mean cyde timelint, bull) Work cycles started Fraction time working Fraction time blocked D 0.00 82.01 0.91 0.00 Order Queue Objects leaving Final inventory Minimum inventory Maximum inventory Mean inventory Mean cycle time 85.12 1.45 0.00 4.78 1.19 2.42 29 Delivery Queue Objects leaving Final inventory Minimum inventory Maximum inventory Mean inventory Mean cycle time 82.01 236 0.00 3.97 193 4.16 Served Customers Objects leaving Final inventory 0.00 81.00 Delivery Queue Objects leaving Final inventory Minimum inventory Maximum inventory Mean inventory Mean cycle time 82.01 2.36 0.00 3.97 1.93 4.16 Served Customers Objects leaving Final inventory Minimum inventory Maximum inventory Mean inventory Mean cycle time 0.00 81.09 0.00 81.09 38.83 Infinite +