Excel File Edit View Insert Format Tools Data Window Help A Thu Mar 24 8:43 PM o AutoSave OFF ASP Homework 3.-1 Insert Draw Page Layout Home - Formulas Data Review View Tell me & Share U Comments Calibri (Body) V v 11 YA APA = = Oy 9. Wrao Text General Y 9 Insert Delete ! Format 27-O Paste B 7 Uw = Merge & Centar Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select Analyze Data Open recovered workbooks? Your recent changes were saved. Da you want to continue working where you left off? Yes No G26 fx D E F G H I J K L M N O P Q R S T U V U W X Y Z AA ABAC B Year Period sales C Season 1 1 1 1 2 3 1 2 31 Weheads for years and there are four won throughout your By using linear regression method, creasonal forecast for year 10 (perlods 37, 38, 39, and 401. 5 2 3 4 5 6 7 4 50 70 ho HO 55 73 ho 1 3 2 2 9 10 11 12 11 14 15 16 17 13 19 GO 89 70 9 GE 3 3 3 4 + 4 4 1 5 5 5 5 5 5 9 10 11 17 13 14 15 16 10 17 18 19 20 21 22 23 74 25 20 27 22 29 30 31 1 2 3 4 1 1 - 2 3 4 1 2 3 41 1 2 85 25 45 20 91 80 21 22 23 24 5 26 27 7 7 7 4 1 2 - 3 41 1 2 75 95 85 1019 90 100 90 110 85 205 31 32 31 34 35 35 37 5 B B 9 3 9 9 33 34 36 4 1 2 3 115 90 110 100 120 37 1 2 39 20 10 10 10 101 39 4 Aggregate Planning (2 points) seasonality (2 points) Exponetial Smothing 12 points) + Ready HE CI 89% 25e7 www.1 24 otv @N A A