POM Module-2 - Ocred
POM Module-2 - Ocred
Layout Planning: Layout Types: Process Layout, Product Layout, Fixed Position
Layout Planning, line balancing, computerized layout planning- overview. CRAFT
Algorithm, ROC algorithm
Forecasting: Principles & methods, moving average, double moving average,
Regression methods, exponential smoothing, double exponential smoothing,
Forecasting error analysis.
PLANT LAYOUT
PROCESS LAYOUT
PRODUCT LAYOUT
GROUP TECHNOLOGY
Advantages. Group technology layout can increase the items given in List A and it can decrease
the 1tems given in List B.
List A
|. Component standardization and rationalization
Reliability of estimates
AR
-o o
Effective machine operation
Producuvity
Costing accuracy
Customer service
Order potential
List B
I. Planning effort
2 . Paper work
3 . Setting time
4. Down time
3 . Work 1n progress
6. Work movement
.
. Dverall production times
8. Finished part stock
9 . Owverall cost
Limitations. This type of layout may not be feasible for all situations. If the product mix is
completely dissimilar, then we may not have meaningful cell formation.
This type of layout is the least important for today’s manufacturing industries. In this type of layout the major
component remain in a fixed location, other materials, parts, tools, machinery man power and other supporting
equipment’s are brought to this location. The major component or body of the product remain in a fixed position
because it is too heavy or too big and as such it is economical and convenient to bring the necessary tools and
equipment’s to work place along with the man power. This type of layout is used in the manufacture of
boilers, hydraulic and steam turbines and ships etc.
Advantages Offered by Fixed Position Layout:
(i) Material movement is reduced
(ii) Capital investment is minimized.
(iii) The task is usually done by gang of operators, hence continuity of operations is ensured
(iv) Production centers are independent of each other. Hence, effective planning and loading can
be made. Thus total production cost will be reduced.
(v) It offers greater flexibility and allows change in product design, product mix and production
volume.
Limitations of Fixed Position Layout:
(i) Highly skilled man power is required.
(ii) Movement of machines equipment’s to production centre may be time consuming.
(iii) Complicated fixtures may be required for positioning of jobs and tools. This may increase
the cost of production.
LAYOUT DESIGN PROCEDURES
Manual methods. Under this category, there are some conventional methods like, travel chart
and Systematic Layout Planning (SLP).
Computerized methods. Under this method, again the layout design procedures can be classified
into constructive type algorithms and improvement type algorithms.
Construction tvpe algorithms
BREEAREE,
1. Flow o 2. Activil
materials 5""'--._ rulal:i-unshgz-s
" ._.,_--'"'___f i
3. Relation ship E
diagrasm <
4. Spacs . 5. EJ:IEEJH
reuirements il svailabds
B. Space
relabonship
cliBgram
. - -
T, Modilying —m — B Frachcal E
consideralions — — hmilalions '
S - iy
L!
9. Develop
|yt
altamatives
____________o e esanaian Salechon
10. Evaluation
Computerized Helative Allocation of Facilities Technigue (CRAFT)
CEAFT algorithm was originally developed by Armour and Buffa. CEAFT 15 more widely used than
ALDEF and COEELAT. It 15 an improvement algorithm. It stams with an initial lavout and improves
the layout by interchanging the departments pairwise so that the transportation cost is minimized.
The algorithm continues until no further interchanges are possible o reduce the transportation cost.
The result given by CRAFT 15 not optuimum in terms of mimmum ¢ost of transportabion. But the
result will be good and close w opuimum in majority of applications. Hence, CRAFT 15 mainly a
heuristic algonthm. Unformunately, plant lavout problem comes under combinatorial category. 5o,
usage of efficient heuristic like CRAFT 1s inevitable for such prohlem.
CRAFT requirements
1. Imitial layout
2. Flow data
3, Cost per unit distance
4, Total pumber of depanmenis
3, Fixed departments
Number of such departments
Locaton of those departments
f. Area of departments.
The steps of CRAFT algorithm are summarized below.
Step [, Input: 1. Number of departments
2. Mumber of interchangeable departments
J. Imitial layout
4, Cost matnx
3. Flow matrix
6. Area of depariments
Step 2. Compute centroids of departments in the present layout.
Step 8 Interchange the selected pair of departments. Call this as the NEW LAYOUT. Compute
centroids, distance matrix and total cost.
Step %. Is the cost of new layout less than the cost of the present layout?
Area of Departments
[department I 2 A 4 b
Are)
{5q. units) 16 16 24 16 5
Mep 2. Centroids of all the departments in the initial layout are calculaled and presented
below, Here, the left side of the layout 15 assumed as ¥ axis and the botom side of the layoul is
pssumed as the X axis.
(X,. ¥)= 2.6
(X Fai= 2,2
(X3 ¥a) = 7, 2
(X, ¥ = 8. 6
Xy, ¥l =5, 6
afep 3, The dislance between any two depariments 15 represented by rechlmear distance between
the centroads of the two departments.
d;=IX;
- X} + ¥, - ¥}
where (X, ¥} and (X, ¥} ore the centrowds of the Departments @ and j, respectively.
The distance matrix 15 shown below
From/To I 2 3 4 5
| - R Q9 b 3
2 Rl 5 11 1
3 i 5 i1
4 b 1) > - A
3 3 7 i 3 -
where
fii= Flow Trom Deparimem¢ 1o the Department §.
dyy = Distance from Department ¢ 1© the Depanment j.
¢y = CostfUnit distance of travel/tnp.
Total Cost Matnx [TC,1
FromsTo | 2 3 R 3
I - 21] I8 14 L]
. U 1] ) [
3 |& i = 0 all
- |& (] 3 - 1
3 0 (] 12 0 -
For the purpose of cosl calculation, an interchange between two depariments would mean thar
their present centroids are interchanged,
For each interchange, the pssocipted distance matnx 1= calculated. Then, the total cost of
handling 15 calcalated.
FromiT o | 2 3 5
| - | 3 | (] 1
2 il L 6 1
1 3 ‘| —~ 3 6
4 1{) A 3 - 3
5 7 3 fy 3 -
(X5, =T, 2
Distance MMairix
FromuT o | 2 3 R 5
| - | 1] 3 6 3
2 1) 5 4 7
1 3 3 —~ 0 6
4 b - L - 3
5 3 7 [y 3
(X, Y;i= 8 6
(X, Yol = 2.6
Distance MMatrix
FromuTo | 2 3 | 5
] I b h J
s T — 5 [ -
3 fy 5 - 5 g
Rl 3 | () 3 - £
5 3 4 ] I
(&3, Fal = 7, 2
(X, Fil =B 6O
Distance Matrix
FromuTo | 2 3 | 5
[ Ly d Ly 1
2 B - 3 3 0
3 4 5 1) T
| 4 5 1M - 3
) 3 5 7 3
(X., =8, 6
Distance Mairix
FromuTo | 2 & R 5
| - £ Ll | 3
2 Iy A 10 3
4 L 5 - 3 0
4 - 100 3 - 7
5 3 3 fy 7 -
Total cost = 20
From'T o | 2 3 4 2
| - g fy g 3
) 4 I 3 7
3 f 14] —~ > i
4 14 5 5 E 6
5 3 7 3 6 -
(X Yopm 2 2
(X3, Fip=3, 06
{-'f-l- Fq} =8 6
{xfil- I'..:I} = -|r| z
Distance Mairix
FromiT o | 2 3 5
| B g 3 6 il
7 4 T |} 5
1 5 1 —~ 5 0
4 b 11l 3 E 5
5 + 5 fy 3 -
Distance Mairix
From'T o | . K 4 5
I - - f 3 6
2z | - 5 7 [1]
1 i § £ 5
dq 3 Y, fy = 3
5 b 11l 5 3 -
1 and 2 2056
1 and 4 193
1 and 5 208
2 and 3 187
2 and 4 201
d and 4 178
3 and 5§ 183
4 and 5 163
Fig. 6.7 Summary ol approximate total cost due o pairwise mterchange of centrgids.
Step6. The mterchange which promises mimimum hamdling cost 15 selected for actual interchange
in the layouat.
The imerchange between 4 and 3 resulis into minimum cost of 163,
Step 7. This cost 15 compared with the cost of the present layout, Only i the cost due o
proposed interchange 15 less than the present layout cost, the mmterchange 1= & be actually made,
Otherwise go o Step 1.
In the problem considered, the approximate handling cost of 1623 is less than the present lavour
cost of 205. Hence, go 1w Step 8.
Step & Interchange can be made between 4 and 5. The lavout afier making actual interchange
between Departments 4 and 3 15 shown in Fig, 6.8 This s called Mew Lavout.
] 4 2
1 4 = q
2 3 4
F. =]
FromuTo 2 3
pE
A g
e e
etk
S
e |
3
5 =
e S
T
i 3
| ] [
Lad
—
Total cost = 181
Step 9. The cost of the New Layoul 13 compared with the cost of the Present Layoul.
If the cost of the Mew Lavout 15 less than the cost of the Present Loyowt, then treat the New
Layout as the Present Layout. Then go to Step 3. Otherwise 2o 1o Step 11.
In the problem, the new layout cost is |81 which is less than the present layout cost of 203.
Hence, trean the new layoul as the present layoul and go 10 Swep 5.
Step 5. Applving the rule of common border or equal area, all the possible puirwise miterchanges
are considered.
For each possibility, the centroids are interchanged and the resulting distance matrix and the
il cost of handling are computed. The results are given in Fig. 6.9,
Step & In the previous step, 1686 15 the minimum total cost. Corresponding pair 1s 3
and 4.
Step 7. Thiz minimuam cost of 166 1= less than the present layout cost of 181, Hence go o
Step 8,
Step 8. Interchange the selected pair of Departments 3 and 4. Call this as the New Layout. This
i3 shown in Fig. &.10.
1 5 =
K
2 o
. 4
4 i
Fig. 6,10 MNew layout,
f =u|E] +a,
K, +---+ak +--+a
XA
gl +H:.+"'+'fl__+"'+fl.
o_afitaf+otaf +osalf
a4, +dd o da
This concept 15 demonstraied vwsing Department 4 1m0 Fig. 6.11.
In Fig. &.11, the Department 4 15 divided into two regular shaped departments, P, and P,
= axb4+mnxl
¥ = =T.5
! R+8
. 5 . B
= =1.5
! B+8
(X,.¥1=(7515
Dietancg MMatrix
Fromd'T o I 3 3 4 9
I -~ - 3 | £} 7
2 - - () i | ]
3 5 fi - 5 4
il 1) i 5 f
9 T 11 4 o _
Since, the cost of the Mew Layout (187) 18 not less than the cost of the Present Layouat {181}, go o
Step 11,
- S 2
E d = i
c & &
4 b
Fig. 6.12 Final layoul.
This algorithm was developed by LR, King (19800, This algorithm considers the following data.
« Number of components.
= LOomponenl sequences,
Step 4, Compute binary equivalent of each ¢column and check whether the columns of the
matrnx are arranged in rankwise (high o kow from left 1o nght)? If not, go o Step 3; otherwise, 2o
o Step 7.
Step 5. Rearrange the columns of the matnx rankwise and compute the hinary equivalent of
ench row,
Step &, Check whether the rows of the matrix are arranged rankwise? If not go w Step 3;
otherwize, go o Step 7.
Component
MNumber Sequence
| | -2-3-4-2-5-6-3-4-1
2 13 - T =14 -15-14
- 15
3 B =12 =8 =11
4 P f-5-4-8
a 14 - 15 -142
£ O-10D-8-11-12
T T =14 = 15
£ | c3-h-2-5_-4_-8_4
4 T -13-14
| (3 9 -8 =10
Compoenent ()
| 2 3 = 3 & 7 # 0 | ()
1 | [ 0 ( { (} 0 | [ 0
2 | [ 0 ( 0 (b 0 I [ 0
3 | 1 0 ] { ( o I 1 i
= | 1 0 | 0 0 0 | 1 {
3 I 1 0 1 { () 0 I [ 0
b | [l 0 1 0 (b 0 I [l 0
7 i ] 0 (] 'L'I Ch ] (b ] i
Machine i 5 | 1 | 1 0 | 0 I 1 |
9 | [ 0 ( 0 I 0 () [ |
1 | [l 0 (l 0 1 0 {0 [ |
11 0 1 | ( 0 1 0 0 [ 0
12 {0 1 | (] 0 | 0 (b 1 {0
13 0 | 0 (] 0 ( o () l {
14 | 1 0 ( } (b ] 0 1 0
15 0 ] 0 ( | (b ] 0 [ 0
Eow No. | 2 o4 5 6 7 B 9 1 11 12 13 14 15
Binary
Egquivalent 5316 316 380 5RO 380 580 266 725 17 17 144 144 258 I08 296
Step 3. Rearrange the rows of the matnix rankwise (high to low from top 1o bottom). The
rowwise rearranged machine-component incidence matrix as follows:
Component {J)
L]
o T e T e B e R eT e
sg eg e
e e
—
—_——— ==
— 0
I
A
0o
= aor o R = e
=
SR =
oo
-
=
B = =
(3
- = =2
Machine | Id
15
= B3 = = —
L
)
= = =
= = =
eR
E—
m—
I
Step 4. The binary eguivalent of each column s computed and the ranks are summarized in
the following maltrix.,
Component {f)
Ll
Lo I e
R
o B
k- -E-E-N-
e T o B
el =
eB e
s U
e
s
==
B
o
o o oo
e B e e
Y P
e I
o [ s
v [
= =
B
e I e |
i
= e e A =3 =
Machine | 14
L
II.“.
= =
15
g -
¥
L3 -
= = = e
=
—_
= =
= =
= O
fl.l—
Il
Fank 10
9 Rank
s Y e
P — -
s~
= = e ==
o
e B B e B e IR
-
D e 23
Lh e e P
e
e Y .
e
Y e
s
o
o I
—
e
Machine ¢ 14 0 |2
|5 |3
|4
| 3
= e
-e —
OO =
s Y
| 1
b Y e eB [
eB [
e
|2
R
0
- [ o Ys
e
e
b Y o
= =
=0
e
1}
—
o
o
Srep &, Smmee the mows of the matnx 1n the previous step are not amanged mnkwise, go o
Step 3
Step 3. The rows of matnix in Step 5 are rearranged rankwise as shown below,
Component | )
DD
p—
e
p—
e L
- e
e B
. Y .Y
eB e eY
e Y
e o i
el
e——
G
el
T
—
Fod sn O
R o
e
sO
eR
—
3 =
G o
hMachine & I
-
—_ D D B i3
12
o Y o
OO i
L
i
—
— = =
— = e
10
o B B
i
s[ o
L4
-
=
T
15
15
Rank |
Step 4. The columns of the matrix in the previous iteration are given rankwise. Hence, go o
Step 7,
Step 7. The final machine-component incidence matnix is presented in the following matrix,
Final Machine-Component Incidence Motrix,
Component { )
| 5 4 N L 10 2 T 5 ':?
! I ] | | | | { ] [ [
3 | I | (] {) i} {l ] [ ()
i | ] | L} 0 i 0 () [} 0
5 | 1 | [l { () 0 i 1 i
fi I ] | (l { (h { i, [l {
] | I { (] () ] {l (b [ ()
2 | 1 0 L] 0 i { () 1 0
1 () [l { 1 | (} { () [l i
Machine¢ 12 i [l {0 | | i { i Ll b
0 i, 1 { ] {) | {l i, 1 ()
I0 i 1 { I 0 I 0 i [ {
Id i, 1 { (] { (} 1 I 1 |
15 i} [l {) (l { (} ] | 1 )
7 ] 1 { (l { ] ] I [ |
13 [ 1 {) (] {] [} ] [ [ |
Kank | 2 4 4 % & 7 8 L | ()
There are three machine-component cells. In the above matrix, there are some exceptional
elements, 2. machine ¥ 18 required in cell | and cell 2. If we get machine-component cells formation
withoul any overlapping on machine regquirement, then the formaton 15 said 1w have perfect block
chagonal form.
Nare, UOmne can assumie a final machine-component incidence matnx with perfect block diagonal
form. Then it may be disturbed suitably o obtain an initial machine-component form for RO
algorithm and again one will get the machine-component cell formaton with perfect block diagonal
form on application of ROC algorithm. This is left a5 an exercise,
Based on the above matrix, the machine-component groupimgs arg given in the following table.
20 °
10Pce —-15 Pcs
Pcs/Hr 10 -
5 -
Machine Capacity
5 Pcs/ Hour
Machine Capacity
5 Pcs/ Hour
Machine Capacity
10 Pcs/ Hour
Machine Capacity
5 Pcs/ Hour
Machine Capacity
Machine Capacity 10 Pes/ Hour
20 Pcs/ Hour
Machine Capacity
5 Pes/ Hour
20-
Pcs/ Hr
10-
- s
» “Line Balancing” in a layout means arrangement of machine
capacity to secure relatively uniform flow at capacity
operation.
» It can also be said as "a layout which has equal operating
times at the successive operations in the process as a
whole”.
Y
PO
Decide number of workstation
Decrease production cost.
W
Available time
Cycle time =
Desired output
Y Task Time
Number of work Stations =
Desired Actual Time
method as such without any modification by using the maximum rank positional weight as the
selection criterion in Step 11 for selection of a work element if we have a tie in List A.
The application of the whole procedure to a problem 1s summarized in the form of a table.
Example 7.1. Consider the assembly network shown in Fig. 7.2 which shows the precedence
relationships 1n assembling a product.
4
5 et
Fig. 7.2 Assembly network of a product. (The nodes from 1-10 represent the real tasks of the
product, while the number by the side of each node represents 1ts duration.)
The number by the side of each node represents the processing time in minutes. The required
production volume in 8-hour shift 15 24 completed assemblies. Design an assembly line using RPW
method.
Solution.
Production time
Cycle time (CT) =
Production volume
~ 8x60
= 20 minutes.
24
iy|
Compute the positonal weight of all the work elements in the network as shown in Fig. 7.3
The same details are also shown in Table 7.1.
A work element can be included in the List A if 1t can satisfy the following two conditions:
1. All its immediate predecessors are already assigned to some stations.
2. Its processing time 15 less than or equal to the UACT.
The calculations are summarized in Table 7.2.
16
b
3l
e L
FUNs Y s
31
21
Wh
18
=0 Ch
13
S
15 =
00
el s a
17
= WD
9
e
Economic forecasts. Government agencies and other organizations involve in collecting data
and prediction of estimate on the general business environment. These will be useful to government
agencies in predicting future tax revenues, level of business growth, level of employment, level of
inflation, etc. Also, these will be useful to business circles to plan their future actuvities based on the
level of business growth.
Demand forecast. The demand forecast gives the expected level of demand for goods or services.
This 15 the basic input for business planning and control. Hence, the decisions for all the functions
of any corporate house are mmfluenced by the demand forecast.
The factors affecting forecast are given below:
Business cycle
e Random variation
Customer’s plan
e Product’s life cycle
e Competition’s efforts and prices
« Customer’s confidence and attitude
e Quality
Credit policy
¢ Design of goods or services
¢ Reputation for service
e Sales effort
o Advertising
Forecasting in different functional areas of management such as Marketing, Production, Finance and
Personnel play a crucial role for planming ahead. The wvarious types of forecast i each of the
aforementioned areas are as follows:
Marketing
* Demand forecasting of products
e Forecast of market share
» Forecasting trend in prices
Production
Forecast of
e Materials requirements
Trends in material and labour costs
« Mamntenance requirements
e Plant capacity
Finance
Forecast of
o Cash flows
Rates ol expenses
e Revenues
Personnel
Forecast of
« Number of workers in each category
« Labour turn over
¢ Absenteeism
Forecasting 15 based on the pattern of events in the past. A pattern may solely exist as a function of
time. Such a pattern can be identified directly from historical data. Another pattern consists of
relationship between two or more variables. 50 it 15 important 0 understand the most common
demand patterns.
Historical pattern (Stationary pattern). This exists when there is no trend in data and when
the mean value does not change over time.
VARV VYA
Products with stable sales, number of defective items from a stable production process are
some of the examples.
Seasonal demand pattern. This demand pattern exists when the series fluctuates according to
some seasonal factor. The season may be months, quarters, weeks, etc. sale of refrigerators, sale of
soft drink, sale of wool items, elc.
Forecast T
variable
\/
Time
Fig. 4.2 Seasonal demand pattern.
Cyclical pattern. In this type of pattern, the length of a single cycle is longer than a year. The cycle
does not repeat at constant intervals of time.
The best examples are the prices of some metals, gross national product, etc.
A
Forecast L=
varnable #
Time
Forecasl
varibale
Time
Fig. 4.4 Trend pattern.
4.4 FORECASTING MODELS
The forecasting techniques can be classified into gualitative technigues and quantitative techniques.
These are presented helow.
Qualitative techniques use subjective approaches. These are useful where no data 1s available
and are useful for new products. Quantitative techniques are based on historical data. These are more
accurate and computers can be used to speed up the process.
£, = 'D.' - F:
where
Dy, = Demand for the period &
F, = Forecast demand for the period f, and
e, = Forecast error for the period .
Mean Absolute Deviation (MAD). 1t is the mean of absolute deviations of forecast demands
from actual demand values. The MAD i1s sometimes called as the mean absolute error (MAE).
SID
—F |
MAD ==
1
where
D, = Actual demand for the period 1
F, = Forecast demand for the period ¢
n = Number of time period used.
Mean Square Error (MSE). Mean square error is the mean of the squares of the deviations of
the forecast demands from the actual demand values. Usually the effects on operations of small
errors are not serious. These errors may be smoothed out by inventory or overtime work. It will be
difficult to have smoothed values for forecast even if there are few large errors. Consequently, a
method of measuring errors that penalizes large errors more than small errors 15 sometime desired.
The mean square error (MSE) provides this type of measure of forecast error.
(D - F;}I
MSE — r=|
where
D, = Actual demand for the period 1
F, = Forecast demand for the period ¢
n = Total number of errors used.
Mean Forecast Error (MFE). Mean forecast error (MFE) is the mean of the deviations of the
forecast demands from the actual demands,
where
D, = Actual demand for the period ¢
F, = Forecast demand for the period «
n = Number of years (time period) used.
Mean Absolute Percentage Error (MAPE). Mean absolute percentage error (MAPE) 15 the
mean of the percent deviations of the forecast demands from the actual demands.
1 = 1D —F|
MAPE =— X » 100
=l
I
Suppose that a forecast of 165 units had been made for the demand in every period for the data given
in Table 4.1. The calculations of these errors are as shown in the last two columns of Table 4.1.
k) + 5 45 575 27.165
MAD = E =4
5
375
MSE=——=113
3
MFE=+?5=+I
4.4.3 Simple Moving Average Method
A simple moving average 15 a method of computing the average of a specified number of the most
recent data values 1n a series.
The formula w compute the simple moving average (SMA) 15 as lollows.
l
M, = {D:—{n—l:l + Dr—[n—’-'_] + -+ DJ'—E + D.l—] + Dr]
I
where
M, = Simple moving average at the end of period r (It 18 to be used as a forecast for period
I+ 1).
D, = Actual demand in period 1.
H MNumhber of neriods included 1n each averave.
l 93
2 100
3 87 94.00
4 123 [003.33 94.00 29.00
3 90 100,00 103,00 ~13.00
6 96 103.00 100.00 — 4.00
7 [ &7.00 103.00 —28.00
8 78 83.00 87.00 ~ 9.00
9 106 86.33 83.00 23.00
10 104 96.00 56.33 17.67
11 89 99.67 96.00 =7.00
12 83 92.00 99.67 —-16.67
Weight MA, = =
IW,
=]
where i = 1, 2, 3 1f we use three periods moving averages. [ = 3 corresponds to the most recent time
period and § = 1 corresponds to the oldest time period.
W, = Weight for the time period 1.
In the example, W, = (0.2, W, = 0.3 and W; = (.5
4.4.5 Double Moving Average Method
Maodel:
Let the moving average period = n
First single moving average = M(n)
[DWr) — Dt —n)])
H
N M (t)—M
(1t —n)
M,(t—1)
"
1 60
2 70
3 B 71.66
4 60 71.66
3 B 77.66 73.66
6 68 72.00 73,77 B5.60 ~17.66
7 106 B7.33 79.00 68.44 37.56
B 75 83.00 80.77 104.00 —20.00
49 86 89.00 ®H.44 B7.44 - 1.44
10) 124 05.00 ®9.00 04.11 29.89
11 122 110.66 08.22 107.00 15.00)
12 87 111.00 1()5.55 135.55 —48.55
Explanation of solution.
n= 23
M(3) = (60 + 70 + 85)/3
71.66
M(4) M(3) + (Di4) — D(1))/3
71.66 + (60 - 60)/3
71.66
(Other single (simple) moving averages are calculated, in the similar way.
First double moving average = M.(2n - 1) = M,(5)
M,(5) = (71.66 + 71.66 + 77.66)/3 = 73.66
M3(6) = My(5) + |M,(6) — M(3)1/3
= 73.60 + (72 = 71.66)/3 = 73.77
New forecast for period say 10, made as of period 9 is
FI9 + 1) =2 % M{9) - My9) + {2 % 113 - 1) * [M(9) - My9)]}
2 x 89 - Bodd + (1 * 203 = 1)) (89 - BH.44)
178 — B6.44 + 2.56
Fr10) 9412
Comments:
1. This method 1s applicable to wrend data patterns.
2. The forecaster must have Zn data points to find a forecast and thus substantial data storage
15 needed.
3. This method can be used to forecast for any number of periods into the future.
4.4.6 Simple (Single) Exponential Smoothing Method
Another form of weighted moving average 15 the exponential smoothed average. This method keeps
a running average of demand and adjusts 1t for each period in proportion to the difference between
the latest actual demand figure and the latest value of the average.
FJ- = F.I'—l + (X r.:fl_] - Fl'—l::l
where
F, = Smoothed average forecast for period t.
F, ) = Previous perniod forecast.
¢ = Smoothing constant, weight given to previous data () < @ < 1).
D,, = Previous period demand.
If 15 equal to 1, then the latest forecast would be egual to the previous period actual demand
value. The preferred range for « is from 0.1 to 0.3.
The apphication of this technique 15 demonstrated using an example,
Example 4.1. A firm uses simple exponential smoothing with @ = (0.2 to forecast demand. The
forecast for the first week of Januvary was 400 units, whereas actual demand turned out to be 450
units.
Solution.
(a) The forecast for the second week of January 1s computed as shown below.
Fo=F_+aD_,-F_
Fo =400 4 0.2 (450 = 400)
= 410 units,
(b) The workings for the remaining weeks are shown in tabular form.
In Table 4.5 ninal forecast was available. If no previous forecast value 15 known, the “old
forecast’ starting point may be estimated or taken to be an average of the values of some preceding
periods.
4.4.7 Adjusted Exponential Smoothing Method
The simple exponential smoothing forecast 1s a smoothed average positioned on the current period.
It 15 taken as a next period forecast. In reality, trend exists in demand pattern of many businesses,
Hence, due recognition should be given to make correction in the demand forecast for trend also.
Adjusted exponential smoothed forecast model actually projects the next period forecast by
adding a trend component to the current period smoothed forecast, F.
Fr+] = F.r + Tr
where
Fo=ab,
(+ (1 —a)ilF,_ +1, )
Tr=fi|:F:—Fr—]]+“—m T,
where o and [ are smoothing constants. The trend adjustment T, utilizes a second smoothing
co-efficient, 3.
Example 4.2. Compute the adjusted exponential forecast for the first week of March for a firm with
the following data. Assume the forecast for the first week of January (F;;) as 60 and corresponding
initial trend (Ty) as 0. Let ¢ = 0.1, and B = 0.2.
Month
Jan. Feb.
Week I 2 3 + I 2 3
Demand 650 600 550 650 625 675 700 710
Solution.
First week of Jan.
F,=oD, _+(1-a)(F,_+T,_
0.1 (650) + 0.9 (600 + 0) = 605
I, =BF,-F_)+(-/T,_,
= (.2 (605 — 600) + 0.8 ()
= 1.00
Fooy =F,+T,=605+1
=606
The adjusted exponential smoothed forecast for the second week of January is 606,
Second week of Jan.
F, = 0.1 (600) + 0.9 (605 + 1) = 605.4
T, = 0.2 (6054 - 603) + 0.8 x 1.0 = (.88
F., =06054 + (.88 = 606.28
The remainder of the calculations are given in Table 4.6. The trend adjusted exponential
smoothed forecast for the first week of March 1s 644.04, 1.e. which 15 approximately 644 units.
Table 4.6 Adjusted Exponential Smooth Forecast for January and February
Comments:
l. Smoothing methods are well suited for short or immediate term predictions of a large
number of items.
2. Suitable for stationary data patterns.
3. Eliminates the need for storing the historical values of the variable,
4. A starting smoothed value and values for the smoothing constants (¢, ) are needed.
5. There 15 no good rule for determining the approximate values of the weighits.
4.4.8 Linear Regression
Regression means dependence and involves estimating the value of a dependent variable ¥, from an
independent variable X. In simple regression, only one independent variable 15 used, whereas n
multiple regression two or more independent variables are involved. The simple regression takes the
following form.
Y=a+ bX
where
Y = Dependent variable
X = Independent variable
a = Intercept
b = Slope (trend)
Y o X
Fig. 4.5 Graph showing simple regression.
Consider the model for the simple linear n_:g,rtflflinn which 15 shown below.
Y=a+ bX
The formulas to compute the constants of the model are given below.
~ EZXY —nXY
b
- IX - nX?
a=Y —bX
where
X =ZX/n and ¥ = ZV/n
and n 15 the number of pairs of observations made.
Exampie 4.3. A firm believes that 1ts annual profit depends on 1ts expenditures for research. The
information for the preceding six years is given below. Estimate the profit when the expenditure
15 6 units.
] 2 20
2 3 25
3 5 34
4 4 3
3 11 4()
) 5 31
7 6 ?
Solution.
Year X ¥ XY X*
] 2 20) 4() 4
2 3 25 TS L
3 5 34 170 25
4 4 30 120 16
5 11 440} () 121
] 3 31 155 25
Total (&) 30 180 1000 200
— 30 — 180
I = — 1" — T—
6 6
=5 =30
a=Y —bX
=3 -2=x5=20
The model 1s:
Y=a+bX=20+2X
The profit when expenditure is 6 units:
Example 4.4. Alpha company has the following sales pattern. Compute the sales forecast for the
yvear 11).
Year ] 2 3 4 5 6 7 8 .
Sales
(in Lakhs) W) ! I1 23 29 34 4() 45 56
Solution.
F=2-0
O
— 252
¥ = > =28
- Ex¥ —nmxY
b
R -l
380
-9 x0x28
=6.33
60 =9 %0 x0
a=Y
- bX
=28 - 633 X0 =18
Y =a+ bx
= 28 + 6.33x
=28 +633(X-3)
Y =28
+ 6.33 (X
- 5)
The forecast of sales for the year 10 15 computed by substituting X = 1(} in the above equation.
[ st Week June 20
2nd Week June 33
(a) Calculate a 3-week moving average for the data to forecast demand for the next week.
(b) Calculate a weighted average forecast for the data, using a weight of (0.6 for the most
recent data and weights of 0.3 and 0.1 for successive older data.
- Compute the adjusted exponential forecast for the first week of June for a firm with the
following data. Assume the forecast for the first week of April (FO) as 700 and corresponding
initial trend (T0) as 0. Let @ = 0.15, and f = (.25.
Month
April May
Week ] 2 3 4 | 2 3 4
Beta company has the following sales pattern during 2002 to 2010, Compute the sales forecast
for 2011.
Year | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
inLakhs) | 8 | 10 [ 13 | 25 | 35 | 39 | 45 | 50 | 60
Sales
The details of sales turnover of a Cement Company for the period 2004-2010 are given In the
following table. Compute the estimated sales for the year 2011.
Consider the following initial layout with unit cost matrix. Use the CRAFT pairwise interchange
B i
4 A B
¢ C D
Initial Layout
Ta A B C L
From
A ~ l &
B 2 - B |
C 0 1) - 2
D 5 2 2 —
Flow Matrix
Consider the following initial layout with unit cost matnx. Use the CRAFT pairwise interchange
techmgue 10 oblain the desirable layouwt
(3 i\
E A &
Initial Layout
To .! B L [
From
A — | | A
B 2 - 2 |
i () 2 - 2
N | 4 3 -
Flow Matrnix
. Consider the followang mitial layout with umit cost matrix. Use the CRAFT pairwise interchange
lechmque o obtain the desirable lavoul.
4 i B
Initial Layout
To A B L
From
A - ] il
B 2 - |
- 6 2 —
Flow Maitrix
Consider the following machine-component incidence matrix with 100 machines and 5
components. Obtain the fnal machine-component cells using Rank Order Clustering Algorithm.
Component
1 2 3 4 3
1 ] L 1 (]
2 ] () (] | (]
k. ] () { | {
Machine S| 1 0 0 0 0
5 ] o0 1 (]
y (] I (] () ]
T 0 I { () {
3 i 1 1 () ]
9 0 0 ] () ]
1 () ] () ]
Machine-Component Incidence Matrix