How do I solve these questions using the Poisson Distribution Formula in Excel, possibly using MegaStat as well?
Boise Cascade Corporation At the Boise Cascade Corporation, lumber mill logs arrive by truck and are scaled {measured to determine the number of board feet] before they are dumped into a log pond. The gure below shows the basic flow. Log Pond Trucks Enter The mill manager must determine how many scale stations to have open during various times of the day. If too many stations are open, the scalers will have excessive idle time and the cost of scaling will be unnecessariiy high. On the other hand, if too few scale stations are open, some log trucks will have to wait. The manager has studied the truck arrival patterns and has determined that throughout the day, trucks randomly arrive at 23 per hour on average. Each scale station can scale 8 trucks per hour [7.5 minutes each]. If the manager knew how many trucks would arrive during the hour, she would know how many scale stations to have open. For example, DB trucks, open 1 scale station: 9-16 trucks, open 2 scale stations, etc. However, the number of trucks is a random variable and is uncertain. Your task is to provide guidance for the decision. 1] Based on the mean rate of 23 trucks per hour, what probability distribution should be used? 2] Use the probabilities from the first probability distribution above to create a probability distribution for the number of scaie stations to open. For example, 0-8 trucks, open 1 scale station; 915 trucks, open 2 scale stations, etc. What is the expected number of scale stations needed? 3] Are there additional factors that should be considered? What are your reoommendations for handling those factors? I 'I'ou need to answer the questions above in paragraph form as if you are writing to the mill manager. 0 Students can work together on the case study. However, each student must turn in their answers in their own words. Your paper needs to be uploaded to Blackboard. It should not be longer than 1 page. See schedule for due date