# LOG 501:Queuing Analysis/Logistics Challenges

EBBD EMAIL – for Internal Use Only
To: You
From: Danny Wilco <>
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.
Download this PowerPoint file [Waiting Lines Queues] (Attached) 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] (Attached). 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.

EBBD EMAIL – for Internal Use Only
To: You
From: Danny Wilco <>
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.
Assignment Expectations of the written report – write the report to your boss, Danny Wilco.
• 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.
o Make sure you attach the Excel file.
o 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).

Calculate the price
Pages (550 words)
\$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with TheBestPaperWriters
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Anthropology
Excellent services will definitely come back
Customer 452441, September 23rd, 2022
Nursing
The paper was EXCELLENT. Thank you
Customer 452449, September 23rd, 2022
Anthropology
excellent loved the services
Customer 452443, September 23rd, 2022
English 101
Very good job. I actually got an A
Customer 452443, September 25th, 2022
Architecture, Building and Planning
The assignment was well written and the paper was delivered on time. I really enjoyed your services.
Customer 452441, September 23rd, 2022
Psychology
Thanks a lot the paper was excellent
Customer 452453, October 26th, 2022
Job well done. Finish paper faster than expected. Thank you!
Customer 452451, October 3rd, 2022
Excellent service - thank you!
Customer 452469, February 20th, 2023
Theology
Job well done and completed in a timely fashioned!
Customer 452451, November 18th, 2022
Thank you!
Customer 452451, November 27th, 2022
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend