# Logistics Supply Chain Management Course Module 4 Case assignment, writing homework help

**Question description**

Here is Background and Case information for module 4:

# Module 4 - Background

## Queuing Analysis/Logistics Challenges

### Virtual World

EBBD EMAIL – for Internal Use Only

To: You

From: Danny Wilco <dwilco@ebbd.com>

Subject: Re: Deliveries clogging the loading dock area

You asked for the specific details regarding the delivery process at the receiving dock. Since you’ve been busy at your other jobs, I had this information determined for you.

- Receiving dock open from 7am to 3pm, 8 hours, or 480 minutes.
- The average number of arrivals on any given day is 28, which is 3.5 arrivals per hour, average.
- The data we have collected indicate that we can unload 4.2 trucks per hour.

This should help you get started to think about how to approach this problem. I will get back to you with your specific assignment shortly.

~DW, VP LogOps.

### Learning Wizard

**Case 4 Resources**

Queuing systems are “stochastic”, which means based on random variables. The arrival rate of the customers is random but is theorized to follow a specific probability function. The key to analyzing queues is using the theory and equations that allow you to determine the probabilities

This website provides a good general overview of Queuing and waiting lines in business.

Queuing Theory. (n.d.). Encyclopedia of Business, 2^{nd} Ed.; Reference for Business, retrieved from: http://www.referenceforbusiness.com/encyclopedia/Pro-Res/Queuing-Theory.html

Download this PowerPoint file [Waiting Lines Queues] which provides lecture notes on queuing and queuing equations. It also has Exercises for you work on.

******WATCH THESE TWO VIDEOS THAT EXPLAINS THE POWERPOINT** - IN YOUTUBE:

PART 1: http://youtu.be/xxlixF0deqE

PART 2: http://youtu.be/NQdt2ldymaM

Download the Excel file [**Excel QueueCalc**]. There are two Tabs - the first is for Single Server models, and the second is for Multi-Server models. You enter the relevant information of a queuing problem and it will calculate the pertinent results. The values shown in this worksheet when you open it are the Phlebotomy Examples in the PowerPoint.

You can use the QueueCalc spreadsheet to try all of the examples and exercises in the PowerPoint.

Once you have mastered the examples and exercises you should be ready to tackle the EBBD problem. You can use the QueueCalc for the EBBD problem in the Case.

# Module 4 - Case

## Queuing Analysis/Logistics Challenges

### Virtual World

EBBD EMAIL – for Internal Use Only

To: You

From: Danny Wilco <dwilco@ebbd.com>

Subject: Re: Deliveries clogging the loading dock area

OK, here’s what I want to know: how often do we have more than 5 trucks, more than 6 trucks, and more than 7 trucks. What is the highest number of trucks we may have in the system with a 95% probability? And then, assuming the arrival rate of the deliveries does not change, what does the unload rate need to be so that we can service up to five trucks 95% of the time? In other words if we want a 95% probability of 5 or fewer trucks in the system at any one time, what does the unloading (service) rate need to be? Then, consider that we have two unloading teams, each able to unload trucks at the same rate. What does the unloading rate need to be for each team in order to ensure (100%) 5 or fewer trucks in the system at any time? I know we don’t have room for two unloading teams at this time, but there is a possibility we might make room in the future.

Analyze this situation and determine what we need to know and give me report. At this point in time, I am looking only for the problem to be quantified and the unload rate determined for the current situation (single server) and possible two servers.

Let me know if you have any questions.

~DW, VP LogOps.

### Learning Wizard

If you have mastered the examples and exercises provided in the Background from the Queuing PowerPoint, you are ready to tackle the EBBD problem.

The current situation is a Single Server situation. Enter the arrival rate and service rate to calculate the pertinent queuing system state data. Find out the probabilities of 5 or more trucks in the system, then 6, then 7. Then use trial and error to find the greatest number of trucks or less that can be in the system with 95% (or as close to 95%).

For the Multi-server problem you will need to use a similar process.

Record the results of your calculations and save the Excel file.

Then write your report.

*Upload the Report to Case 4. Upload the Excel file with the solution to Additional Files in Module 4.*

### Assignment Expectations of the written report - write the report to your boss, Danny Wilco.

The report should thoroughly address these aspects in depth and breadth:

- Problem situation: clearly elucidate the problem situation at EBBD
- Assumptions: what are the assumptions that need to be made and your critical evaluation
- Solution: discuss how you developed the Solver solution. Keep in mind that your audience is not too technical and do not need a lot of detail on this.
- Make sure you attach the Excel file.
- You should refer to the Excel file when necessary.
- Explanation: clear articulation of the results that you obtain, based on what Mr. Wilco is asking for.
- Conclusion: Even though Mr. Wilco is not asking for a conclusion, you should determine if there is a conclusion to this situation and elucidate what it is.
- Writing style & Organization: well-formed sentences and paragraphs, well organized with flow of reason, and good use of language that pertain to concepts and terminology
- Use of references & citations: If you use references, be sure to include appropriate use of citations in the paper and reference list (APA is required).

## Tutor Answer

find the complete answer herein

models

How to choose a queueing model

All models in this workbook are Poisson arrivals, infinite population, and FCFS.

The models differ by

(1) the service time distribution (exponential, constant)

(2) the number of servers (single server or multiple servers)

(3) waiting room capacity (unlimited waiting room or limited waiting room buffer)

M/M/1

Service time distribution Exponential

Number of servers

Single

Waiting room capacity

Unlimited

M/C/1

M/M/s

M/M/s/b

Constant

Single

Unlimited

Exponential

Multiple

Unlimited

Exponential

Multiple

Limited

Instruction on using this workbook:

1. Choose the model that is appropriate for your analysis

2. In the "INPUTS" part, change the "unit of time" to your desired time unit, such as hour, minute, etc.

The rest of the report will be changed accordingly.

3. Input the correct l, m and, if necessary, number of servers.

4. Read the output solutions.

Note: To identify the appropriate model for your analysis, you have to find out three pieces of information

1: Customer arrival rate (l)

2. Service rate (m)

3. Number of servers

Important: the unit for both l and m has to be consistent (both in per hour or per minute or other time un

Note to user: when you first start this workbook, Excel may ask you if you want to enable the macros. Ju

Page 1

models

as hour, minute, etc.

nd out three pieces of information:

ur or per minute or other time units)

u want to enable the macros. Just say yes...

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors