Compute the MSE for each set of forecasts. Given your results, which forecast appears to be more accurate? (Round your answers to 2 decimal places.) d. Compute MAPE for each data set. Which forecast appears to be more accurate? (Round your intermediate calculations to 2 decimal places and and final answers to 2 decimal places.)

Please help with the correct answers in details:   Centerville Bikes and Stuff (CBS) sells motorcycles and accessories. The number of helmets sold by CBS per week for the past six weeks follows. Week 1 2 3 4 5 6 Value 19 12 17 10 18 15 Using the naive method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy. (a) mean absolute error MAE =  (b) mean squared error MSE =  (c) mean absolute percentage error (Round your answer to two decimal places.) MAPE =  % (d) What is the forecast for week 7?

K Following are two weekly forecasts made by two different methods for the number of gallons of gasoline, in thousands, demanded at a local gasoline station. Also shown are actual demand levels, in thousands of gallons: Week 1 2 3 4 Forecast Method 1 0.95 1.05 0.97 1.20 Actual Demand 0.68 1.05 0.96 1.00 Week 1 2 3 4 Forecast Method 2 0.82 1.21 0.88 1.17 The MAD for Method 1 = thousand gallons (round your response to three decimal places). Actual Demand 0.68 1.05 0.96 1.00 Save D

Given the table below, complete the missing cell values applying the Exponential Smoothing method of forecasting and Mean Absolute Deviation. Answer also the other 2 related questions below the table. Numbers with decimal should take 2 decimal places. Actual Quarter Tonnage Unloaded 1 2 3 4 5 6 7 8 175 160 170 160 160 170 180 200 Forecast for a=3 175 175.0 170.5 167.2 165.1 166.6 170.6 Sum of absolute deviation = Absolute Deviation for a = .3 Other questions: (1) What is the MAD for a = .3? (2) Which smoothing constant would you prefer? 0.00 15.00 0.50 10.35 4.93 13.45 29.41 80.89 Forecast for a = .6 175 166.0 168.4 163.4 161.3 166.5 174.6 Absolute Deviation for a = .6 0.00 15.00 4.00 8.40 3.36 8.66 13.46 25.38

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

Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to see which method was better over this period.   MONTH ACTUAL January 120 February 145 March 146 April 171 May 154 June 182 July 138 August 135 September 146     a. Forecast April through September using a three-month moving average. b. Use simple exponential smoothing with an alpha of  0.20 to estimate April through September, using the average of January through March as the initial forecast for April.  c-1. Calculate MAD for Three-month moving average and Exponential smoothing. c-2. Use MAD to decide which method produced the better forecast over the six-month period.

UltraPure used two different techniques (F1 and F2) to forecast demand for cases of bottled water.   Actual demand and the two sets of forecasts are in the table below.      PREDICTED DEMAND Period Demand F1 F2 1 68 67 60 2 75 67 67 3 70 71 70 4 74 69 72 5 69 71 77 6 72 70 77 7 80 72 75 8 78 75 83     a. Compute MAD for each set of forecasts. Given your results, which forecast appears to be more accurate? (Round your answers to 2 decimal places.)

Give typed explanation Part 2: Using exponential smoothing, the forecasted demand for period 5 using the smoothing constant determined in image= ?

The following table shows the actual demand observed over the last 11​ years:                                                                                                                                             Year 1 2 3 4 5 6 7 8 9 10 11 Demand 6 8 4 7 11 7 13 12 10 13 8 This exercise contains only parts​ b, c, and d. Part 2 ​b) Using the​ 3-year moving​ average, provide the forecast from periods 4 through 12 ​(round your responses to one decimal​ place).                                           Part 3 ​c) Using the​ 3-year weighted moving average with weights   0.10​,   0.30​, and   0.60​, using   0.60 for the most recent​ period, provide the forecast from periods 4 through 12​ (round your responses to two decimal​ places).                                           Part 4 ​d) Mean absolute deviation for the forecast developed…

Use exponential smoothing with trend adjustment to forecast deliveries for period 5. Let α = 0.1, β = 0.2, and let the initial trend value be 4 and the initial forecast be 200 (both are given in the table).    (a) Complete the table below and to predict the demand for Period 5 (See image).                         Show the calculations for the demand for Period 2.    (b) Based on the actual demands of the first 4 periods forecast the demand for period 5 using the linear regression method.       (c) Which method performs better based on the actual demand for period 5? Why do you think so?