Question

In: Accounting

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. 20
  Mar. 17
  Apr. 13
  May. 28
  Jun. 17
  Jul. 23
  Aug. 26
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 .30, 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, .10 for July, and .30 for June. (Round your answer to 2 decimal places.)

  Weighted average thousands

Solutions

Expert Solution

Ans

Given

Month

Sales

(000) units

Feb 20
March 17
April 13
May 28
June 17
July 23
Aug 26

b.

(1)

The linear trend equation is as below:-

y = a + bt

y = Forecast for peroid t

t = Specified number of time period

a = Value of Ft at t = 0

b = Slope of the line

Now,

b = nƩ(ty) - ƩtƩy / nƩt² - t)²

a = Ʃy - bƩt / n

t Month

y Sales

(000 units)

ty

2 (Feb) 4 20 40
3 (Mar) 9 17 51
4 (April) 16 13 52
5 (May) 25 28 140
6 (June) 36 17 102
7 (July) 49 23 161
8 (Aug) 64 26 182
Ʃt = 35 Ʃt² = 203 Ʃy = 144 Ʃty = 728
t)² = 1225

n = number of month = 7

t = 9 (Sept)

Now

b = 7 * 728 - 35 * 144 / 7 * 203 - 1225

= 5096 - 5040 / 1421 - 1225

= 56 / 196

= 0.29

a = 144 - 0.29 * 35 / 7

= 144 - 10.15 / 7 = 133.85 / 7

= 19.12

Now

y = a + bt

= 19.12 + 0.29 * 9 = 19.12 + 2.61

= 21.73

Hence, as per linear trend equation

Sales Forecast for month of Sept = 21.73 (000 units)

(2)

A five-month moving average is calculated by averaging Feb to June (a) , then March to July (b) & April to Aug (c).

These data points are

a = 20 + 17 + 13 + 28 + 17 / 5

= 95 / 5

= 19

b = 17 + 13 + 28 + 17 + 23 / 5

= 98 / 5

= 19.6

c = 13 + 28 + 17 + 23 + 26 / 5

= 107 / 5

= 21.4

So the Sept Sales Forecast = 21.40 thousand units

(4)

The naive approach takes the last period's actuals as the forecast for the next month

As Aug sales was 26 thousand units (as per given table)

Hence,

Naive Forecast for Sept = 26.00 thousand units

(5)

The weighted average calculation Sep has weights of 1 for each month except Aug 0.60

Weighted
(000) units Weighted Average
Weight Month Sales Sales Forecast
1.00 Feb 20 20
1.00 March 17 17
1.00 April 13 13
1.00 May 28 28
1.00 June 17 17
1.00 July 23 23
0.60 Aug 26 15.60
Sept 19.09

Hence,

Weighted Average of Sept = 19.09 Thousand Units


Related Solutions

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. 14 Mar. 20 Apr. 11 May. 22 Jun. 21 Jul. 25 Aug. 16 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...
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. 12 May. 22 Jun. 19 Jul. 24 Aug. 26 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 (4) The naive approach. Naive approach _______ thousands
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. 18 Mar. 17 Apr. 15 May. 22 Jun. 15 Jul. 24 Aug. 28 b. Forecast September sales volume using each of the following: (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 .20, assuming a March forecast of 18(000). (Round your intermediate calculations and...
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. 8 May. 17 Jun. 19 Jul. 20 Aug. 22 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...
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. 22 Apr. 8 May. 24 Jun. 19 Jul. 27 Aug. 22 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...
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. 12 Mar. 22 Apr. 9 May. 24 Jun. 19 Jul. 27 Aug. 24 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...
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. 18 Mar. 16 Apr. 15 May. 18 Jun. 20 Jul. 21 Aug. 23 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...
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows:
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: SalesMonth(000)UnitsFeb.19Mar.22Apr.8May.24Jun.19Jul.27Aug .22b. 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 .50 for August, .15 for July, and.35 for June. 
1. National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were...
1. National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales February 19 March 18 April 19 May 20 June 18 July 21 August 19 Forecast September sales volume using each of the following: a. The naive approach. b. A three-month moving average. c. A weighted average using 0.70 for August, 0.20 for July, and 0.10 for June. d. Exponential smoothing with a smoothing constant 0.30, assuming a March forecast of...
1. National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were...
1. 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. 8 May. 17 Jun. 19 Jul. 20 Aug. 22 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    21.42 Correct thousands (2) A five-month moving average. (Round your answer to 2 decimal places.) Moving average      ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT