problems must be done in Excel. Can you show how it was done in excel as well? Commercial trucks traveling through Monum
Posted: Wed Jul 06, 2022 12:11 pm
problems must be done in Excel. Can you show how it was done inexcel as well?
Commercial trucks traveling through Monument, Colorado must stopat aweigh station. Trucks arrive at the station at an average rate of16 per hour(Poisson distributed), and it takes on average of 2.8 minutes toweigh eachtruck (following an exponential distribution) on the singlescale.
a. What is the average number of trucks waiting to beweighed?b. How long, on average, does a truck spend at the weigh station(includingthe time in line, and the time being weighed)?c. The weigh station can operate safely with up to 8 trucks in thesystem.What is the probability that this capacity will be exceeded?d. A national trucking association estimates that the cost of anidle truck is$39 per hour. In an 8 hour day, what does the weigh station costthetrucking industry?e. Adding another person to work at the weigh station would cost$22 perhour, and would allow trucks to be processed in 2.4 minutes. Shouldthetrucking industry offer to pay for this additional worker?
Commercial trucks traveling through Monument, Colorado must stopat aweigh station. Trucks arrive at the station at an average rate of16 per hour(Poisson distributed), and it takes on average of 2.8 minutes toweigh eachtruck (following an exponential distribution) on the singlescale.
a. What is the average number of trucks waiting to beweighed?b. How long, on average, does a truck spend at the weigh station(includingthe time in line, and the time being weighed)?c. The weigh station can operate safely with up to 8 trucks in thesystem.What is the probability that this capacity will be exceeded?d. A national trucking association estimates that the cost of anidle truck is$39 per hour. In an 8 hour day, what does the weigh station costthetrucking industry?e. Adding another person to work at the weigh station would cost$22 perhour, and would allow trucks to be processed in 2.4 minutes. Shouldthetrucking industry offer to pay for this additional worker?