
(online) = ISSN 2285 – 3642 ISSNL = 2285 – 3642 Journal of Economic Development, Environment and People Volume 1, Issue 2, 2012
URL: http://jedep.spiruharet.ro email: office_jedep@spiruharet.ro 
Impact of weight indicators of TOPSIS technique in the selected district in the Slovak Republic
PhDr. Roman Vavrek, doc. Ing. Peter Adamišin, PhD.
University of Prešov, Slovakia
Abstract. The purpose of multicriteria decision models is to help decision maker to evaluate each alternative and to rank them in descending order of performance. This study analyses the concept of Multiple Attribute Decision Making for using in local government area. The aim of this paper is to analyze the concept of Multiple Attribute Decision Making for selecting the most efficient municipality in selected district in the Slovak Republic. Achieving this purpose, TOPSIS technique (in two variants) is used as decision making tools.
Keywords: TOPSIS technique, municipality, Prešov district
JEL Codes: H79
1. Introduction
According to [5] the aim of multicriteria decision is on a base of chosen criteria to select one variant which shows the best characteristics. However to be successful in this aim needs a huge amount of information which might not be available. Each of methods differs in providing ordinal or cardinal information about the order of each particular variant ( the importance of particular criteria) and whether they need ordinal or cardinal information for its use about particular variants towards particular criteria (about the preference of those criteria). According to [8] the ordinal (order) variable takes verbal value. Those are presenting categories. They have relative meaning because we can’t the difference between those categories. That is why you use cardinal (interval) variable which, according to [10] makes quantification. Moreover it makes quantification of differences between the categories.
According to [10] the basic advantage of evaluation on a base of more criteria is the fact, that they do not force reducing non  economic criteria to economic criteria at the expense of precarious or sparing operations.
According to [11] the first step is choosing of objects contained in analyze folder which is followed by choosing of concrete method of more criterion evaluation. Next step is a choosing of characteristics (indicator) characterizing a concrete object, which are considered to be important (the importance of each indicator) on a base of subjective preferences of each person individually. The obvious part is the identification of character of each indicator (whether it is the indicator of maximization or the one of minimization).
The process is divided by [5] of more criterion evaluation into following steps:
a) Creating of intentional set of criteria for evaluation with the important characteristics.
b) Making the list of the most important criteria.
c) The evaluation of results (outcomes, profits, and also lacks), variants, consisting of partly evaluation and the synthesis of those partly evaluations.
d) Considering the risk of realization.
e) Making the order list of variants and choosing the most sufficient one.
Other author [2] makes those following methods of more criteria evaluation the ones which are mostly used and also he explains why:
a) Simple method or the method of order summary
b) The method of points
c) The method of standard variable
d) The method of distance of fictive point
Last cited author [9] is describing the two categories of methods of more criteria evaluation of variants:
a) Methods based on partial evaluations of variants
 the method of summary (WSA)
 the method of base variant
b) Methods based on pairscomparing of variants
 the lexicographical method
 the method AHP (Analytic Hierarchy Process)
 the method TOPSIS (Technique for Order Preference by Similarity to Ideal Solution)
