Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Macroeconomics

Authors: Glenn Hubbard, Anthony Patrick O Brien

9th Edition

0138102494, 9780138102494

Students also viewed these Economics questions