Question: Please show all steps when solving. Thank you! The following table shows the actual sales of upholstered chairs for a furniture retailer and the forecasts

Please show all steps when solving. Thank you!

Please show all steps when solving. Thank you! The following table showsthe actual sales of upholstered chairs for a furniture retailer and theforecasts made for each of the last eight months. Calculate MSE and

The following table shows the actual sales of upholstered chairs for a furniture retailer and the forecasts made for each of the last eight months. Calculate MSE and MAD for this product. The marketing department for a large retailer tracks sales and advertising expenditures each month. The regression results based on the monthly data from Jan 2011 to Jan 2019 are shown as below: Based on the regression results, answer the following questions: 1) What percent in the variation of Sales is explained by Advertising? 2) For every dollar spent on advertising, it will increase sales by how much? 3) If no money were spent on advertising, how much is the expected sales? 4) If advertising spending for Feb 2019 is budged to be $60,000, what is the expected sales for that month? 5) In order to realize the sale of 250,000 units for Feb 2019, how much advertising spending should the company target? First calculate the three-week simple moving average forecasts for the following weekly sales data. Then calculate the weighted moving average using weights of 0.7,0.2 and 0.1 with 0.7 applied to the most recent data. Please round your answers to 1 decimal. Develop the exponentially smoothed forecasts using a forecast for February of 108 and an alpha of 0.5 for the following sales data. Calculate the mean squared error for this forecasting procedure at the end. Please round your calculations to the nearest whole number

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!