Help needed on homework question

A local warehouse and distribution center for a grocery chain wants to forecast demand for their own-brand soup for the next month based upon the monthly demands given below.

a) Develop a linear trend forecast for the next month.

b) Develop adjusted exponential smoothing forecast (use ?=0.2 and ?=0.3) for the next month.

c) Develop a 4-period moving average for the next month.

d) Compare the forecasts using MAPD. Which appears to give the better forecast?

**show all forecast and error calculations for the above questions**

Sheet 1 contains the data

Please show steps and screenshots. Thank you so much

Show all work in this worksheet, then answer the questions in the Answers worksheet. A local warehouse and distribution center for a grocery chain wants to forecast demand for their own-brand soup for the next month based upon the monthly demands given below. a) Develop a linear trend forecast for the next month. b) Develop adjusted exponential smoothing forecast (use =0.2 and =0.3) for the next month. c) Develop a 4-period moving average for the next month. d) Compare the forecasts using MAPD. Which appears to give the better forecast? SHOW ALL FORECAST AND ERROR CALCULATIONS FOR THE QUESTIONS ABOVE IN THIS WORKSHEET. NUMERICAL ANSWERS AND EXPLANATIONS ARE TO BE ENTERED IN THE "ANSWERS" WORKSHEET. Month Soup Sales 1 Nov-18 1459 2 Dec-18 1389 3 Jan-19 1501 4 Feb-19 1419 5 Mar-19 1397 6 Apr-19 1468 7 May-19 1435 8 Jun-19 1399 9 Jul-19 1439 10 Aug-19 1492 11 Sep-19 1445 12 Oct-19 1528 13 Nov-19 1429 14 Dec-19 1502 15 Jan-20 1410 16 Feb-20 1524 17 Mar-20 1424 18 Apr-20 1511 19 May-20 1468 20 Jun-20 1426 For the questions posed on the previous worksheets, provide the numerical forecasts and associated errors and any explanation as required for each question. Question 1 a) b) c) d)