These problems illustrate the application of Little's Law. 1. Suppose that a voting facility processes an average of 40 people per hour (throughput) and that, on average, it takes 20 minutes for each person to complete the voting process (flow time). 2. Suppose that the loan department of a bank takes an average of 15 days (0.5 months) to process an application (flowtime) and that an internal audit found that about 140 applications are in various stages of processing at any one time (work-in-process). 3. Suppose that a restaurant makes 410 pizzas per week, each of which uses 1/2 pound of dough, and that it typically maintains an inventory of 60 pound 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. voters 2. What is the throughput (per month) for the problem 2? Round your answer to the nearest whole value. spplications per month 3. What is the fow time (in weeks) for the problem 3? Round your answer to two decimal places. weeks Prepared order waits for waiter to pick up customer's order 8 (6 minutes per order) X(1hw/60 min) X ( $70 per hour) =$7.00 Total Time =20 minutes (VA time) +11 minutes (NVA time) =31 minutes Total Cost =$11.67( VA cost )+$7.417 (NVA cost )=$19.087 If a restaurant uses iPads to place orders and notify waiters when the customer's order is ready, the time on the order board (now an electronic order board) decreases from 5 to 2 minutes, and the prepared order wait time decreases from 6 to 3 minutes. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below