Case Study: Tip Top Markets
Refer to the data and information provided on “Tip Top Markets Case” on pages 406 and 407 for this assignment and answer below questions.
For this report you need to submit a PDF file with the questions on the assignment template, your answers including tables, charts, graphs, and analysis of the data as well as an Excel file that includes the Pareto Diagram, Run Charts, and Cause and Effect Diagram.
For Your PDF report simply download the template on the page 3 of this assignment and complete it. Do not change fonts or formatting.
- Develop a check sheet for the customer complaints for 9 weeks of data provided in the case. Use below table and complete it.
For example for June 1st, Out of Orange Yogurt and Out of Maple Walnut Ice Cream fall under “Out-of-Stock” category hence 2 check marks are put in that box. Complete the rest accordingly.
| Date | Out-of-Stock | Customer
Unable to Find Product |
Store/Parking Lot Conditions | Checkout Line/Pricing Problems | Quality of Products | Other |
| June 1 | √√ | |||||
| June 8 | ||||||
| June 15 | ||||||
| June 22 | ||||||
| June 29 | ||||||
| July 6 | ||||||
| July 13 | ||||||
| July 20 | ||||||
| July 27 |
- Develop a Pareto Diagram in Excel for the 9 weeks collected data. See figure 9.2, page 392, and research Pareto chart online.
Here is a video that teaches how to draw a Pareto chart in Excel:
- Develop 6 Run Charts for each of the category complaints in Excel and draw a linear trend line for each one. See figure 9.11 and page 397.
- Develop a Cause and Effect diagram in Excel for Out-of-Stock category on your Pareto Diagram. Do your analysis based on 4M methodology (Man, Machine, Method, Material). For example causes because of Machine/Equipment might be: inadequate racking, defective refrigerators increasing material spoilage, etc. See figure 9.2 and page 396.
- Based on your analysis make at least 3 recommendations that will address customer complaints. Make sure your recommendations follow the priority of the complaints. To prioritize the complaints pay attention to the Pareto Chart (bigger issues need to be addressed first) and Run Charts (issues with an upward trend need to be prioritized)
- Develop a check sheet for the customer complaints for 9 weeks of data provided in the case. Use below table and complete it.
| Date | Out-of-Stock | Customer
Unable to Find Product |
Store/Parking Lot Conditions | Checkout Line/Pricing Problems | Quality of Products | Other |
| June 1 | √√ | |||||
| June 8 | ||||||
| June 15 | ||||||
| June 22 | ||||||
| June 29 | ||||||
| July 6 | ||||||
| July 13 | ||||||
| July 20 | ||||||
| July 27 |
- Develop a Pareto Diagram in Excel for the 9 weeks collected data. Add image of your Pareto chart here.
- Develop 6 Run Charts for each of the category complaints in Excel and draw a linear trend line for each one. Add images of your run charts here.
- Develop a Cause and Effect diagram in Excel for Out-of-Stock category on your Pareto Diagram.
- Based on your analysis make at least 5 recommendations that will address customer complaints.
TO GET THIS OR ANY OTHER ASSIGNMENT DONE FOR YOU FROM SCRATCH, PLACE A NEW ORDER HERE
