FA Word Typesetting Find and Select Settings Replace Student Tools The following questions are based on the material in Chapters 9 and 2: Q6. 6a. Sales data for Fusaichi & Co. for the period 2012 to 2016 is as follows: YEAR 2012 2013 2014 2015 SALES (Y) 2016 5,000 5,500 6,000 6,500 7,000 Required: Exponentially smooth the data with a smoothing constant of 0.8 and complete the following table: YEAR SALES (Y) SX-1 (1-A) SX-1 YA SX 2012 5,000 5,000 2013 5,500 5,000 1,000 4,400 5,400 2014 6,000 5,400 1,080 4,800 5,880 2015 6,500 5,880 1,176 5,200 6,376 2016 7,000 6,376 1,275.2 5,600 6,875.2 6b. Sales data for Pegasus & Co. for the period January to June 2016 is as follows: ACTUAL SALES SEASONALLY ADJUSTED INDEX 2016 ($,000,000) SALES ($,000,000) JAN 150 176 1.0714 FEB 140 175 1 MAR 130 173 0.9285 APR 120 185 0.8571 MAY 110 183 0.7857 JUN 190 158 1.3571 (i) Complete the table (above) for Pegasus by calculating the implied seasonal index for each month. (ii) The trend equation based on the last 6 months seasonally adjusted data is 110% - Thunderstorm 9 4 0906216 LG Balence Deet Recounttia NATO integrated Acc - Balance on ATO for He Got lindalicks payblue. - around of Net out dew I not lodged on the period. DAVE Priscr Scroll PauseW FNSINC602 Assi...nt Copy_190306 Home Insert Page Layout References Review View Section Tool Calibri (Body) 12 A A & Aa- AaBbCcDo Format B / U- A- X X A & AA Normal Painter Page 13 of 20 Required: Prepare a forecast of actual month sales for next June 2017. Assume the time value (x) for next June 2017 is 10 and use the seasonal index from last June 2016. Show your calculation workings. ge: 13/20 Section: 1/1 SetValue: 12cm Row: 8 Column: 24 Words: 2848 Spell Check O O AR