Compute the forecast sale using α = 0.20 and α = 0.35 respectively. (Note: express all answers using 4 decimal places)

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.6: Moving Averages Models
Problem 19P: The file P13_19.xlsx contains the weekly sales of a particular brand of paper towels at a...
icon
Related questions
Question

Compute the forecast sale using α = 0.20 and α = 0.35 respectively.

(Note: express all answers using 4 decimal places) 

Exponential Smoothing
The following data shows the monthly sales (millions of pesos) of a product over the past
periods.
Actual
25.60
24.70
21.30
13.90
12.60
18.00
21.50
22.30
30.70
15.00
13.80
22.60
Data
Month May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19
Transcribed Image Text:Exponential Smoothing The following data shows the monthly sales (millions of pesos) of a product over the past periods. Actual 25.60 24.70 21.30 13.90 12.60 18.00 21.50 22.30 30.70 15.00 13.80 22.60 Data Month May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19
Expert Solution
steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,