Attached is a copy of an Excel spread sheet,

This spreadsheet contains 4 worksheets

oWorksheet #1: Lists the random numbers you use for your simulation. There are three sets, with each set having up to 50 numbers. Use each set for each type of randomization. For example, on problem 9, you will use the first set to randomize interarrival times and the second set to randomize service times.

oWorksheet #2: This contains the solution to problem 4-12. The formulas contained in this worksheet should assist you with 4-9 and 4-20. Also note how the random numbers from worksheet #1 were used in this worksheet.

oWorksheet #3: Contains problem 4-9, to complete

oWorksheet #4: Contains problem 4-20, to complete.

Problem 12 is already done. their are only two problems that is 9 and 20

9. The time between arrivals of oil tankers at a loading dock at Prudhoe

bay is given by the following probability distribution.

Time between ship arrivals (days)

Probability

1

.05

2

.10

3

.20

4

.30

5

.20

6

.10

7

.05

1.00

The time required to fill a tanker with oil and prepare it for sea is

given by the following probability distribution.

Time to fill and Prepare (days)

Probability

3

.10

4

.20

5

.40

6

.30

1.00

Simulate the movement of tankers to and from the single loading dock for

the first 20 arrivals. Compute the average time between arrivals,

average waiting time to load, and the average number of tankers waiting

to be loaded.

Discuss any hesitation you might have about using your results for

decision making.

12. Each semester the student in the college of business at State

University must have their course schedules by the college advisor. The

students line up in the hallway outside the advisorâs office. The

students arrive at the office according to the following probability

distribution.

Time between Arrivals (min)

Probability

4

.20

5

.30

6

.40

7

.10

1.00

The time required by the advisor to examine and approve a schedule

corresponds to the following probability distribution.

Schedule Approval (min)

Probability

6

.30

7

.50

8

.20

1.00

Simulate this course approval system for 90 minutes. Compare the average

queue length and the average time a student must wait, and discuss the

results.

20. The Western Outfitters store specializes in denim jeans. The

variable cost of the jeans varies according to several factors,

including the cost of the jeans from the distributor, labor cost,

handling, packaging, and so on. Price also is a random variable that

varies according to the competitorâs price. Sales volume also varies

each month. The probability distributions for price, volume, and

variable costs each month are as follows.

Sales Volume

Probability

300

.12

400

.18

500

.20

600

.23

700

.17

800

.10

1.00

Price

Probability

$22

.07

23

.16

24

.24

25

.25

26

.18

27

.10

1.00

Final costs are $9,000 per month for the store.

Simulate 20 months of store sales, and compute the probability the store

will at least break even and the average profit (or loss).

This spreadsheet contains 4 worksheets

oWorksheet #1: Lists the random numbers you use for your simulation. There are three sets, with each set having up to 50 numbers. Use each set for each type of randomization. For example, on problem 9, you will use the first set to randomize interarrival times and the second set to randomize service times.

oWorksheet #2: This contains the solution to problem 4-12. The formulas contained in this worksheet should assist you with 4-9 and 4-20. Also note how the random numbers from worksheet #1 were used in this worksheet.

oWorksheet #3: Contains problem 4-9, to complete

oWorksheet #4: Contains problem 4-20, to complete.

Problem 12 is already done. their are only two problems that is 9 and 20

9. The time between arrivals of oil tankers at a loading dock at Prudhoe

bay is given by the following probability distribution.

Time between ship arrivals (days)

Probability

1

.05

2

.10

3

.20

4

.30

5

.20

6

.10

7

.05

1.00

The time required to fill a tanker with oil and prepare it for sea is

given by the following probability distribution.

Time to fill and Prepare (days)

Probability

3

.10

4

.20

5

.40

6

.30

1.00

Simulate the movement of tankers to and from the single loading dock for

the first 20 arrivals. Compute the average time between arrivals,

average waiting time to load, and the average number of tankers waiting

to be loaded.

Discuss any hesitation you might have about using your results for

decision making.

12. Each semester the student in the college of business at State

University must have their course schedules by the college advisor. The

students line up in the hallway outside the advisorâs office. The

students arrive at the office according to the following probability

distribution.

Time between Arrivals (min)

Probability

4

.20

5

.30

6

.40

7

.10

1.00

The time required by the advisor to examine and approve a schedule

corresponds to the following probability distribution.

Schedule Approval (min)

Probability

6

.30

7

.50

8

.20

1.00

Simulate this course approval system for 90 minutes. Compare the average

queue length and the average time a student must wait, and discuss the

results.

20. The Western Outfitters store specializes in denim jeans. The

variable cost of the jeans varies according to several factors,

including the cost of the jeans from the distributor, labor cost,

handling, packaging, and so on. Price also is a random variable that

varies according to the competitorâs price. Sales volume also varies

each month. The probability distributions for price, volume, and

variable costs each month are as follows.

Sales Volume

Probability

300

.12

400

.18

500

.20

600

.23

700

.17

800

.10

1.00

Price

Probability

$22

.07

23

.16

24

.24

25

.25

26

.18

27

.10

1.00

Final costs are $9,000 per month for the store.

Simulate 20 months of store sales, and compute the probability the store

will at least break even and the average profit (or loss).

### Recently Asked Questions

- What do we call the period of time towards the end of the Permian period when lots of species died out? A. Mass extinction. B. The

- I need help creating a simple multiplication table using nested loops and if statements with Python. This source code must prompt the user for the size of the

- A diet doctor claims that the average North American is more than 20 pounds over-weight . To test his claim , a random sample of 20 North Americans was