Skip to main content

What is Exponential Smoothing Forecast Method?

 Exponential Smoothing Forecast Method: It is a time series used previous data to forecast future data. It is used to forecast short term data. It does not able to forecast future trend with the help of previous data. It is a simple method to forecast future demand with the help of past actual demand data and by using alpha.

Formula:

Ft = αAt-1 + (1-α) Ft-1

Where,

Ft = Forecast demand for week t

Αt-1 = previous period actual demand

Ft-1 = previous period forecast demand

And α =Smoothing constant

Common Measures of Error

Mean Absolute Deviation (MAD):

MAD = Ʃ ǀ actual –forecast ǀ / n

Mean Squared Error (MSE):

MSE = Ʃ (forecast errors) 2 / n

Mean Absolute Percentage Error:

MAPE = 100* Ʃ ǀ actual i –forecast i ǀ/actual i / n

Example: Find out the future demand with the help of using exponential smoothing forecast method. Alpha (α) is 0.2.

Time period

Actual Demand(At)

Forecast demand(Ft)

1

480

300

2

460

-

3

340

-

4

490

-

5

400

-

6

370

-

7

580

-

 Solution:

Time period

Actual Demand(At)

Forecast demand(Ft)

At-Ft

(At-Ft)2

1

480

300

180

32400

2

460

336

124

15376

3

340

360.8

-20.8

432.64

4

490

356.64

133.36

17784.89

5

400

383.31

16.69

278.5561

6

370

386.65

-16.65

277.2225

7

580

383.32

196.68

38683.02

 

Ft = αAt-1 + (1-α) Ft-1

= 0.2(480) + (1-0.2)300

= 96 + 0.8*300

= 96+240

F2=336

Ft = αAt-1 + (1-α) Ft-1

= 0.2(460) + (1-0.2)336

= 92 + 268.8

F3= 360.8

Ft = αAt-1 + (1-α) Ft-1

= 0.2(340) + (1-0.2)360.8

= 68 + 288.64

= 356.64

Ft = αAt-1 + (1-α) Ft-1

= 0.2(490) + (1-0.2)356.64

= 98 + 285.31

= 383.31

Ft = αAt-1 + (1-α) Ft-1

= 0.2(400) + (1-0.2)383.31

= 80 + 306.65

= 386.65

Ft = αAt-1 + (1-α) Ft-1

= 0.2(370) + (1-0.2)386.65

=74 + 309.32

= 383.32

Example: Find out the “α” with the help of given information:

Time

Actual demand (At)

Forecast demand (Ft)

1

80

80

2

72

80

3

85

76

 

Solutions: With the help of Forecast method we calculate “α”:

Let’s take F3 value:

Ft = Ft-1 + α (At-1-Ft-1)

76 = 80 + α (72-80)

 76 = 80 + (-8α)

-4/-8= α

And α = 0.5

Example: Find out the mean squared error and mean absolute deviation with the help of following information:

Time period

Actual Demand(At)

Forecast demand(Ft)

1

265

290

2

325

300

3

340

320

4

280

360

5

400

260

6

320

275

7

220

330

8

260

290

 Solution:

Time period

Actual Demand(At)

Forecast demand(Ft)

At - Ft

ǀ At – Ft ǀ

(ǀ At – Ft ǀ)^2

(ǀ At – Ft ǀ / At)*100

1

265

290

-25

25

625

9.43

2

325

300

25

25

625

7.69

3

340

320

20

20

400

5.88

4

280

360

-80

80

6400

28.57

5

400

260

140

140

19600

35.00

6

320

275

45

45

2025

14.06

7

220

330

-110

110

12100

50.00

8

260

290

-30

30

900

11.54

Total

 

 

 

475

42675

162.18

MAD = Ʃ (ǀ actual –forecast ǀ)/ n

          = 475/8

          = 59.38

MSE = Ʃ (forecast errors) 2 / n

        = 42675 /8

       = 5,334.38

MAPE = 100* Ʃ ǀ actual i –forecast i ǀ/actual i / n

            = 162.18/8                                                  

           = 20.27                                                                                                                                                                                                                                                                                                                                                                  

 

 

 

 

 

 

 

Comments

Popular posts from this blog

How to calculate Cost of Preference Share Capital?

Cost of Preference Share Capital:  An amount paid by company as dividend to preference shareholder is known as Cost of Preference Share Capital. Preference share is a small unit of a company’s capital which bears fixed rate of dividend and holder of it gets dividend when company earn profit. Dividend payable is not a tax deductible amount. So, there is no tax adjustments required for comparing with cost of debt. Formula for Cost of Preference Share: Irredeemable Preference Share Redeemable Preference Share K p  = Dp/NP K p  = D p +((RV-NP)/n )/ (RV+NP)/2 Where, K p  = Cost of Preference Share D p  = Dividend on preference share NP = Net proceeds from issue of preference share (Issue price – Flotation cost) RV = Redemption Value N = Period of preference share Example:  A company issues 20,000 irredeemable preference share at 8% whose face value is Rs.50 each at 4% discount. Find out the Cost of ...

What is the difference between Cheque book and Pass book?

 Cheque book is issued by bank in customers / account holder request. With the help of this book account holder can withdraw cash from his/her account. Bank does not charge any fee to issued cheque book to its customer. But afterward bank charges some amount for using bank facility like cheque book, Debit card etc.So, Automatic some definite amount deducted from customer bank account. Pass book is  also issued by bank to its customer. It helps to record all the bank related activity according to date that is withdrawal and deposit. It is recorded by bank but the book is kept by customer to know the current balance of  his /her account.  Point of difference Pass book Cheque book What is the meaning of pass book and cheque book? Passbook is a book in which all withdrawal and deposit against customer account is recorded.   Cheque book is a book of cheques which are used to withdrawal the money to b...

Numericals with solutions of Net income Approach

Net income approach questions and answers:   Questions:  Find out the value of the firm with the help of given information: Particulars Amount Earnings before interest and tax 3, 50, 000 Cost of equity 10% Cost of debt 7.2% Debenture 1,00,000 Find out the overall cost of capital with the help of net income approach. (Assume tax rate-10%) Solution: Particulars Amount Earnings before interest and tax 3, 50, 000 Less: Interest @7.2% 7, 200 Earnings before tax 3, 42, 800 Less: Tax@10% 34, 280 Net income 3, 08, 520 Cost of equity 10% Market value of equity (S =net income/ cost of equity) 30, 85, 200 Market value of debt (B) 1, 00, 000 Value of the firm (S+B) 31, 85, 200 Questions:  Find out the overall cost of capital if the equity capitalisation rate is 12...