The Reliance Manufacturing Company produces an aircraft part. The company can produce the part entirely at a flexible work center with multiple computerized machines. The company has four work centers, all of which are different because they were purchased at different times. Each work center has a single operator; however, the company’s operators have different skill levels, resulting in different levels of daily output and product quality. The following tables show the average daily output and average number of defects per day for each of the company’s five operators who are capable of producing the aircraft part:Average Daily Output per MachineOperatorABCD118202117219152218320201719424211623522192121 Average Number of Defects Daily per MachineOperatorABCD10.30.90.60.420.80.51.10.731.11.30.60.841.20.80.60.951.00.91.01.0The company wants to determine which operator to assign to each machine to maximize daily output and keep the percentage of defects to less than 4 percent. Formulate and solve this problem by using Excel.

Question
Asked Apr 3, 2019
366 views

The Reliance Manufacturing Company produces an aircraft part. The company can produce the part entirely at a flexible work center with multiple computerized machines. The company has four work centers, all of which are different because they were purchased at different times. Each work center has a single operator; however, the company’s operators have different skill levels, resulting in different levels of daily output and product quality. The following tables show the average daily output and average number of defects per day for each of the company’s five operators who are capable of producing the aircraft part:

Average Daily Output per Machine

Operator A B C D
1 18 20 21 17
2 19 15 22 18
3 20 20 17 19
4 24 21 16 23
5 22 19 21 21

 

Average Number of Defects Daily per Machine

Operator A B C D
1 0.3 0.9 0.6 0.4
2 0.8 0.5 1.1 0.7
3 1.1 1.3 0.6 0.8
4 1.2 0.8 0.6 0.9
5 1.0 0.9 1.0 1.0

The company wants to determine which operator to assign to each machine to maximize daily output and keep the percentage of defects to less than 4 percent. Formulate and solve this problem by using Excel.

check_circle

Expert Answer

Step 1

The cells should be assinged with the following values and formulae in order to determine the final value:

fullscreen
Step 2

The following image shows the solver parameter that must be used to solve the problem:

fullscreen
Step 3

Final solution:

once the solver parameter is added. Then give solve to get the solution. The following image p...

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.

Related Operations Management Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

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...

question_answer

Q: Miguel has a product with an annual holding cost percentage of 20%, an ordering cost of $110 per ord...

A: The following table shows that calculation of optimal order quantity and total cost:

question_answer

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...

question_answer

Q: What kind of white-collar crime involves billing for health care services that have not been perform...

A: White collar crimes: are also known as corporate crimes. These involve criminal activities which are...

question_answer

Q: What is a group technology?

A: Step1:Group technology is the approach to manufacturing in which similar parts are identified and gr...

question_answer

Q: Do you provide help with Management Information Systems?

A: Step1: Management Information System:A management information system is a computerized database of f...

question_answer

Q: What is economic order quantity?

A: Define economic order quantity:Economic order quantity is the method that helps to determine the bes...

question_answer

Q: What is the relevance of the resource-based view of the firm to strategic management in a global env...

A: The relevance of the research-based view of the firm to strategic management in a global environment...

question_answer

Q: Explain how the seven differences between goods and services would be applied to a major airline ser...

A: Introduction- Goods refer to any physical quantity which can be touched whereas the services are any...