3. National Mixer, Inc., sells can openers. Monthly sales for a seven-month period were as follows: , Sales Month (000 units) Feb. .. 19 Mar. 18 Apr. May Jun. Jul. 15 20 18 22 20 Aug. a. Plot the monthly data on a sheet of graph paper. b. 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 .20, assuming a March forecast of 19,000. (4) The naive approach. (5) A weighted average using .60 for August, .30 for July, and .10 for June. Which method seems least appropriate? Why? What does use of the term sales rather than demand presume? C.
3. National Mixer, Inc., sells can openers. Monthly sales for a seven-month period were as follows: , Sales Month (000 units) Feb. .. 19 Mar. 18 Apr. May Jun. Jul. 15 20 18 22 20 Aug. a. Plot the monthly data on a sheet of graph paper. b. 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 .20, assuming a March forecast of 19,000. (4) The naive approach. (5) A weighted average using .60 for August, .30 for July, and .10 for June. Which method seems least appropriate? Why? What does use of the term sales rather than demand presume? C.
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)...
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 5 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing