70.2K

Verified Solution

Link Copied!

Attached above are the project 1 questions. The questions pertain to Walmart Sales for the years of 2002 to 2003. As for the data, please use the data in the link below: http://faculty, mi, edu/mstick/g2. 122/material/ /almart%20dry%20goods % E2Oweekly%20sales.htm Dry Goods Sales: The data is for weekly sales in the dry goods department at a WalMart store in the Northeast. Peak values l.e. spikes, usually occur at holiday periods. Week 1 is the first week of February 2002. To show continuity, week 1 of 2003 is represented as week 54 since week 53 represents the end of fiscal 2002 and start of the 2003 fiscal year. Dry Goods 1. Can youide ntify holiday periodsor spe cial events that cause the spike sin the data? 2. What holiday re sults in the macimum sales forthis de partment? 3. a) Gene rate line ar and quadratic modelsfor this data, b) What is the marginal sale s for this department using e ach model. c) Which model do you feel best pre dicts future trends and explain your rational 4. Base d on the model sele cted, what type of se asonal adjustments, if any, would be re quired to meet customer needs? Attached above are the project 1 questions. The questions pertain to Walmart Sales for the years of 2002 to 2003. As for the data, please use the data in the link below: http://faculty, mi, edu/mstick/g2. 122/material/ /almart%20dry%20goods % E2Oweekly%20sales.htm Dry Goods Sales: The data is for weekly sales in the dry goods department at a WalMart store in the Northeast. Peak values l.e. spikes, usually occur at holiday periods. Week 1 is the first week of February 2002. To show continuity, week 1 of 2003 is represented as week 54 since week 53 represents the end of fiscal 2002 and start of the 2003 fiscal year. Dry Goods 1. Can youide ntify holiday periodsor spe cial events that cause the spike sin the data? 2. What holiday re sults in the macimum sales forthis de partment? 3. a) Gene rate line ar and quadratic modelsfor this data, b) What is the marginal sale s for this department using e ach model. c) Which model do you feel best pre dicts future trends and explain your rational 4. Base d on the model sele cted, what type of se asonal adjustments, if any, would be re quired to meet customer needs

Answer & Explanation Solved by verified expert

See Answer