Please answer this question in excel and show the steps.

1. For the following problems, show your work by hand (scan or photo your handwritten work) or by typing out all the values in Microsoft Word.

You will use the data in the table to calculate four separate forecasts for July. Remember that each calculation and answer is separate (i.e., your answer from part a has nothing to do with your calculation for part b, and so on). (40 points)

PROBLEM: Calculating demand for trampolines at the local sporting goods store: The demand values for the first six months of the year are presented in the table below:

Applying decimals:

Use 2-decimal places throughout the calculations, then round the final answer to the nearest whole number.

1. Using a simple three-month moving average, find the forecast for July. done
   2. Using a three-month weighted moving average with weights of .60, .30, and .10, find the forecast for July. (REMEMBER: In your calculations, apply the highest weight to the most recent week, middle weight to the week before that, and so on.) done

1. 3. Using exponential smoothing with = .5 and a June FORECAST equal to 15, find the forecast for July. - done

4. Using simple linear regression analysis, calculate the regression equation and the forecast for July. - need this one only

MONTH	DEMAND
January	9
February	6
March	7
April	13
May	14
June	17