Calculate a forecast using a three-period weighted moving average. Using the following weights. (Excel formulas included with solution)

Excel File Edit View Insert Format Tools Data Window Help 70%O Fri 4:10 PM a AutoSave OFF HESU- Case 7-1 Tires For you Students Template-1 Q V Home Insert Draw Page Layout Formulas Data Review View Share Comments Calibri (Body) 11 ab Wrap Text General Insert Ayu Or 2X Delete v Paste BI av A. E $ % ) 2 Merge & Center Ideas Conditional Format Formatting as Table Cell Styles Sort & Filter Format Find & Select Sensitivity B32 - x fx A B D E F G H - J K L M N O 3PMA 3PF Error Abs Error MAPE 0.6 alpha beta 0.3 0.1 gama Q2. Weighted Moving Average 2 Demand 3 Oct 9,797 4 Nov 11,134 5 Dec 10,687 6 Jan 9,724 7 Feb 8,786 8 Mar 9,254 9 Apr 10,691 10 May 9,256 11 Jun 8,700 12 Jul 10,192 10,751 14 Sep 9,724 15 Oct 10,193 16 Nov 11,599 17 Dec 11,130 18 Total Demand 19 Avg. Demand 20 Total Bias 21 Ave. Bias 22 Absolute Dev 23 Mean Abs Dev 24 MAPE 25 Q1 Q2 Q3 13 Aug Q4 + Ready 150% 504 X W P 29 ? M A G ? H Excel File Edit View Insert Format Tools Data Window Help 70%O Fri 4:10 PM a AutoSave OFF HESU- Case 7-1 Tires For you Students Template-1 Q V Home Insert Draw Page Layout Formulas Data Review View Share Comments Calibri (Body) 11 ab Wrap Text General Insert Ayu Or 2X Delete v Paste BI av A. E $ % ) 2 Merge & Center Ideas Conditional Format Formatting as Table Cell Styles Sort & Filter Format Find & Select Sensitivity B32 - x fx A B D E F G H - J K L M N O 3PMA 3PF Error Abs Error MAPE 0.6 alpha beta 0.3 0.1 gama Q2. Weighted Moving Average 2 Demand 3 Oct 9,797 4 Nov 11,134 5 Dec 10,687 6 Jan 9,724 7 Feb 8,786 8 Mar 9,254 9 Apr 10,691 10 May 9,256 11 Jun 8,700 12 Jul 10,192 10,751 14 Sep 9,724 15 Oct 10,193 16 Nov 11,599 17 Dec 11,130 18 Total Demand 19 Avg. Demand 20 Total Bias 21 Ave. Bias 22 Absolute Dev 23 Mean Abs Dev 24 MAPE 25 Q1 Q2 Q3 13 Aug Q4 + Ready 150% 504 X W P 29 ? M A G ? H