Month Demand 1 45 2 48 3 43 4 48 5 49 6 54 7 47 8 50 9 46 10 47 Using the table above, calculate two forecasts using the following method:- i. First, for periods 4 through 10, develop the exponentially smoothed forecasts for period 3 (F 3) of 45.0 and an alpha of 0.4. using a forecast ii. Calculate the weighted moving average for periods 4 through 10, using weights of .70, .20, and .10, with 0.70 applied to the most recent data. iii. Calculate the mean absolute deviation (MAD) for each forecasting procedure. Which forecasting procedure would you select? Why?

A recently introduced product has a positive trend in sales. The product’s sales have increased in each of its first eight weeks on the market. The forecast for week 6 was 1,325 (F6 = 1,325), with A6 = 1,283 and T6 = 42. Using smoothing components α = 0.20 and β = 0.30, develop forecasts for weeks 7 and 8.

Explain different forecasting techniques like moving averages, exponential smoothing, regression etc.

One forecasting model was used to forecast demand for a product. The forecasts and the demand are shown in the table below. Use two decimals in your answer. Actual Forecast 1 40 41 2 35 38 3 38 35 4 33 30 The Mean Absolute Deviation (MAD) is O 0.5 2.5 O 1.48 7.01

Period 1 2 3 4 5 New Accounts Period 201 215 212 229 236 6 7 8 9 10 New Accounts Period 233 249 253 254 268 11 12 13 14 15 New Accounts 282 276 281 289 311

Given the following original forecast and actual data: Month Actual Forecast Jan Feb Mar Apr May Jun Jul 600 475 550 575 688 649 ??? 400 —— 1 ??? Using exponential smoothing with a - = 0.64, what is the forecast for July. Round your answer to 2 decimal places.

b5  need urgent in 15 minutes

a. Use a 3-month moving average to estimate the month-in-advance forecast of demand for months 4–12 and generate a forecast for the first month of next year. Calculate the average forecast error and mean absolute error. b.   Use a 3-month weighted moving average with weights of 0.6, 0.3, 0.1 (most recent to least recent, respectively) to calculate month-in-advance forecasts for months 4–12 and forecast for the first month of next year. Calculate the average forecast error and mean absolute error. c.   Compare the average forecast error and MAD for the forecasting methods in parts a and b. Based on these error calculations, which of the two forecast methods would you recommend? Why?

Problem 5 You are trying to determine what forecast method to use. Based upon the following historical data, calculate the following forecast and specify what procedure you would utilize. MAY JUNE MONTH JANUARY FEBRUARY MARCH APRIL DEMAND 62 65 67 68 71 73 MONTH JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER DEMAND 76 78 78 80 84 85 a. Calculate the simple three-month moving average for periods 4 to 12. b. Calculate the weighted three-month moving average for periods 4 to 12. Use weights of 0.50, 0.30, and 0.20 for the most recent, second most recent, and third most recent periods, respectively. c. Calculate the single exponential smoothing forecast for periods 2 to 12 using an initial forecast (F₁) of 61 and a of 0.30. d. Calculate the exponential smoothing with trend component forecast for periods 2 to 12 using an initial trend forecast (T₁) of 1.8, and initial exponential smoothing forecast (F₁) of 60, an a of 0.30 and ō of 0.30. e. Calculate the MAD for the forecasts made by each…

Following table shows the weekly sales of smart phones at electronic retail store: Week Number of smart phones Sold Forecast using 3 period moving average Error Forecast using exponential smoothing (with α =0.4) Error 1 48         2 41         3 55         4 64         5 62         6 55         7           8             Answer the following questions based on the data given above. Show all your calculations. What is the expected sales for the 7th week based on 3 period moving average. What is the forecast for the 8th week using the same method if the actual sales for week 7 happens to be 70?  What is the expected sales for the 7th week based on exponential smoothing with α = 0.3?  Which of the above two forecasting method is better based on MSE? Explain why?