Question

 

2. 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?