Question: Problem A LL Pinto is a catalog company with one operator to take phone orders. The time to process a phone order follows an exponential

Problem A LL Pinto is a catalog company with one

Problem A LL Pinto is a catalog company with one operator to take phone orders. The time to process a phone order follows an exponential distribution. The operator can process an average of 20 orders per hour. 1. Simulate the processing of 1000 orders. Generate random numbers using RANDO function. Do not use any add-in functions. Show simulated processing time in minutes. (HINT: inverse transformation method) 2. Develop a histogram of the order processing time (see Data Analysis tools or the FREQUENCY function). Include a chart of the results. Format the chart. 3. Show the average time to process an order based on your simulation. (in minutes) 4. Show the standard deviation of the time to process an order based on your simulation. (in minutes)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

U.S. Copyright Law (title 17 of U.S. code) governs the reproduction and redistribution of copyrighted material. Downloading this document for the purpose of redistribution is prohibited. Chapter 15...

Rolling Tires Manufacturing Using Six Sigma Process improvement Tools to Reduce Lead Time To complete your assignment, read the case study on the Brief tab and provide your responses in the Questions...

Overview Rolling Tires Manufacturing is a European multinational automotive manufacturing company specializing in producing tires, brake systems, interior electronics, powertrain, and other vehicle...

Case Study Rolling Tires Manufacturing Using Six Sigma Process Improvement Tools to Reduce Lead Time To complete your assignment, read the case study on the Brief tab and provide your responses in...

if you were part of the six sigma process improvement team wht improvements you would suggest to reduce the lead time? justify your answer using data and info from the case. Overview Rolling Tires...

To complete your assignment, read the case study on the Brief tab and provide your responses in the Questions tab. Y Overview Rolling Tires Manufacturing is a European multinational automotive...

if you were part of the six sigma process improvement team wht improvements you would suggest to reduce the lead time? justify your answer using data and info from the case. Overview Rolling Tires...

PLS HELP Rolling Tires Manufacturing Using Six Sigma Process Improvement Tools to Reduce Lead Time To complete your assignment, read the case study on the Brief tab and provide your responses in the...

use excel solver 2. Deadwood Backpackers is a retail catalog store in South Dakota that specializes in outdoor clothing and camping equipment. A large pool of computer operators, some of whom are...

In the circuit in Figure, the ac generator produces an rms voltage of 115 V when operated at 60 Hz. What is the rms voltage across points (a) AB, (b) BC, (c) CD, (d) AC, and (e) BD? 137 mH ele 115 V...

Whom should you call first if you suspect fraud in your company, your forensic accounting firm, or your external audit firm? Why?

One objective of accounts payable is to authorize payment only for goods or services actually ordered and recelved. The best way to process supplier irvoices is to use electronic funds transfer for...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...