1A plumbing repair company has 3 employees and must choose which of 3 jobs to assign each to (each employee is assigned toexactly one job and each job must have someone assigned). Each employee can perform each job, but the cost to perform any givenjob can vary. The following table shows the cost for each employee to perform each jobJob 1Job 2Job 3Employee A Employee4843514535455150Solve this assignment problem in Excel to find the lowest cost solution and answer the following questions:a. Which employee is assigned to job 17(Click to select)b. Which employee is assigned to job 27Employee C44(Click to select) sc. Which employee is assigned to job 37(Click to select)d. What is the minimum cost to complete all three jobs?Minimum cost

ABCJOB 1484544JOB 2433545JOB 3515150

Answered: a. Which employee is assigned to job 17…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter5: Network Models

Section5.5: Shortest Path Models

Problem 34P

See similar textbooks

Similar questions

Maximize p = 10x + 20y + 15z subject to x + 2y + z ≤ 40 2y − z ≥ 10 2x − y + z ≥ 20 x ≥ 0, y ≥ 0, z ≥ 0.
9. Dana is 30 years old and owns a wedding planning business. She takes care of all wedding events details from arranging flowers, tables, theme to catering food to a high standard. She has a good reputation in the market. Recently, she discovered another food catering company with wider varieties and lower prices that her customers will love to have. Thus, she decided to write a negative letter to the current catering company to inform them about terminating their business together. Dana has to plan her negative letter very carefully and to explain the needs of her customers: * A.to avoid responsibility for the message B.to improve future performance on the part of the sender C.to avoid adding a personal message to the recipient D.to gain control of the context of the message E.to minimize damage to the business relationship
Janice Brown is employed by Starport Hardware Limited as a store clerk. One day she was inthe store arranging some items on a top shelf, the ladder she was standing on collapsed and shesuffered a broken arm and leg. The doctor told her that she had to a major surgery and it wouldtake approximately three months for her to heal enough to return to work. She is very concernedabout how she would pay her medical and recurring bills during this period. Her colleaguevisited her a week after the accident and told her about workers compensation. She is unsureabout the concepts and seeks your help to answer certain questions. A. Explain the concept ‘workers compensation’ B. Discuss the main objectives of workers compensation.C. Explain to Janice how workers compensation can assist her.D. Self-insurance is connected to workers compensation. State what isself -insurance and outline three advantages of it.
Maximize p = 7x + 6y + 3z subject to x + y + z ≤ 150 x + y + z ≥ 100 x ≥ 0, y ≥ 0, z ≥ 0. p= (x, y, z)=
Asap
Calculating outcomes as equally likely would BEST describe: O a. Maximax criterion O b. Laplace criterion O c. Regret criterion Od. Maximin criterion Determining the average payoff for each alternative and choosing the one with the BEST payoff is the approach called: ea, maximax O b. minimax regret O c. laplace Od maximin 2
Suppose my utility function for asset position x is givenby u(x) ln x.a Am I risk-averse, risk-neutral, or risk-seeking? b I now have $20,000 and am considering the follow-ing two lotteries: L1: With probability 1, I lose $1,000.L2: With probability .9, I gain $0.L2: With probability .1, I lose $10,000.Determine which lottery I prefer and the risk premium of L2.
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: Chardonnay and 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 approximately four years from the time of planting before new grapes can be harvested. This length of time creates a great deal of uncertainty concerning future demand and makes the decision concerning 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 consider only two demand possibilities for each type of wine: strong or weak. With two possibilities for each type of wine it was necessary to assess four probabilities. With the help of some forecasts in…
Use the information below to answer question 2x + 3y + 3z = 2 4x – 3y – 6z = 2 10x – 6y + 3z = 0 1. The co-factor for the first element in the coefficient matrix for this system is: A. -27 B. -45 C. 27 D. 45
Please do not give solution in image formate thanku. 11-24 Using PERT, Ed Rose was able to determine that the expected project completion time for the construction of a pleasure yacht is 21 months and the project variance is 4. What is the probability that the project will be completed in 17 months or less? What is the probability that the project will be completed in 20 months or less? What is the probability that the project will be completed in 23 months or less? What is the probability that the project will be completed in 25 months or less?
Assume that the payoff table provides cost rather than profit payoffs. What isthe recommended decision using:i. the optimistic approachii. the conservative approachiii. the minimax regret approachiv. the Laplace method
3 II | Here are the changes to the original problem and the revised conditions for this decision-making problem: With a favorable market, John Thompson thinks a large facility would result in a net profit of $195,000 to his firm. If the market is unfavorable, the construction of a large facility would result in $185,000 net loss. A small plant would result in a net profit of $110,000 in a favorable market, but a net loss of $25,000 would occur if the market was unfavorable. Doing nothing would result in $0 profit in either market conditions. a) Create a decision table, b) What is your recommendation if you would apply the Maximax criterion (Optimistic)? Follow the guidance from your textbook and create a table. c) What is your recommendation if you would apply the Maximin Criterion (Pessimistic)? Follow the guidance from your textbook and create a table. d) What is your recommendation if you would apply the Criterion of Realism (Hurwicz Criterion) with a coefficient of realism a =…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS

a. Which employee is assigned to job 17 [Click to select) b. Which employee is assigned to job 27 (Click to select) c. Which employee is assigned to job 37 (Click to select) d. What is the minimum cost to complete all three jobs? Minimum cost