The Golding Discount Department Store: Excel Queuing System Problem
Not what you're looking for?
Excel Queuing System
The Golding Discount Department Store has approximately 300 customers shopping in its store between 9am and 5pm on Saturdays. In deciding how many cash registers to keep open each Saturday, Golding's manager considers 2 factors: customer waiting time(and the associated waiting cost) and the service costs of employing additional checkout clerks. Checkout clerks are paid on average of $4 per hour. When only one is on duty, the waiting time per customer is about 10 minutes or 1/6 hour; when 2 clerks are on duty, the average checkout time is 6 minutes per person; 4 minutes when 3 clerks are on duty; and 3 minutes when 4 clerks are on duty.
Golding's management has conducted customer satisfaction surveys and has been able to estimate that the store suffers approximately $5 in lost sales and goodwill for every hour of customer time spent waiting in checkout lines. Using the information provided, determine the optimal number of clerks to have on duty each Saturday to minimize the store's expected cost.
Purchase this Solution
Solution Summary
This solution determines the optimal number of clerks to have on duty each saturday at The Golding Discount Department Store in the attached Excel file.
Purchase this Solution
Free BrainMass Quizzes
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.
Graphs and Functions
This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.
Know Your Linear Equations
Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.
Geometry - Real Life Application Problems
Understanding of how geometry applies to in real-world contexts