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.

Question

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.

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 vary by subject and question complexity. Median response time is 34 minutes and may be longer for new subjects.

Related Operations Management Q&A

Find answers to questions asked by students like you.

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

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

Q: What is a group technology?

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

Q: Do you provide help with Management Information Systems?

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

Q: What is economic order quantity?

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

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

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