operations research -linear programming problem -assignment pls include a full solution ty! 1. You want to assign a set of jobs to a set of machines. The following table provides data as to theproduction/day of each machine when performing a particular job.MachineJobАв с D140 180 | 160 200210 195 140 120220 170 180 1251234185 230 100 160Determine the best assignment of jobs to. What is the resulting total production of the assignment?

Assignment problems solve the problem of assigning different jobs to different and best resources.…

Answered: Determine the best assignment of jobs…

Business

Operations Management

Determine the best assignment of jobs to. What is the resulting total production of the assignment?

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

2. Jamila wants to set up a manufacturing unit, so she meets with Rashid, a humanresource manager at her company. Rashid explains that in order to decide on thehuman resource needs for the unit, they should conduct a workflow analysis. Shesuggests they start by defining the outputs of the process. To do this, what shouldJamila define?A) the processes that will be involved in manufacturingB) the number of people required for productionC) the type of products that will need to be manufacturedD) the special equipment, facilities, and systems needed for productionE) the data and information needed by the work unit
You are the owner of a business and must perform the work of ten clients during the day. It has four collaborators who are capable of carrying out the different jobs with the same level of quality. Depending on the skills of the different collaborators and the complexity of the jobs, the execution times are different and are presented in the following table: Cliente Andrea Bruno Claudio Daniela Arkitex 3 3 2 1 Bravia 3 3 4 3 Cúbika 4 5 6 4 Doratta 8 6 5 7 Evergreen 3 4 2 2 Fenix 5 6 3 4 Golden 3 3 1 4 Horizon 6 8 6 5 Icónika 5 5 5 5 Luxus 4 4 1 2 Now consider the following additional conditions:- Bravia and Cúbika projects cannot be assigned to the same collaborator.- The Fenix and Golden projects cannot be assigned to the same collaborator.State and solve the problem through excel
You are the owner of a business and must perform the work of ten clients during the day. It has four collaborators who are capable of carrying out the different jobs with the same level of quality. Depending on the skills of the different collaborators and the complexity of the jobs, the execution times are different and are presented in the following table: Client A B C D Arkitex 3 3 2 1 Bravia 3 3 4 3 Cúbika 4 5 6 4 Doratta 8 6 5 7 Evergreen 3 4 2 2 Fenix 5 6 3 4 Golden 3 3 1 4 Horizon 6 8 6 5 Icónika 5 5 5 5 Luxus 4 4 1 2 Solve it through excel solver.
You are the owner of a business and must perform the work of ten clients during the day. It has four collaborators who are capable of carrying out the different jobs with the same level of quality. Depending on the skills of the different collaborators and the complexity of the jobs, the execution times are different and are presented in the following table: Client A B C D Arkitex 3 3 2 1 Bravia 3 3 4 3 Cúbika 4 5 6 4 Doratta 8 6 5 7 Evergreen 3 4 2 2 Fenix 5 6 3 4 Golden 3 3 1 4 Horizon 6 8 6 5 Icónika 5 5 5 5 Luxus 4 4 1 2 b) Now consider that each employee must carry out at least one job during the day. State and solve the problem throught excel solver
You are the owner of a business and must perform the work of ten clients during the day. It has four collaborators who are capable of carrying out the different jobs with the same level of quality. Depending on the skills of the different collaborators and the complexity of the jobs, the execution times are different and are presented in the following table: Cliente A B C D Arkitex 3 3 2 1 Bravia 3 3 4 3 Cúbika 4 5 6 4 Doratta 8 6 5 7 Evergreen 3 4 2 2 Fenix 5 6 3 4 Golden 3 3 1 4 Horizon 6 8 6 5 Icónika 5 5 5 5 Luxus 4 4 1 2 Now consider that each employee can carry out at most three jobs during the day. State and solve the problem thorugh excel solver.
I'm trying to find the capacity of a current line (on a conveyor-paced assembly). Each worker must perform at least one task. There are 6 tasks. Time to complete each task, starting with task 1, is 30, 25, 35, 40, 15, and 30 - all in seconds. There are 4 workers. Worker 1 completes Task 1; Worker 2 completes Task 2; Worker 3 completes Tasks 3 and 4; and Worker 4 completes Task 5 and 6.
b. The Healthy Food Restaurant, a 24-hour restaurant, faces changing requirements from hour tohour. More workers are needed for peak hours, and fewer are needed in between. The followingTable 6 (below) shows the worker requirement for the first 12 hours in the restaurant:Table 6. Staff Requirement at the Healthy Food RestaurantTime Period 10AM11AM12PM1PM2PM3PM4PM5PM6PM7PM8PM9PMRequirement 8 10 12 12 9 7 6 7 9 10 12 8AssignedOn DutyOverstaffed8(i) You are required to apply the first-hour principle to staff each hour with the required number ofcafeteria staff, showing how many staff are on duty each given hour, the number of staffyou have assigned to work each hour and any overstaffing for each hour. i. Schedule the staff to work in 8-hour shifts.
A manager has 5 subordinates and 5 tasks in his department. Each subordinate differs in efficiency. His estimate the task each would do cost given in the following table. By applying the assignment method, how the task should be allocated to his people so the total cost of his department is minimum? And how much? Cost (in thousand USD$) Task 1 2 3 4 5 Subordinate A 9 10 11 8 8 B 9 8 9 9 8 C 9 9 8 8 8 D 9 8 8 8 9 E 9 8 8 9 8
9-33. Bechtold Construction is in the process of installingpower lines to a large housing development. SteveBechtold wants to minimize the total length of wireused, which will minimize his costs. The housingdevelopment is shown as a network on this page.Each house has been numbered, and the distancesbetween houses are given in hundreds of feet. Whatdo you recommend?
The efficiency of five machines on each of the five jobs is given in the following table. Determine the assignment schedule of the job to the machines such that the total efficiency is maximum. Job Machine 1 2 3 4 5 I 62 78 50 101 82 II 70 85 60 75 55 III 88 96 118 85 71 IV 48 64 87 77 80 V 60 70 98 66 83
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
Construct a multi-activity chart. Assume the operator is handling 3 machines. His travel timefrom the machine is 0.5 minutes, loading of materials is 1 minute, unloading is 1 minute, machiningis 8 minutes, and inspection & packing is 0.5 minutes. The analyst will observe the operator up tothree cycles. Compute the following1. Idle Time of operator __________ minutes2. Idle time of machine 1 __________ minutes3. Idle Time of machine 2 __________ minutes4. Idle time of machine 3 ___________ minutes5. The third cycle of machining will be finished on _________ minutes