Question: Please use any data set you have available to you. I only want to learn how to solve these questions on Excel. Thank you in
Please use any data set you have available to you. I only want to learn how to solve these questions on Excel.
Thank you in advance.
You have been assigned as the quality manager of a chain of burrito restaurants in San Diego. You are new to the job, so as your initial assignment, you will create run charts, X-bar, and R-charts for critical quality metrics of three different burrito chains in San Diego. Complete the following:
- Sort the dataset and identify three burrito restaurant chains that have more than 10 locations.
- Create run charts and control charts for burrito length, circumference, volume, and overall customer rating scores. Briefly describe key observations and "take-aways" from these charts.
- After creating these charts, consider if these are the optimal dimensions to be used for controlling quality. If they are, describe how you might control them as quality manager.
- Identify one additional quality metric you could employ to manage overall burrito quality in your restaurant chain. Briefly summarize your identified metric and provide an example in the form of a run chart and control chart.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
