Question
In: Operations Management
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 Not
attempted thousands
(3) Exponential
smoothing with a smoothing constant equal to .25, assuming a March
forecast of 15(000). (Round your intermediate forecast
values and final answer to 2 decimal places)
Forecast
Not attempted thousands
(4) The naive
approach.
Naive
approach
Not attempted thousands
(5) A weighted average
using .65 for August, .10 for July, and .25 for June.
(Round your answer to 2 decimal places.)
Weighted average Not attempted thousands
Solutions
Expert Solution
Do give a positive rating if you think this answer helped
keosha answered 1 month agoRelated 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.
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)...
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...
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...
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.
Problem # 1 The monthly sales for Telco Batteries Inc. were as follows: Sales Month &
Problem # 1
The monthly sales for Telco Batteries Inc. were as follows:
Sales
Month
(000 units)
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 coming January sales using each of the following:
The naïve approach
A 6-month moving average
A 6-month weighted average using 0.1, 0.1, 0.1, 0.2, 0.2 and
0.3, with the heaviest...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- 1. Identify a type of business and suggest how it could be improved using a lean...
- A local car dealer closes on Sundays at 6:00 pm. He counts the number of cars...
- Assignment #1: Sorting with Binary Search Tree (IN C LANGUAGE) Through this programming assignment, the students...
- what material has greater creep resistance and why? metal plastic or ceramic?
- Create a simple Graphical User Interface (GUI): Create new JFrameForm and use the Palette to drag...
- List five characteristics/traits that you think define who you are. Then, try to determine how those...
- (c) A 50 mm-diameter propeller was installed in a 150 mm-diameter water pipe and the propeller...
ADVERTISEMENT