The method of summary is useful when you need to state quantitative criteria. But it expects linear dependence on behalf of criteria (indicators). The principle of base method is stating of the best values and then you are about calculating of each useful function alternative. The lexicographical method consists of the supposal and it is that the biggest influence has the most important criteria. In the case of congruence you observe the second and the next criteria in an order. The method AHP includes all of the factors that influence the result (connection in between and intension of how much they influence each other). The method of TOPSIS is based on choosing a variant which is closest to the one which has been chosen before and also the farthest from the base variant.
The municipality in some part of the Slovak republic was chosen for the purpose of this contemplation and the chosen method was the TOPSIS method.
2. TOPSIS technique
According to [7] the main concept behind TOPSIS (Technique for Order Preference by Similarity to Ideal Solution), as a technique for solving the Multiple Attribute Decision Making problems, is that the chosen alternative should have the shortest distance from the Positive Ideal Solution, and also have the farthest distance from the Negative Ideal Solution. Positive Ideal Solution is the solution that maximizes the benefit criteria and minimizes the cost criteria, while Negative Ideal Solution is the solution, which maximizes the cost criteria and minimizes the benefit criteria. Furthermore, TOPSIS alleviates the requirement of paired comparisons, and the capacity limitation may not significantly dominate the process. Hence, it is suitable for cases with a large number of attributes and alternatives, and especially handy for objectives with quantitative data.
„It is a rational and relatively simple method where the underlying concept is that the most preferred alternative should not only have the shortest distance from 'ideal' solution, but also the longest distance from an 'antiideal' solution.“ [12]
The other one characteristic by [4] is: “The basic concepts of TOPSIS are based on the predetermined positive ideal solution and negative ideal solution. The purpose is to find the alternative that is closest to positive ideal solution and farthest from the negative ideal solution. The positive ideal solution is the one with the most benefits and lowest cost of all alternatives, the negative ideal solution is the one with the lowest benefits and highest cost.“
Series of stages of TOPSIS technique are described by [7] as follows:
a) Construct normalized decision matrix.
b) Construct the normalized weighted decision matrix.
c) Determine the positive ideal and negative ideal solutions.
d) Calculate the separation measures (distance from PIS and NIS for each alternative).
e) Calculate the relative closeness to ideal solution.
f) Rank the preference order.
The same number of stages of TOPSIS techniques is identified by [1] as [7]. They indicate the little more detail 6 stages:
a) Construct the matrix of consequences.
b) Construct the matrix of normalized consequences.
c) Construct the weightednormalized matrix with the criteria importance coefficients.
d) Define the PIS vector and the NIS vector (the vector for minimal value of alternatives if the criteria is a minimal criteria or the maxim value of alternatives if the criteria is a maxim criteria).
e) Calculation of distance between the each alternative and the positive alternative and the calculation of distance between the each alternative and the negative ideal alternative.
f) Determination of the index to positive ideal solution.
3. Methodology
Used methods in this article we can divide in three categories:
a) TOPSIS technique,
b) Financial indicators,
c) Statics methods used to municipal valuation.
3.1. Topsis technique
According to [3] is the TOPSIS method based on choosing of an alternative, which is closest to the ideal variant and at the same time the farthest from the base variant. The supposal is maximal character of criteria.
We tend to [6], who considers the first step of the method making a matrix of criteria and then the summary of standard matrices. We can describe the calculus as following:
a) Construct starting criterial matrix (y_{ij}) a construction of vector weights (v_{1}, v_{2}, ..., v_{k}),
b) Construct criterial matrix R = (r_{ij}) of formula:
,
where i = 1, 2, ..., n; j = 1, 2, ..., k.
c) Construct the normalized weighted matrix W = (w_{ij}) of formula, where y_{j }– weight of jcriterion.
d) Using the matrix W elements is creating ideal variant (H_{1}, H_{2},..., H_{k}) and baseline variant (D_{1}, D_{2},..., D_{k}), where
,
where j = 1, 2, ..., k.
f) For the calculation of the distance from the ideal option () and baseline option () we use the formula:
, or ,
where i = 1, 2, ... n.
g) The last step is calculating a relative distance from baseline variant:
,
where i =1, 2, ... n.
Values c_{i} are in the range <0;1>, where 0 represents the basal variant 1 ideal option. The higher the value c_{i}, the greater is the distance from the baseline alternatives.
3.2. Financial indicators
The described method TOPSIS was used for evaluation of economy in villages belonging to Prešov county (the number of municipalities is 91). The charts consist of chosen villages because of the high number of municipalities in county (just for the illustration of method).
We used for municipal comparison these selected indicators (after consultation with municipalities):
a) R_{1} – total expenditure per capita,
b) R_{2} – borrowed funds to total municipal assets,
c) R_{3} – total income per capita,
d) R_{4} – current profit per capita,
e) R_{5} – return on assets,
f) R_{6} – current expenditure per capita,
g) R_{7} – borrowed funds per capita,
h) R_{8} – current income per capita,
The first indicator (R_{1}) describes only expenditure (cost = expenditure, i.e. is not examined law compliance) for one financial period per capita:
,
where: C – total expenditure,
PO – city population.
We can identify the construct of the second indicator (R_{2}) as follows:
,
where: CzZ – borrowed funds,
A  assets.
The third indicator (R_{3}) presents total income per capita:
,
where: P – total income,
PO – city population.
Current profit per capita in one financial period is the fourth indicator (R_{4}) that was calculated:
,
where: VH – current profit per capita,
PO – city population.
Return on assets (ROA) presents the fifth indicators (R_{5}) that is the basic indicator of evaluation of municipal management:
,
where: VH  current profit per capita,
A  assets.
Current expenditure per capita is the sixth indicator (R_{6}) that we can calculate:
,
where: C_{b} – current expenditure,
PO – city population.
The seventh indicator (R_{7}) borrowed funds per capita was calculated:
,
where: CzZ – borrowed funds,
PO – city population.
Current income per capita presents the last indicator (R_{8}):
,
where: P_{b} – current income,
PO – city population.
3.3. Used statistics methods
In addition to demonstrations and applications TOPSIS techniques such as multicriteria evaluation of the effectiveness of the algorithm municipalities, we focus in the next section to analyze the results of multicriteria algorithms.
Municipalities have scored TOPSIS technique quantified of municipality with lowest score were the best. We investigate whether the success factor has a significant effect size of municipality. This leads us to the assumption that the largest of municipality can both realize economies of scale, and have more qualified personnel infrastructure to effectively ensure all processes at of municipality level.
For analysis, we took off in addition to MS excel even further, specialized statistical programs (SPSS and Systat).
Appropriate coefficient to measure context was chosen KendallStuartovo tauc:
,
where: n_{c} – number of concordant pairs (i.e. ifk x_{i}>x_{j} a y_{i}>y_{j} or x_{i}<x_{j} a y_{i}<y_{j }for each sample consisting of nobservations of two variables Y and Y),
n_{d}  number of disconcordant pairs (i.e. if x_{i}>x_{j} a y_{i}<y_{j} or x_{i}<x_{j} a y_{i}>y_{j})
k – smaller value of m, n.
Both of these coefficients take values from 1 to 1. High value indicates a high degree of value dependence.
The significance testing of coefficients is based on the calculation of pvalues. The significance factor is accepted if the calculated pvalue less than 0,05.
4. Results
Since the method TOPSIS is choosing an alternative which is closest to the ideal variant and at the same time the farthest from the base variant we need to use the character of maximum of spotted indicators. Because of this reason were the indicators R_{1}, R_{2}, R_{6}, R_{7} multiplied by coefficient 1.
The first step of the TOPSIS method is making a criterion matrix.
Table 1: Criterion matrix in 2012

