Use the Queueing Calculator (Assignment 3 template.xlsm) to answer the following questions. Submit one file with textboxes that include a word summary of your analysis and results in the appropriate tabs. Also, insert your completed and signed Ethics Agreement for Group work in the last tab.

1. What is the minimum number of operating scanners that are required each hour (starting at 3- 3:59am until 8-8:59pm) to ensure the line processes passengers without blocking (that is,without the queue length exceeding 130)? Assume that during a given hour the queue will not extend beyond its capacity of 130 if the value of the macro function PrBalk equals 0.0000 or less.

2. What are the resulting daily costs of this model? (include salaries, overtime, scanner operations, and blocking)

3. Redo the analysis in 1 & 2 if Margaret now tolerates a PrBalk value equal to 5% or less. Factor in the $25 cost per blocked passenger who clears security at Terminal 2 and shuttles back to 1.

4. MidRoad has set a very tight budget target for security clearing operations. For Terminal 1, their daily target is $14,000. See if you can help Margaret cut down the operating costs to meet this target by applying some of the following options:

   1. Slightly change the number of opened scanners per hour and tolerate a threshold for PrBalk of 5% (rather than 0.0000) and keep assuming a blocking cost of $25 per passenger.

   2. Remove the extra staff from some of the opened scanners during some of the hours. (Note: you must then adjust the service rate and the salary costs accordingly.)

4 points per question and 4 points for the quality of the workbook (clarity, ease of navigation, etc.) Full credit on question 4 only to the team(s) with a valid and reasonable solution that also yields theminimum cost over all submitted assignments.

Hour of day* Arr. Rate** 3 22.3 4 628.6 5 988.4 6 610.9 7 534.6 8 519.2 9 372.1 10 427.6 11 202.6 12 181.0 326.6 13 14 288.1 15 639.4 16 689.5 17 429.1 18 577.0 19 182.6 20 82.4 * Indicates the full hour beginning at the value (.e. 3 means the hour from 3am to 3:59am) ** Average over 5 days w Wa La Util PO PrBalk PrWait Hour Arr. of Rate day Serv.Rate Open Scanners Capacity (with extra staff) 3 22.5 160 1 130 #NAME? 5 6 7 9 10 11 12 13 14 15 16 17 18 19 20 Hour of day* Arr. Rate** 3 22.3 4 628.6 5 988.4 6 610.9 7 534.6 8 519.2 9 372.1 10 427.6 11 202.6 12 181.0 326.6 13 14 288.1 15 639.4 16 689.5 17 429.1 18 577.0 19 182.6 20 82.4 * Indicates the full hour beginning at the value (.e. 3 means the hour from 3am to 3:59am) ** Average over 5 days w Wa La Util PO PrBalk PrWait Hour Arr. of Rate day Serv.Rate Open Scanners Capacity (with extra staff) 3 22.5 160 1 130 #NAME? 5 6 7 9 10 11 12 13 14 15 16 17 18 19 20