Question

N U ST C Question 3 (2 points) A bus route using 40-seat buses has a total of nine (9) stops. The door opening and closing times can be assumed to be equal to 4 seconds. All passengers are required to board the bus through the front door and alight through the back door. Ridership for the route is given below: Stop Number 1 2 3 4 5 7 8 Alighting 0 10 22 28 17 25 31 31 Passengers Boarding Passengers 22 17 24 20 22 26 15 25 Studies have shown that boarding time is 2.5 s/passenger when no standees are present and that the presence of standees increases the boarding time to 3 s/passenger. Alighting time is estimated to be equal to 2 s/passenger. In Box #1, enter the critical bus stop (e.g.. "1" or "2" or 3, etc.). In Box #2, enter the dwell time at that critical bus stop. number with no units of measure. Your answer should be a whole Page 3 of 3 Previous Page Next Pagé Submit Quiz 0 of 3 questions saved

Answer 1

50 Mrcrosoft Excel n Picture Tools Formulas Format Home Insert Page Layout Data Review View E AutoSum Cut = == A A Wrap Text General Fill Copy A Conditional Format Formatting as Table Paste Merge & Center Cell Insert Delete Format Sort & Find & S BIU Format Painter Clear Styles Filter Select Styles Editing Clipboard For Allignment Number Cells Picture 1 A C D G J M N 1 Given SAlighting Time Dwell Time = Door movement time + max ofBoarding Time 2 40 seater bus 4 sec for opening and closing of door at each stop 2sec/passenger Alighting time 4 2.5 sec/passenger when number of passengers in bus <40 3 sec/passenger when number of passengers in bus <40 5 Boarding time = 6 7 Alighting Boarding Number of Time Dwell Passengers in Bus Time Stop 8 Number time 22 9 1 22 59 10 17 7 32 46.5 Answer: 11 10 24 46 76 Critical Bus stop is the stop with withlowest capacity i.e 12 22 20 44 64 the stop with maximum number of passengers in bus (a.) Here the Critical Bus stop is stop no.6 (b.) The dwell time for critical stop is 82 seconds 13 28 22 38 60 14 6 17 26 47 82 15 7 25 15 37 54 16 31 25 1 66.5 66 17 9 31 0 0 18 19 20 Sheet1 Sheet2 Sheet3 120% Ready 4:50 AM 14/06/2019

PO x 50 Mrcrosoft Excel Picture Tools X Home Insert Page Layout Formulas Data Review View Format Trace Precedents Show Formulas Trace Dependents Error Checking Define Name- Calculate Now ? &Use in Formula Date & Lookup & Time Reference Calculation Calculate Sheet Options Insert AutoSum Recently Financial Lo gical Text Math More Name Watch Remove Arrows Evaluate Formula Window Formula Auditing Manager & Trig Functions ? Create from Selection Function Used Detined Names Calculation Function Library Picture 1 C D E G 1 Given seater bus 2 40 Dw sec for opening and 3 4 2sec/passenger Alighting time = 4 sec/passenger when number of passen 2.5 5 Boarding time = sec/passenger when number of passen 6 7 Boarding Time Dwell Time Number of Alighting time Stop Passengers in Bus 8 Number =$A$3+MAX(B9*2,C9*IF(D9<40,2.5,3)) =SA$ 3+ MAX(B10*2,C10* I F(D10<40,2.5,3)) =SA$ 3 + MAX (B11*2,C11* I F(D11<40,2.5,3)) -SA$3+MAX(B12*2,C12* I F(D12<40,2.5,3)) -SA$3+MAX(B13*2,C13*IF(D13<40,2.5,3)) -SA$3+MAX(B14*2,C14* I F(D14<40,2 .5,3 ) - SA$ 3+ MAX (B15*2,C15 * I F(D15<40,2.5,3)) |SA$3+MAX(B16*2,C16*IF(D16<40,2.5,3)) =SA$3+MAX(B17*2,C17*IF(D17<40,2.5,3)) 22 9 1 -C9 - B9 =D9+C10-B10 17 10 2 7 -D10+ C11 - B11 11 3 24 10 20 -D11 +C12-B12 22 12 4 - D12 + C13 - B13 13 5 28 22 + C14- B 14 14 6 17 26 -D13 15 7 25 15 - D14 + C15 - B15 25 D15+C16-B16 16 8 31 D16+C17-B17 17 9 31 0 18 19 20 Sheet1 Sheet2 Sheet3 120% Ready 4:51 AM 14/06/2019