Seasonal-component analysis, Mechanical Engineering

Assignment Help:

Seasonal-Component Analysis:

A food processor uses a moving average to forecast next month's demand. Actual demand data for the past few months is available as depicted in the following table.

 

618_Seasonal-Component Analysis.png

 (a) Calculate a simple five-month moving average to forecast demand for month 22.

 (b) Calculate a weighted three month moving average where the weights are highest for the latest month and descend in order of 3, 2, 1.

Solution

 (a) While only one 5-month moving average is needed, it is taken as the average of the demand for the last 5 months for which the data is available.

So, MA = (117 + 108 + 110 + 101 + 94) /5 = 106 units

Therefore forecast for the 22nd month = 106 units

This value of MA is a deseasonalised monthly demand. While the actual demand for 22nd month becomes known, a new moving average is computed by dropping the oldest monthly demand (that means of 17th month) and including the most recent one of 22nd month.

 (b) MAweight = ∑ (weight) (X ) /∑ (weight)

Weight            Value   Total

3          ×          117      =          351

2          ×          108      =          216

1          ×          110      =          110

----------------------------------------

                                              677

∴ MAweight = 677/6 ≅ 113 units.

Let us take another instance. The actual demand for trailors for the months of year 2000 are shown in Table. The moving average may be calculated by averaging the first n items of data into a single number (where n is the number of items of data to be averaged). The grouping is then incremented by one data-item. The three-month moving average for third to the last month is shown in the third column, while forecasts for the fourth month and subsequent months are depicted in 4th column. The difference of actual demand and forecast demand is shown in the last column.

For selecting the value of n, it must be kept in mind that the larger the value of n, the greater the dampening or smoothing effect. A large n shall show the entire trend but can obliterate seasonal cycles. Alternatively, smaller n has very little smoothing effect and the moving average tends to resemble the original data.

Table: Three Months Moving Averages

568_Seasonal-Component Analysis1.png

The ratio of actual demand in a given period to the moving average demand for the same period is known as the specific seasonal index. Its value determines the seasonal effect and some random influences of the period for which it is calculated. By averaging the values of the specific seasonal index for the same period in successive years the remaining random influence may be smoothened out, and thus seasonal effects can be isolated.


Related Discussions:- Seasonal-component analysis

Exhaust manifold-basic components of engine , Exhaust Manifold : The pipe ...

Exhaust Manifold : The pipe which connects the exhaust system to the exhaust valve of the engine through which the products of combustion escape into the atmosphere is called the

How can heat be applied to acrylic, In most hardware stores, you can find w...

In most hardware stores, you can find what has known as a Heat Gun. Hold the heat gun about 6 inches away from the acrylic you intend on bending say the bumper on a car. They are p

DEVELOP A COMPUTER PROGRAM, Develop a computer program that can be used for...

Develop a computer program that can be used for internal flow analysis in SI units. The program should be able to: ? Get the required input data from the user ? Decide the flow ty

Describe the term critical insulation thickness, Q. Describe the term ‘Crit...

Q. Describe the term ‘Critical Insulation thickness'. What is its significance? Derive an expression for the critical insulation radius of a spherical system. A bar of square cr

Determining the largest eigenvalue, The Power Method is a classic numerical...

The Power Method is a classic numerical algorithm for determining the largest eigenvalue and eigenvector associated with a matrix A. Write a matlab function that returns the larges

Determine frequency of free oscillations, (a) Illustrate critical damping a...

(a) Illustrate critical damping and its uses. (b) A horizontal spring mass system with coulomb damping has a mass of 5 Kg attached to a spring of stiffness 1KN/m. if the coeffic

Loop transfer function, Obtain the closed loop transfer function of the sys...

Obtain the closed loop transfer function of the system shown:

Law of superposition - mechanics, Law of superposition: When the two f...

Law of superposition: When the two forces are in equilibrium (equal, collinear and opposite), their resultant is zero and their combined action on rigid body is equivalent to

Dead centre -engine terminology , Dead Centre The position of the wor...

Dead Centre The position of the working piston and the moving parts which are mechanically connected to it, at the moment when the direction of the piston motion is reserved

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