I need all work completed in excel spread sheet with all steps and formulas screen shoted. Any and all work done by hand needs to be shown how to complete. If it can be competed in excel, it must be completed in excel and show all steps.
Historical demand for a product is:
DEMAND
January 12
February 11
March 15
April 12
May 16
June 15
Using a weighted moving average with weights of 0.60, 0.30, and 0.10, find the July forecast. Remember to use the largest weight for the most recent month.
Using the simple three-month moving average, find the July forecast.
Using single exponential smoothing with an α of .20 and a June forecast of 13, find the July forecast. Make whatever assumptions you wish.
Using simple linear regression analysis, calculate the regression equation for the preceding demand data.
Using the regression equation in d, calculate the forecast for July.