All project reports must have a cover page containing your project title, your name, section, date and professor name. Project reports must be submitted as a single PDF through the Blackboard Assignment by its listed due date.

Create your project report individually (or in teams of two), as if you are working as a consultant to

WalMart. Present your project report using a structured format – under major section headers [Introduction, Data Analysis (Body) & Results and Conclusion] so that a non-technical person can follow & understand the outcome of the project but also providing the necessary mathematical data analysis – with backup calculations & graph to support your work. Your project report must be typed and contain the following report components [Outlined in I, II, III, IV ].

Project Submission Format Outline and Requirements :

1. 10% Introduction : This section generally should include a short description of the project undertaken, overview of the given sales data information, the objective of your project assignment and the methods used to model raw data into a realistic mathematical model in order to fulfill the project requirements.

1. 75% Data Analysis : This section includes addressing and answering the specifications and requirements listed below. Each model is to be supported by appropriate data plots, graphs, mathematical computations and explanations where needed showing all work.

Spikes in the data are outliers and major ones should normally be considered and removed from the data to clean and ensure a better model as part of your option to differentiate results.

Generate supporting Excel graphs (use scatter plots) to answer the following questions for the Dry Goods 2002-2003 data. The Dry Goods 2002-2003 data was provided in a separate Excel file. Provide proper labeling of the axes in the graphs when used in context to your analysis.

1. Identify spikes (outliers) in the data where extreme sales values occur and correlate these spikes with actual calendar dates in 2002 or 2003 and with events that may occur during these periods. Present your result in a table format as follows:

Week #

Calendar dates associated with week #

Special holiday or event

Spike Sales Value ($)

2. Modeling the data linearly –
   1. Generate a linear model for this data by choosing two points.
   2. Generate a least squares linear regression model for this data.
   3. How good is this regression model? Discuss how the model output compares to actual data and discuss the R2 value.

MATH 1220 (MANAGEMENT CALCULUS) – PROJECT 1 1

d. What are the marginal sales (derivative, i.e. rate of change) for this department using the linear model with two data points and the regression model? e. Compare the two models. Which do you feel is better?

f. Remove appropriate outliers as you deem necessary and rerun the linear regression model. What is the marginal sales and discuss improvements.

3. Modeling the data quadratically –

1. Generate a quadratic model for this data. Discuss how the model output compares to actual data and discuss the R2 value.
2. What are the marginal sales for this department using this model?
3. Calculate the model generated relative max/min value. Show backup analytical work.
4. Compare actual and model generated relative max/min value.
5. Remove outliers and rerun the quadratic least squares model. What is the marginal sales and discuss improvements.

1. 10% Conclusion : There should be a discussion of the results of a good model based on the R2 value for least squares models, marginal sales (rates of change of the sales models) and their meanings for the various models generated, along with discussion around the questions listed below.

4. Comparing models

1. 
   
   1. Based on all models run, which model do you feel best predicts future trends? Explain your rationale.
   2. Based on the model selected, what type of seasonal adjustments, if any, would be required to meet customer needs?

1. 
   

Answer rating: 100% (QA)

Title Sales Analysis and Modeling for Walmarts Dry Goods Department Name Your Name Section Section Number Date Current Date Professor Professors Name I Introduction In this project we will analyze the ... View the full answer