stat week 5
sbatniji
week_5.docxPurpose
To assess your ability to apply appropriate configurations to solve queuing problems.
Action Items
1. If you have any difficulty completing the cases, you should work through the problems at the end of Chapter 13 in Quantitative Analysis for practice.
2. Complete each of the following cases making certain that you address all questions in each case:
3. Use the QM Excel plug in and directions in Chapter 5 to develop your model. Place each problem in a separate worksheet within the same Excel document.
Submission Instructions
· Complete and submit your assignment per your professor's instructions.
Grading Criteria
· Documentation: thorough documentation with clarity of thought and process: 0 – 1 point
· Problem solving and analysis:
· Solution is accurate (0 – 2 points)
· Calculations are accurate and valid (0 – 2 points)
Responses are detailed and accurate (0 – 1 point)
Purpose
To assess your ability to analyze the differences between single and multiple channel queuing systems.
Action Items
4. Review Problems 13-24 and 13-25 at the end of Chapter 13 in Quantitative Analysis.
13-24
Billy's Bank is the only bank in a small town in Arkansas. On a typical Friday an average of 10 customers per hour arrive at the bank to transact business.
There is one single teller at the bank, and the average time required to transact business is 4 minutes. It is assumed that service times can be described by the exponential distribution. Although this is the only bank in town, some people in the town have begun using the bank in a neighboring town about 20 miles away. A single line would be used, and the customer at the front of the line would go to the first available bank teller. If a single teller at Billy's is used, find
(a) The average time in the line.
(b) The average number in the line.
(c) The average time in the system.
(d) The average number in the system.
(e) The probability that the bank is empty
13-25
For the Billy's Bank situation in Problems 13-24 and 13-25, the salary and benefits for a teller would be $12 per hour. The bank is open 8 hours each day. It has been estimated that the waiting time cost per hour is $25 per hour in the line.
(a) How many customers would enter the bank on a typical day?
(b) How much total time would the customers spend waiting in line during the entire day if one teller were used? What is the total daily waiting time cost?
(c) How much total time would the customers spend waiting in line during the entire day if two tellers were used? What is the total waiting time cost?
(d) If Billy wishes to minimize the total waiting time and personnel cost, how many tellers should be used?
5. Divide the case into manageable components. Determine what you consider to be the inputs to the case as well as what type of queuing problem it represents.
6. Complete each of the problems using one problem per worksheet tab.
Submission Instructions
· Complete and submit your assignment per your professor's instructions.
Grading Criteria
· Problem Solutions: 0 – 6 points
· Problem solving and analysis (0 – 3 points)
· Solution setup, calculations, and result are accurate (0 – 2 points)
Question responses are detailed and accurate (0 – 1 point)
Purpose
To assess your ability to analyze the trade-off of cost of waiting time versus cost of service.
Action Items
7. Review the "New England Foundry" case study at the end of Chapter 13 on page 530 in Quantitative Analysis.
8. Divide the case into manageable components. Determine what you consider to be the inputs to the case as well as what type of queuing problem it represents.
Guidance:
· The business problem is determining the viability of migrating from a combined existing model layout to a completely new configuration that divides the existing departments into separate workflows. Students will need need more than one spreadsheet to answer how much time the new layout would save. You'll first have to run the numbers with arrival and service rates for the OLD layout and the NEW layout, then use those calculations to answer the questions.
· When doing your time savings, you'll need to calculate employee total time, including travel time, to and from departments.
· You'll need to be precise to get the right numbers; e.g., four minutes and 42 seconds. Just saying four or five minutes won't be enough, especially when you do the cost savings.
· Once you determine time savings, you need to convert to dollars or cost.
· Please provide thorough answers to each of the questions: full sentences with specifics explaining your analysis.
Submission Instructions
· Complete and submit your assignment per your professor's instructions.
Grading Criteria
· Documentation thorough documentation with clarity of thought and process: 0 – 1 point
· Problem solving and analysis: 0 – 6 points
· Solution is accurate (0 – 3 points)
· Calculations are accurate and valid (0 – 2 points)
Responses are detailed and accurate (0 – 1 point)
