Question
Susan Winslow has two alternative routes to travel from her home in Olport to her office in Lewisburg. She can travel on Freeway 5 to
Susan Winslow has two alternative routes to travel from her home in Olport to her office in Lewisburg. She can travel on Freeway 5 to Freeway 57 or on Freeway 55 to Freeway 91. The time distributions are as follows:
Freeway 5 | Freeway 57 | Freeway 55 | Freeway 91 | ||||
| Relative |
| Relative |
| Relative |
| Relative |
Time | Frequency | Time | Frequency | Time | Frequency | Time | Frequency |
5 | 0.30 | 4 | 0.10 | 6 | 0.20 | 3 | 0.30 |
6 | 0.20 | 5 | 0.20 | 7 | 0.20 | 4 | 0.35 |
7 | 0.40 | 6 | 0.35 | 8 | 0.40 | 5 | 0.20 |
8 | 0.10 | 7 | 0.20 | 9 | 0.20 | 6 | 0.15 |
|
| 8 | 0.15 |
|
|
|
|
Do a five-day simulation of each of the two combinations of routes using the random numbers below. Based on this simulation, which routes should Susan take if her objective is to minimize her total travel time?
Freeway 5 | 63 | 88 | 55 | 46 | 55 |
Freeway 57 | 59 | 09 | 57 | 87 | 07 |
Freeway 55 | 71 | 95 | 83 | 44 | 34 |
Freeway 91 | 51 | 79 | 09 | 67 | 15 |
Then do a 365-day simulation of each of the two combinations of routes using Microsoft Excel. Based on this simulation, are the routes Susan should take different from the above? If so, why?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started