National Scan, Inc., sells radio frequency inventory tags.Monthly sales for a seven-month period were as follows:
Click here for the Excel Data File
a. Forecast September sales volume usingeach of the following:
(1) The naive approach.
(2) A five-month moving average. (Round your answerto 2 decimal places.)
(3) A weighted average using 0.65 for August, 0.05 for July, and0.30 for June. (Round your answer to 2 decimalplaces.)
(4) Exponential smoothing with a smoothing constant equal to0.20, assuming a March forecast of 14(000). (Roundyour intermediate forecast values and final answer to 2 decimalplaces.)
(5) A linear trend equation. (Round yourintermediate calculations and final answer to 2 decimalplaces.)
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Click
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am