Fill out the Waiting Lines Analysis Template spreadsheet.
It is set up to show you 17 customers’ interarrival times over a 20-minute period and service times at a checkout line in a store.
Note how many customers arrive. Divide by 20 minutes to get your average arrival rate per minute (λ).
Place your answer in the appropriate spreadsheet cell.
During that same 20-minute period, note how much time (in minutes) the cashier needs to process each customer.
Take the average of these process times.
Then calculate 1/(average process time) to get your average service rate (µ).
Place your answer in the appropriate spreadsheet cell.
Use the spreadsheet to calculate the following information.
Show all formulas:
a. The probability that 2 customers will arrive in 10 minutes.
b. The probability that the resource can process a customer in one-half the average service time (whatever the average service time is in the spreadsheet, take one-half of it).
c. The average utilization of the cashier.
d. The probability that 0 customers are in the system.
e. The probability that 1 customer is in the system.
f. The probability that more than 1 customer is in the system (Hint: all probabilities should sum up to 1 or 100%).
g. The average number of customers in the system (waiting + being served).
h. The average number of customers waiting to be served.
i. The average time customers spend in the system (waiting + being served).
j. The average time customer spend waiting to be served.
k. A short analysis of how you would improve utilization and/or reduce waiting time.
Include 3-5 specific ideas with some rationale for them. Do not simply state generalities like “shorten the waiting line.”

Solution PreviewSolution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

Waiting Lines Analysis
    $50.00 for this solution

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available Operations Management Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Upload a file
    Continue without uploading

    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats