Exercise 6.13 The required staffing in a call center, from 9am to 9pm in 30-minuteintervals, is as follows:10, 11, 13, 16, 16, 13, 11, 10, 10, 11, 12, 13, 14, 14, 13, 11, 10, 9, 9, 10, 9, 8, 8, 8.There are 2 types of shifts:- 8 hours working time, with a 30-minute unpaid break in the middle, wage 20108100Koole – Business AnalyticsEuro/hr, possible starting times every half hour from 9am to 12:30pm;-4 hours consecutive, wage 24 Euro/hr, possible starting times every half hour from9am to 5pm.Formulate this as a covering problem and solve it with the Excel solver.Machine scheduling is another important class of ILO problems. However,because it involves some modeling tricks that are discussed in Section 6.7,we defer discussing it to that section.The next two exercises concern problems that can be solved with appro-priately chosen binary decision variables.Th

Answered: Image /qna-images/answer/fbc198a1-7f88-46af-8981-f32c41b56834.jpg

Answered: Formulate this as a covering problem…

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

12 Tasks to 4 Workers Consider the following tasks that must be assigned to four workers on a conveyor-paced assembly line (i.e., a machine-paced line flow). Each worker must perform at least one task. There exists unlimited demand unless stated otherwise. Time to Complete Task (seconds): Task 1: 30 Task 2: 25 Task 3: 15 Task 4: 20 Task 5: 15 Task 6: 20 Task 7: 50 Task 8: 15 Task 9: 20 Task 10: 25 Task 11: 15 Task 12: 20 The current conveyor-paced assembly-line configuration assigns the workers in the following way: • Worker 1: Tasks 1, 2, 3 • Worker 2: Tasks 4, 5, 6 • Worker 3: Tasks 7, 8, 9 • Worker 4: Tasks 10, 11, 12 A)What is the capacity of the current line (in units per hour)? Given the Capacity of Workers: Worker 1 = 51.428571 Worker 2 = 65.45 Worker 3 = 42.352941 Worker 4 = 60.00 Capacity of each workers were available. But how will you determine the capacity of the current line (in units per hour)? What will be the answer? Thank you for your help!
12 Tasks to 4 Workers Consider the following tasks that must be assigned to four workers on a conveyor-paced assembly line (i.e., a machine-paced line flow). Each worker must perform at least one task. There exists unlimited demand unless stated otherwise. Time to Complete Task (seconds): Task 1: 30 Task 2: 25 Task 3: 15 Task 4: 20 Task 5: 15 Task 6: 20 Task 7: 50 Task 8: 15 Task 9: 20 Task 10: 25 Task 11: 15 Task 12: 20 The current conveyor-paced assembly-line configuration assigns the workers in the following way: • Worker 1: Tasks 1, 2, 3 • Worker 2: Tasks 4, 5, 6 • Worker 3: Tasks 7, 8, 9 • Worker 4: Tasks 10, 11, 12 A)What is the capacity of the current line (in units per hour)? B)What is the direct labor content (in seconds per unit)? C) Assume a demand rate of 20 units per minute. What would be the takt time of the process (in seconds per unit)? D)Assume a demand rate of 20 units per minute. What would be the target manpower?
Gertrude and Harry are both new coders at PVH. They have been hired at the entry-level Coder 1 position which requires an associate degree, which they both recently earned. However, neither of them has previous HIM or coding experience. Gertrude will be working the first shift (day, 7 a.m.-3 p.m.), while Harry works the second shift (evening, 3 pm-11 pm). Harry has achieved his CCS credential, but Gertrude has not. The rate of pay for Gertrude is $14.21 per hour; Harry will be making $14.71. Is the pay difference a violation of the Equal Pay Act of 1963? Justify your answer.
T:35) A cafeteria opens from 9 am to 5 pm. Staffing is as folllows: a full time worker works 7 hours with a 1 hour (paid) break in the middle. A part-time worker works 4 hours (consecutively). The number of workers needed per time-slot is shown below. A full time worker earns $12.00 per hour whereas a part time worker earns $7.50 per hour. At least 4 full time workers must be hired throughout the day. What is the best hiring schedule to minimise labour cost as well as deliver adequate service?
Five jobs are waiting for processing through two work centers. Their processing time (in minutes) at each work center is contained in the table below. Each job requires work center Sigma before work center Delta. According to Johnson's rule, what sequence of jobs will minimize the completion time for all jobs? Job Sigma Delta R 20 10 S 25 30 T 30 20 U 35 35 V 15 25 Part 2 A. V−S−U−T−R B. V−R−U−S−T C. R−V−T−S−U D. S−U−T−V−R E. R−S−T−U−V
in an assignment problem involving 8 workers and 8 jobs, total number of assignments possible are a. 8 b. 16 c. 24 d. 64
2. The operations manager of an assembly and paint shop has five trucks to schedule for repair. He would like to minimize the throughput time (makespan) to complete all work on these cars. Each truck requires assembly prior to painting. The estimates of the times required to do the assembly and paint work on each are as follows:Use Johnson's rule to sequence these five jobs for minimum total duration. Show your step by step work in determining the job sequence and calculate the total duration of finishing assembly and painting operations on all the five trucks ?
JOHNSON’S RULE Five specialty jobs at a La Crosse, Wisconsin, tool and die shop must be processed through two workcenters (drill press and lathe). The time for processing each job follows:Work (processing) Time for Jobs (hours)JOBWORK CENTER 1(DRILL PRESS) WORK CENTER 2(LATHE)A5 2B3 6C8 4D 10 7E 7 12
Four workers are available to perform jobs 1–4.Unfortunately, three workers can do only certain jobs:worker 1, only job 1; worker 2, only jobs 1 and 2; worker3, only job 2; worker 4, any job. Draw the network for themaximum-flow problem that can be used to determinewhether all jobs can be assigned to a suitable worker.
janitorial service, Mother’s Helpers, provide workers to clean office buildings during late evening hours using workers with two skill levels, 1 and 2. Each level 1 person is paid $12 per hour and each level 2 person is paid $8 per hour. The workers wash floors and vacuum offices. Each level 1 person can vacuum 9 offices per hour, whereas level 2 person can vacuum only 2 offices per hour. Each level 1 person can wash 2 floors per hour; whereas level 2 person can wash 3 floors per hour. In order to complete a new job in the allotted time, 18 offices must be vacuumed per hour and 12 floors must be washed per hour.
Jennifer supervised 50 employees in 5 departments. She sent a memo to her team in order to be efficient and cut costs of unnecessary overtime. The message was the following: “When workloads increase to a level requiring hours in excess of an employee’s regular duty assignment, and when such work is estimated to require a full shift of eight hours or more on two or more consecutive days, even though unscheduled days intervene, an employee’s tour of duty shall be altered so as to include the hours when such work must be done, unless an adverse impact would result from such employee’s absence from his previously scheduled assignment”. After the 50 copies were sent out, Jennifer’s office received 40 phone calls asking what the memo meant. The 10 employees left did not call but their thoughts about the memo is uncertain. It took two weeks to clarify the new policy. What is the main problem that the supervisor is trying to solve? What is the purpose of the message: to inform, persuade,…
Article: Harry Hartfield was looking over some recent travel brochures while consulting his recent Google search. Retirement is only 5 days away and he could not wait to see the Fiji Islands. He and his wife thought they would start with a restful break before they started their travels in earnest. Harry is the head aero engineer at Global Delivery Direct and has been in charge of purchasing the planes and maintenance for the last 15 years after being an employee with GDD 25 years before. Harry had worked up in the company to his current position and has seen a lot of initiatives come and go when it came to eco-friendly flying machines. In the last four weeks, Harry has been breaking in his replacement, Imogine Farthing, who is coming from their London branch. Harry likes Imogine and thinks that she will do well. However, she is keen to purchase the new Boeing 777 cargo plane. She thinks it will go a long way to improving their fuel consumption and air emissions in the long-run…

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