The Drive Thru Restaurant

You are asked to analyze the Customer Complaints at Drive Thru Restaurants. The data is attached in spread sheet. The data provides the # of Complaints by day by type.

You are going to analyze this data using basic quality tools to begin to understand what is going on, what we should try to correct first, and if there are any relationships between the types of complaints.

You are asked to:

1. Develop and provide a Pareto Chart to show in order the # of complaints by type. The X axis should be the categories and the Y axis should be the Total # of Complaints for each category. Which category would you try to address / correct first?

2. Develop and provide a Run Chart / Time Series Chart showing a separate line for each complaint category. The X axis should be the Days and the Y axis should be the # of complaints. Do any of the categories show a major "shift" indicating some type of underlying change during this 30 day period?

3. Develop and provide a Cause & Effect Diagram that identifies potential causes for food to be undercooked.

Day	Long Line	Under Cooked	Over Cooked	Wrong Order
Day 01	3	6	6	33
Day 02	8	9	10	38
Day 03	16	13	5	43
Day 04	15	15	6	45
Day 05	11	11	14	40
Day 06	13	11	13	41
Day 07	3	5	13	37
Day 08	10	10	20	38
Day 09	12	12	12	39
Day 10	15	14	12	42
Day 11	6	9	7	36
Day 12	10	9	8	36
Day 13	6	8	3	37
Day 14	14	14	6	45
Day 15	10	10	16	38
Day 16	11	11	16	40
Day 17	7	7	8	37
Day 18	15	13	7	45
Day 19	7	10	13	39
Day 20	12	12	7	42
Day 21	13	12	48	41
Day 22	7	8	54	36
Day 23	16	14	50	46
Day 24	16	15	45	48
Day 25	6	8	44	37
Day 26	12	13	43	38
Day 27	15	17	45	43
Day 28	14	16	45	43
Day 29	20	17	42	50
Day 30	2	5	53	31