Calit - AA General AY Wiap Text Merge Center inuet Delite Format B1 W % 911 o A- Cada anal format Cell Formatting Table Styles Sort & Filters Cipboard C Aimot Number Editing 652 Project 2: PART II. Ideal Number of Toll Booths (Introduction) Number of Arrivals Probability 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 tollate during peak traffic) follows the probability distribution shown in the tables and the Histograme 10 to 19 12% 20 10 24 37% 33% 25 to 29 30 10 33 12% 7 34 to 45 6% 1 11 Probability Distribution of Cars Arriving each Minute Number of 10 to 19 20 to 24 Arrivals Probability 12% 2296 3000 33 34 to 45 25 to 29 33% 12% 6% Shorts Dart Warm Up Part II introduction) PUD PART IV Cost Revenge destination Rent Data Page Layout Home Formas Insert Help Review Search T Caleb A = Waplot General WC Insert Delete Format 8 1 V- a A- Meige Center. $ - % *## Conditional Format Cell Formatting Table Styles Styr Sort Find Filter Selec Iding Dad Font Abonnent Numbe Probability Distribution of Cars Arriving each Minute Number of 10 to 19 20 to 24 Arrivals Probability 12% 37% 25 to 29 30 to 33 34 to 45 33% 12% 6% H Antent the you therefore with of time, the 11 of men will be ben 10 and time will content insan AND SOON 1.12 points) We will later build a table with the form shown below. What you see below is merely a practice Compute the values in each blank cell using your own brain (not using excel function.) and "hand-type" these numbers. Assume that there are 6 toll boths and each booth can process a car in 15 seconds. Minutes New Arrivals Total Cars Departures Back-Up INumber of tumbn of cars that ved portaching the tourneren are still waiting Dacoth torted booths during this previoule the end of the observation period) period 21 21 Part 1 Warm Up) Part Il introduction) Part Back Up) PART IV (Cast and Revenue nation and INTER Chorite Type here to search BI G mer . O oSave project2-1 - Excel mirthamed@gmail.com Home Insert Page Layout Formulas Data Review View Search Calibri 10 A A Wrap lant 53. Merge Center - General 5 - % 8 Insert Delde forma Sant BTU- Conditional Format Cell Formatting Table Styles Font Alignment Number Ce Edit M 1.2 points) We will later build a table with the form shown below. What you see below is merely a practice Compute the values in each blank cell using your own brain (not using excel functions.) and "hand-type" these numbers. Assume that there are 6 toll boths and each booth can process a car in 15 seconds. Minutes New Arrivals Total Cars... Departures Back Up on approaching the toll number of new arrivals the number of care booths during this number Ortoperiod identified by the plus bacarom the previoul period the departe during the number of cars that are still waiting at the end of the period observation period 1 2 25 20 5 25 2. (2 points) Let's try another one. This time let's assume there are only 4 toll boths As before, assume that each booth can process a car in 15 seconds. Parti (Back up PART IV Cost and Revenue Part II introduction) Sheet1 Part I (Warm Up) stion and press ENTER or choose Pai G Type here to search ORE DOLL 05 D Search 24 Home Page Layout Formus Data Review View rip Colibri -AA Wiplert Date BTU- A = Menge Center Clipboard Font Ang General $ % WC Insert Drir Fumet Conditional Format CH Formatting - Table Styles Style Sona Sind Filter Select Tating Nuno Cells GS2 2. (2 points) Let's try another one. This time let's assume there are only 4 toll boths As before, assume that each booth can process a car in 15 seconds. Minutes New Arrivals Back Upine Total Care Departures number of cars that herning the Cheras daryti om the there pre booth during this observation period 21 wel wat the end of the Deriod 21 7 15 END OF PARTI Part It Introduction Pat (Back up PART IV Cost and Revente Sheet Part (Warm Up) cortandort BHITR or choose Paste Type here to search o DOLL