Question: Actual sales of a product are given as follows: Period 1 2 3 4 5 6 7 8 9 10 11 12 Actual sales 48

Actual sales of a product are given as follows:
Period            1         2        3        4        5        6        7        8        9       10        11        12                              

Actual sales      48       51      54      50      48      47      49      50       52      50       53        54  

Forecast for the first period is 51. Assume smoothing constant   = 0.4 and trend smoothing constant        

i) Forecast by exponential smoothing for each of the periods from 2 onwards. 

ii) Forecast by exponential smoothing including trend adjustment for the same periods.  

iii) Plot the actual sales given and identify the trend in the demand data. 

iv) Plot the forecasted sales in i) and ii), and check which one is closer to the actual ones overall.

Step by Step Solution

3.44 Rating (151 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

636ae4b0af527_233281.pdf

180 KBs PDF File

Word file Icon

636ae4b0af527_233281.docx

120 KBs Word File

Students Have Also Explored These Related Mathematics Questions!