This is a managing operation question. Please Do and show working in Excel. Must be in Excel.

Suppose that 15 components are sampled (n=15) from a very large lot of components that have just been received. Assume that management decides to accept the lot only if no more than two nonconforming items are found in the sample; that is, c=2. Although we do not have the actual percentage of nonconforming components in the lot, let us assume that this value is 5%. What is the probability that the lot will be accepted using this particular sampling plan? What happens if c=3 ? b). Use the information above and develop the OC curve for n=15,c=2; and n=15,c=2. If AQL is 3% and LTPD is 15%, what will be the producer and consumer risks for the two sampling plans (n=15,c=2 ) and (n=15,c=2 ) to be appropriate