Problem Set 6″ for BUSN603 D003 Win 15: Part 1 of this quiz is based on the information in Problem 13-10 and Part 2 is based on the information in Problem 13-15 in the Textbook.
Please review the Single-Channel Queuing Model in Section 13.4 of the textbook before taking this quiz. You may find it very helpful to go through the examples presented in Program 13.1 in the textbook as well as in the Week 5 PowerPoint Slides (13-9 to 13-10 and 13-20 to 13-28). Please also join our Discussion Post 6a for any additional tips and hints on completing this quiz.
If you use “by the chapter” list to find the appropriate program to use in Excel QM, then you actually have to look in Chapter 14 instead of 13.
| Part 1 of 2 – Part 1 |
This part of the question is based on the following information.
The Schmedley Discount Department Store has approximately 300 customers shopping in its store between 9 A.M. and 5 P.M. on Saturdays. In deciding how many cash registers to keep open each Saturday, Schmedley’s manager considers two factors: customer waiting time (and the associated waiting cost) and the service costs of employing additional checkout clerks. Checkout clerks are paid an average of $8 per hour. When only one is on duty, the waiting time per customer is about 10 minutes (or hour); when two clerks are on duty, the average checkout time is 6 minutes per person; 4 minutes when three clerks are working; and 3 minutes when four clerks are on duty.
Schmedley’s management has conducted customer satisfaction surveys and has been able to estimate that the store suffers approximately $10 in lost sales and goodwill for every hour of customer time spent waiting in checkout lines.
Please fill out the following table to answer the quiz questions in Part 1. (You may also download the attached worksheet.)
Number of checkout clerks
1 2 3 4
Number of customers 300 300 300 300
Average waiting time (per customer)
Total customer waiting time
Cost per waiting hour
Total waiting cost
Checkout clerk hourly salary
Total pay of clerks for an 8-hour shift
Total expected cost
| Question 1 of 1010.0 Points The total customer waiting time is hours when there is only one clerk, and it will be reduced to only hours if there are four clerks. (Please only enter an integer and include no units.) Mark for Review What’s This? |
| Question 2 of 1010.0 Points The total wait cost is dollars when there is only one clerk, and it will be reduced to only dollars if there are four clerks. (Please only enter an integer and include no units.) Mark for Review What’s This? |
| Question 3 of 1010.0 Points The total cost of hiring is only dollars when there is only one clerk, and it will be increased to dollars if there are four clerks. (Please only enter an integer and include no units.) Mark for Review What’s This? |
| Question 4 of 1010.0 PointsTo minimize the total expected cost based on your calculations above, the optimal number of clerks to have on duty each Sunday is ___________. A.1 B.2 C.3 D.4 |
| Part 2 of 2 – Part 2This part of the question is based on the following information.The wheat harvesting season in the American Midwest is short, and most farmers deliver their truckloads of wheat to a giant central storage bin within a two-week span. Because of this, wheat-filled trucks waiting to unload and return to the fields have been known to back up for a block at the receiving bin. The central bin is owned cooperatively, and it is to every farmer’s benefit to make the unloading/storage process as efficient as possible. The cost of grain deterioration caused by unloading delays, the cost of truck rental, and idle driver time are significant concerns to the cooperative members. Although farmers have difficulty quantifying crop damage, it is easy to assign a waiting and unloading cost for truck and driver of $18 per hour. The storage bin is open and operated 16 hours per day, 7 days per week, during the harvest season and is capable of unloading 35 trucks per hour according to an exponential distribution. Full trucks arrive all day long (during the hours the bin is open) at a rate of about 30 per hour, following a Poisson pattern.The cooperative, as mentioned, uses the storage bin only two weeks per year. Farmers estimate that enlarging the bin would cut unloading costs by 50% next year. It will cost $9,000 to do so during the off season. Question 5 of 1010.0 Points The average number of trucks in the system is trucks. (Please only enter an integer and include no units.) Mark for Review What’s This?Question 6 of 1010.0 Points The average time per truck spent in the system is minutes. (Please only enter an integer and include no units.) Mark for Review What’s This?Question 7 of 1010.0 Points The utilization rate for the bin area is . (Please round it to two decimal points.) Mark for Review What’s This?Question 8 of 1010.0 Points The probability that there are more than 3 trucks in the system is about . (Please round it to two decimal points.) Mark for Review What’s This?Question 9 of 1010.0 Points The total daily cost in the unloading process is per day. (Please only enter an integer and include no units.) Mark for Review What’s This?Question 10 of 1010.0 Points Based on the above calculation, the net saving/loss of enlarging the bin is dollars, hence the cooperative proceed to enlarge the bin. (Please round to an integer and include no units. Use a “-” sign in front the number to indicate a net loss, if there is a loss. Also, enter only “should” or “should not” in the second blanket.) Mark for Review What’s This? |
Problem Set 7″ for BUSN603 D003 Win 15
Part 1 of this quiz is based on the information in Problem 16-9 and Part 2 is based on the information in Problem 16-16 and Problem 16-17 in the Textbook.
Please review the Control Charts introduced in Section 16.4 in the textbook before taking this quiz. You may find it very helpful to go through the examples presented in Program 16.2 in the textbook as well as in the Week 5 PowerPoint Slides (16-22 to 16-23).
If you use “by the chapter” list to find the appropriate program to use in Excel QM, then you actually have to look inChapter 17 instead of 16.
| Part 1 of 2 – Part 1This part of the question is based on the following information.When set at the standard position, Autopitch can throw hard balls toward a batter at an average speed of 60 mph. Autopitch devices are made for both major- and minor-league teams to help them improve their batting averages. Autopitch executives take samples of 10 Autopitch devices at a time to monitor these devices and to maintain the highest quality. The average range is 3 mph. Using control chart techniques, determine control-chart limits for averages and ranges for Autopitch.Please use the attached table or Excel QM to answer the following questions. Question 1 of 1010.0 Points Based on the attached table or Excel QM, the upper control limit for averages is . (Please round it to two decimal points and include no units.) Mark for Review What’s This?Question 2 of 1010.0 Points Based on the attached table or Excel QM, the lower control limit for averages is . (Please round it to two decimal points and include no units.) Mark for Review What’s This?Question 3 of 1010.0 Points Based on the attached table or Excel QM, the upper control limit for ranges . (Please round it to two decimal points and include no units.) Mark for Review What’s This?Question 4 of 1010.0 Points Based on the attached table or Excel QM, the lower control limit for ranges is . (Please round it to two decimal points and include no units.) Mark for Review What’s This? |
| Part 2 of 2 – Part 2This part of the question is based on the following information.Colonel Electric is a large company that produces light bulbs and other electrical products. One particular light bulb is supposed to have an average life of about 1,000 hours before it burns out. Periodically the company will test 5 of these and measure the average time before these burn out. The attached table gives the results of 10 such samples. Question 5 of 1010.0 Points The overall average of these means is , and the overall average range is . (Please round it to one decimal point and include no units.) Mark for Review What’s This?Question 6 of 1010.0 Points Based on the result in Question 5 and the attached table for Part 1 or Excel QM, the upper control limit for a 99.7% control chart for the mean/average is . (Please round it to two decimal points and include no units.) Mark for Review What’s This?Question 7 of 1010.0 Points Based on the result in Question 5 and the attached table in Part 1 or Excel QM, the lower control limit for a 99.7% control chart for the mean/average is . (Please round it to two decimal points and include no units.) Mark for Review What’s This?Question 8 of 1010.0 PointsDoes this process appear to be in control in terms of the mean? A.Yes. B.No. Reset Selection Mark for Review What’s This?Question 9 of 1010.0 Points Based on the result in Question 5 and the attached table for Part 1 or Excel QM, the upper control limit for a 99.7% control chart for the range is and the the lower control limit is . (Please round it to two decimal points and include no units.) Mark for Review What’s This?Question 10 of 1010.0 PointsDoes this process appear to be in control in terms of the range? A.Yes. B.No. |
Calculator
Our features
We've got everything to become your favourite writing service
Money back guarantee
Your money is safe. Even if we fail to satisfy your expectations, you can always request a refund and get your money back.
Confidentiality
We don’t share your private information with anyone. What happens on our website stays on our website.
Our service is legit
We provide you with a sample paper on the topic you need, and this kind of academic assistance is perfectly legitimate.
Get a plagiarism-free paper
We check every paper with our plagiarism-detection software, so you get a unique paper written for your particular purposes.
We can help with urgent tasks
Need a paper tomorrow? We can write it even while you’re sleeping. Place an order now and get your paper in 8 hours.
Pay a fair price
Our prices depend on urgency. If you want a cheap essay, place your order in advance. Our prices start from $11 per page.