Problem 9-09 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:
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 | ? | ||||
X1 + | X2+ | X5+ | X6+ | X7 | ? | ||||
X1 + | X2+ | X3+ | X6+ | X7 | ? | ||||
X1 + | X2+ | X3+ | X4+ | X7 | ? | ||||
X1 + | X2+ | X3+ | X4+ | X5 | ? | ||||
X2 + | X3+ | X4+ | X5+ | X6 | ? | ||||
X3 + | X4+ | X5+ | X6+ | X7 | ? | ||||
X1, | X2, | X3, | X4, | X5, | X6, | X7 | ? | 0 |
Find the optimal solution.
X1 | = | |
X2 | = | |
X3 | = | |
X4 | = | |
X5 | = | |
X6 | = | |
X7 | = |
Total Number of Employees =
Give the number of call center employees that exceed the minimum required.
Excess employees:
Monday | = | |
Tuesday | = | |
Wednesday | = | |
Thursday | = | |
Friday | = | |
Saturday | = | |
Sunday | = |
Excel model and solution
X1 | = | 20 |
X2 | = | 20 |
X3 | = | 0 |
X4 | = | 45 |
X5 | = | 5 |
X6 | = | 5 |
X7 | = | 0 |
Total number of employees = 95
Excess Employees
Mon | 0 |
Tue | 0 |
Wed | 0 |
Thu | 25 |
Fri | 0 |
Sat | 0 |
Sun | 10 |
Problem 9-09 Epsilon Airlines services predominantly the eastern and southeastern united States. The vast majority of E...
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...
Problem 4-09 (Algorithmic) Epsilon Airlines services predominately 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 phone. Epsilon employs call-center personnel to handle these reservations along with any problems with the website reservation system and for the rebooking challenge for Epsilon's magement team. Having too many employees on hand of flights for customers if their plans change or their travel s disrupted. Staffing...
Epsilon Airlines services predominately the eastern and southeastern United States. A vast majority of Epsilon's customers make reservations through Epsilon's website, but a small percentage of customers make reservations via phone. Epsilon employs call-center personnel to handle these reservations along with any problems with the website reservation system and for the rebooking of flights for customers if their plans change or their travel is disrupted. Staffing the call center appropriately is a challenge for Epsilon's management team. Having too many...
please help with the bottom portions EDUUR Problem 9 09 (Algorithmic) 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 reservatior 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...
3. A post office requires different numbers of full-time employees on different days of the week. Each full-time employee must work five consecutive days and then receive two days off. The following table gives the number of employees required on each day of the week is specified. The post office would like to minimize the number of full-time employees needed to satisfy these constraints. Day No. of full-time employees required 15 Monday Tuesday Wednesday Thursday Friday Saturday Sunday 16 11...
Optimization Problem QUESTION 1 15 Marks A post office requires different numbers of full-time employees on different days of the week. Each full-time employee must work five consecutive days and then receive two days off. In Table 1, the number of employees required on each day of the week is specified. Table 1: Employee work schedule Day 1=Monday 2=Tuesday 3=Wednesday 4=Thursday S=Friday 6=Saturday 7=Sunday Number of full-time Employees Required 17 13 15 19 16 Formulate a linear programming (LP) model...
This is a cyclic scheduling problem unlike the other personnel scheduling problems we considered earlier which were acyclic. In this case, for example, a driver who starts his working week on Friday will work for the rest of the week (F, Sa and Su) and the first part of the following week (M and Tu) while is taking off W and Th (see attached file). In other words, his schedule spans not just one week (cycle) but two. The decision...
MATLAB only please I am trying to get my getdatafuntion to work. I am also trying to get all my x's, y's, and v's to popup in the command window so I can put in any value and it will find the value for me using the equation I put in. function project_9_sjl() % PROJECT_9_SJL project_9_sjl() is the driver function for the program. % % Name: Scott Lawrence % Date: 3/27/2019 % Class: CMPSC 200 % Description: Determine the optimal...