Question

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 of 0.30, 0.40, and 0.30 for June, July, and August, respectively? (Do not round intermediate calculations. Round your answer to 2 decimal places.)



c. Using single exponential smoothing and assuming that the forecast for June had been 142, forecast sales for September with a smoothing constant α of 0.30. (Do not round intermediate calculations. Round your answer to 2 decimal places.)

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

Question: 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.

Answer:

Forecast for September:

a. Simple Three-Month Moving Average = 191.00

b. Weighted Moving Average = 191.30

c. Exponential Smoothing = 179.58

Explanation:

a. Using a simple three-month moving average, what is the forecast for September?

Moving Average Forecast is given by:

Moving Average Forecast = (A1 + A2 + A3 + ... + An) / n

Therefore:

September Forecast = (225 + 194 + 154) / 3

September Forecast = 573 / 3

September Forecast = 191.00

b. Using a weighted moving average, what is the forecast for September with weights of 0.30, 0.40, and 0.30 for June, July, and August, respectively?

Weighted moving average is given by:

Weighted Moving Average Forecast = (W1 x A1 + W2 x A2 + ... + Wn x An)

Therefore:

September Forecast = ((0.30 x 225) + (0.40 x 194) + (0.30 x 154))

September Forecast = 191.30

c. Using single exponential smoothing and assuming that the forecast for June had been 142, forecast sales for September with a smoothing constant α of 0.30.

Given that:

α = 0.30

Ft = 142

Now:

Exponential Smoothing Forecast is given by:

Ft+1 = α x At + (1 - α) x Ft

Therefore:

July Forecast = 0.30 x 154 + (1 - 0.30) x 142 = 145.6

August Forecast = 0.30 x 194 + (1 - 0.30) x 145.6 = 160.12

September Forecast = 0.30 x 225 + (1 - 0.30) x 160.12 = 179.58

Add a comment
Know the answer?
Add Answer to:
Assume that your stock of sales merchandise is maintained based on the forecast demand. If the...
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: 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...

  • Please help. Im stuck on the exponential smoothing part of this problem. Here are the actual...

    Please help. Im stuck on the exponential smoothing part of this problem. Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to see which method was better over this period. MONTH ACTUAL January 110 February 130 March 150 April 170 May 160 June 180 July 140 August 130 September 140 a. Forecast April through September using a three-month moving average. (Round your answers to 1...

  • Forecast September sales volume using each of the following:

    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.

  • 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.)...

  • 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...

  • 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.

  • The historical demand for a product is as follows: Month Demand January 12 February 11 March...

    The historical demand for a product is as follows: Month Demand January 12 February 11 March 15 April 12 May 16 June 15 Stating any assumptions that you make answer the following questions. (i) Using a weighted moving average with weights of 0.60 for June; 0.30 for May and 0.10 for April, find the July forecast. (4 marks) (ii) Using a simple three-month moving average, find the July forecast. (4 marks) (iii) Using simple exponential smoothing with α=0,2 and a...

  • The monthly sales for Yazici Batteries, Inc., were as follows:

    The monthly sales for Yazici Batteries, Inc., were as follows:MonthJanFebMarAprMayJunJulAugSeptOctNovDecSales202115121518151922212124This exercise contains only parts b and c. b) The forecast for the next month (Jan) using the naive method = _______  sales (round your response to a whole number) The forecast for the next period (Jan) using a 3-month moving average approach = _______  sales (round your response to two decimal places) The forecast for the next period (Jan) using a 6-month weighted average with weights of 0.10, 0.10, 0.10, 0.20,0.20, and 0.30,...

  • The monthly sales for Yazici Batteries, Inc., were as follows: Jan Month Feb Mar Apr May...

    The monthly sales for Yazici Batteries, Inc., were as follows: Jan Month Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec 24 Sales 19 23 16 15 13 15 17 18 22 21 23 This exercise contains only parts b and c. b) The forecast for the next month (Jan) using the naive method 24 sales (round your response to a whole number) The forecast for the next period (Jan) using a 3-month moving average approach 22.67sales (round...

  • The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 36...

    The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 36 2 38 3 40 4 41 5 43 6 42 7 43 8 45 9 46 10 48 a. Calculate the single exponential smoothing forecast for these data using an α of 0.30 and an initial forecast (F1) of 36. (Round your intermediate calculations and answers to 2 decimal places.) b. Calculate the exponential smoothing with trend forecast for these data using an α...

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