Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Carl Wright, Inc. specializes in direct mail coupon advertising for major food manufacturers. One client has run 10 advertising campaigns weekly using this medium. The
Carl Wright, Inc. specializes in direct mail coupon advertising for major food manufacturers. One client has run 10 advertising campaigns weekly using this medium. The response rate for cupouns for the lastg 10 campaigns which were taken consecutively over the last 10 weeks are as follows Campaign Response % 1 4.6 2 2 5.2 3 4.8 4 5.3 5 4.5 6 5.9 7 5.2 8 5.4 9 4.7 10 4.9 c. Use Exponential Smoothing as follows: with Data Table determine the best alpha value based on MAE. Let alpha change in increments of 0.05. (i) Demonstrate the application of exponential smoothing using the alpha value you found above, for the first four periods only. (that is, show your calculations for the first 4 periods by applying the exponential smoothing method). d. Use WMA of 3-periods, with W1 = 0.7, W2 = 0.2, and W3 = 0.1 to make the same forecasts as in question 'b'. Carl Wright, Inc. specializes in direct mail coupon advertising for major food manufacturers. One client has run 10 advertising campaigns weekly using this medium. The response rate for cupouns for the lastg 10 campaigns which were taken consecutively over the last 10 weeks are as follows Campaign Response % 1 4.6 2 2 5.2 3 4.8 4 5.3 5 4.5 6 5.9 7 5.2 8 5.4 9 4.7 10 4.9 c. Use Exponential Smoothing as follows: with Data Table determine the best alpha value based on MAE. Let alpha change in increments of 0.05. (i) Demonstrate the application of exponential smoothing using the alpha value you found above, for the first four periods only. (that is, show your calculations for the first 4 periods by applying the exponential smoothing method). d. Use WMA of 3-periods, with W1 = 0.7, W2 = 0.2, and W3 = 0.1 to make the same forecasts as in question 'b
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started