Homework help needed and very much appreciated!!

Show all work in this worksheet (with all calculation done using Excel - no manual calculations), 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 following year based upon the past five years sales data (in thousands) given below (broken out by year/quarter). a) Develop a linear trend forecast for the next year. b) Using the data given by quarter, estimate the quarterly forecasts for next year. SHOW ALL FORECAST AND ASSOCIATED CALCULATIONS FOR THE QUESTIONS ABOVE IN THIS WORKSHEET. NUMERICAL ANSW Year/Quarter 1 2 3 4 5 Orders (1,000s) Jan-Mar 18.6 April-June July-Sept Oct-Dec Jan-Mar April-June July-Sept Oct-Dec Jan-Mar April-June July-Sept Oct-Dec Jan-Mar April-June July-Sept Oct-Dec Jan-Mar April-June July-Sept Oct-Dec 23.5 20.4 41.9 18.1 24.7 19.5 46.3 22.4 28.8 21 45.5 23.2 27.6 24.4 47.1 24.5 31 23.7 52.8 manual calculations), own-brand soup for the y year/quarter). ORKSHEET. NUMERICAL ANSWERS AND EXPLANATIONS ARE TO BE ENTERED IN THE "ANSWERS" WORKSHEET. For the questions posed on the previous worksheets, provide the numerical forecasts and associated errors and any explanation as required for each question. Question 2 a) b)