Question: Question 1 Aini is a Quality Engineer in ABC plastic injection company. She is doing a quality inspection on a lot of 60 plastic covers

Question 1 Aini is a Quality Engineer in ABC

Question 1 Aini is a Quality Engineer in ABC plastic injection company. She is doing a quality inspection on a lot of 60 plastic covers and reported the rejection percentage as x'n. The plastic covers are rejected due to 5 type of defect modes, which are sink mark, warping, flash etc. a. Complete the inspection table (refer Appendix 1) with 60 plastic covers details, such as series number, pass or fail injection, if fail, list down the defect mode. Identify the rejection, 2%, and use EXCEL to draw a pareto chart to represent the type of defect modes and draw conclusion (7 marks) b. Refer to part (a), use EXCEL to calculate the probability that a randomly selected 25 plastic covers in a lot of 60), will have the following: (0) exact two are goods (no defect) (ii exact two are sink marks (iii) at least 10 rejects Compare the answers with manual calculation and draw conclusions. Draw a graph to illustrate the probability distribution of the rejects. List down all the assumptions/values and methods used for the calculation. Appendix 1 (complete the table) Defect mode Serles number 1 Table 1 Pass/Fall Inspection Pass Pass 2 3 Pass - 4 Fail Sink mark 5 Fail Sink mark Warping 6 Fail 7 Pass 8 Fail Flash 9 Pass 10 Pass 11 Fail Sink mark Pass 12 13 Fail Warping Flash 14 Fail 15 Pass 16 Pass Fail Flash 17 18 19 Fail Fail Flash 2 20 Pass 21 Fail 2 ? 22 Pass - 23 Pass - 24 Pass - 25 Fail 7 26 27 28 29 30 31 32 33 34 35 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 Question 1 Aini is a Quality Engineer in ABC plastic injection company. She is doing a quality inspection on a lot of 60 plastic covers and reported the rejection percentage as x'n. The plastic covers are rejected due to 5 type of defect modes, which are sink mark, warping, flash etc. a. Complete the inspection table (refer Appendix 1) with 60 plastic covers details, such as series number, pass or fail injection, if fail, list down the defect mode. Identify the rejection, 2%, and use EXCEL to draw a pareto chart to represent the type of defect modes and draw conclusion (7 marks) b. Refer to part (a), use EXCEL to calculate the probability that a randomly selected 25 plastic covers in a lot of 60), will have the following: (0) exact two are goods (no defect) (ii exact two are sink marks (iii) at least 10 rejects Compare the answers with manual calculation and draw conclusions. Draw a graph to illustrate the probability distribution of the rejects. List down all the assumptions/values and methods used for the calculation. Appendix 1 (complete the table) Defect mode Serles number 1 Table 1 Pass/Fall Inspection Pass Pass 2 3 Pass - 4 Fail Sink mark 5 Fail Sink mark Warping 6 Fail 7 Pass 8 Fail Flash 9 Pass 10 Pass 11 Fail Sink mark Pass 12 13 Fail Warping Flash 14 Fail 15 Pass 16 Pass Fail Flash 17 18 19 Fail Fail Flash 2 20 Pass 21 Fail 2 ? 22 Pass - 23 Pass - 24 Pass - 25 Fail 7 26 27 28 29 30 31 32 33 34 35 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

hi can i get this question answered on excel less than 24 hours please. thanks Question 1 Aini is a Quality Engineer in ABC plastic injection company. She is doing a quality inspection on a lot of 60...

Luis is a Quality Engineer in Z plastic injection company. He is doing a quality inspection on a lot of 60 plastic covers and reported the rejection percentage as %. The plastic covers are rejected...

Final Paper Instructions/Guidelines: The final paper must be a minimum of 5 pages and a maximum of 7 pages in APA format. You can find APA guidelines in the Week Six folder under final paper tips....

CASE STUDY When our old cost system was designed and implemented, it was state-of-that-art. But it no longer provided us with accurate numbers. The reported numbers were too aggregated to provide us...

Please answer the following questions: Alyeska Services Company, a division of a major oil company, provides various services to the operators of the North Slope oil field in Alaska. Data concerning...

3 COLLEGE ALGEBRA - TRIGONOMETRY Business and Finance (MAT115) This course will start with a review of basic algebra (factoring, solving linear equations, and equalities, etc.) and proceed to a study...

Conducting successful international sport business requires sound and ethical decision making. Leading sport businesses realize that managers face many different situations that may require them to...

Please answer all of the following questions. Chapter 4 questions Question 1 The Accounting Cycle - How do the different steps affect the financial statements? What is the effect on the financial...

\ This case was developed solely for the purpose of classroom discussion. Some details of the case have been disguised. This case is not intended to serve as endorsements, sources of academic or...

A 1500-kg rocket is to be launched with an initial upward speed of 50.0 m/s. In order to assist its engines, the engineers will start it from rest on a ramp that rises 53° above the horizontal...

Under the liquidity preference theory, if inflation is expected to be falling over the next few years, long-term interest rates will be higher than short-term rates. True/false/uncertain? Why?

1 5 . In March, Adrian Saylor sold government bonds owned exclusively by him and with $ 6 , 4 5 0 of the proceeds opened a savings account in a bank in the name of " Mr . or Mrs . Adrian M . Saylor."...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...