Question

Month (O00) Units Feb Mar. Apr May Jun Jul. Aug 17 20 12 19 24 26 b. Forecast September sales volume using each of the follow

image.png

b. Forecast September sales volume using each of the following: 

(1) (Omitted) 

(2) A five-month moving average.

(3) Exponential smoothing with a smoothing constant equal to .20, assuming a March forecast of 16(000).

(4) The naive approach 

(5) A weighted average using .60 for August, .10 for July, and .30 for June.


0 0
Add a comment Improve this question Transcribed image text
✔ Recommended Answer
Answer #1

3)The Exponential smoothening for September = 0.20*20.6+(1-0.20)*26 = 24.92
4)Naive approach = 26 ( Same as August)
5) A weighted Average =0.60*26+0.10*24+0.3*19 = 23.70

Please Discuss in case of Doubt

Best of Luck. God Bless
Please Rate Wel



Add a comment
Know the answer?
Add Answer to:
Forecast September sales volume using each of the following:
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as...

    National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: MonthSales(000)UnitsFeb.15Mar.18Apr.12May.20Jun.23Ju1.23Aug -27b. Forecast September sales volume using each of the following: (1)A linear trend equation.(2) A five-month moving average. (3) Exponential smoothing with a smoothing constant equal to .25, assuming a March forecast of 17(000).(4) The naive approach. (5) A weighted average using.55 for August, .10 for July, and .35 for June.

  • National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as...

    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. 14 May. 22 Jun. 21 Jul. 25 Aug. 29 b. Forecast September sales volume using each of the following: (1) A linear trend equation.(Round your intermediate calculations and final answer to 2 decimal places.)    Yt _ thousands (2) A five-month moving average. (Round your answer to 2 decimal places.)    Moving average _ thousands...

  • 1. National Scan, Inc sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows:

    1. National Scan, Inc sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000 units) Feb. 21 Mar. 20 Apr. 17 May 22 Jun. 20 Aug. 22 a. Plot the monthly data on a sheet of graph paper.b. Forecast September sales volume using each of the following: (1) The naive approach (2) A five month moving average (3) A weighted average using 60 for August, 30 for July, and. 10 for June (4) Exponential smoothing with a smoothing constant equal to.20, assuming a March-forecast of...

  • Note: A solution without detailed explanation/calculation will get no more than 1 point out of 100....

    Note: A solution without detailed explanation/calculation will get no more than 1 point out of 100. Problem 1. National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Sales (000 units) Month 18 15 20 18 20 a. Plot the monthly data on a sheet of graph paper b. Forecast September sales volume using each of the following: (1) The naive approach. (2) A five month moving average. (3) A weighted average using...

  • National Scan Inc. sells radio frequency inventory tags. Monthly sales for a seven-month period were as...

    National Scan Inc. sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000) Units Feb 19 Mar 18 Apr 15 May 20 Jun 18 Jul 22 Aug 20 b. Forecast September sales volume using each of the following: SHOW WORKS!!!! (1) Thenaiveapproach. (2) A five month moving average. (3) A weighted average using .60 for August, .30 for July, and .10 for June. (4) Exponential smoothing with a smoothing constant equal to .20,...

  • Need some help with this operations management question. It'd also be nice if you could explain...

    Need some help with this operations management question. It'd also be nice if you could explain how you got your answer. Thanks. National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Feb Mar Sales (000)Units 16 15 12 May Jun Jul Aug 19 23 25 b. Forecast September sales volume using each of the following (1) A linear trend equation. (Round your intermediate calculations and final answer to 2 decimal places.)...

  • ASSIGNMENT: #2 a through c. NOTE: Problem 2b. (1), change toNaive with Trend 2. National Scan,...

    ASSIGNMENT: #2 a through c. NOTE: Problem 2b. (1), change toNaive with Trend 2. National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Feb. Mar. Apr. May Jun. Jul. Aug Sales (000 units) 19 18 15 20 18 22 20 a. Plot the monthly data on a sheet of graph paper. b. Forecast September sales volume using each of the following: (1) The naive approach. (2) A five month moving average....

  • Problem 3-2 National Scan, Inc., sells radlo frequency Inventory tags. Monthly sales for a seven-month period...

    Problem 3-2 National Scan, Inc., sells radlo frequency Inventory tags. Monthly sales for a seven-month period were as follows: Sales Month(ee)Units Feb Mar Apr May Jun Jul Aug 2e 23 25 18 28 30 b. Forecast September sales volume using each of the folloWng: (1 A linear trend equation.(Round your Intermedlate calculatlons and final answer to 2 declmal places.) Yt thousands (2) A five-month moVing average. (Round your answer to 2 declmal places.) Moving averagehousands (3) Exponentlal smoothing with a...

  • Assume that your stock of sales merchandise is maintained based on the forecast demand. If the...

    Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on the first day of each month, compute your forecast sales by each of the three methods requested here. ACTUAL June 154 July 194 August 225 a. Using a simple three-month moving average, what is the forecast for September? (Round your answer to 2 decimal places.) b. Using a weighted moving average, what is the forecast for September with weights...

  • The monthly sales for Yazici batteries were as follows on January 21, February 20, March 16,...

    The monthly sales for Yazici batteries were as follows on January 21, February 20, March 16, April 15.May 15,June 18,July 17,August 18, September 22, October 20, November 21, December 24. forcast for the next month (Jan) using the naive method. The forecast for the next period (Jan) using the 3-month moving approach. Using smoothing with a=0.30 and a September forecast of 18.00 the forecast for the next period (Jan) sales.

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT