Question

The monthly sales for Yazici Batteries, Inc., were as follows: MONTH SALES January 20 February 21...

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

MONTH SALES
January 20
February 21
March 15
April 14
May 13
June 16
July 17
August 18
September 20
October 20
November 21
December 23
  1. Plot the monthly sales data.

  2. Forecast January sales using each of the following:

    1. Naive method.

    2. A 3-month moving average.

    3. A 6-month weighted average using .1, .1, .1, .2, .2, and .3, with the heaviest weights applied to the most recent months.

    4. Exponential smoothing using an α = .3 and a September forecast of 18.

    5. A trend projection.

  3. With the data given, which method would allow you to forecast next March’s sales?

Please answer V. and C. at the bottom and show work Thank you

Homework Answers

Answer #1

b)

1) Naive method: It is the forecast method to have previous period actual value

Jan forecast = Dec actual = 23

2) 3 month moving average = Average (Oct+Nov+Dec) = (20+21+23)/3 = 21.33

3) Weighted average = Jul*0.1 + Aug*0.1 + Sep*0.1 + Oct*0.2 + Nov*0.2 + Dec*0.3 = 0.1*17 + 0.1*18 + 0.1*20 + 0.2*20 + 0.2*21 + 0.3*23 = 20.60

4) Exponential:

Forecast (t+1) = Forecast (t) + alpha*(Actual(t) - Forecast(t))

Oct = 18 + 0.3*(20-18) = 18.6

Nov = 18.6 + 0.3*(20-18.6) = 19.02

Dec = 19.02 + 0.3*(21-19.02) = 19.61

Jan = 19.61 + 0.3*(23-19.61) = 20.63

c) I will prefer to use exponential smoothing as it helps to factor in the demand fluctuation to give more realistic estimate and minimum error

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar 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.       21 Mar.      20 Apr.       17 May       22 Jun.       20 Jul.         24 Aug.       22 Plot the monthly data on a sheet of graph paper. 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)...
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. 16   Mar. 19   Apr. 11   May. 22   Jun. 19   Jul. 24   Aug. 21     b. Forecast September sales volume using each of the following:      (Fill in the blanks) (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...
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. 15   Mar. 15   Apr. 10   May. 27   Jun. 15   Jul. 23   Aug. 28     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...
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 15 Apr 12 May 28 Jun 17 Jul 24 Aug 28 b. Forecast September sales volume using each of the following: SHOW WORKS!!!! (1) The naive approach. (2) A five month moving average. (3) A weighted average using .60 for August, .10 for July, and .30 for June. (4) Exponential smoothing with a smoothing constant equal...
this question how The Naïve approach =20 National Scan, Inc., sells radio frequency inventory tags. Monthly...
this question how The Naïve approach =20 National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows Monthly Sales (000 units) Feb……... Mar……. Apr…….. May……. June……. July…….. Aug…….. 19 18 15 20 18 22 20 a) Plot the monthly data on a sheet of a graph paper b) Forecast September sales volume using each of the following (1) A linear trend equation (2) A five-month moving approach (3) Exponential smoothing with a smoothing...
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 (3) Exponential smoothing with a smoothing constant equal to .10, assuming a March forecast of 15(000). (Round your intermediate forecast values and final answer to 2 decimal places) Forecast _______
Actual sales for January through April are shown below: Observation Month Actual Sales (A) Forecasted Sales...
Actual sales for January through April are shown below: Observation Month Actual Sales (A) Forecasted Sales (F)   1 January 18 2 February 23 3 March 20 4 April 16 5 May a. Use exponential smoothing with α = 0.2 to calculate smoothed averages and forecast sales for May from the above data. Assume the forecast for the initial period (January) is 18. b. Calculate MSE, and MAPE.
Suppose a company has the following sales for the last six months (January – June): Month...
Suppose a company has the following sales for the last six months (January – June): Month Period Sales January 1 16 February 2 25 March 3 20 April 4 20 May 5 31 June 6 35 July 7 26 August 8 (a) Use this information to answer the following 7 questions: 6.Using January through July values, develop a linear trend equation for this time series (to 4 decimals). Please write the equation in the proper form. 7.Using your answer from...
Suppose a company has the following sales for the last six months (January – June): Month...
Suppose a company has the following sales for the last six months (January – June): Month Period Sales January 1 16 February 2 25 March 3 20 April 4 20 May 5 31 June 6 35 July 7 26 August 8 (a) Use this information to answer the following 7 questions: ques 1 given the information above 1.Use exponential smoothing (a= 0.10) to forecast the sales for August (to 2 decimals). What is the value? 2. Compute the MSE for...
Latest monthly sales for a company are as follows: Month Sales November 81 December 78 January...
Latest monthly sales for a company are as follows: Month Sales November 81 December 78 January 73 February 98 March Compute a 2-Month Moving Average forecast for March.