A 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 job.Employee AEmployee BEmployee CJob 1464549Job 2Job 3365537383951Solve this assignment problem in Excel to find the lowest cost solution and answer the following questions:a. Which employee is assigned to job 1?(Click to select)b. Which employee is assigned to job 2?(Click to select)c. Which employee is assigned to job 3?(Click to select)d. What is the minimum cost to complete all three jobs?Minimum cost< Prev2 of 5......Next >

Answered: a. Which employee is assigned to job 1?…

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

Consider the Following data below. FAMILY MONTHLY INCOME LIFE INSURANE A 10 20 B 12 30 C 15 50 D 23 100 E 35 200 F 12 40 G 13 80 H 28 150 I 45 300 J 18 70 If monthly income is $20, what would be the amount of Life insurance coverage? O a. $90.687 O b $85.672 O $95.432 O $95.732
Maximize p = 10x + 20y + 15z subject to x + 2y + z ≤ 40 2y − z ≥ 10 2x − y + z ≥ 20 x ≥ 0, y ≥ 0, z ≥ 0.
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)=
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.
Three methods can be used for producing heat sensors for high-temperature furnaces. Method A will have a fixed cost of $140,000 per year and a production cost of $62 per part. Method B will have a fixed cost of $210,000 per year and a production cost of $28 per part. Method C will require the purchase of equipment costing $500,000. It will have a life of five years and a 25% of first cost salvage value. The production cost will be $53 per part. At an interest rate of 10% per year, determine the breakeven annual production rate between the two lowest cost methods.
Which of the following types of mortgage loans is presumed to feature points or fees not excending 3%, a maximum term not to exceed 30 years, and no risky features (such as negative amortization, interest-only, or balloon loans)? A) A qualified mortgage B) A conventional mortgage C) A non-qualified mortgage D) A home equity line of credit (HELOC) mortgage
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
ABC Corporation has recently given out a nine-month contract to a construction subcontractor. At the end of the first month, it becomes obvious that the subcontractor is not reporting costs according to an appropriate WBS level. ABC Corporation asks the subcontractor to change its cost reporting procedures. The subcontractor states that this cannot be done without additional funding. This problem has occurred with other subcontractors as well. What can ABC Corporation do about this?
Private Insurance provides coverages that can be used to meet specific loss situations. For each of the following insurance situation, identify a private insurance coverage that would provide the desired protection and explain your recommendation; A. John, 32, single parent with 1 dependent child. He recently purchased a house worth PhP 5 million, where half of this amount is mortgaged loan (PagIBIG). He wants to be certain that he would be able to pay his loan in case of disability. B. Rey, 36, married with 3 dependents. His wife is a disabled person and is unable to work. As the sole breadwinner, he wants to be sure that his family would have funds in case of his premature death. C. Marian, 44, owns a trading shop. The premises are rented. The total amount value of goods in her shop amounts to PhP 7 million. She has no savings. She wants to be certain she will be able to run her business if her shop catches fire and other loss. D. Dominic, 15, a talented motor racer. However, his…
Consider a project with the following cash flows: year 1, 2$400; year 2, $200; year 3, $600; year 4, 2$900; year 5, $1000; year 6, $250; year 7, $230. Assume a discount rate of 15% per year.a. Find the project’s NPV if cash flows occur at the ends of the respective years.b. Find the project’s NPV if cash flows occur at the beginnings of the respective years.c. Find the project’s NPV if cash flows occur at the middles of the respective years.
A firm that plans to expand its product line must decide whether to build a small or a large facilityto produce the new products. If it builds a small facility and demand is low, the net present valueafter deducting for building costs will be $400,000. If demand is high, the firm can either maintainthe small facility or expand it. Expansion would have a net present value of $450,000, and maintaining the small facility would have a net present value of $50,000.If a large facility is built and demand is high, the estimated net present value is $800,000. If demandturns out to be low, the net present value will be – $10,000.The probability that demand will be high is estimated to be .60, and the probability of low demandis estimated to be .40.a. Analyze using a tree diagram.
Manny signs a variable lease. He pays $10/ square foot. His index is 2.His utilities will cost $350.If his index goes up to 2.5 next year, how much will Manny payin rent? $25/square foot $12.50/square foot $8/square foot $50/square foot |

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

a. Which employee is assigned to job 1? (Click to select) b. Which employee is assigned to job 2? (Click to select) c. Which employee is assigned to job 3? (Click to select) v d. What is the minimum cost to complete all three jobs?