View the step-by-step solution to:

# Attached is a copy of an Excel spread sheet, This spreadsheet contains 4 worksheets oWorksheet #1: Lists the random numbers you use for your...

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).

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents
• ### -

Question & Answers

Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

Ask a Question