Question

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 average thousands  

    

(3)

Exponential smoothing with a smoothing constant equal to .50, assuming a March forecast of 19(000). (Round your intermediate forecast values and final answer to 2 decimal places)

    

  Forecast thousands  

   

(4) The naive approach.

    

   Naive approach thousands  

    

(5)

A weighted average using .60 for August, .20 for July, and .20 for June. (Round your answer to 2 decimal places.)

     

  Weighted average thousands  

Homework Answers

Answer #1

1)

from above forecast =10.429+2.143*8 =27.57 ( please try 27.55 or 27.56 id this comes out wrng due to rounding)

2)

five-month moving average =(28+23+15+27+10)/5=20.6

3)

exponential
Month Sales forecast
(000)Units
  Feb. 15
  Mar. 15 15.00
  Apr. 10 15.00
  May. 27 12.50
  Jun. 15 19.75
  Jul. 23 17.38
  Aug. 28 20.19
24.09

from above  forecast value =24.09 ( please try 24.10 if this comes wrong due to rounding)

4)

from  naive approach forecast =28

5)

Weighted average forecast=0.6*28+0.2*23+0.2*15=24.4

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. 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 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...
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 _______
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)...
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...
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 Plot the monthly sales data. Forecast January sales using each of the following: Naive method. A 3-month moving average. A 6-month weighted average using .1, .1, .1, .2, .2, and .3, with the heaviest weights applied to the most recent months. Exponential smoothing using...
Consider the following data: Monthly Profit of a Gym Month Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12...
Consider the following data: Monthly Profit of a Gym Month Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Profit ($) 6,150 5,903 5,304 5,077 5,320 5,998 7,419 6,299 6,012 Step 1 of 5: Determine the three-period moving average for the next time period. If necessary, round your answer to one decimal place. Step 2 of 5: What are the MAD, MSE and MAPE scores for the three-period moving average? Round any intermediate calculations, if necessary, to no less than...
Consider the following data: Monthly Profit of a Gym Month Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12...
Consider the following data: Monthly Profit of a Gym Month Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Profit ($) 5,3505,350 5,1035,103 4,8244,824 4,4374,437 5,0805,080 5,3585,358 5,8195,819 6,0916,091 5,8375,837 Step 4 of 5: What are the MAD, MSE and MAPE scores for the three-period weighted moving average forecast? Round any intermediate calculations, if necessary, to no less than six decimal places, and round your final answer to one decimal place.
The values of Alabama building contracts (in millions of dollars) for a 12-month period are as...
The values of Alabama building contracts (in millions of dollars) for a 12-month period are as follows. Click on the datafile logo to reference the data. 240 350 230 260 280 320 220 310 240 310 240 230 (b) Compare a three-month moving average forecast with an exponential smoothing forecast for α = 0.2. Which provides the better forecasts based on MSE? Do not round your interim computations and round your final answers to two decimal places. Three-Month Moving Average...
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 24...
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 24 13 20 12 19 23 15 Develop a three-month moving average for this time series. Compute MSE and a forecast for month 8. If required, round your answers to two decimal places. Do not round intermediate calculation. MSE: The forecast for month 8: (c) Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT