A plumbing repair company has 3 employees and must choose which of 3 jobs to assign each to (each employee is assigned to exactly one job and each job must have someone assigned). Each employee can perform each job, but the cost to perform any given job can vary. The following table shows the cost for each employee to perform each job.     Employee A Employee B Employee C Job 1   48     45     44   Job 2   43     35     45   Job 3   51     51     50       Solve this assignment problem in Excel to find the lowest cost solution and answer the following questions:   Which employee is assigned to job 1?     (Click to select)   Employee A   Employee B   Employee C  Which employee is assigned to job 2?     (Click to select)   Employee A   Employee B   Employee C  Which employee is assigned to job 3?     (Click to select)   Employee A   Employee B   Employee C  What is the minimum cost to complete all three jobs?

Question

A plumbing repair company has 3 employees and must choose which of 3 jobs to assign each to (each employee is assigned to exactly one job and each job must have someone assigned). Each employee can perform each job, but the cost to perform any given job can vary. The following table shows the cost for each employee to perform each job.

 

  Employee A Employee B Employee C
Job 1   48     45     44  
Job 2   43     35     45  
Job 3   51     51     50  
 

 

Solve this assignment problem in Excel to find the lowest cost solution and answer the following questions:

 

  1. Which employee is assigned to job 1?

 

  (Click to select)   Employee A   Employee B   Employee C 

  1. Which employee is assigned to job 2?

 

  (Click to select)   Employee A   Employee B   Employee C 

  1. Which employee is assigned to job 3?

 

  (Click to select)   Employee A   Employee B   Employee C 

  1. What is the minimum cost to complete all three jobs?

 

 

 

Expert Answer

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.
Tagged in
Business
Operations Management

Other

Related Operations Management Q&A

Find answers to questions asked by students like you.

Q: 40 & 42

A: Note: First question was answered. Kindly post another question seperatelyDetermine the option that ...

Q: Case Study: Managing Employee Benefits: Strategic Benefits Planning at Makers Craft Makers Crafts...

A: Part AMakers crafts is a leader in the crafts business. Easy Crafts, a new company of this field giv...

Q: The operations manager of a mail order house purchases double (D) and twin (T) beds for resale. Each...

A: The LP modelThe decision variables are the number of double beds (D) and twin beds (T).The constrain...

Q: What industry forces might cause a propitious niche to appear or disappear?

A: 1)Propitious niche of interest will disappear if the external setting and consequently the trade cha...

Q: How do I explain 'Observation' in a essay?

A: IntroductionObservation is very important while writing an essay. Observation is very important not ...

Q: What does adverse impact mean? and how might it apply to hospitality companies?

A: With respect to the decisions on business employment, an adverse impact refers to the inconsistency ...

Q: Explain what is meant by the total cost approach to logistics.

A: Total cost approach to logistics:It is the kind of approach, which acts as a key to managing the fun...

Q: which forms of marketing research would be best in gathering consumer information relating to the pr...

A: Market research is very important to gather the information related to the customer’s choice their f...

Q: What are the steps ( it is 3 part question ) the second part is the multi factor productivity ? And...

A: Given information: Last yearNowUnits produced15001500Labour(hours)300275Resin(Pounds)6046Capatial in...

Q: George Johnson recently inherited a large sum of money;he wants to use a portion of this money to se...

A: (a) In the linear program the general mathematical model and the linear objective function set of li...

Q: How did European/Euro-American bias influenced early scientific measurements of various racial group...

A: In distinction,a pair of the four outcomes were according to a bunch dominance in society perspectiv...

Q: When should someone from outside a company be hired to manage the company or one of its business uni...

A: The policy of promotion from within:It is the policy of the firm stating that the promotion opportun...

Q: Creative sports design (CSD) manufactures a standard size racket and an over sized racket. The firm'...

A: Let us consider the 2 week production period together to build our model. Let us assume SS be the nu...

Q: 52 & 53

A: Note: Answered the first question. Kindly post another question separatelyDetermine the option that ...

Q: Which of the five different channel arrangements do you feel is the most complex,  and why?

A: The channel arrangement in which not a single player is controlling all the decisions but a joint de...

Q: Suppose that you are using a p chart to monitor the percentage of times that you fail to get phone n...

A: Given information:Total samples (k)                                                          = 30Sam...

Q: Daily high temperatures in st. Louis for the last week were as follows: 33,33,38,36,43,23,28(yesterd...

A: Given information:Temperatures in last week is 33,33,38,36,43,23,28 

Q: Think about the highly publicized safety recall at General Motors (GM) for defective ignition system...

A: With respect to the latest safety problem with GM’s (General Motors) defective ignition system, it b...

Q: What systems or processes should public health agencies utilize to ensure communication and accounta...

A: Establishing effective communication between the governing board and leaders is very important. In p...

Q: What is the systems approach to problem solving? How is this concept applicable to logistics.

A: Systems ApproachSystems approach to problem solving involves modelling of all factors in a particula...

Q: What is a business reseach methods

A: Business research methods are the techniques used by management to collect, analyse and disseminate ...

Q: Apex Brothers builds birdhouses for its customers. The average birdhouse is priced at $30. Labor cos...

A: Step1: Calculating the value of labour productivity. We have,Labour productivity is the ratio of out...

Q: The Terraco Motor Company has produced a lightweight, all-terrain vehicle code-named “J99 Terra” for...

A: We model the problem by using the following decision variables:20 variables to represent the number ...

Q: Many organizations establish project management office (PMO) as an integral part of their organizati...

A: Requirement for PMOLarge software development projects especially where the product is going to be u...

Q: What is a real life example of a business that uses a bottom-up operational perspective?

A: Bottom-up operational perspective:The bottom-up operations perspective follows a strategy formed by ...

Q: Answer the following questions related to value engineering:   a. What is value engineering?   b. Wh...

A: Hi there, thanks for the question, as per our honor code we are authorized to solve only first three...

Q: Could you please explain to me the pyramid of Top manager, middle manager, First-line manager, Te...

A: Top-level Managers:Top-level managers are also called senior management or executives. These individ...

Q: ProHaul specializes in trans-American shipments for businesses through the delivery of containers. ...

A: Step1: Calculating the value of break-even sales for the company. We have,Break-Even Sales = Fixed C...

Q: Give an example of how a logistics system can be effective but not efficient.

A: Logistics:Logistics is a system which contains a network of people, information, resources, and orga...

Q: One

A: Determine the early start of Activity C:It is given that the early start of A is 6 and B is 5. Hence...

Q: Ethics vs morality

A: Ethics:Ethics is said to be the discipline of morals, which can be the rules and regulations that wo...

Q: Is Google creating synergy by diversifying into many products/services? If so, where is the synergy?

A: Google is the USA based tech giant who special deals in internet-related services and products. Inte...

Q: There are 9 competitive priorities for success in the marketplace. Why would a company not necessari...

A: Competitive priorities:It includes the dimension of the operations, which would be controlled by the...

Q: Charles Lackey operates a bakery in Idaho​ Falls, Idaho. Because of its excellent product and excell...

A: Multi-factor productivityMulti-factor productivity = Total Output / Total Input= Total output / (Lab...

Q: What skills should a person have for managing a business unit following a differentiation strategy? ...

A: Differentiation strategy:Differentiation strategy is the strategy followed by the firm to differenti...

Q: Muir Manufacturing produces two popular grades of commercial carpeting among its many other products...

A: Given information:Each roll of grade X carpet uses synthetic fiber is=50unitsProduction time of synt...

Q: Monitoring and controlling processes on a project focused on measuring progress toward project objec...

A: The following tools may be used to monitor the project:use of PERT / CPM to plan the schedule and re...

Q: How does Control differ from Organizing?

A: Organizing:Organizing in management is the implementation of action by the optimum utilization of re...

Q: The Pew Research Center Internet Project conducted a survey of 857 Internet users. This survey provi...

A: a)Determine the confidence interval:Here, 1.96 is the Z value (table of z-scores) for 95% confidence...

Q: 7.2 If suppliers were to be rated on the following basis, what would be the ranking of the two suppl...

A: Determine the ranking:

Q: Myra is a project manager who is evaluating Rob's Rubbish Removal Service in the Twin Cities. They h...

A: This problem will be solved using the multiplication rule of probability for joint events as well as...

Q: For fixed order quantity inventory system, which of the following costs is increased when order size...

A: Both (b) and (c)(b)ordering cost(c)start-up quality cost

Q: I need help with question 13.8, chapter 13, question 8

A: Given information:Monthly demand (d)                           = 27,000 jarsAnnual demand (D)       ...

Q: What are the objectives of finance? How can these objectives be met?

A: Determine the objectives of finance:Determining the uses of funds and the sources is the responsibil...

Q: What is economic production quantity?

A: Economic production quantity (EPQ):EPQ can be termed as the quantity of a product that is required t...

Q: How is planning and conrol linked?

A: Planning:Planning is the initial step in establishing an objective or accomplishing it. Planning is ...

Q: John's House of Pancakes uses a weighted moving average method to forecast pancake sales.  It assign...

A: Weighted moving average:In weighted moving average equal weights are assigned to all periods in the ...

Q: Managers should not focus on the current stock value because doing so will lead to an overemphasis o...

A: The statement is false.Explanation: Stock price fundamentally is based on the all the expected cash ...

Q: The Reliance Manufacturing Company produces an aircraft part. The company can produce the part entir...

A: Information provided:The following information is necessary in order to determine the total daily ou...

Q: Referring to Woodward’s research on manufacturing technology and structure, how would you categorize...

A: The effective research on the relationship between manufacturing technology and the structure of an ...