Reference no: EM131011689
This is the entire question. I need have this done by this evenning. Please and Thank you. The link below provides the data on two different spread sheets. It has to be done on excel. https://faculty.uml.edu/mstick/92.122/material/Walmart dry goods weekly sales.htm
Project 1: The data used is from the Methuen Walmart store infiscal 2002 - 2003 and fiscal 2003 - 2004. Walmart's fiscal year starts with the first week of February, so week 1 in 2002 is the first week in February and week 52 (or week 53 based on roundoff) occurs during the last week of January in 2003.
Questions: 1. Can you identify holiday periods or special events that cause the spikes in the data?
2. What holiday results in the maximum sales for this department?
3. Generate several linear models for this data and discuss the rational behind the model that you believe best predicts future results.
a. For each linear model, discuss the meaning of the slope and y intercept.
b. Using your most preferred linear model, predict sales for the next four weeks. Provide backup computation.
4. Based on your favorite linear model selected, compute the percent rate of increase (y2 - y1)/ y1 for the next four weeks.
|
Time value of money-relationship in discounting-compounding
: What is the relationship between discounting and compounding? What is the relationship between the present-value factor and the annuity present-value factor? What is an annuity due? How does this differ from an ordinary annuity? What is the present v..
|
|
Does the form contain information on power of attorney
: Does the form contain information on power of attorney? Does the form contain information on the living will? Should extraordinary care continue, or are comfort measure only the best option
|
|
Examine an art piece of futurism in its content and form
: Think about the idea of success and failure: How doesAntigone examine what determines failure and success. What about Marx? Can one control one's "fate", if so, to what extent, if not, why?
|
|
Investments in two funds
: Linda invests her money in a portfolio that consists of 70% Fidelity 500 Index Fund and 30% Fidelity Diversi?ed International Fund.
|
|
Discuss the meaning of the slope and y intercept
: For each linear model, discuss the meaning of the slope and y intercept. Using your most preferred linear model, predict sales for the next four weeks. Provide backup computation.
|
|
Calculate the NPV of the project
: Sanders Enterprises, Inc., has been considering the purchase of a new manufacturing facility for $288,000. The facility is to be fully depreciated on a straight-line basis over seven years. It is expected to have no resale value after the seven years..
|
|
How do flotation costs affect the cost of capital
: How do flotation costs affect the cost of capital? Are these costs about the same for each of the three capital components? How do they change as the firm raises larger and larger amounts of capital, and how do flotation costs affect the way a compan..
|
|
Differences between criminologists and criminalists
: Explain the differences between criminologists and criminalists and their respective areas of study. How are the criminologists and criminalists used in the public sector (working within a governmental body)? How are they used in the private secto..
|
|
Identify the inflation rate of your home country
: Identify the inflation rate of your home country and some well-known foreign country. Then identify the percentage change of your home currency with respect to that foreign country. Did the currency change in the direction and by the magnitude that y..
|