Please show me how to show the formulas in Excel for these problems. I have to show how I got the answers and this is where I am struggling.

MAT540 Homework Week 3 Page 2 of 3

Simulate the arrival of cars at the service station for 20 arrivals and compute the average time between arrivals.

Simulate the arrival of cars at the service station for 1 hour, using a different stream of random numbers from those used in (a) and compute the average time between arrivals.

Compare the results obtained in (a) and (b).

The Dynaco Manufacturing Company produces a product in a process consisting of operations of five machines. The probability distribution of the number of machines that will break down in a week follows:

Machine Breakdowns Per Week

Probability

Simulate the following decision situation for 20 weeks, and recommend the best decision.

A concessions manager at the Tech versus A&M football game must decide whether to have the vendors sell sun visors or umbrellas. There is a 30% chance of rain, a 15% chance of overcast skies, and a 55% chance of sunshine, according to the weather forecast in college junction, where the game is to be held. The manager estimates that the following profits will result from each decision, given each set of weather conditions:

a. b.

0 0.10
1 0.20
2 0.15
3 0.30
4 0.15
5 0.10
1.00

Simulate the machine breakdowns per week for 20 weeks.

Compute the average number of machines that will break down per week.

MAT540 Homework Week 3 Page 3of 3

Decision

Sun visors Umbrellas

Rain 0.35 $-400 2,100

Weather Conditions

Overcast Sunshine 0.25 0.40

$-200 $1,500 0 -800

5. Every time a machine breaks down at the Dynaco Manufacturing Company (Problem 3), either 1, 2, or 3 hours are required to fix it, according to the following probability distribution:

Repair Time (hr.)

1 0.20

2 0.503 0.30 1.00

Simulate the repair time for 20 weeks and then compute the average weekly repair time.