please post all the steps and work as it has to be typed up in excel and emailed.

THANK YOU FOR YOUR HELP

Alabama Airlines Call Center Alabama Airlines opened its doors in December 2015 as a commuter service with its headquarters and hub located in Birmingham. The airline was started and managed by two former pilots, David Douglas and George Devenney It acquired a fleet of 12 used prop-jet planes and the airport gates vacated by Delta Air Lines in 2014 With business growing quickly Douglas turned his attention to Alabama Air's "800" reservations system. Between midnight and 6:00 am only one telephone reservations agent had been on duty. The time between incoming calls during this period is distributed as shown in Table F.8 Carefully observing and timing the agent Douglas estimated that the time required to process passenger inquiries is distributed as shown in Table F.90 Table F.8 Incoming call Distribution Time Between Calls (Minutes) Probability 1 11 2 21 3 22 4 20 5 16 6 10 Table F.9 Service-Time Distribution Time to Process Customer Inquiries (Minutes) Probability 1 20 2 2 19 3 18 4 17 5 13 6 10 7 03 All customers calling Alabama Air go on hold and are served in the order of the calls received unless the reservations agent is available for immediate service Douglas is deciding whether a second agent should be on duty to cope with customer demand. To maintain customer satisfaction, Alabama Air wants a customer to be on hold" for no more than 3 to 4 minutes, it also wants to maintain a "high" operator utilization Furthermore, the airline is planning a new TV advertising campaign. As a result, it expects an increase in "800" line phone inquiries. Based on similar campaigns in the past the incoming call distribution from midnight to 6:00 a.m. is expected to be as shown in Table F.10 (The same service-time distribution will apply.) Table F.10 Incoming call Distribution Time Between Calls (Minutes) Probability 1 22 2 25 3 19 4 15 5 12 6 07 Discussion Questions 1. Given the original call distribution, what would you advise Alabama Air to do for the current reservation system? Create a simulation model to investigate the scenario. Describe the model carefully, and justify the duration of the simulation, assumptions, and measures of performance. 2. What are your recommendations regarding operator utilization and customer satisfaction if the airline proceeds with the advertising campaign