Question: Can you provide a step by step solution because I cannot see the solution, it's only the question Project : Toll Booth The Maine State

Can you provide a step by step solution because I cannot see the solution, it's only the question

Can you provide a step by step solution because I cannot see

Project : Toll Booth The Maine State Thruway Authority is planning a new entrance/exit and is thinking about the number of tollbooths to construct. Extensive thruway data shows that the average time needed to handle a toll transaction is 15 seconds. Let us suppose that the number of vehicles needing to pass through the tollgate (during peak traffic) follows the probability distribution: 10-20 21-25 26-29 30-33 34-45 12% 37% 31% 14% 6% Screenshots from Microsoft Excelk) Used by permission of Microsoft Corporation Create a spreadsheet which randomly assigns the # cars arriving per minute using the probabilities above, allows you to input a number of tollbooths. and which tracks the back-up of cars over a I hour period. 1. Fill in the following table (by hand no Excel) assuming there are 6 toll booths constructed. This is VERY IMPORTANT, you must do this paper and pencil exercise first and understand what you are being asked to do before you can hope to create a spreadsheet! Minutes New Arrivals Total Cars Departures Back-up 21 32 3 15 28 Your spreadsheet should include: 2. Well-labeled cells giving

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!