NOTE: Please CLEARLY answer all parts 1 through 7. Please record your answer next to the question. Also, develop a simple linear regression model out clearly so that it can be understood! Thank you kindly!

MGT 431 CHAPTER 4 ASSIGNMENT SHOW ALL WORKINGS FOR IN ORDER TO OBTAIN ANY CREDIT FOR ANSWERS. THE FOLLOWING TABLE IS FOR PROBLEMS 1 TO 6. Month Actual Sales Forecast January 24 25 February 28 30 March 27 31 April 32 34 May 36 33 June 44 45 1. What is the 4-month moving average forecast for July? 2. Using a weighted 4-month moving average, with a weight of 0.4 for the most recent value and weights of 0.3, 0.2 and 0.1 for successively older sales data, obtain the forecast for July 3. Use single exponential smoothing with a smoothing constant of.65 to forecast sales for July 4. 5. 6. 7. Calculate the MAD measure of accuracy for the forecasts in the Table above. Calculate the MSE measure of accuracy for the forecasts in the Table above. Calculate the MAPE measure of accuracy for the forecasts in the Table above. House Depot Inc. has accumulated data relating the number of fumaces sold to the number of times their advertisement appeared on television the previous week. Using the data, develop a simple linear regression model to predict sales for a week following the one during which they advertised four times on television Number of Units TV Adverts (x) Sold (v) 11 26 14 aut