customers $->$

measurement $->$

You are starving. It is time to make the trek to the grocery story and buy food for tonight's

meal. Below, illustrate the process flow for doing just that from creating a list at home to

returning home. You must include at least $6($six$)$ steps.

For each process step $($in row $20)$ list all the following: supplier$($s$)$ in row $14,$ input$($s$)$ in row

$17,$ output$($s$)$ in row row $23,$ customer$($s$)$ in row $26,$ and ways to measure success in row $29$

$(2$pts$)$

Use the cells of Excel to imply process steps in row $20$: label each cell with the name of the

process step and keep a blank column between each step. insert $($draw$)$ an arrow between

steps to imply the direction of flow.

Part A

The following $200$ data points were recorded

$17\mathrm{.}475617\mathrm{.}97073$ The specification states that the maximum allowed is $25,$ and the minimum is $13$

$18\mathrm{.}8222318\mathrm{.}40818$ Calculate Cp and Cpk using excel formulas $($typing in literal answers is not sufficient$)$

$21\mathrm{.}9263418\mathrm{.}4756$

$17\mathrm{.}9707318\mathrm{.}82223$ Cp: Cpk:

$20\mathrm{.}5415219\mathrm{.}46783$

$20\mathrm{.}4999920\mathrm{.}49999$

$18\mathrm{.}4081820\mathrm{.}54152$

$19\mathrm{.}4678321\mathrm{.}92634$

$21\mathrm{.}321713\mathrm{.}4756$ Part B

$18\mathrm{.}6633618\mathrm{.}66336$

$20\mathrm{.}7052919\mathrm{.}02305$ The bus schedule advertises the trip from the beach to the Sawgrass Mall as $73$ minutes.

$17\mathrm{.}475620\mathrm{.}70529$ To help people plan, they say this trip will take $+/-10$ of the advertized duration.

$21\mathrm{.}8197120\mathrm{.}74884$ Currently, the average time is $77$ minutes with a standard deviation of $2$ minutes.

$19\mathrm{.}0230521\mathrm{.}3217$ The city requires a process capability ratio of at least $1\mathrm{.}33$ to be deemed "capable."

$20\mathrm{.}7488421\mathrm{.}56302$ Is the process capable? Is an adjustment needed?

$22\mathrm{.}6015621\mathrm{.}81971$

$20\mathrm{.}4756322\mathrm{.}10964$ Calculate and interpret the following:

$22\mathrm{.}1096422\mathrm{.}60156$

$17\mathrm{.}9970417\mathrm{.}7231$ Cp: Cpk:

$20\mathrm{.}6447617\mathrm{.}99704$

$23\mathrm{.}3870720\mathrm{.}30958$ Is the process capable $($yes$/$no$)?$

$20\mathrm{.}7500320\mathrm{.}41096$ Why?

$21\mathrm{.}0039520\mathrm{.}64476$

$20\mathrm{.}3095820\mathrm{.}75003$

$17\mathrm{.}723120\mathrm{.}8839$

$21\mathrm{.}7321321\mathrm{.}00395$ Is there an adjustment needed $($yes$/$no$)?$

$20\mathrm{.}883921\mathrm{.}73213$ Why?

$20\mathrm{.}4109623\mathrm{.}38707$

$18\mathrm{.}2967215\mathrm{.}40457$

$18\mathrm{.}627217\mathrm{.}4756$

$19\mathrm{.}185317\mathrm{.}87086$

$20\mathrm{.}4537318\mathrm{.}29672$

$17\mathrm{.}8708618\mathrm{.}6272$

$19\mathrm{.}9160619\mathrm{.}1853$

$21\mathrm{.}1849219\mathrm{.}7353$

$17\mathrm{.}475619\mathrm{.}95551$

$19\mathrm{.}735320\mathrm{.}45373$

$15\mathrm{.}4045721\mathrm{.}18492$

$21\mathrm{.}7334311\mathrm{.}92769$

$21\mathrm{.}7463117\mathrm{.}19958$

$22\mathrm{.}8160318\mathrm{.}90474$

$21\mathrm{.}2150819\mathrm{.}29917$

$21\mathrm{.}6074920\mathrm{.}50941$

$20\mathrm{.}5094121\mathrm{.}21508$

$23\mathrm{.}2991721\mathrm{.}60749$

$18\mathrm{.}9047421\mathrm{.}73343$

$13\mathrm{.}9276921\mathrm{.}74631$

$17\mathrm{.}1995822\mathrm{.}81603$

$21\mathrm{.}0448813\mathrm{.}59674$

$19\mathrm{.}0835615\mathrm{.}71785$

$20\mathrm{.}8314618\mathrm{.}40047$

$15\mathrm{.}7178519\mathrm{.}08356$

$19\mathrm{.}5282219\mathrm{.}35686$

$18\mathrm{.}4004719\mathrm{.}52822$

$19\mathrm{.}3568619\mathrm{.}94112$

$19\mathrm{.}9411220\mathrm{.}83146$

$24\mathrm{.}5097221\mathrm{.}04488$

$15\mathrm{.}5967424\mathrm{.}50972$

$21\mathrm{.}8167516\mathrm{.}23781$

$20\mathrm{.}7173317\mathrm{.}09537$

$17\mathrm{.}0953717\mathrm{.}4756$

$21\mathrm{.}7680118\mathrm{.}36035$

$17\mathrm{.}475618\mathrm{.}48863$

$16\mathrm{.}2378120\mathrm{.}71733$

$18\mathrm{.}4886321\mathrm{.}05628$

$22\mathrm{.}090121\mathrm{.}76801$

$18\mathrm{.}3603521\mathrm{.}81675$

$21\mathrm{.}0562822\mathrm{.}0901$

$20\mathrm{.}6412416\mathrm{.}91455$

$20\mathrm{.}8238419\mathrm{.}16011$

$23\mathrm{.}9710919\mathrm{.}84389$

$16\mathrm{.}9145520\mathrm{.}34281$

$21\mathrm{.}7253820\mathrm{.}64124$

$19\mathrm{.}8438920\mathrm{.}82384$

$21\mathrm{.}8259821\mathrm{.}72538$

$22\mathrm{.}1622821\mathrm{.}82598$

$20\mathrm{.}3428122\mathrm{.}16228$

$19\mathrm{.}1601123\mathrm{.}97109$

$20\mathrm{.}0371518\mathrm{.}684$

$19\mathrm{.}1263519\mathrm{.}02672$

$19\mathrm{.}7240419\mathrm{.}12635$

$20\mathrm{.}1002219\mathrm{.}48663$