Forecast Demand and calculate MAD & MSE for the different methods using EXCEL

In table: The last 12 months of actual demand and forecasted.

using EXCEL

Calculate MAD & MSE for the already existing numbers.

-> and Use moving average of 4 periods, what is your estimate in demand for June and July?

You want to try a different method to forecast June & July, so you use a more advanced forecasting method: linear regression. What is the forecast now?

Using the two different forcasting methods you just did, calculate the MSE for the Moving average and the linear regression.

Year Month Actual demand (units) Forecast (units) 2018 June 2701 2676 2018 July 2883 2971 2018 August 2997 3140 2018 September 3180 3277 2018 October 3248 3428 2018 November 3487 3576 2018 December 3590 3669 2018 January 3549 3803 2018 February 3787 3896 2018 March 3859 3982 2019 April 3933 4155 2019 May 4239 4210