Objective IV: a. [6] Use MS Excel to figure out sample size n and acceptance number c corresponding to the single acceptance sampling plan. Carry out this exercise in EXCEL. Copy-paste the tables from EXCEL to the WORD document file. Include the EXCEL sheet separately as a part of the .zip folder. b. [5] Construct an operating characteristic curve (OCC) based on n and c for the using lot proportion of defectives p={0, 0.01, , 0.3}. Just copy-paste the graph from EXCEL in your answer sheet with proper labelling. c. [2] Calculate the average outgoing quality (AOQ) value for p=0.05.

aliy Management-OP-EPGP-13 PDF-XChange Editor Help Quick Launch (Ctrl.) Q Company X is a manufacturer of AA batteries. Consider lifetimes (in hours) of AA batteries when put in constant use, i.e., keeping flashlight 'on' till the battery dies. Recently, with advancement in technology, other companies manufacturing AA batteries claim that the lifetime of AA battery is significantly greater than the ones manufactured by company X. This motivated company X to investigate several quality characteristics for AA batteries. The objectives of the investigation are as follows: I. Figuring out if indeed the lifetime of AA battery manufactured by company X is less than their friendly competitor, company Y, who is ready to help company X by sharing process data II. Identifying the action items to be carried out if indeed the lifetimes of the batteries manufactured by company X are significantly lesser than the ones manufactured by company Y III. Verifying whether the manufacturing process is in control and capable IV. Devising a single acceptance sampling plan before releasing any battery lot for sale to the market Following are the details with respect to the objectives. Objective I: The following data were obtained on AA battery lifetimes in hours: -W612.0pt X: 493.pt H720pt 631.0pt 18C ENG D OSD Shot on OnePlus By Kalpit Gupta 2021/12/05 10:09 UL 0.1 0.08 0.06 0.04 0.02 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 ---Measure Center LCL UCL Figure 1. 2. According to customer specifications, standard AA battery length should be between 49.0 mm and 50.5 mm. Assuming the lengths to be normally distributed, the average and the standard deviation of the lengths are 49.9 mm and 0.2 mm, respectively. Objective IV Before sending out any batch of batteries (typically of size 10000) to market, company X decides to carry out an acceptance sampling based on a single sampling plan. An internal decision is taken that acceptable quality level limit (AQL) should be 1% while lot tolerance percent defective (LTPD) is obtained as 50, from a market surrey. A producer's risk of 10% and a consumer's risk of 8% are considered logical for the plan. Shot on OnePlus 2021/12/05 10:12 By Kalpit GuptaBased on the case study, please do the following