Q$4\mathrm{.}1(15$ points$)$

The Elon Company manufactures parts for an aircraft company using three computerized numerical

controlled $($CNC$)$ turning centers.

The company wants to decide which machines are capable of producing a specific part with design

specifications of $0\mathrm{.}097$ inch $+-0\mathrm{.}015$ inch.

The suppliers machines have the following process parameters:

machine $1($process mean$=0\mathrm{.}095,$ sigma$=0\mathrm{.}004)$

machine $2($process mean$=0\mathrm{.}096,$ sigma$=0\mathrm{.}009)$

Determine which machine $($if any$)$ can produce the products within design specifications.

Q$4\mathrm{.}2(10$ points$)$

A team within the procurement department has undertaken an initiative to enhance the efficiency

of managing suppliers. The primary objective is to minimize operational costs associated with

supplier$-$related processes by reducing the fraction of suppliers with discrepancies or issues. The

team has developed a clear operational definition for a problematic supplier: a supplier is

considered problematic if it exhibits inconsistencies in pricing, delivers incorrect quantities, utilizes

incorrect coding, provides inaccurate address information, or has incorrect contact names.

To assess the impact of their efforts, the team has adopted a method of randomly selecting and

evaluating a sample of $100$ suppliers daily. If any of these randomly chosen suppliers are found to

have one or more issues, they are labeled as problematic. The team has consistently applied this

sampling methodology over the past $25$ days.

The data collected during the last $25$ days and already prepared for the assessment. $($see the excel

file$).$

Please construct the SPC control to evaluate the process $($Please note, the data is preprocessed.

Please build the chart$).$

What variation in the data does the p control chart discover?

Is the process in statistical control? What does this mean?

Is the process variation acceptable? What should be done next to the process of improving this

process?

Q$4\mathrm{.}1(15$ points$)$ coutrolled $($CNC$)$ thuing cemers. specifications oC $0\mathrm{.}097$ inch $+0\mathrm{.}015$ malh

The supliers machines have the following pesces permetien:

machime $1($process mean$-0\mathrm{.}095,$ sgma$-2004)$

machine $2($process mean$-0\mathrm{.}056,$ sgmas$-0\mathrm{.}009)$

Q$4\mathrm{.}2(16$ points$)$ sampling methodologer wer the past $25$ thes. filt$).$ Please buils the chact:

What variation in the tara does the $\backslash ($ p $\backslash )$ comitol chant atsoved? precess?