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

Question

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 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, assuming a a March

forecast of 19(000).
(5) Alineartrendequation.

business Operations-Management

Add a comment Improve this question Transcribed image text

Answer 1

✔ Recommended Answer

Answer #1

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

1. (1) The naive approach.

The naïve approach takes last period sales as the forecast for next period. Hence, the naïve forecast for September is 20,000 units

2. (2) A five month moving average 1 Month Sales Forecast (5 month moving average) 2February19000 3 March 18000 4April15000 5 May 20000 6 June 1000 MA July 2200

Forecast for September using 5 month moving average is 19000 units

-----------------------

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

xSUMPRODUCT(B6:B8,C6:C8) D9 1Month Sales Weights Forecast 2February19000 3 March 18000 Apri 15000 4 May 20000 0.10 June 18000

Forecast for September using weighted moving average is 20,4000 units

-----------------------

4. (4) Exponential smoothing with a smoothing constant equal to 0.20, assuming a March forecast of 19(000).

alpha - smoothing constant Dt-demand of period t Ft- Forecasted value of period t 4 7 Month Sales Forecast 8 February19000 9 2 alpha - smoothing constant Dt-demand of period t Ft-Forecasted value of period t 4 7 Month SalesForecast 8 February 19000 9

Forecast for September = 19261.18 units

-----------------

5. (5) A linear trend equation

1 Month Month Sales 3 February 1 B3 C3 -C3 C3 19000 ВЗВЗ 4 March 2 B4 C4 -C4 C4 18000 B4 B4 B5*C5 -C5 C5 B5 B5 5 April 6 Ma 1 MonthMonth Sales 3 Februa 19000 190003610000001 4 March 2 18000 360003240000004 5 April 45000 2250000009 6 Ma 4 80000 40000

or september x 8 forecast for september 16857.14+500 (8)

Add a comment

Answer 2

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

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...
2. National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were...

2. National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Sales (000 units) Month Feb. 19 Mar. 18 15 Apr. May 20 Jun. 18 Jul. 22 Aug. 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. Compute the multifactor productivity measure for each of the weeks shown for...
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....

A can opener manufacturer has had monthly sales for a seven-month period as follows: Month ...

A can opener manufacturer has had monthly sales for a seven-month period as follows: Month Sales (000 units) Feb. 19 Mar. 18 Apr. 15 May 20 Jun. 18 Jul. 22 Aug. 20 a) Plot the data b) Forecast September's sales volume and the previous months and calculate MAD for each method using each of the following: 1)The naïve approach. 2)A four-month moving average. 3)A weighted average using .50 for the recent month, .30 for 2 months ago, and .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.)...
The monthly sales for Yazici Batteries, Inc., were as follows:

The monthly sales for Yazici Batteries, Inc., were as follows: Month Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov DecSales 19 21 17 14 11 18 16 19 20 20 23 23b) The forecast for the next month (Jan) using the naive method (round your response to a whole number)The forecast for the next period (Jan) using a 3-month moving average approach =(round your response to two decimal places)The forecast for the next period (Jan) using a 6-month weighted average with weights ofandwhere the heaviest weights are applied to the most recent month = (round your response to one decimalplace)Using...

The monthly sales for Yazici Batteries, Inc. were as follows: Month Jan 20 Feb 21 Mar...

The monthly sales for Yazici Batteries, Inc. were as follows: Month Jan 20 Feb 21 Mar 16 Apr May 15 13 Jun 18 Jul 15 Aug Sept Oct Nov Dec 18 19 22 202 This exercise contains only parts de 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 sales (round your...

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

Homework Answers

Add Answer to:
National Scan Inc. sells radio frequency inventory tags. Monthly sales for a seven-month period were as...

Post as a guest

Earn Coins