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 thatthe 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 X; = thenumber of call-center employees who start work on day i where i = 1 = Monday, i = 2 = Tuesday, etc).Mins.t.MondayTuesdayWednesdayThursdayFridaySaturdaySundayX₁, X₂, X3, X₁, X5, X6, X7 20Find the optimal solution.(X1, X21 X3, X4, X5, X6₁X7) = |Give the number of call-center employees that exceed the minimum required.(M, TU, W, Th, F, Sa, Su) = 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's website, but a small percentage of customers makereservations 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 planschange 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 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 the first two weeks of August). These estimates are givenin the following table.DayMondayTuesdayWednesdayThursdayFridaySaturdaySundayMinimum Number ofEmployees Needed65353040757040

DayMinimum employees neededMonday65Tuesday35Wednesday30Thursday40Friday75Saturday70Sunday40Working…

Answered: A linear programming computer package…

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

Describe the necessity of computers in conducting a real world simulation in operations ?
Ted Glickman, the administrator at D.C. General Hospital emergency room faces the problem of providing treatment for patients who arrive at different rates during the day. There are 4 doctors available to treat patients when needed. If not needed, they can be assigned other responsibilities (such as doing lab tests, reports, X-ray diagnoses) or else rescheduled to work at other hours. It is important to provide quick and responsive treatment, and Ted feels that, on the average, patients should not have to sit in the waiting area for more than 4 minutes before being seen by a doctor. Patients are treated on a first-come, first-served basis and see the first available doctor after waiting in the queue. The arrival pattern for a typical day is as follows: Time Arrival Rate 9 A.M.−3 P.M. 8 patients/hour 3 P.M.−8 P.M. 3 patients/hour 8 P.M.−midnight 13 patients/hour Arrivals follow a Poisson distribution, and treatment times, 12…
A manufacturing plant produces a product 'A' that requires one unit of 'B' and ½ unit of 'C'. Each unit of 'B' is comprised of one unit of 'D', two units of 'E', and one unit of 'F'. Each unit of 'C' requires ½ unit of 'G' and three units of 'H'. The manufacturing lead times for the components are as follows: 'A' - two weeks, 'B' - one week, 'C' - two weeks, 'D' - two weeks, 'E' - three weeks, 'F' - one week, 'G' - two weeks, 'H' - one week. There are 20 units in stock for each of these components. 100 units of 'A' are needed for delivery in seven weeks: a) Develop the product structure and indexed bill of materials for the product. b) Create a gross and net requirements plan for the manufacturer of the product.
Sensuality Corporation's management keeps track of the time it takes to process orders. During the most recent month, the following average times were recorded per order. Days Wait time 15. 6 Inspection time 0.8 Process time 1.6 Move time 0.7 Queue time 3.9 Required: A. Compute the delivery cycle time in days B. Compute the Percentage of manufacturing cycle time spent on non-value-added activities
An order for 200 units of a product is processed on work centers A and B. The set up time on A is 45 minutes and the run time is 5 minutes per piece. The set up time on B is 40 minutes and the run time is 8 minutes per piece. The wait time between the two operations is 2 hours. The move time between A and B is 15 minutes. Wait time after operation B is 1 hour and the move time into stores is 50 minutes. There is no queue at either work station. Calculate the total manufacturing lead time for the order.
To remain competitive, several fast food businesses began to diversify their menus. While this has aided in competitiveness, it has increased the complexity of operations, particularly inventory management. More precisely, in what ways does expanding menu selections complicate inventory management?
Choice Bank receives credit card applications that need to be reviewed for a decision. There are two types of applications; preapproved, and non-preapproved. Preapproved applications only need a quick review and therefore take 6 minutes to process. Applications that are not preapproved need a secondary credit check and take 15 minutes to process. 8. The bank receives 10 preapproved applications every hour and 6 applications that are not preapproved every hour. What is the utilization of the process?
The Dahlia Medical Center has 34 labor rooms, 18 combination labor and delivery rooms, and 5 delivery rooms. All of these facilities operate around the clock. Time spent in labor rooms varies from hours to days, with an average of about a day. The average uncomplicated delivery requires about one hour in the delivery room. The average time in a combination labor-delivery room is about 24 hours. During an exceptionally busy three-day period, 101 healthy babies were born at Dahlia Medical Center. 59 babies were born in separate labor and delivery rooms and 42 were born in combined labor and delivery rooms. Which of the facilities (labor rooms, combination labor and delivery rooms, or delivery rooms) had the greatest utilization rate? ▼had the highest utilization rate of %. (Enter your response as a percent rounded to two decimal places.) The combination labor and delivery rooms delivery rooms labor rooms
A process improvement team is working to improve the production output at the Johnson Manufacturing plant’sHeader Cell that manufactures a key component, headers, used in commercial air conditioners. A header is partof the circulatory system of a commercial air conditioner that moves coolant between various components suchas the evaporator coil and the condenser coil. Currently, the header production cell is scheduled separately fromthe main work in the plant. Often, individual headers are not sequenced to match the product they go into on thefinal assembly line in a timely fashion, and so the product can sit in queue waiting for a header
The selection of the convenient data flow type (simplex, duplex, full duplex) depends mainly on the: Data Application Medium O Computer
Sherwood Store is a retail grocery store chain with a central distribution center and 14 retail stores in a major metropolitan area. Managers at all levels at the headquarters office, at the distribution center, and in the retail stores use reports generated from various information systems. One of the important information systems is the inventory system that keeps track of physical inventory by product line. Sales information gathered at point-of-sale checkout terminals is used to update inventory levels. At the end of each day, the store manager receives a reorder report indicating which items in inventory have reached their reorder point and need to be reordered from the distribution center. The inventory system also includes a report of items on order by product line, prices, and expected delivery dates. Each department manager within each store develops a sales plan that indicates the expected sales volume for each item for the subsequent week. Actual sales for each item are…

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