Simulation Problem: Not on Excel-Please identify whether usage of Poisson or Exponential for Direct Table Lookup)

Create table

1. Philip D. Selz owns Phils Truck Stop which opens at 6:00 AM each morning. Trucks arrive randomly at a rate of 20 per hour. There is one self-service ($4/gallon) and one full-service ($4.20/gallon) pump. The time to service a truck is variable and averages 3 minutes at the self-service and 4 minutes at the full-service pump. Trucks prefer the self-service but will switch to the full-service if the self-service is busy and the full-service pump is idle. The amount of fuel a truck will hold is normally distributed with a mean of 50 gallons and a standard deviation of 10 gallons. Simulate the revenue from trucks.

Arrival Time: .8647, .6321, .6321

Service Time: .9817, .7769, .7769

Gasoline Volume: .0228, .8413, .5000