Management of the first Syracuse bank is concerned about a loss of customers at its main office downtown. One solution that has been proposed is to add one or more drive through teller stations to make it easier for customers in cars to obtain quick service without parking. Chris Carlson, the bank president, thinks the bank should only risk the cost of installing one drive through. he is informed by his staff that the cost (amortized over 20 year period) of bluing a drive through is $12,000 per year. It also costs $16,000 per year in wages and benefits to staff each new teller window. The director of management analysis Beth Shader, believes that the following two factors encourage the immediate construction of two drive through stations, however. According to a recent article in banking research magazine, customers who wait in long lines for drive-through teller service will cost banks an average of $1 per minute in loss of goodwill. Also, adding a second drive through will cost an additional $16,000 in staffing but amortized construction costs can be cut to a total of $20,00 installed together instead of one at a time. to complete her analysis, Shader collected one month's arrival and service rates at a competing downtown banks drive through stations. This data are shown as observation analyses 1 and 2 in the following tables. A) Simulate a 1 hour time period, from 1 pm to 2pm, for a single line of people waiting for next available teller in a two-teller system. INCLUDE EXCEL FORMULAS PLEASE :)

Observation analysis 1: interarrival times for 1,000 observations ,000 observations Number of occurrences 200 250 300 150 100 Time between arrivals 2 3 4 Observation analysis 2: customer service time for 1,000 customers Service time (minutes) Number of occurrences 100 150 350 150 150 150 2 3 4