Search Kemmis, Carter AutoSave . Off)[ chapter03_02_v06 - Excel Com File Home Insert Page Layout Formulas Data Review View Automate Add-ins Help X Cut 29 Wrap Text General Normal Bad Good LIX AutoSum LO Segoe UI 11 ~ A A = AY O [a Copy Fill Paste BIUY CE E Merge & Center $ ~ % " Conditional Format as Neutral Calculation Check Cell nsert Delete Format Sort & Find & Analyze Sensiti Clear ~ Formatting * Table Filter ~ Select Data Format Painter Cells Editing Analysis Sensit Clipboard Font Alignment Number Styles A1 X V fix Month K L M N O P Q R S T U V W X Y Z AA A E F G H Sales Month (000 units) Feb. 17 Mar. 20 Apr. 14 May 22 Jun. 21 Jul. 25 Aug 29National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Sales Month (000) Units Feb. 17 Mar. 20 Apr. 14 May. 22 Jun. 21 Jul. 25 Aug . 29 Click here for the Excel Data File a. Forecast September sales volume using each of the following: (1) The naive approach. Naive approach thousands (2) A five-month moving average. (Round your answer to 2 decimal places.) Moving average thousands (3) A weighted average using 0.55 for August, 0.20 for July, and 0.25 for June. (Round your answer to 2 decimal places.) Weighted average thousands (4) Exponential smoothing with a smoothing constant equal to 0.10, assuming a March forecast of 15(000). (Round your intermediate forecast values and final answer to 2 decimal places.) Forecast thousands (5) A linear trend equation. (Round your intermediate calculations and final answer to 2 decimal places.) Yt thousands