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…
3 35 The customers go to the company are at the rate of one arrival every 12 minutes. The time between arrivals follows an exponential distribution. Each customer gets the service with mean 8 minutes. There is just one person to serve. Company management wants to learn performance values for the service. Answer the following questions for the company. a. Determine the arrival frequency, service frequency and system utilization factor b. Determine the probability that no customer in the service c. Determine expected number of customers in system d. Determine expected number of customers in queue e. Determine expected waiting time in system f. Determine expected waiting time in queue
Ee 264.
(Use output ranges of 2000, 4000, 6000, 8000 etc. and intervals of $50,000 on the Y axis. Output X Location A Location B Location B Location D 2 000 120 000 120 000 130 000 150 000 4 000 180 000 160 000 160 000 170 000 6 000 240 000 200 000 190 000 190 000 8 000 300 000 240 000 220 000 210 000 10 000 360,000 280 000 250 000 230 000 12 000 420 000 320 000 280 000 250 000 14 000 480,000 360 000 310,000 270 000 16 000 540 000 400 000 340 000 290 000 18 000 600 000 440 000 370 000 310 000 20 000 660 000 480 000 400 000 330 000 Over what range of output is location A the most preferred location? 2. Over what range of output is location B the most preferred location? 3.Over what range of output is location C the most preferred location?
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?
A company possesses two manufacturing plants, each of which can produce three products, X, Y, and Z, from a common raw material. However, the proportion in which the products are produced differs in each plant, and so are plant's operating costs per hour. Data on production per hour and costs are given below, together with current orders in hand of each product. Products Operating cost per hour Y Plant A 4 9. Plant B 4 2 10 Orders on hand 50 24 60 Formulate the above as a linear programming problem. Find the number of production hours needed to fulfill the orders on hand at minimum cost using the using Big M method.
plz solve it within 30-40 mins I'll give you multiple upvote

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) =