Done in excel: In today

$$

s competitive marketplace, efficient supply chain management is crucial

for maintaining profitability and customer satisfaction. One useful tool in identifying

and prioritizing areas for improvement is the Pareto Analysis. By focusing on the

most significant issues, organizations can allocate their resources more effectively

and achieve better results.

In this problem, you will apply Pareto Analysis to a case involving a local grocery

store experiencing customer complaints regarding various aspects of its supply chain

operations over a six

$-$

month period.

Problem Statement: The grocery store has been receiving complaints across various

aspects such as product availability, delivery delays, wrong deliveries, and damaged

goods among others. The management is concerned about the impact of these issues

on customer satisfaction and the store

$$

s reputation. They are keen to understand

which areas they should prioritize to address the complaints and improve their

service level.

Tasks:

$($

$1$

$)$

$$Using the data provided in

$$

Problem

$1$

$\_$

Template

$$

$,$

$$conduct a simple Pareto

Analysis to categorize the complaints received over the last six months.

$($

$2$

$)$

$$Based on your analysis, identify the two categories of complaints that are the

most frequent. Calculate their cumulative percentage contribution to the total

number of complaints.Complaint Type # of complaints

All other

$7$

$1$

Checker

$5$

$9$

General

$5$

$8$

Service Level

$5$

$5$

Policy

$/$

Procedures

$4$

$0$

Price Marking

$4$

$5$

Product Quality

$8$

$7$

Product Request

$1$

$0$

$5$

Checkout Queue

$3$

$3$

Stock Condition

$1$

$7$

$0$