Reference no: EM133048420

Central University Food Service Analysis

A large Canadian University Food service provider was informed by the University administrator that there had been a number of complaints regarding the food. The food service provider decided to administer a survey with each lunch and dinner meal served from Jan. 6^th until Jan 24th 2021. The cafeteria serves students that both live in residence and pay annually for meals, as well as day students who pay cash, and faculty and staff.  Customers were asked to comment on the meal quality by filling out a survey card. Comment cards were given out to customers Monday - Friday. At the end of each day the comment cards were emptied from the boxes and information was recorded.  At the end of the survey period, all cards went into a draw for prizes such as I PADS and meal certificates. The recorded data is in the chart below. 

Compile a report for Food Service Director Maxine Thomas summarizing the results that were received.   

Upload one EXCEL document to present the following information: 

1. Using EXCEL, complete a Pareto Table containing the number of each complaint, the percentage and cumulative percentage. Use formulas for calculations. Also create a Graph for the total number of complaints from each category including the cumulative percent line. Ensure that your tables and graphs are correctly labelled as well as both axes. Ensure they are properly formatted.
2. For each of the top two complaints on your Pareto analysis, complete a run chart showing one line for lunch and one line for dinner.  A run chart will have the date on the X axis and the number of daily defects on the Y axis. In summary, a chart for each of the top 2 complaints (2 charts required).
3. Insert a text box with your top two recommendations on how to reduce the complaints and improve customer satisfaction at Central University Food Services. Use a maximum of one paragraph each. Consider what you have learned in our unit on Quality.