A A ? CG ... wa week 10 Forecasting in class Tutorial Questions Home Insert Design Layout References Mailings Review View Table Design Layout LE Share A" A Aa Ap ab A A AaBbCcDdEe AaBbCcDdEe AaBbCcDc AaBbCcDdE AaBb( AaBbCcDdEE Paste BIUvab X X|AAA # Normal No Spacing Heading 1 Heading 2 Title Subtitle Styles Pane * Subscription Required to Edit and Save Start your free one month trial of Microsoft 365 or sign in to activate an existing subscription. Activate Week 9 Op Man Tut Read and prepare for answering problems 2 (part 1 is not included), 3, 4 and 5 from Chapter 3 (Stevenson, 2018, p. 125) 2. National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Sales Month (000 units) Feb 19 Mar . 18 Apr. 15 May 20 Jun. 18 Jul. 22 Aug. 20 Sep? 2a. graphing 2b. Forecast September sales volume using each of the following: 2b1. The naive approach = 2b2. A fixe month moving average Moving Average = F, = At-1+ At-2+At-3+A-4+Al-s 2b3. A weighted average using .60 for August, .30 for July, and .10 for June Weighted Moving Average = Ft = Wt-1 (At-1) + Wt-2 (At-2) + Wt-3 (At-3) + Wt-4 (At-4) - Page 1 of 2 2 of 261 words x English (Australia) & Accessibility: Investigate E + 84%A A ? CG ... wa week 10 Forecasting in class Tutorial Questions Home Insert Design Layout References Mailings Review View Table Design Layout LE Share A" A Aa Ap ab A A EV EEVEEAINLIT AaBbCcDdEe AaBbCcDdEe AaBbCcDc AaBbCcDdE AaBb( AaBbCcDdEE Paste BIUvab X X|AAA # Normal No Spacing Heading 1 Heading 2 Title Subtitle Styles Pane * Subscription Required to Edit and Save Start your free one month trial of Microsoft 365 or sign in to activate an existing subscription. Activate 2b4. Exponential smoothing with a smoothing constant equal to .20, assuming a a March forecast of 19(000) Sales Month (000 units) Feb Mar. 18 Apr. 15 May 20 Jun. 18 Jul. 22 Aug. 20 Exponential Smoothing = Ft = Ft-1+ @(At-1) - Ft-1) = Fsep = Faug+ @(Aaug) - Faug) ---we don't have forecast for august but we got forecast for march given. Therefore using forecast for march we find forecast for April--- = Fapr = Fmar + @ (Amar) - Fmar) then use forecast for April to find forecast for may ----and keep doing until you get forecast for september Month Forecast F(old) + .20[Actual - F(old) ] April +.201 18 - 19 May + .201 15 - 18.80 ] * .201 20 18.04 ] July + .20[ 18 -18.43 ] August + .201 22 - 18.34 September .20[ 20 -19.07 ] 7 Page 2 of 2 2 of 261 words X English (Australia) & Accessibility: Investigate E + 84%