Question

In: Math

Epsilon Airlines services predominately the eastern and southeastern United States. A vast majority of Epsilon’s customers...

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 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 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 75
Tuesday 50
Wednesday 45
Thursday 60
Friday 90
Saturday 75
Sunday 45

The call-center employees work five consecutive days and then have two consecutive days off. An employee may start work 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. Find the optimal solution. Give the number of call-center employees that exceed the minimum required. Use a software package LINGO or Excel Solver. If your answer is zero, enter "0".

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______ + X2______ + X3______ + X4______ + X5______ + X6______ + X7______ ______
X1______ + X2______ + X2______ + X2______ + X5______ + X6______ + X7______ ______
X1______ + X2______ + X3______ + X4______ + X5______ + X6______ + X7______ ______
X1______ + X2______ + X3______ + X4______ + X5______ + X6______ + X7______ ______
X1______ + X2______ + X3______ + X4______ + X5______ + X6______ + X7______ ______
X1______ + X2______ + X3______ + X4______ + X5______ + X6______ + X7______ ______
X1______ + X2______ + X3______ + X4______ + X5______ + X6______ + X7______ ______
X1, X2, X3, X4, X5, X6, X7 ≥ 0

Solution:

X1 = ______
X2 = ______
X3 = ______
X4 = ______
X5 = ______
X6 = ______
X7 = ______

Number of excess employees:

Monday = ______
Tuesday = ______
Wednesday = ______
Thursday = ______
Friday = ______
Saturday = ______
Sunday = ______

Total Number of Employees = ______

Solutions

Expert Solution


Related Solutions

Epsilon Airlines services predominately the eastern and southeastern United States. The vast majority of Epsilon’s customers...
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 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...
Epsilon Airlines services predominately the eastern and southeastern United States. A vast majority of Epsilon’s customers...
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...
Problem 4-09 (Algorithmic) Epsilon Airlines services predominately the eastern and southeastern United States. A vast majority...
Problem 4-09 (Algorithmic) 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....
Epsilon Airlines services predominantly the eastern and southeastern united States. The vast majority of Epsilon’s customers...
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 9-09 (Algorithmic) Epsilon Airlines services predominantly the eastern and southeastern united States. The vast majority...
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 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....
Southwest Airlines provides scheduled air transportation services in the United States. Like many airlines, South-west leases...
Southwest Airlines provides scheduled air transportation services in the United States. Like many airlines, South-west leases many of its planes from Boeing Company. In its long-term debt disclosure note included in the financial statements for the year ended December 31, 2015, the company listed $324 million in lease obligations. The existing leases had an approximate ten-year remaining life and future lease payments average approximately $45 million per year. Required: 1. Determine the effective interest rate the company used to determine...
Because of a job change, Ben Hardesty has just relocated to the southeastern United States. He...
Because of a job change, Ben Hardesty has just relocated to the southeastern United States. He sold his furniture before he moved, so he's now shopping for new furnishings. At a local furniture store, he's found an assortment of couches, chairs, tables, and beds that he thinks would look great in his new two-bedroom apartment; the total cost for everything is $3,000. Because of moving costs, Ben is a bit short of cash right now, so he's decided to take...
Consider the situation of United Airlines (UA), an international airline based in United States of America....
Consider the situation of United Airlines (UA), an international airline based in United States of America. As part of its business it is heavily exposed to fluctuations in the price of jet fuel and foreign exchange rates. It sells tickets in foreign currencies and has significant EUR costs. For either jet fuel costs or forex, evaluate one derivative product UA could use to hedge fluctuations in the underlying price. • Briefly describe how the product would be used to hedge...
The majority of alleles responsible for CF in the United States contain the same genetic alteration,...
The majority of alleles responsible for CF in the United States contain the same genetic alteration, designated F508. What is the significance of this alteration and how does it lead to CF? " please type the answer don't handwrite it "
Wheels, Inc. manufactures bicycles sold through retail bicycle shops in the southeastern United States. The company...
Wheels, Inc. manufactures bicycles sold through retail bicycle shops in the southeastern United States. The company has two salespeople that do more than just sell the products- they manage relationships with the bicycle shops to enable them to better meet consumers' needs. The company's sales reps visit the shops several times per year, often for hours at a time. The owner of Wheels is considering expanding to the rest of the country and would like to have distribution through 2,250...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT