For Questions 4.0--- Jee the worksheet Forecasting-2 The table below chowe 5-year record of quarterly Sacs of adscount shoro rodi. Nodith quarter includes Thanicating. Hanukah, Christmas. Sales thousand YA 1 10 $31,25 $32,167 $92,320 40 $42,33a Year 2 10 $34,512 20 $35,334 $ 30 $25,510 40 $43.195 YAA 3 10 $34,814 20 $35,414 $38.935 40 $45,500 Year 10 $35,157 20 $38,000 30 $26.492 40 $49.913 YARS 10 $97,005 20 $29,394 $38.180 40 $51,230 You are tied to make sale forecastoresch querlerin Year 6. As the 10 includes trobusy shopping second 40 ve been much higher than those of other waters in the years. you decided to use 85 a forecast ng rehod To use the method, you need a forecast of Year 6 total annual sales. You fit calculate the annual sales figures for the last 5 years, and acc there is a parten. The annual das figums show trera and the dependent ratio is ! Using the annual sacs data you decide to establish a linear regression model to forecas: Year annual sacs. In the lncar regression, the independent vanabicic You get the regression equation with a sopa Thus you forecast Year Eamus sales ass thund 6,290 AnnA pott 2,132 ALAS 133,824.20 B0721990 malih method an upward sperentis 171.228.20 adwardin an exponer al eching method 10 year an upardiner Please put an answer inch box In the next step, you ostablish the seasonal Indexes using all-year quarterly data iCalculate casonal dexes to 4 decimal places such as 0.xxxi. Temmuut the Year Barrules force of $172,500 thousand What do you get any form for Aod's do in Year 6? thousand Hound to the cares: thousanc. Example: S867.664 thousand will be rounded to see thousand.)