Epsilon Airlines services predominantly the eastern and southeastern united States. The vast majority of Epsilon’s customers make reservations through Epsilon’s website, but a small percentage of customers make reservations via phones. Epsilon employs call center personnel to handle these reservations and to deal with website reservation system problems and for the rebooking of flights for customers whose plans have changed or whose travel is disrupted. Staffing the call center appropriately is a challenge for Epsilon’s management team. Having too many employees on hand is a waste of money, but having too few results in very poor customer service and the potential loss of customers. Epsilon analysts have estimated the minimum number of call center employees needed by day of the week for the upcoming vacation season (June, July, and the first two weeks of August). These estimates are as follows:   Day Minimum Number of Employees Needed Monday 50 Tuesday 90 Wednesday 45 Thursday 65 Friday 75 Saturday 65 Sunday 45   The call center employees work for five consecutive days and then have two consecutive days off. An employee may start work on any day of the week. Each call center employee receives the same salary. Assume that the schedule cycles and ignore start up and stopping of the schedule. Develop a model that will minimize the total number of call center employees needed to meet the minimum requirements.   Let Xi = the number of call center employees who start work on day i         (i = 1 = Monday, i = 2 = Tuesday...)     Min X1 + X2 + X3 + X4 + X5 + X6 + X7     s.t.                     X1 +     X4+ X5+ X6+ X7   fill in the blank 2   X1 + X2+     X5+ X6+ X7   fill in the blank 4   X1 + X2+ X3+     X6+ X7   fill in the blank 6   X1 + X2+ X3+ X4+     X7   fill in the blank 8   X1 + X2+ X3+ X4+ X5       fill in the blank 10     X2 + X3+ X4+ X5+ X6     fill in the blank 12       X3 + X4+ X5+ X6+ X7   fill in the blank 14   X1, X2, X3, X4, X5, X6, X7 ≥ 0   Find the optimal solution.   X1 = fill in the blank 15 X2 = fill in the blank 16 X3 = fill in the blank 17 X4 = fill in the blank 18 X5 = fill in the blank 19 X6 = fill in the blank 20 X7 = fill in the blank 21   Total Number of Employees = fill in the blank 22 Give the number of call center employees that exceed the minimum required. Excess employees: Monday = fill in the blank 23 Tuesday = fill in the blank 24 Wednesday = fill in the blank 25 Thursday = fill in the blank 26 Friday = fill in the blank 27 Saturday = fill in the blank 28 Sunday = fill in the blank 29

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
icon
Concept explainers
Topic Video
Question

Epsilon Airlines services predominantly the eastern and southeastern united States. The vast majority of Epsilon’s customers make reservations through Epsilon’s website, but a small percentage of customers make reservations via phones. Epsilon employs call center personnel to handle these reservations and to deal with website reservation system problems and for the rebooking of flights for customers whose plans have changed or whose travel is disrupted. Staffing the call center appropriately is a challenge for Epsilon’s management team. Having too many employees on hand is a waste of money, but having too few results in very poor customer service and the potential loss of customers.

Epsilon analysts have estimated the minimum number of call center employees needed by day of the week for the upcoming vacation season (June, July, and the first two weeks of August). These estimates are as follows:

 


Day
Minimum Number of
Employees Needed
Monday 50
Tuesday 90
Wednesday 45
Thursday 65
Friday 75
Saturday 65
Sunday 45

 

The call center employees work for five consecutive days and then have two consecutive days off. An employee may start work on any day of the week. Each call center employee receives the same salary. Assume that the schedule cycles and ignore start up and stopping of the schedule.

Develop a model that will minimize the total number of call center employees needed to meet the minimum requirements.

 

Let Xi = the number of call center employees who start work on day i
        (i = 1 = Monday, i = 2 = Tuesday...)

 

 

Min X1 + X2 + X3 + X4 + X5 + X6 + X7    
s.t.                  
  X1 +     X4+ X5+ X6+ X7   fill in the blank 2
  X1 + X2+     X5+ X6+ X7   fill in the blank 4
  X1 + X2+ X3+     X6+ X7   fill in the blank 6
  X1 + X2+ X3+ X4+     X7   fill in the blank 8
  X1 + X2+ X3+ X4+ X5       fill in the blank 10
    X2 + X3+ X4+ X5+ X6     fill in the blank 12
      X3 + X4+ X5+ X6+ X7   fill in the blank 14
  X1, X2, X3, X4, X5, X6, X7 0

 

Find the optimal solution.

 

X1 = fill in the blank 15
X2 = fill in the blank 16
X3 = fill in the blank 17
X4 = fill in the blank 18
X5 = fill in the blank 19
X6 = fill in the blank 20
X7 = fill in the blank 21

 

Total Number of Employees = fill in the blank 22

Give the number of call center employees that exceed the minimum required.

Excess employees:

Monday = fill in the blank 23
Tuesday = fill in the blank 24
Wednesday = fill in the blank 25
Thursday = fill in the blank 26
Friday = fill in the blank 27
Saturday = fill in the blank 28
Sunday = fill in the blank 29
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 7 steps with 5 images

Blurred answer
Knowledge Booster
Inventory management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.