Supply Chain Analytics Report 2022

Supply Chain Analytics 1
Supply Chain Analytics
Student Name
Professor Name
Course Name
Date

Supply Chain Analytics 2
Table of Contents
Introduction....................................................................................................................................3
Task 2..............................................................................................................................................3
Task 3..............................................................................................................................................3
Complaint analysis.....................................................................................................................3
By complaint type.....................................................................................................................3
By product family.....................................................................................................................3
By customer..............................................................................................................................4
By CRS staff..............................................................................................................................4
Root causes..................................................................................................................................5
Task 4: Solution to problem..........................................................................................................6
Conclusion......................................................................................................................................8
References.......................................................................................................................................9

Supply Chain Analytics 3
Introduction
The report consists of three sections. The first section entails a calculation designed to
determine an order size that will minimize the inventory costs. The second section involves
analyses of the three top complaints by the complaint type, product family, customer, and CSR
staff. The part will also hypothesize the root causes of such claims. The last section gives the
recommended solutions for the problems.
Task 2
Considering the case provided;
The demand for the first six months is 600
The holding cost is $2 per unit per month
The ordering cost is $55 per order
The Optimum Order Quantity = √ 2 SD
H
=√ 2∗600∗55
2
=√ 33000
=181.65
The demand for the next six months is 900
The holding cost is $2 per unit per month
The ordering cost is $55 per order
The Optimum Order Quantity = √ 2 SD
H
=√ 2∗900∗55
2
=√ 49500
=222.48

Supply Chain Analytics 4
Task 3
Complaint analysis
By complaint type
Row Labels Count of Complaints
Delivery 233
Wrong Quantity 136
Lost in Transit 127
As revealed in the excerpt from tabular analysis above, the three top complaints include
delivery (233), wrong quantity (136) and cases of lost orders in transit (127). It should be noted
that some of these complaints are from customers, while others are from the CSR staff.
By product family
Product Family Count of complaints
PF12 67
PF11 58
PF4 57
As revealed in the excerpt from tabular analysis above, the three key product families
which registered many complaints include PF12, PF11 and PF4. Product family PF 12 registered
a total of 67 complaints, and the top complaints include the wrong product (22), delivery (15)
and wrong quantity (12). Product PF 11 registered 58 claims, and the top three complaints
include wrong quantity (18), delivery (13) and wrong product (10). Lastly, the PF4 family
experienced a total of 57 complaints, and the three top charges included delivery (16), lost in
transit (12) and wrong quantity (10).