R_{1} 
R_{2} 
R_{3} 
R_{4} 
R_{5} 
R_{6} 
R_{7} 
R_{8} 
Abranovce 
0,078 
0,010 
0,127 
0,004 
0,008 
0,109 
0,007 
0,104 
Bajerov 
0,181 
0,307 
0,190 
0,007 
0,012 
0,254 
0,251 
0,247 
Bertotovce 
0,170 
0,185 
0,120 
0,024 
0,012 
0,120 
0,531 
0,113 
Brestov 
0,056 
0,066 
0,058 
0,000 
0,000 
0,079 
0,033 
0,076 
Bretejovce 
0,049 
0,025 
0,058 
0,013 
0,056 
0,068 
0,008 
0,065 
Source: Own calculations
The criterion matrix (table 1) creates a base for making a standard matrix. This matrix is considering the importance of each particular criterion (indicator), which was studied in two dimensions:
a) each of those indicator has the same weight, means 0,125,
b) each of those indicator has weight determined by municipal representatives (table 3).
Table 2: Weight ration of financial indicators

R_{1} 
R_{2} 
R_{3} 
R_{4} 
R_{5} 
R_{6} 
R_{7} 
R_{8} 
Weight ratio 
0,098 
0,197 
0,125 
0,188 
0,089 
0,098 
0,143 
0,062 
Source: Own calculations
The normalized weighted matrix obtained by weighting the individual indicators contained in table 3.
Table 3: Normalized weighted matrix in 2012

R_{1} 
R_{2} 
R_{3} 
R_{4} 
R_{5} 
R_{6} 
R_{7} 
R_{8} 
Origin weight rations of financial indicators 

Abranovce 
0,010 
0,001 
0,016 
0,000 
0,001 
0,014 
0,001 
0,013 
Bajerov 
0,023 
0,038 
0,024 
0,001 
0,001 
0,032 
0,031 
0,031 
Bertotovce 
0,021 
0,023 
0,015 
0,003 
0,002 
0,015 
0,066 
0,014 
Brestov 
0,007 
0,008 
0,007 
0,000 
0,000 
0,010 
0,004 
0,009 
Bretejovce 
0,006 
0,003 
0,007 
0,002 
0,007 
0,009 
0,001 
0,008 
Modify weight rations of financial indicators 

