Question.4216 -
Answer Below:
Sheet1East Route Scheduled 10% longer20% longer30% longer40% longerTotal DistanceSpeedTime ( hrs ) ProbTime ( hrs ) ProbTime ( hrs ) ProbTime ( hrs ) ProbTime ( hrs ) ProbExpected time Washington- Baltimore 40700.570.70.630.30.6900.7400.800.59Baltimore - New York City175702.5002.750.13.000.23.250.53.50.23.20New York City - Kingston 80701.140.11.260.21.370.31.490.31.60.11.38Kingston - sister's Home 10400.250.80.280.20.3000.3300.3500.26Total 4.464.915.365.806.255.43West Route Scheduled 10% longer20% longer30% longer40% longerTotal DistanceSpeedTime ( hrs ) ProbTime ( hrs ) ProbTime ( hrs ) ProbTime ( hrs ) ProbTime ( hrs ) ProbExpected time Washington- Baltimore40700.570.70.630.30.6900.7400.800.59Baltimore - Binghamton160702.290.92.510.12.7402.9703.202.31Binghamton - East Branch50700.710.90.790.10.8600.930100.72East Branch- sister's Home 60401.500.81.650.21.8001.9502.101.53Total 5.075.586.096.597.105.15The total expected time for east route is 5.43 hours and the total expected time for west route is 5.15 hours. Time is calculated as distance / speed. For 10% longer, multiply the scheduled time with 1 + 0.10 or 1.1.Similary for 20 % longer and other, multiply the scheduled time with the given percentage.Total expected time is calculated as D4*E4+F4*G4+H4*I4+J4*K4+L4*M4 for Washington - Baltimore. It applies the same with others and then add the epected time.
.ico)
.ico)
.ico)
.ico)
