a. What is the cost of the optimal crew assignment?Cost of optimal crew assignmentb. Which crews are assigned to work?Crew 1 willCrew 2 willCrew 3 willCrew 4 willCrew 5 willCrew 6 willCrew 7 willCrew 8 willnot be assignedbe assignednot be assignedbe assignednot be assignednot be assignednot be assignedbe assigned The university is scheduling cleaning crews for its ten buildings. Each crew has a different cost and is qualified to clean only certainbuildings. There are eight possible crews to choose from in this case. The goal is to minimize costs while making sure that eachbuilding is cleaned. The management science department formulated the following linear programming model to help with theselection process.Min 190x1 + 290x2 + 300x3+ 250x4 +210x5 +220x6 +290x7 + 240x8s.t. x₁ + x₂ + x5 + x7 2 1 (Building A constraint}x1 + x₂ + x3 = 1 [Building B constraint}X6 + x8 2 1 (Building C constraint}x₁ + x4 + x7 ² 1 (Building D constraint}x2 + x7 > 1 [Building E constraint}x3 + x8 > 1 [Building F constraint}x₂ + x5 + x71 [Building G constraint}x1 + x4 + x61 [Building H constraint}x1+ X4 + x8> 1 [Building I constraint}x₁ + x₂ + x = 1 {Building J constraint}[1, if crew j is selected0, otherwiseSet up the problem in Excel and find the optimal solution.xj =

Linear programming is a mathematical technique that is also used in operations management…

Answered: a. What is the cost of the optimal crew…

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

Joanne supervised 36 professionals in 6 city libraries. To cut the costs of unnecessary overtime, she issued this one-sentence memo to her staff: 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 (8) hours or more on two (2) 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 36 copies were sent out, Joanne’s office received 26 phone calls asking what the memo meant. What the 10 people who did not call about the memo thought is uncertain. It took a week to clarify the new policy. 3. How would Joanne's past associations with her staff impact the interpretation of this message?
Joanne supervised 36 professionals in 6 city libraries. To cut the costs of unnecessary overtime, she issued this one-sentence memo to her staff.“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 (8) hours or more on two (2) 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 36 copies were sent out, Joanne’s office received 26 phone calls asking what the memo meant. What the 10 people who didn’t call about the memo thought is uncertain. It took a week to clarify the new policy. discuss the “communication pitfalls” in the communication process and how this could be avoided.
Task 4The incidence of rust attack along a gas pipeline can be modeled as a Poisson process withintensity λ per kilometer. This means that the number of rust attacks per kilometer along the pipeline canassumed to be Poisson distributed with expected value λ.Assume initially that it is known that λ = 5.The distance between two subsequent rust attacks is exponentially distributed with parameter λ (the distancebetween subsequent events in a Poisson process is exponentially distributed), and we still assumethat λ = 5 per kilometer.b) What is the expected distance between two successive rust attacks?What is the probability that the distance between two consecutive rust attacks is more than 200meters?What is the probability that the distance between two successive rust attacks is less than300 meters?What is the probability that the distance between two consecutive rust attacks is between 200and 300 meters?
Scenario: Early one Monday morning in Jamaica, Susan, a Restaurant Manager starts getting ready for the morning’s work operations. She is particularly happy because tonight he has a date with Marvin, the new Chef that was recently hired. The problem, as Susan sees it, is that Roberta, another Restaurant employee has been just a little too friendly with Marvin lately and that really upsets Susan. Susan has redone the work schedule, assigning Roberta the clean-up shift in the night and cutting back on her hours of work. She is hoping that Roberta would simply quit and out of her way. However, that plan doesn’t seem to be working.Despite a lighter pay cheque and frequent reprimand through the disciplinary process of creating reasons to write to her about her conduct and performance. Roberta has decided to quit her studies due to her inability to fund her tuition. A few days later, Susan noticed Marvin and Roberta having lunch together in the staff dining room. Susan got furious and…
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.
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?
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,…
8. A manufacturer of sails for small boats has a group of custom candles awaiting the latest two processing operations before they are sent to customers. Operation 1 must be performed before operation 2, and the tasks have requirements for different times for each operation. The required hours are the following: assignment: 1 2 3 4 5 6 7 8 9 10 Operation 1: 1 5 8 3 9 4 7 2 4 9 Operation 2: 8 3 1 2 8 6 7 2 4 1 A. Use Johnson's rule to determine the sequence excellent. B. Draw a Gantt chart for each operation.
Client 1: Mdm. Aurora LaiMdm. Aurora is planning to organise a birthday party of her daughter, Isabelle, who will be 10 years old in a month time. They are expecting 50 guest coming with most of them will be Isabelle’s schoolmates. Below are the information that your group have gathered from Mdm. Aurora.  No peanut based in any of the meals due to Isabelle’s allergic to peanut. Isabelle’s favourite movie is El Canto. Briefly propose the theme’s title/ name and concept of the event.
6. Which of the following is a graphical network model that depicts a project’s tasks and the relationships between those tasks? a. PERT chart b. WBS c. Gantt chart d. Line chart
Case: The Drop-In Visitor As the door closed behind her departing visitor, Jumanji Residential Supervisor Janet Mills glumly reflected that she had just lost an hour that she could ill afford to lose. She would either have to forego the schedule she was working on or be later for an upcoming meeting. The hour had been lost because of a visit from a pleasant but marginally aggressive sales representative trying to acquaint her with "the greatest little thing to come along". As was her practice, Janet consented to see the visitor although she resented the intrusion. This incident, occurring on a Friday, made Janet realize that she had lost time to four such drop-in visits this week alone. She did not like the idea of simply saying no or otherwise trying to avoid people who wanted to see her, but she was becoming more aware that her work was beginning to suffer because of such demands on her time. Questions: 1. Describe how stress can be both positive and negative.

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