Using the attached excel spreadsheet and the information below please answer the four case questions at the very bottom. Include a separate Excel
document with all calculations and please make sure the case questions are answered in a word document in APA format.
Information for paper:
Rapido Burrito is a small, regional chain of quick service restaurants. Rather than wait in a cafeteria-style line, customers check boxes for their choice of
ingredients, sauce, and so on paper menus at their table. The food is prepared quickly and then delivered to the tables.
Lately, one of the store managers has been hearing customer complaints, such as: “The tortillas are too thin”; “The food is not hot”; “Every time I get a burrito,
it seems to be a different size”; and “I got the wrong ingredients on my burrito.” Many complaints were submitted through the corporate website.
The district manager was most concerned with the comments about the consistency of size. One of the staff designed a customer survey using the
questions below, based on a 5-point Likert scale (5=excellent, or strongly agree; 1= poor or strongly disagree) for the first 10 questions. The last two
questions were coded as a 1, 2, 3, or 4.
Customer Survey Questions:
Was the menu easy to read?
Was the order prepared correctly?
Was the food tasty?
Was the food served hot?
Were employees courteous and polite?
Was the restaurant clean?
In your opinion, did you receive a good value for the price you paid?
What was your level of satisfaction?
How likely are you to dine with us again?
How likely are you to recommend us to your friends/family?
How often do you eat at Rapido Burrito? First time, less than once/month, one to three times a month, weekly?
What was the main ingredient in your burrito: chicken, beef, pork, or beans?
They administered the questionnaire to 25 random customers. The restaurant also gathered data on the weights of 50 samples of 3 burritos (a total of 150).
Both the survey data and weight data are available on the Excel worksheet Rapido Burrito Case Data included in Week 1 of this course.
Case Questions:
What conclusions do you reach when you calculate descriiptive statistics for the answers to each of the survey questions in the database?
If you average the responses to the first seven questions by customer, how closely are those averages correlated to the satisfaction score? Include a scatter
chart in your analysis.
Analyze the data on burrito weights using descriiptive statistical measures such as the mean and standard deviation, and tools such as a frequency
distribution and a histogram. What do your results tell you about the consistency of the food servings?
What recommendations for decision making and improvement can you make to the store manager?
