Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Property Finance

Authors: Giacomo Morri, Antonio Mazza

1st Edition

1118764404, 978-1118764404

More Books

Students also viewed these Finance questions