Create two regressions using each of these variables

Assignment Help Supply Chain Management

Reference no: EM133398851

Question: Using this dataset* (REVISED AS OF 24-APR)UK_Retail_data_REVISED.xlsxDownload UK_Retail_data_REVISED.xlsx perform the following: Create three pivot table that summarize (1) quantity per sku, (2) quantity per customer, and (3) average spend per customer Perform an ABC analysis on all SKUs and report the percentage breakdown of A/B/C items.

Perform a separate ABC analysis for the largest spend customer 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.

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.

Source-this is a modified version of this dataset.

Attachment:- UK Retail data REVISED.rar

Reference no: EM133398851

Questions Cloud

Discuss capital structure of the company : MN0491 Corporate Financial Management, Northumbria University - Evaluate and discuss the financial performance of the company over the period of analysis

Write a unix pipeline that reads the datastream on standard : Write a unix pipeline that reads the datastream on standard input and writes the last line that contains the string "cout" to standard output.

Explain the purpose of your visualization and the story : explain the purpose of your visualization and the story you are trying to tell You do not need to formally respond to other students' contributions

What is the file system type of the or tmp file system : Create 1 empty file in your home directory named "myEmptyFile". Show a long listing of the non-hidden files/directories in your home directory.

Create two regressions using each of these variables : What do the results tell you about the impact that each of these variables have on demand - choose an appropriate forecasting method. Report the next period

What is the difference between data modeling and logical : Your software engineering team is using the term "NoSQL". Explain the situation. Give an example of different views that are useful to different stakeholders

Determine the maximum bit error rate probability : Determine the maximum bit error rate probability (e.g. probability that one bit in a packet is received in error) that the physical link can have such that

Explain in detail about the design of the arithmetic circuit : Explain in detail about the design of the arithmetic circuit of a processor. Describe serial in serial out shift register with necessary details and diagram.

Analyse the relative strengths and weaknesses of each : Analyse the relative strengths and weaknesses of each of the six of Bounce's HR policies and procedures identified in question Document at least two strength

User Account

All Pages