[go: up one dir, main page]
Scribd
Upload
5 views3 pages

Question 3

The document presents a demand forecasting analysis using both moving averages and exponential smoothing methods for a series of months. It details the calculations for moving averages and provides a formula for exponential smoothing with a specified alpha value of 0.3. Additionally, it includes calculations for a specific statistical measure, resulting in a percentage value.

Uploaded by

Jas Mol
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
5 views3 pages

Question 3

The document presents a demand forecasting analysis using both moving averages and exponential smoothing methods for a series of months. It details the calculations for moving averages and provides a formula for exponential smoothing with a specified alpha value of 0.3. Additionally, it includes calculations for a specific statistical measure, resulting in a percentage value.

Uploaded by

Jas Mol
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Question 3:

Month Demand Moving average

1 120

2 135

3 150

4 160 120+135+150
=135
3
5 175 135+1 50+1 6 0
=148.3
3
6 185 150+160+175
=161.7
3
7 195 160+175+185
=173.3
3
8 200 175+185+195
=185
3
9 215 185+195+200
=193.3
3
10 225 195+200+215
=203.5
3
B)The formula for exponential smoothing is:

Where:

 Ft= Forecast for month t


 Dt−1= Actual demand for previous month
 Ft−1 = Forecast for previous month
 α=0.3

Month Demand Forecast(α=0.3)

4 160 140

5 175 0.3(160)+0.7(140)=146

6 185 0.3(175)+0.7(146)=154.3

7 195 0.3(185)+0.7(154.3)=163.7

8 200 0.3(195)+0.7(163.7)=173.6

9 215 0.3(200)+0.7(173.6)=181.5

10 225 0.3(215)+0.7(181.5)=191.1
c)

(20+29+ 30.7+31.3+26.4 +33.5+33.9)


= 7

205.8
= 7

=29.26

2)

100
= 7 × (12.5+16.57+16.59+16.05+13.2+15.58+15.07)

=15.08%

You might also like