Below is a table containing data on product demand for the most recent three months along with the forecasts that had been made for those three previous months. Calculate the MSE. Month Demand Forecast 1 308 310 2 388 390 3 344 342

a) Apply moving average and exponential smoothing to generate two forecasts of the closing price for the entire data period. Set appropriate values for the forecast parameters (e.g., k and a). b) Plot and compare the actual and predicted data values you calculated in part (b). Provide one chart that displays actual, moving average, and exponential smoothing lines. Hint: Calculate MSE, MAD, or MAPE to compare the different forecasts. Develop your own forecast from scratch. Do NOT use Excel’s Data Analysis or Forecast Sheets.

Use simple exponential smoothing with a -0.8 to forecast electric scooter sales at Guelph- Humber Inc. for July. Assume that the forecast for May was for 45 electric scooters. Round your answer to 1 decimal Electric Scooter Sales Month May 42 June 47 July 45 August 40 Weekly demand for medical masks for the last five weeks at Chopper Drug Store has been as follows: 92, 96, 100, 100 and 102 (listed from the oldest to most recent). Suppose a naive forecast was used to forecast demand. What would the MAD be for this situation? Enrollment in a particular Yoga class at Guelph Fitness Centre for the last five months has been 80, 86, 88, 88 and 90(listed from the oldest to most recent). Suppose a two-month mov average was used to forecast enrollment. What would the MSE be for this situation?

4. The sales (in millions of dollars) for an 18-month period are as follows. Month Sales Month Sales 1 600 600 775 10 775 3 600 11 600 4 650 12 575 700 13 625 800 14 650 550 15 600 8 775 a. Compare a three-month moving average forecast with an exponential smoothing forecast. Use a = 0.1. Which provides the better forecasts based on MSE? b. Find the forecast for the next month using the best forecast method. 2.