A manufacturing company must assign machine operators to each of four jobs. The time an operatortakes to accomplish the job varies depending on their individual abilities. The table below shows thetime in minutes it takes each operator to perform each job. Let's say you ran solver to find optimalassignments that minimized the total labor time, In minutes, what would be the objective functionvalue?Job (Time in Minutes)Worker6.5.38.48.4.45.Worker3\8.4.4.C84.D7.4O 16O 17O 1804O 20

Assignment problems are used to allocate different available resources to different jobs or…

Answered: A manufacturing company must assign…

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

A manufacturing system is used to produce a product.Each unit of product must be processed sequentially through workstations.V -----> W -----> X -----> Y The processing time on each workstation are as follows:Workstation V, 11 minutes per unit,Workstation W, 6 minutes per unit,Workstation X, 19 minutes per unit,Workstation Y, 19 minutes per unit. The raw material is always available in the front of workstation V. The manufacturing system can produce __________ units in 27 hours. Use at least 4 decimals.You must show your calculation steps and brief explanation on your Excel spreadsheets.
please see images
(Use the same scenario as above.) If the company produces 8 units of A and 5 units of B, the amount of slack (in hours) for process 1 is a. 14 hours b. 20 hours c. 57 hours d. 23 hours.
A paper-making company has five machines that can produce four different types of papers. The company wants to assign each paper type to separate machines to minimize the total time required. The manufacturing times in minutes per unit of paper produced is listed below: Paper Type Machine Type A B C D M1 2.40 1.60 3.20 3.20 M2 2.10 2.40 3.20 4.50 M3 1.90 1.70 2.60 5.10 M4 2.50 2.50 3.20 6.50 M5 3.25 2.40 3.10 3.60 What is the optimal minimum time?
A medical clinic performs three types of medical tests that use the same machines. Tests A, B, and C take 15 minutes, 30 minutes, and 1 hour, respectively, with respective profits of $120, $240, and $500. The clinic has four machines and four workers available. One person is qualified to do test A, two to do test B, and one to do test C. If the clinic has a rush of customers for these tests, how many of each type should it schedule in a 10-hour day to maximize its profit?
Seneca Hill Winery recently purchased land for the purpose of establishing a new vineyard.Management is considering two varieties of white grapes for the new vineyard: Chardonnayand Riesling. The Chardonnay grapes would be used to produce a dry Chardonnay wine,and the Riesling grapes would be used to produce a semidry Riesling wine. It takes approximatelyfour years from the time of planting before new grapes can be harvested. Thislength of time creates a great deal of uncertainty concerning future demand and makes thedecision about the type of grapes to plant difficult. Three possibilities are being considered:Chardonnay grapes only; Riesling grapes only; and both Chardonnay and Riesling grapes.Seneca management decided that for planning purposes it would be adequate to consideronly two demand possibilities for each type of wine: strong or weak. With two possibilitiesfor each type of wine, it was necessary to assess four probabilities. With the help of someforecasts in industry…
Daniel Glaser, chairman of the College of San Antonio's business department, needs to assign professors to courses next semester. As a criterion for judging who should teach each course, Professor Glaser reviews the past 2 years' teaching evaluations (which were filled out by students). Since each of the four professors taught each of the four courses at one time or another during the 2-year period, Glaser is able to record a course rating for each instructor. These ratings are shown in the following table. Professor W.W. Fisher D. Golhar Z. Hug N. K. Rustagi a) The optimal assignment of courses to professors that will maximize the overall teaching rating is: Statistics 65 90 70 85 Statistics Management Finance Economics Course Management 75 65 60 40 → Finance 70 95 80 80 The overall teaching rating of the assignment = (enter your response as a whole number). b) The school does not want Professor Fisher to be assigned to the statistics class. Based on the assignment above, a change to…
Ensemble Theatre of Cincinnati D. Lynn Meyers has been Producing Artistic Director of the nationally renowned Ensemble Theatre of Cincinnati (ETC) since 1995. The nonprofit ETC, recently celebrating its 25th anniversary, is dedicated to the production and development of new plays and of works new to the region. Lynn values the opinions of each member of her small staff when hiring. She usually interviews four or five people for a staff position and conducts two interviews. After the preliminary interview determines that an applicant is suitable, she says, “We invite the person back to meet the staff they would have contact with on a daily basis.” She has passed on qualified candidates who did not interact well with their prospective coworkers or who did not convince her that they had a strong desire for the job. Lynn researches job applicants online and on social media sites. “Frankly, if we find unprofessional behavior, we take that into consideration,” she says. “We always check…
An entrepreneur is starting up a new bakery featuring a special pastry from an old family recipe. The basic dough recipe requires 5cups of flour, which is 0.75kg, plus another 0.75kg consisting of all the other ingredients, sugar, butter, milk, yeast, fruits, nuts and spices, to make the dough for 15 medium pastries. She runs some tests to scale up her recipe. In her first test batch she creates dough for 300 pastries, how much flour, in kg, was required?
KrazySockzThe KrazySockz Company is known for their colorful yetcomfortable socks. They have forecasted their demand for the nextsix months as follows: Month 1 demand is 30,000, month 2demand is 50,000, month 3 demand is 20,000, month 4 demand is10,000, month 5 demand is 15,000 and month 6 demand is 20,000.At the beginning of month 1 they have 15,000 pairs of socks onhand. KrazySockz currently has 40 production employees. Each productionemployee costs the company the company $4,000 per month ($3,200 salary and $800in other costs) per month. Production employees can work up to 160 hours permonth before they must be paid overtime. Overtime is paid at a rate of $30 per hourand production employees can not work more than 30 hours per month overtime. Ittakes 15 minutes of labor and $0.75 of raw material to produce a pair of socks.KrazySockz can hire or fire employees each month. Hiring a production employeeincurs a cost of $3,500 and firing a production employee costs $4,500. At the end…
Monsters, Inc. has two plants for producing electricity, one in Monsterville and another is in New Yeti. The Monsterville plant produces according to eM(x1,x2) = min{xX1,2x2} and the New Yeti plant produces according to eNY(x1,x2) = min{2x1,x2}, where xi and x2 are the inputs. iii. How much of each input will the firm need in order to produce 20 units electricity in the New Yeti plant? iv. Assume now that Monsters, Inc. decides to produce 40 units of electricity and it can split production in any manner between the two plants. Is the technology available to this firm convex or concave? Explain your answer.
Use the simplex iteration method each of the objective function using the same constrains Maximize Z=3X1-X2+3X3+4X4 Minimize Z=5x1-4x2+6x3-8x4 Constrains x1+2x2+2x3+4x4=<40 2x1-x2+x3+2x4=<8 4x1-2x2+x3-x4=<10 x1, x2, x3, x4=>0

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