Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Sales of Big screen Television (TV) have growth steadily during the past 5 years. A dealer predicted that the demand for February would be 148 TVs.

Actual demand in Feb was158 TVs. If the smoothing constant is α=1.3, the demand forecast for March, using the exponential smoothing model, will be: a)148 TV b)151 TV c)153 TV d)158 TV

user-image
Question added by Khalid Khan , Finance Manager / Chief Accountant , IDEAL ENTERPRISES LLC (Construction & Contracting)IDEAL LINK SOLUTIONS (IT SOFTWARE & HARDWARE)
Date Posted: 2014/03/10
Fadly Harahap
by Fadly Harahap , Founder & Director , PT Farindo Harapan Makmur

Simple forecast by averaging forecast and actual, is 153 the answer is c, we need buffer stock in april if sales is not on target on march, sales sometimes cannot be predicted due to demand trends and competior activites

Khalid Khan
by Khalid Khan , Finance Manager / Chief Accountant , IDEAL ENTERPRISES LLC (Construction & Contracting)IDEAL LINK SOLUTIONS (IT SOFTWARE & HARDWARE)

Answer is (B)151 TVs

Solution 

The Formula for exponential smoothing is:

F(t+1) = α [A(t)] + (1-α) [(t)]

Where:

F = Forecast

A= Actual

t = Current Time Period

α = the smoothing constant

February forecast = F(t) =148

February Actual = A(t) =158

March Forecast =  F(t+1) = α [A(t)] + (1-α) [(t)] = (0.3)(158) + (1-0.3)(148) = 151 TVs

More Questions Like This