SCM $301$ Module $3$ Activity

Complete the following case before submitting answers on Canvas.

The operations manager at Jiffy Pie, a company that specializes in manufacturing frozen chicken pot

pies, is concerned about the increased number of customer complaints in recent months. He called

you, the newly assigned QA manager, into his office to charge you with the task of identifying where

to start in resolving this problem. He handed you a single piece of paper with the defect data below

that he received from the VP of customer service and gave you an urgent due date to respond.

$1.$ Create a Pareto chart including axis labels.

$2.$ What percent of all defects does the biggest defect represent?

$3.$ Jiffy Pie uses SQC for the weight of vegetables added to each pie. Each hour they sample $6$ pies

from the production line to test for the weight of vegetables $($in grams$).$ Copy and paste the table

below into EXCEL to determine average weight, average range, and control limits for xbar and R

charts using tabular values $($std deviation not known$).$ Sketch the control charts and plot the points.

Be sure to copy the entire table, which continues onto the next page.

Sample Ave.

Wt

Smallest Largest

$149\mathrm{.}648\mathrm{.}750\mathrm{.}7$

$250\mathrm{.}249\mathrm{.}151\mathrm{.}2$

$350\mathrm{.}649\mathrm{.}651\mathrm{.}4$

$450\mathrm{.}850\mathrm{.}251\mathrm{.}8$

$549\mathrm{.}949\mathrm{.}252\mathrm{.}3$

$650\mathrm{.}348\mathrm{.}651\mathrm{.}7$

$748\mathrm{.}646\mathrm{.}250\mathrm{.}4$

$849\mathrm{.}046\mathrm{.}450\mathrm{.}0$

$949\mathrm{.}046\mathrm{.}050\mathrm{.}6$

$1049\mathrm{.}848\mathrm{.}250\mathrm{.}8$

$1150\mathrm{.}349\mathrm{.}252\mathrm{.}7$

$1251\mathrm{.}450\mathrm{.}055\mathrm{.}3$

$1351\mathrm{.}649\mathrm{.}254\mathrm{.}7$

$1451\mathrm{.}850\mathrm{.}055\mathrm{.}6$

$1551\mathrm{.}048\mathrm{.}653\mathrm{.}2$

$1650\mathrm{.}549\mathrm{.}452\mathrm{.}4$

$1749\mathrm{.}246\mathrm{.}150\mathrm{.}7$

missing veggies missing chicken bad taste missing chicken bad taste

poor pkg seal spilled contents bad taste missing chicken poor pkg seal

poor pkg seal missing chicken missing chicken bad taste spilled contents

bad taste missing veggies missing chicken poor pkg seal bad taste

bad taste spilled contents missing chicken missing veggies bad taste

missing veggies missing veggies missing veggies poor pkg seal missing veggies

bad taste bad taste poor pkg seal missing veggies bad taste

missing veggies poor pkg seal missing veggies poor pkg seal missing chicken

spilled contents poor pkg seal poor pkg seal poor pkg seal spilled contents

poor pkg seal bad taste poor pkg seal bad taste poor pkg seal