Abranovce 
0,008 
0,002 
0,016 
0,001 
0,001 
0,011 
0,001 
0,006 
Bajerov 
0,018 
0,060 
0,024 
0,001 
0,001 
0,025 
0,036 
0,015 
Bertotovce 
0,017 
0,036 
0,015 
0,005 
0,001 
0,012 
0,076 
0,007 
Brestov 
0,006 
0,013 
0,007 
0,000 
0,000 
0,008 
0,005 
0,005 
Bretejovce 
0,005 
0,005 
0,007 
0,002 
0,005 
0,007 
0,001 
0,004 
Source: Own calculations
With the help of elements of standard matrices (table 2) it was created the ideal and baseline variant and then calculated the relative distance from the baseline variant.
Tab. 4: The relative distance from baseline variant in 2012

Origin 
Modify 
Abranovce 
0,382 
0,382 
Bajerov 
0,279 
0,232 
Bertotovce 
0,232 
0,220 
Brestov 
0,369 
0,362 
Bretejovce 
0,396 
0,386 
Source: Own calculations
On a base of the relative distance from baseline variant the municipalities were given points and they were arranged in the order for the certain year.
Table 5: The individual score of municipalities in 2012

Origin rank 
Modify rank 
1. 
Geraltov 
Geraltov 
2. 
Gregorovce 
Janov 
3. 
Janov 
Gregorovce 

… 
... 
89. 
Bajerov 
Bajerov 
90. 
Rokycany 
Bertotovce 
91. 
Bertotovce 
Rokycany 
Source: Own calculations
The municipality with very little points was classified as the best by the TOPSIS method in the particular section (the years 20102012).
Table 6: The overall score of municipalities 2010 – 2012

Origin rank 
Modify rank 


municipality 
points 
PO 
municipality 
points 
PO 
1. 
Janov 
6 
304 
Janov 
5 
304 
2. 
Široké 
31 
2408 
Široké 
35 
2408 
3. 
Záborské 
31 
584 
Záborské 
19 
584 

… 
... 

... 
... 

104. 
Šarišské Bohdanovce 
244 
695 
Šarišské Bohdanovce 
243 
695 
105. 
Chmiňany 
266 
874 
Chmiňany 
267 
874 
106. 
Bertotovce 
271 
485 
Bertotovce 
267 
485 
Source: Own calculations
Graph 1 from figure 1 shows the results obtained municipalities by population.
Fig. 1: Scatter plot of parameters the city population and the score
* for better illustration are the city with a population over 5000 eliminated
Source: Own calculations
The distribution of the monitored parameters indicates that it is not possible to image by a single regression function. Kendall correlation coefficient more closely monitors a correlation between monitored parameters. Simultaneously, coefficient KendallStuartovo tauc presents correlation between the score and a municipal size (a city population).
Table 7: Correlation matrix of municipal size and score – origin
Kendall's tau_b 
Size 
Score 

Municipal size 
Correlation coefficient 
1,000 
0,120 
Sig. (2tailed) 
. 
,092 

N 
91 
91 

Score 
Correlation coefficient 
,120 
1,000 
Sig. (2tailed) 
0,092 
. 

N 
91 
91 
Source: Own calculations
Table 8: Correlation matrix of municipal size and score – modify
Kendall's tau_b 
Size 
Score 

Municipal size 
Correlation coefficient 
1,000 
0,133 
Sig. (2tailed) 
. 
,063 

N 
91 
91 

Score 
Correlation coefficient 
,133 
1,000 
Sig. (2tailed) 
0,062 
. 

N 
91 
91 
Source: Own calculations
Reliability calculated parameter does not allow drawing conclusions about the existence of links between those phenomena; even when a statistical confidence level of the correlation coefficient would indicate to statistical inconsistency of the phenomena.
4.1. Graphical representation of the results
In the spotted Prešov district was made the ideal variant, means the best values of indicators, which were reached in each of the municipalities in the same year. Following graphical image is describing the year 2012 – the ideal variant with the comparison of results from the best municipality to the worst municipality for the particular year. (Fig2)
Fig. 2: Illustration of results in 2012
Source: Own calculations
The best municipality in Prešov district according to TOPSIS method was Geraltov (0, 843, resp. 0,881) for the year 2012. And the worst one was Bertotovce (0,232). Using modifies weight of indicators  the worst one was Rokycany (0,200).
As you can see the results of both municipalities differ from the ideal (fictive) variant while the deviations are shown in the fig 3.
Fig. 3: Indicator comparison of selected municipalities in 2012
Source: Own calculations
5. Conclusions
In this study, TOPSIS technique was evaluated and compared using data obtained to assist decision making for selecting the most efficient municipality in selected district in the Slovakia (Prešov district). With the help of 8 chosen indicators it was evaluated the economy of 91 villages in the certain county for the particular section (20102012).
On the basis of the research we can conclude that the municipal size and classified by the applied procedures is not a link. Modified weights had an impact on the ranking each year. In order for the whole period 2010  2012 these differences were minimal.
TOPSIS and other MADM problem solving techniques can be used as accurate techniques for decision making in public economy. We expect the using of the method to evaluate villages of Prešov district and later also the Slovak republic.
6. Acknowledgements
This article was elaborated as a part of grants VEGA 1/0760/13, KEGA 032PU4/2013 and KEGA 007PU4/2011.
7. References
[1] ONDOR, C. I., MURESAN, A. 2012.Correlated Criteria in Decision Models: Recurrent Application of TOPSIS Method. In Applied Medical Informatics [online]. 2012. [cit. 2013.10.12]. Available on the internet:
<http://search.proquest.com/docview/934310759?accountid=14716>.
[2] FABUŠ, M. 2011. Využitie matematickoštatistických metód v ŠVOC. In K rozvoju študentskej vedeckej odbornej činnosti na Ústave ekonomie a manažmentu na VŠEMvs. Bratislava : Vysoká škola ekonomie a manažmentu verejnej správy v Bratislave, 2011. ISBN 9788097049591, pp. 914.
[3] JABLONSKÝ, J. 2002. Operační výzkum: Kvantitativní modely pro ekonomické rozhodování. 2. vyd. Praha : Professional Publishing, 2002. 323 pp. ISBN 8086419231.
[4] LINGFENG, H., JIUNGBIN, CH., MUCHEN, W., 2006. Performence evaluation for university electronic libraries in Taiwan. In The Electronic Library. [online]. 2010. [cit. 2013.10.13]. Available on the internet:
<http://search.proquest.com/docview/218233243?accountid=14716>.
[5] LIŠTIAK, P. 2012. Konkurencieschopnosť slovenského hospodárstva vo vzťahu k energetike v období finančnej krízy. In . Management Challenges in the 21st Century [online]. 2012. [cit. 2013.10.12]. Available on the internet:
<http://www.cutn.sk/Library/proceedings/mch_2012/editovane_prispevky/Li%C5%A1tiak.pdf>.
[6] MINAŘÍK, P. 2010. Porovnání investičních instrumentů – vicekriteriální rozhodování. In Matematika v ekonomické praxi. Jihlava : VŠP Jihlava, 2010. ISBN 9788087035344, pp. 121132.
[7] NOORAMIN, A.S. ET AL. 2012. TOPSIS and AHP techniques for selecting the most efficient marine container yard gantry crane. In Operational Research Society of India [online]. 2012. [cit. 2013.10.12]. Available on the internet:
<http://www.pulib.sk:2088/pqcentral/docview/1017942897/141115FE11FDBD1D61/1?accountid=14716>.
[8] PANCÁKOVÁ, V. 2009. Štatistické metódy pre ekonómov. Bratislava : Ekonóm, 2009. 411 pp. ISBN 9788080782849.
[9] REKTOŘÍK, J. A KOL. 2007. Ekonomika a řízení odvětví veřejného sektoru. Praha : Ekopress, 2007. 309 s. ISBN 9788086929293.
[10] RIMARČÍK, M. 2007. Štatistika pre prax. 1. vyd. 2007. 200 pp. ISBN 9788096981311
[11] ŠEBO, J. – ŠEBOVÁ, M. 2010. Meranie konkurencieschopnosti viackritériálnym hodnotením. In Journal of Competitiveness 1/2010 [online]. 2010. [cit. 2013.10.12]. Available on the internet: <http://www.cjournal.cz/index.php?hid=clanek&bid=archiv&cid=23&cp=>.
[12] YILMAZ, B., HARMANCIOGLU, N.B. 2010. Multicriteria decision making for water ressource management: A case study of the Gediz River Basin, Turkey. In Water S.A. [online]. 2010. [cit. 2013.10.13]. Available on the internet:
<http://search.proquest.com/docview/814875563?accountid=14716>.