Problém 3-2 National Scan, Inc., sells radio frequency inventory tags. Monthly s

Question

Problém 3-2 National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as Feb Mar Apr May Jun Jul. Aug 16 19 14 21 19 23 25 b. Forecast September sales volume using each of the following inar tnd equation (Round your intermedians and final answer to 2 decimal places.) thous ands (2) A five-month moving average (Round your answer to 2 decimal places.) thousands Moving average (3) Exponential smoothing with a smoothing constant equal to 40, assuming a March forecast of 16(000) (Round your intermediate forecast values and final answer to 2 decimal places)

Explanation / Answer

Answer:- Five month moving average= (25+23+19+21+14)/5 =20.4 thousand

Answer:- Exponential smoothing forecasting = Ft = Ft-1 +(At-1-Ft-1)

In the question, Ft-1=16 =0.4 At-1=19

Exponential smoothing forecasting for April=16+0.4(19-16)=17.2

Exponential smoothing forecasting for May=17.2+0.4(14-17.2)=15.92

Exponential smoothing forecasting for June=15.92+0.4(21-15.92)=17.95

Exponential smoothing forecasting for July=17.95+0.4(19-17.95)=18.37

Exponential smoothing forecasting for August=18.37+0.4(23-18.37)=20.22

Exponential smoothing forecasting for September=20.22+0.4(25-20.22)=22.13

So the answer is:- 22.13 thousands

Answer:- Forecast for September as per naive approach = actual sales of August =25,0000

So the answer is 25 thousand

Answer:- Weighted Moving average forecast for September = (0.6*25 +0.1*23 +0.3*19)/(0.6+0.1+0.3)=23

So the answer is 23 thousand

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.