Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

How do I solve these questions using the Poisson Distribution Formula in Excel, possibly using MegaStat as well?

image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Ordinary Differential Equations

Authors: William A Adkins, Mark G Davidson

1st Edition

1461436184, 9781461436188

More Books

Students also viewed these Mathematics questions

Question

How have our views of gender changed in recent history?

Answered: 1 week ago