Perform separate abc analysis for the largest spend customer

Assignment Help Database Management System

Reference no: EM133393482

Question 1: Create three pivot table that summarize (1) quantity per sku, (2) quantity per customer, and (3) average spend per customer

Question 2: Perform an ABC analysis on all SKUs and report the percentage breakdown of A/B/C items.

Question 3: Perform a separate ABC analysis for the largest spend customer

Question 4: Using month, and week, create two regressions using each of these variables as IVs and quantity sold as the DV. What do the results tell you about the impact that each of these variables have on demand.

Question 5: For customer 18270, plot the demand overtime (i.e. chronologically), and choose an appropriate forecasting method. Report the next period forecast, and the error measures, along with the smoothing constant(s), as appropriate.

Reference no: EM133393482

Questions Cloud

What are the monomer units required to synthesize : What are the monomer units required to synthesize a polysaccharide? a protein? a nucleic acid? a triglyceride? Do such reactions typically require energy input?

Ways of organizing an argument : Identify other positions-acknowledging other positions, refuting other positions, and ways of organizing an argument

What are the general facts of prokaryotic cells : What are the general facts of prokaryotic cells; provide as much information as possible. Try itemizing and commenting on the facts provided

Write the equation for the world population : Write the equation for the world population, P, as a function of the years since 1800. (keep four decimal places): Identify the slope of the linear model

Perform separate abc analysis for the largest spend customer : Perform an ABC analysis on all SKUs and report the percentage breakdown of A/B/C items and Perform a separate ABC analysis for the largest spend customer

What does a type toke ratio measure : List 3 activites you could use when obtaining a language sample What does a Type Toke Ratio measure? What is a good number of utterances to obtain from

Compare and contrast the procaryotic replication fork : Compare and contrast the procaryotic replication fork with the eucaryotic replication fork. What are the similarities and differences between the two?

Create a pivot table expressing the total sales per store : Create a pivot table expressing the total sales per store per year and Plot the data, provide the plot, and comment on what you

Are you using graphics that are pertinent to the information : Are you using graphics that are pertinent to the information you are presenting? Are those graphics enhancing the readability and useability of the poster

User Account

All Pages