Homework SourseProblem 32 National Scan Inc sells radio frequency inventory
Problem 3-2
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows:
A linear trend equation.(Round your intermediate calculations and final answer to 2 decimal places.)
A five-month moving average. (Round your answer to 2 decimal places.)
Exponential smoothing with a smoothing constant equal to .30, assuming a March forecast of 19(000). (Round your intermediate forecast values and final answer to 2 decimal places)
The naive approach.
A weighted average using .50 for August, .20 for July, and .30 for June. (Round your answer to 2 decimal places.)
| National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows:
|
Solution
https://www.dropbox.com/s/dwo6mokskipkwfp/excel%20solution.xlsx?dl=0
