Sales of Cool-Man air conditioners have grown steadily during the past 5 years: Year 1 2 3 4 5 6 7 8 9 10 11 Demand for Fertilizer (1,000 bags) d) e) f) 4 6 4 5 10 8 7 9 12 14 15 a) b) The sales manager had predicted, before the business started, that year I's sales would be 410 air conditioners. Using exponential smoothing with a weight of develop forecasts for years 2 through 6. Using smoothing constants of 0.6 and 0.9, develop forecasts for the sales of Cool-Man air conditioners. What effect did the smoothing constant have on the forecast for Cool-Man air conditioners? Which smoothing constant gives the most accurate forecast? c) Use a three-year moving average forecasting model to forecast the sales of Cool-Man air conditioners. Using the trend projection method, develop a forecasting model for the sales of Cool-Man air conditioners. Would you use exponential smoothing with a smoothing constant of 0.3, a 3-year moving average, or a trend to predict the sales of Cool-Man air conditioners?
Sales of Cool-Man air conditioners have grown steadily during the past 5 years: Year 1 2 3 4 5 6 7 8 9 10 11 Demand for Fertilizer (1,000 bags) d) e) f) 4 6 4 5 10 8 7 9 12 14 15 a) b) The sales manager had predicted, before the business started, that year I's sales would be 410 air conditioners. Using exponential smoothing with a weight of develop forecasts for years 2 through 6. Using smoothing constants of 0.6 and 0.9, develop forecasts for the sales of Cool-Man air conditioners. What effect did the smoothing constant have on the forecast for Cool-Man air conditioners? Which smoothing constant gives the most accurate forecast? c) Use a three-year moving average forecasting model to forecast the sales of Cool-Man air conditioners. Using the trend projection method, develop a forecasting model for the sales of Cool-Man air conditioners. Would you use exponential smoothing with a smoothing constant of 0.3, a 3-year moving average, or a trend to predict the sales of Cool-Man air conditioners?
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.3: Simple Regression Models
Problem 2P: The file P13_02.xlsx contains five years of monthly data on sales (number of units sold) for a...
Related questions
Question
Subpart A : Moving constant = 0.30
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 7 steps with 18 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