County Beverage Drive Thru Inc operates a chain of beverage supply stores in northern Illinois. Each store has a single service lane cars enter at one end of the store and exit

County Beverage Drive Thru Inc operates a chain of beverage supply stores in northern Illinois. Each store has a single service lane cars enter at one end of the store and exit

County Beverage Drive-Thru, Inc., operates a chain of beverage supply stores in northern Illinois. Each store has a single service lane; cars enter at one end of the store and exit at the other end. Customers pick up soft drinks, beer, snacks, and party supplies without getting out of their cars. When a new customer arrives at the store, the customer waits until the preceding customer’s order is complete and then drives up to the store order window for service.
Typically, three employees operate each store during peak periods; one clerk takes orders, another clerk fills orders, and a third clerk serves as cashier and store supervisor. County
Beverage is considering a revised store design in which computerized order-taking and payment are integrated with specialized warehousing equipment. Management hopes that the new design will permit operating each store with one clerk. To determine whether the new design is beneficial, management decided to build a new store using the revised design.
County Beverage’s new store will be located near a major shopping center. Based on experience at other locations, management believes that during the peak late afternoon and evening hours, the time between arrivals follows an exponential probability distribution with a mean of six minutes. These peak hours are the most critical time period for the company; most of the company’s profit is generated during these peak hours.
An extensive study of times required to fill orders with a single clerk led to the following probability distribution of service times:
Service Time (minutes) Probability 0.24 0.20 0.15 0.14 0.12 0.08 0.05 0.02 Total 1.00
In case customer waiting times prove too long with just a single clerk, County Beverage’s management is considering two design alternatives: (1) add a second clerk to help with bagging, taking orders, and related tasks (still functioning as a single-server system and serving one car), or (2) enlarge the drive-through area so that two cars can be served at once (operating as a two-server system). With either of these options, two clerks will be needed. With the two-server option, service times are expected to be the same for each clerk (server). With the second clerk teaming with the first clerk in the single server design, service times will be reduced and would be given by the probability distribution in the following table.
Service Time (minutes) an Probability 0.20 0.35 0.30 0.10 0.05 Total 1.00
County Beverage’s management would like you to develop a spreadsheet simulation model of the new system and use it to compare the operation of the system using the following three designs:
Design
A
Single-server system operated by one clerk
B
Single-server system operated by two clerks
C
Two-server system operated by two clerks
Management is especially concerned with how long customers have to wait for service. As a guideline, management requires the average waiting time to be less than 1.5 minutes.
Managerial Report
Prepare a report that discusses the general development of the spreadsheet simulation model, and make any recommendations that you have regarding the best store design and staffing plan for County Beverage. One additional consideration is that the design allowing for a two-server system will cost an additional $10,000 to build.
Construct a separate simulation model to evaluate the performance of each design alternative.
Execute the simulation for 360 minutes (representing the peak hours of 4 p.m. to 10 p.m). You may assume that the system begins empty at 4 p.m You may want to make more than one run with each alternative. Record relevant summary statistics over the simulation runs and use this information to support your final recommendation.