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

Process selection in making a simple part, Process Selection in Making a Si...

Process Selection in Making a Simple Part You should first determine the part's function, the types of load and environment to which it would be subjected, the dimensional to

Production function for bicycles, Let B be the number of bicycles formed  f...

Let B be the number of bicycles formed  from F bicycle frames and T tires. Each bicycle require exactly two tires and one frame. a. Sketch the isoquants for bicycle production.

Scope of pipeline systems, Q. Scope of pipeline systems? This specifica...

Q. Scope of pipeline systems? This specification covers the specific materials, surface preparation, method of application, quality assurance, and repair necessary for the appl

Conceptual engineering phase in project development, Q. Conceptual engineer...

Q. Conceptual engineering phase? During this phase, a conceptual engineering estimate will be prepared by Project Management with input from all disciplines. Activities at t

Disadvantages of two stroke engine, Disadvantages of two stroke engine: ...

Disadvantages of two stroke engine: The following are some of the disadvantages of two stroke engine when compared with four stroke engine: 1. As firing takes place in ever

Data and tasks - rough-cut capacity planning, Expected quarterly sales in Y...

Expected quarterly sales in Year 1 (vehicles) The work content of a single unit of each product in each process has been estimated at: Using MS-Excel, calculate the workloads

Physics, State and explain parallelogram law of vectors

State and explain parallelogram law of vectors

Computer integrated manufacturing, methods involved in grouping the parts i...

methods involved in grouping the parts into families?

What are the causes of high fuel consumption, (a) What are the causes of hi...

(a) What are the causes of high fuel consumption? (b) How can the problem of "motorcycle pulls to one side" be corrected? (c) How can engine overheating problem be solved?

Determine concept of hydrostatic sensor paver machine, Determine concept of...

Determine concept of Hydrostatic sensor paver machine A sensor asphalt paver is a machine used to deal out, shape, and partially compact a layer of asphalt on the surface of a

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