A linear programming computer package is needed.Epsilon Airlines services predominately the eastern and southeastern United States. A vast majority of Epsilon's customers make reservations through Epsilon'swebsite, but a small percentage of customers make reservations via phone. Epsilon employs call-center personnel to handle these reservations along with anyproblems with the website reservation system and for the rebooking of flights for customers if their plans change or their travel is disrupted. Staffing the callcenter 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 verypoor 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 thefirst two weeks of August). These estimates are given in the following table.Mins.t.MondayTuesdayWednesdayThursdayFridaySaturdayDaySundayMondayTuesdayWednesdayThursdayFridaySaturdaySundayThe 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 minimizethe total number of call-center employees needed to meet the minimum requirements. (Let X; = the number of call-center employees who start work on day iwhere i = 1 = Monday, i = 2 = Tuesday, etc).Minimum Number ofEmployees Needed65Х1, Х2, Хз, Х4, X5, X6 X, zoFind the optimal solution.(X₁, X2, X3, X4, X5, X6¹ X7) = (504560857545Give the number of call-center employees that exceed the minimum required.(M, Tu, W, Th, F, Sa, Su) =

First, let me formulate the LP, Decision variables: Xi, here, i is 1, 2,...7, Here, X is the number…

Answered: Min s.t. Monday Tuesday Wednesday…

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...

See similar textbooks

Similar questions

Hello. Need help with this practice question.
A manufacturing firm has four plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below: Customer (requirement) Factory (capacity) Customer 1 (125) Customer 2 (150) Customer 3 (175) Customer 4 (75) A (100) $ 15 $ 10 $ 20 $ 17 B (75) $ 20 $ 12 $ 19 $ 20 C (100) $ 22 $ 20 $ 25 $ 14 D (250) $ 21 $ 15 $ 28 $ 12 How many supply nodes are present in this problem? Multiple Choice: 4 3 1 8 16
A1
The manager of a large group of employees must decideif she needs another photocopying machine. The cost of amachine is $40 per 8-hour day whether or not the machineis in use. An average of 4 people per hour need to use thecopying machine. Each person uses the copier for an averageof 10 minutes. Interarrival times and copying times areexponentially distributed. Employees are paid $8 per hour,and we assume that a waiting cost is incurred when a workeris waiting in line or is using the copying machine. Howmany copying machines should be rented?
Problem 6-09 (Algorithmic) The Ace Manufacturing Company has orders for three similar products: Product Order (Units) A 1750 B 500 C 1100 Three machines are available for the manufacturing operations. All three machines can produce all the products at the same production rate. However, due to varying defect percentages of each product on each machine, the unit costs of the products vary depending on the machine used. Machine capacities for the next week and the unit costs are as follows: Machine Capacity (Units) 1 1550 2 1450 3 1150 Product Machine A B C 1 $0.80 $1.30 $0.70 2 $1.40 $1.30 $1.50 3 $0.80 $0.80 $1.20 Use the transportation model to develop the minimum cost production schedule for the products and machines. Show the linear programming formulation. If the constant is "1" it must be entered in the box. If your answer is zero enter "0". The linear programming formulation and optimal solution are shown. Let xij = Units of…
Klein Chemicals, Inc., produces a special oil-based material that is currently in short supply. Four of Klein's customers have already placed orders that together exceed the combined capacity of Klein's two plants. Klein's management faces the problem of deciding how many units it should supply to each customer. Because the four customers are in different industries, different prices can be charged because of the various industry pricing structures. However, slightly different production costs at the two plants and varying transportation costs between the plants and customers make a "sell to the highest bidder" strategy unacceptable. After considering price, production costs, and transportation costs, Klein established the following profit per unit for each plant-customer alternative. Plant Clifton Springs Danville Plant Clifton Springs 2 Danville D₁ D3 D₂ $32 $34 $32 $40 $38 $34 $30 $28 The plant capacities and customer orders are as follows. Customer Capacity (units) 5,000 3,000 3 4…
Ee 264.
55. The mail order firm of L. L. Pea receives an averageof 200 calls per hour, where times between calls areexponentially distributed. It takes an L. L. Pea operatoran average of three minutes to handle a call. If a callergets a busy signal, L. L. Pea assumes that he or she willcall a competing mail-order company, and L. L. Pea willlose an average of $30 in profit. The cost of keeping aphone line open is $9 per hour. How many operatorsshould L. L. Pea have on duty? Use simulation to answerthis question. Does the answer depend on whether theservice times are exponentially distributed?
L.P. Model: Minimize Subject to: Z = 15X+12Y 7X+11Y288 (C₂) (C₂) 16X+4Y280 X,Y 20 On the graph on right, constraints, C, and C₂ have been drawn. Using the point drawing tool, plot all the corner points for the feasible area. 24- 22- 20- 18- 16- 14- 12- 10 8- 64 4- 2- -N 10 12 14 16 18 20 22 24 X C G
A grocery store has three open checkout counters. There is a single queue leading up to these three counters. On average, 45 shoppers arrive at this queue. The coefficient of variation of the interarrival time is equal to 1. The average service capacity of each of the three servers is 18 customers per hour, and the coefficient of variation of service time distribution for each server is 3. (a) (3 points) What is the percentage decrease in capacity utilization when one more checkout lane is added to the system? (b) (7 points) On average, how many customers are waiting in the queue?
establish the significance of random numbers in Monte Carlo simulations.
14

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

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

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

Min s.t. Monday Tuesday Wednesday Thursday Friday Saturday Sunday X1 X2 X3 X4 X5, X6, Xy 20 Find the optimal solution. (X₁, X2, X3, X4, X5, X61 X7) = ([ Give the number of call-center employees that exceed the minimum required. -([ (M, Tu, W, Th, F, Sa, Su) =