View the step-by-step solution to:

Problem 1 Smails Airlines opened its doors in June 2004 as a commuter service, with its headquarters and only hub located in Birmingham. A product of...

Please Help!
This is an operations research/ management science question that involves complex modeling. Please help and show all work, and make sure to include all excel work sheets used. Thank you!
Please see that attached word document, for the problem.
Problem 1 Smails Airlines opened its doors in June 2004 as a commuter service, with its headquarters and only hub located in Birmingham. A product of airline deregulation, Smails Air joined the growing number of successful short-haul, point-to-point airlines, including Lone Star, Comair, Atlantic Southeast, Skywest, and Business Express. Smails Air was started and managed by a former pilot, Al Czervik (who had been with the defunct Eastern Airlines). It acquired a fleet of 12 used prop-jet planes and the airport gates vacated by Delta Air Lines’ 2003 downsizing. With business growing quickly, Czervik turned his attention to Smails Air’s toll-free reservations system. Between midnight and 6:00am, only one telephone reservations agent had been on duty. The time between incoming calls during this period is distributed as shown in Table 1. Czervik carefully observed and timed the agent and estimated that the time taken to process passenger inquiries is distributed as shown in Table 2. Time Between Calls (Min) Probability 1 0.11 2 0.21 3 0.22 4 0.20 5 0.16 6 0.10 Table 1. Current Incoming Call Distribution Time to Process Inquiries (Min) Probability 1 0.20 2 0.19 3 0.18 4 0.17 5 0.13 6 0.10 7 0.03 Table 2. Service Time Distribution
Background image of page 1
All customers calling Smails Air go on hold and are served in the order of the calls unless the reservations agent is available for immediate service. Czervik is deciding whether a second agent should be on duty to cope with customer demand. To maintain customer satisfaction, Smails Air does not want a customer on hold for more than three minutes. What would you advise Smails Air to do? Create a simulation model to investigate the scenario. If one agent is not enough, justify that hiring a second agent is sufficient.
Background image of page 2
Sign up to view the entire interaction

Top Answer

Great question... View the full answer

8440030.xlsx

start at 12 AM Time between calls (Min)
1
2
3
4
5
6 Probability Cumulative Prob Intervals
0.11
0.11 0-10
0.21
0.32 11-31
0.22
0.54 32-53
0.2
0.74 54-73
0.16
0.9 74-89
0.1
1 90-99 1
2
3
4
5
6
7...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online