BUSI 411 Homework Forecasting
Problem 3-2 (Algo) 1. National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000)Units Feb. 17 Mar. 20 Apr. 12 May. 22 Jun. 19 Jul. 24 Aug. 26 Click here for the Excel Data File a. Forecast September sales volume using each of the following: (1) The naive approach. Explanation: Using the naïve approach, the forecast for the next month (September) will equal 20. (2) A five-month moving average. (Round your answer to 2 decimal places.) Explanation: A five-month moving average is shown below: MA5 = 12 + 22 + 19 + 24 + 26 = 20.60 5 (3) A weighted average using 0.60 for August, 0.10 for July, and 0.30 for June. (Round your answer to 2 decimal places.) Explanation: 0.30(19) + 0.10(24) + 0.60(26) = 23.70
Información del documento
- Subido en
- 14 de septiembre de 2023
- Número de páginas
- 6
- Escrito en
- 2023/2024
- Tipo
- Otro
- Personaje
- Desconocido