complete on spreadsheet

smoothing method? Which meth 3. The owner of the Chocolate Outlet Store wants to forecast chocolate demand. Demand for the preceding four years is shown in the following table: YEAR DEMAND (POUNDS) 1 2 3 4 68,800 71,000 75,500 71,200 Forecast demand for year 5 using the following approaches: (1) a three-year moving average; (2) a three-year weighted moving average using 0.40 for year 4, 0.20 for year 3, and 0.40 for year 2; and (3) exponential smoothing with a = 0.30, and assuming the forecast for period 1 = 68,000. golf balls in dozens for the last twelve