DAD220 Project 2

.docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

DAD220

Subject

Industrial Engineering

Date

Dec 6, 2023

Type

docx

Pages

Uploaded by ChiefPheasant2716

DAD220: Project Two Southern New Hampshire University April 12, 2023

This report is intended to address the request for analysis (RFA) from the product manager. Analyze the number of returns by state : MYSQL Query - SELECT Customers.State, COUNT(*) AS Total_Returns FROM Orders INNER JOIN RMA ON Orders.OrderID = RMA.OrderID INNER JOIN Customers ON Customers.CustomerID = Orders.CustomerID GROUP BY STATE ORDER BY Total_Returns DESC LIMIT 20; The screenshot above shows the returns by the top 20 states. Massachusetts is the state with the most returns at 972, followed by Arkansas with 844, and Oregon with 840. This information

could be used for your department to further investigate the need for staffing estimates and supply ordering for the regions that these states fall into. However, it should be noted to take caution in using this data set as the sole source of evidence to make staffing or supply changes as this high-level view is only intended to steer further investigation. Other considerations should include which SKUs are being returned and the reason, as well as where they originated from. The potential for a faulty lot from one of the many supplier’s factories or warehouses should be tracked in order to quickly recognize patterns to initiate recalls to help retain and improve levels of customer satisfaction. Analyze the percentage of returns by product type : Return Percentage by state - MYSQL Query - SELECT Customers.State, (COUNT(*) * 100 / (SELECT COUNT(*) FROM Orders INNER JOIN RMA ON Orders.OrderID= RMA.OrderID)) AS Return_Percent FROM Orders INNER JOIN RMA ON Orders.OrderID = RMA.OrderID INNER JOIN Customers ON Customers.CustomerID = Orders.CustomerID GROUP BY STATE ORDER BY Return_Percent DESC LIMIT 20;

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help