Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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!

image text in transcribedimage text in transcribedimage text in transcribed 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Inventory Optimization Models And Simulations

Authors: Nicolas Vandeput

1st Edition

3110673916, 978-3110673913

More Books

Students also viewed these General Management questions

Question

11. What are the three aspects of organizational architecture?

Answered: 1 week ago