Answered step by step
Verified Expert Solution
Question
1 Approved Answer
a. What is driving the sales return decrease? b. Are there unusual patterns in the northwest region sales returns for certain product lines? C. Create
a. What is driving the sales return decrease? b. Are there unusual patterns in the northwest region sales returns for certain product lines? C. Create a trend analysis showing returns by date for each product line for the current year compared to the prior year. d. Filter data to isolate the northwest region sales returns and examine total sales returns, average sales returns, and sales return quantity. e. Create an optimization model to identify the most appropriate number of sales returns given the constraint of sales and quantity manufactured. f. Calculate the standard deviation of sales and compare to the standard deviation of employee expenses for the period. g. Calculate the overall spending by the company in customer services to determine if sales returns are related to manufacturing quality.Objective Initial Question Sub-questions Why did Are there sales anomalies in returns sales returns decrease for any from prior specific year? product the company sells? Are there identifiable trends in sales returns for any specific product?Possible Measures Create a scatterplot comparing quantity returned to sales price for items to identify anomalies in returns. Create a scatterplot comparing sales dollars to sales returns for items to identify anomalies in returns. Why is there a large decrease in sales returns in the northwest region? What factors are driving the decrease in sales returns in the northwest region
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started