Use the queueing spreadsheet we used in class to answer the following questions. In your report, make

sure that in addition to your answers to the questions, you indicate in each question how you used the

spreadsheet $($which tab, which parameters you took$).$ You may include screenshots from the

spreadsheet to show your use.

You are an analyst at a hotel. The hotel lobby deals with check$-$in and check$-$out requests. The

concierge desk handles other requests by guests.

Data were collected for both customer arrival patterns and service timesfor the $9$:$00-5$:$00$ time period.

The average numbers of customer arrivals for the lobby and concierge desk are provided in the Table

below. The average time it takes to serve customers in the lobby is three minutes for both the lobby

and the concierge desk. Inter$-$arrival times and service times come from an exponential distribution.

An overall goal for the hotel is that customers should not have to wait more than an average of two

minutes in the line.

Average number of customers

Time Lobby Concierge Desk

$9$:$00-10$:$0065$

$10$:$00-11$:$00157$

$11$:$00-12$:$002415$

$12$:$00-13$:$003619$

$13$:$00-14$:$003819$

$14$:$00-15$:$00318$

$15$:$00-16$:$00206$

$16$:$00-17$:$00139$

$1.$ Find the staffing requirements $($in terms of number of servers$)$ for the lobby for each time

period that satisfies the hotel$$s overall goal. Similarly find the staffing requirements $($in terms

of number of servers$)$ required for the concierge desk.