Reference no: EM131064170
A product is made by activities performed sequentially through three work stations (WS#1, WS#2, WS#3).
At the beginning of the shift, WS#1 is supplied with all the raw materials it might need for the day. Ws#1 can therefor work continuously, beginning on the next item as soon as it finishes the current item. The time it takes to complete the activities in WS#1 is distributed uniformly, with a minimum time of 4 minutes and a maximum time of 6 minutes.
WS#2 begins the shift with nothing and can complete its activities only as WS#1 provides its work-in-progress. The time it takes to complete the activities in WS#2 is : 20% probability of 4 minutes; 50% probability of 5 minutes; and 30% probability of 6 minutes.
WS#3 begins the shift with nothing and can complete its activities only as WS#2 provides its work-in-progress. The time it takes to complete the activities in WS#3 is distributed normally with a mean of 5 minutes and a standard deviation of 1.8 minutes.
a) Construct a simulation in EXCEL for this production line. Determine the number of items that can be produced in an 8 hour shift. Run the simulation three times. How many items are produced for each simulation?
b) What is the total amount of idle time (waiting time) in WS#2 for the 8 hour shift?
C) What is the total amount idle time ( waiting time) in WS #3 for the 8 hour shift?
|
What are the odds that penn state will beat michigan
: What are the odds that Penn State will beat Michigan? What are the odds that Penn State will beat Michigan State
|
|
Was he entitled to specific performance
: When the buyer refused to take and pay for the stock, Gingerich sued for specific performance of the contract on the ground that the value of the stock was unknown and could not be readily ascertained because it was not sold on the general market...
|
|
Find the coefficient of correlation
: Find the coefficient of correlation and the coefficient of determination. Now find the log of y and recalculate the two statistics. How would you interpret your results?
|
|
Moisture concentration in the compost pile
: Five tons of a mixture consisting of paper and other compostable materials has a moisture content of 7%. The intent is to make a mixture for composting that is 50% moisture. How many tons of water or sludge must be added to the solids to achieve t..
|
|
What is the total amount of idle time
: b) What is the total amount of idle time (waiting time) in WS#2 for the 8 hour shift? C) What is the total amount idle time ( waiting time) in WS #3 for the 8 hour shift?
|
|
Number of fertilizer applications to each of the fields
: A farmer has recorded the number of fertilizer applications to each of the fields in one section of the farm and, at harvest time, records the weight of crop per acre. The results are given in the table below:
|
|
Provide explanation behind companys bubbly corporate value
: Provide an explanation behind the company's bubbly corporate valuation during this time. Determine how outside investors were valuing this company. (Hint: look at similar businesses.)
|
|
Arnold palmer hospital
: Why is it important for Arnold Palmer Hospital to get a patient's assessment of healthy care quality? Does the patient have the expertise to judge the healthcare she receives?
|
|
Emergency management or related discipline
: This is for someone that is knowledgeable in fire safety, safety engineering, emergency management or related discipline.
|