A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales during the last 15 days were a. Assume the data refer to demand rather than sales. Using trend-adjusted exponential smoothing with an initial forecast of 46 for Day 8, an initial trend estimate of 2, and α = β = .3, develop demand forecasts for Days 9 through 16. Then compute the resultant MSE using the error values from Days 8 through 15. (Round your intermediate period-by-period forecast and error values to 3 decimal places. Round your final MSE answer to 3 decimal places.) MSE = Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Number sold: 31 32 35 38 38 42 42 43 41 44 46 46 49 55 52
A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales during the last 15 days were a. Assume the data refer to demand rather than sales. Using trend-adjusted exponential smoothing with an initial forecast of 46 for Day 8, an initial trend estimate of 2, and α = β = .3, develop demand forecasts for Days 9 through 16. Then compute the resultant MSE using the error values from Days 8 through 15. (Round your intermediate period-by-period forecast and error values to 3 decimal places. Round your final MSE answer to 3 decimal places.) MSE = Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Number sold: 31 32 35 38 38 42 42 43 41 44 46 46 49 55 52
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
A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales during the last 15 days were |
a. Assume the data refer to demand rather than sales. Using trend-adjusted exponential smoothing with an initial MSE = |
Day: | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 |
Number sold: | 31 | 32 | 35 | 38 | 38 | 42 | 42 | 43 | 41 | 44 | 46 | 46 | 49 | 55 | 52 |
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 3 steps with 3 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