1. A startup company is selling its experimental neural network accelerator chip to the hobbyist. The chip is designed to speed up low-precision calculations and help neural network training. The company wants to choose the best forecasting technique possible to automate the forecasting system and reduce the effects of stockouts and extra inventories. Your tasks are to: You may show details of your calculations in the Word file below or submit an Excel file with the calculations to get full credit. Use two decimal point accuracy (e.g.,93.78) 1. Calculate forecasts from February to June using 4-Month Moving Average ( 4 points) 2. Calculate forecasts from February to June using 4-Month Weighted Moving Average. The weights are as follows: w1=0.48,w2=0.32,w3=0.12,w4=0.08 ( 4 points) 3. Calculate forecasts from February to June using exponential smoothing. Use =0.25 and Fman=150 (4 points) 4. Calculate MAD and Sf values for Moving Average (4 points) 5. Calculate MAD and Sf values for Weighted Moving Average ( 4 points) 6. Calculate MAD and Sf values for Exponential Smoothing (4 points) 7. Which forecasting method would you choose based on MAD and Sf values? Why? ( 53 points) 8. Assuming you choose the best forecasting method based on Sf values, calculate the 95% Confidence Interval for July Forecast ( 3 points) 1. A startup company is selling its experimental neural network accelerator chip to the hobbyist. The chip is designed to speed up low-precision calculations and help neural network training. The company wants to choose the best forecasting technique possible to automate the forecasting system and reduce the effects of stockouts and extra inventories. Your tasks are to: You may show details of your calculations in the Word file below or submit an Excel file with the calculations to get full credit. Use two decimal point accuracy (e.g.,93.78) 1. Calculate forecasts from February to June using 4-Month Moving Average ( 4 points) 2. Calculate forecasts from February to June using 4-Month Weighted Moving Average. The weights are as follows: w1=0.48,w2=0.32,w3=0.12,w4=0.08 ( 4 points) 3. Calculate forecasts from February to June using exponential smoothing. Use =0.25 and Fman=150 (4 points) 4. Calculate MAD and Sf values for Moving Average (4 points) 5. Calculate MAD and Sf values for Weighted Moving Average ( 4 points) 6. Calculate MAD and Sf values for Exponential Smoothing (4 points) 7. Which forecasting method would you choose based on MAD and Sf values? Why? ( 53 points) 8. Assuming you choose the best forecasting method based on Sf values, calculate the 95% Confidence Interval for July Forecast ( 3 points)
