Excel Online Activity: Little's Low These problems illustrate the application of Little's Law 1. Suppose that a voting facility processes an average of 56 people per hour (throughput) and that, on average, it takes 35 minutes for each person to complete the voting process (flow time) 2. Suppose that the loan department of a bank takes on average of 12 days (0,4 months) to process an application (flowtime) and that an Internal audit found that about 80 applications are in various stages of processing at any one time (work-in-process). 3. Suppose that a restaurant makes 420 pizzas per week, each of which uses 1/2 pound of dough, and that it typically maintains an inventory of 65 pounds of dough Open the spreadsheet and perform the required analysis to answer the questions below. HHH X Open spreadsheet 1. What is the work-in-process for the problem 17 Round your answer to two decimal places, voters 2. What is the throughput (per month) for the problem 27 Round your answer to the nearest whole value applications per month 3. What is the flow time (in weeks) for the problem 3? Round your answer to two decimal places weeks Little's Law Formulas 56 35 Throughput (per hour) Flow time (in minutes) Flow time (in hours) Work-in-process (WIP) #N/A #N/A Flow time (in month) Work-in-process (WIP) Throughput (per month) 0.40 80 #N/A Work-in-process (WIP) Number of pizzas (per week) Pound of dough (per pizza). Throughput (per week) Flow time (in weeks) 65 420 0.50 #N/A #N/A