Example of simple exponential smoothing, Mechanical Engineering

Assignment Help:

Example of simple exponential smoothing:

A TV manufacturer utilizes simple exponential smoothing with α = 0.1 to forecast demand. For the first week of March, the forecast was 400 units while actual demand turned out to be 370 units.

1. Forecast the demand for the second week of March.

2. If the actual demand for the second week turned out to be 417 units, forecast the demand for the 3rd week. Continue forecasting for the subsequent four weeks. You can take actual demands for the subsequent weeks as 409, 388, 377, 445, and 410 units.

3. Develop an adjusted exponential forecast for this company. You may assume the initial trend adjustment factor Tt as zero and β = 0.1.

Solution

(a) Ft + 1 = Ft + α (Dt - Ft)

                     = 400 + 0.1 (370 - 400) = 397 units.

 (b)

707_Adjusted Exponential Smoothing.png

(c)        The trend adjustment is accomplished by total of a correction factor

[(( 1 -β )/ β ) Tt +1 )]   to the simple exponential forecast.

As the initial trend adjustment factor (given) Tt = 0, we have

March 1st Week

Tt + 1 = β (Ft + 1 - Ft) + (1 - β) Tt

= 0.1 (397 - 400) + (0.9) (0) = - 0.30

T(t +1) adj = Ft +1 +( 1 -β / β )T t +1

= 397 +( 0.9/0.1)  (- 0.30) = 394.30

The adjusted forecast for the second week of March = 394.30.

March 2nd Week

Tt + 1 = 0.1 (399 - 397) + (0.9) (- 0.30)

= 0.2 - 0.27 = - 0.07

F(t + 1) adj = 399 + 9 (- 0.07) = 398.37

The remaining values may be put in table form, as below.

606_Adjusted Exponential Smoothing1.png

The trend-adjusted forecast for the third week of April is Ft, adj   = 393.54 units whereas simple exponential forecast for the same week is 400 units.

The main reason for broad use of simple and adjusted exponential smoothing is that the forecast may be computerized quickly, requires very little memory space, and data can be updated easily. These methods are specifically useful to firms which have thousands of items in inventory. Since each forecast value contains all past forecast and demand data in the properly exponentially weighted manner, there is no requirement to maintain records of historical data (as in case of arithmetic moving averages). It is an effective and efficient method of forecasting with a built-in means of tracking the average while discounting the erratic random fluctuations.


Related Discussions:- Example of simple exponential smoothing

Cyclone dip tube length calculation., how can we calcute the length of dip ...

how can we calcute the length of dip tube and what are its effects on cyclone efficiency if we change its length

Linear problen, A paper mill produces two grades of paper viz. , X and Y. B...

A paper mill produces two grades of paper viz. , X and Y. Because of raw material restrictions, it cannot produce more than 400 tons of grade X paper and 300 tons of grade Y paper

Determine the work transfer, (a) Derive the mathematical expression for Ste...

(a) Derive the mathematical expression for Steady Flow Energy Equation. State the assumption made before the derivation. (b) The internal energy of a substance is provided by th

Calculate days of inventory, Calculate days of inventory: From the dat...

Calculate days of inventory: From the data provided in table 1 and 2, calculate days of inventory. Solution Average Inventory Investment = (Last year inventory + Curre

Load on beam, Load on beam: A beam AB as shown in the figure give...

Load on beam: A beam AB as shown in the figure given below is hinged at A and supported at B by a vertical cord that passes over two frictionless pulleys C and

Sizing a solar pv system, The Rusk's own fairly large house near San Franci...

The Rusk's own fairly large house near San Francisco and the following spreadsheet shows their month to month power use for two years.  1. What is their monthly average power us

Magnetic device with moving iron element , A singly excited magnetic device...

A singly excited magnetic device with a moving iron element is illustrated in the figure below. g = 0.10 mm d = 2.0 cm b = 3.0 cm Assume the mmf in the iron and th

Determine the stability of the closed loop system, Determine the stability ...

Determine the stability of the closed loop system whose open loop transfer function is Use the Nyquist criterion

Define cam - application of computers in manufacturing, Define Cam - Applic...

Define Cam - Application of Computers in Manufacturing CAM can be simply defied as "the application of computers in manufacturing." Most elaborately, CAM refers to the use

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd