Use Excel-show work please, need the answer for question 7!

6.TheDynacoManufacturingCompanyproducesaparticularproductinanassemblylineoperation. One of the machines on the line is a drill press that has a single assembly line feeding into it. A partially completed unit arrives at the press to be worked on every 7.5 minutes, on average. The machine operator can process an average of 10 parts per hour. Determine the average number of parts waiting to be worked on, the percentage of time the operator is working, and the percentage of time the machine is idle.

7. The management of Dynaco Manufacturing Company (see Problem 6) likes to have its operators working 90% of the time. What must the assembly line arrival rate be for the operators to be as busy as management would like?

6. The Dynaco Manufacturing Company produces a particular product in an assembly line operation. One of the machines on the line is a drill press that has a single assembly line feeding into it. A partially completed unit arrives at the press to be worked on every 7.5 minutes, on average. The machine operator can process an average of 10 parts per hour. Determine the average number of parts waiting to be worked on the percentage of time the operator is working, and the percentage of time the machine is idle. 7. The management of Dynaco Manufacturing Company (see Problem 6) likes to have its operators working 90% of the time. What must the assembly line arrival rate be for the operators to be as busy as management would like