National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven month period were as follows: Months                 Sales (in thousand units) February                            15 March                                19 April                                   12 May                                    21 June                                   23 July                                    24 August                              27 a. Using the Naïve method in order to forecast September sales volume. b. Using linear trend equation in order to forecast September sales volume. c. Using five-month moving average in order to forecast September sales volume.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section: Chapter Questions
Problem 42P: The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars)...
icon
Related questions
Question

National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven month period were as follows:
Months                 Sales (in thousand units)
February                            15
March                                19
April                                   12
May                                    21
June                                   23
July                                    24
August                              27
a. Using the Naïve method in order to forecast September sales volume.
b. Using linear trend equation in order to forecast September sales volume. c. Using five-month moving average in order to forecast September sales volume.
d. Using weighted moving average of 0.80 for August, 0.05 for July, and 0.15 for June in order to forecast September sales volume.
e. Using Exponential smoothing with a smoothing constant equal to 0.25 and assuming a March forecast of 18(000) in order to forecast September sales volume.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 4 images

Blurred answer
Knowledge Booster
Forecasting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Contemporary Marketing
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing