Excel Online Activity: Little's Law These problems illustrate the application of Little's Law. 1. Suppose that a voting facility processes an average of 43 people per hour (throughput) and that, on average, it takes 15 minutes for each person to complete the voting process (flow time). 2. Suppose that the loan department of a bank takes an 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 370 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. Open spreadsheet 1. What is the work-in-process for the problem 1? Round your answer to two decimal places. 15.1 voters 2. What is the throughput (per month) for the problem 2? Round your answer to the nearest whole value. 267 applications per month 3. What is the flow time (in weeks) for the problem 3? Round your answer to two decimal places. 0.35 weeks 123456789 9 10 11 12 13 14 15 16 17 18 3456 A Throughput (per hour) Flow time (in minutes) Flow time (in hours) Work-in-process (WIP) Flow time (in month) Work-in-process (WIP) Throughput (per month) Work-in-process (WIP) Number of pizzas (per week) Pound of dough (per pizza) Throughput (per week) Flow time (in weeks) Little's Law B 43 15 0.40 80 65 370 0.50 D Formulas #N/A #N/A #N/A #N/A #N/A E