a.) how would I develop a linear trend forecast for next month manually and with excel? If you could show all calculations and explain step by step how to do develop a linear trend forecast for next month it would be of great help thank you.

b.) how would I develop an exponential smoothing forecast for next month manual and excel please.

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 of tissues for the next month based upon the monthly demands given below. a) Develop a linear trend forecast for the next month. b) Develop an exponential smoothing forecast (use a=0.35) for the next month. c) Develop adjusted exponential smoothing forecast (use a=0.35 and B=0.45) for the next month. d) Develop a 5-period moving average for the next month. e) Compare the forecasts using MAPD and MSE. 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 Sales 1 Aug-18 1654 23 2 Sep-18 1499 3 Oct-18 1683 4 Nov-18 1578 5 Dec-18 1599 6 Jan-19 1736 7 Feb-19 1612 8 Mar-19 1555 9 Apr-19 1737 2 10 May-19 1777 11 Jun-19 1772 12 Jul-19 1693 13 Aug-19 1659 14 Sep-19 sep 1562 15 Oct-19 1598 16 Nov-19 NOV 17 1543 17 Dec-19 1544 18 Jan-20 1533 19 Feb-20 1522 20 Mar-20 1510 21 Apr-20 1626 22 May-20 1555 23 Jun-20 1491 24 Jul-20 1501 25 Aug-20 1651 26 Sep-20 1598 27 Oct-20 1525 . 28 Nov-20 1500 29 Dec-20 1503 30 Jan-21 1661 ce 31 Feb-21 1570 32 Mar-21 1708 33 Apr-21 1690 34 May-21 1804 way 35 Jun-21 1633 uc 20 36 Jul-21 1641 37 Aug-21 1671 38 Sep-21 1643 39 Oct-21 1670