Feasibility study of industrial projects using SIMOS' procedure.
Marzouk, Mohamed ; Amer, Omar ; El-Said, Moheeb 等
1. Introduction
Multi-Criteria Decision Making has taken massive concern in the research field over the past few decades. This reflects how important this issue is since its early conception. When the number of factors/criteria which affect the decision making process increase, it is then considered multi-criteria decision making process. In industrial projects, wrong decisions might lead to bankruptcy of crucial economic entities as well as bankruptcy of banks and might expand to be rated as crimes, as in Waste of Public Money. Feasibility study should be well prepared prior to any further procedures. There exist a type of private investors that might have the good initiative and the capital to construct economically successful projects but they might either select the inappropriate type of industry that might turn the investment to a failure or might not include some important/crucial considerations into account (Amer 2010). This paper targets private investors who have investment intentions in Egypt and who search for the most suitable/appropriate industrial project to be constructed in Egypt's industrial zones (e.g.: New Port Said East Port, 10th of Ramadan City, etc.) in order to invest their capitals. This paper proposes a methodology for selecting industrial projects.
In construction industry, value engineering is one fertile discipline for the application of Multi-Criteria Decision Making techniques thanks to the several exchanges of alternatives' combinations till the decision maker reaches a satisfactory solution. A generic tool for value engineering has been proposed using superiority and inferiority ranking technique (SIR). The tool has been developed using VBA[R] (Marzouk 2008a). The SIR-VE input includes: i) selected criteria; ii) alternatives to be ranked; iii) ranking procedure (either SAW or TOPSIS) and iv) criteria weights (either to be defined or estimated). For all selected criteria, it is required to define name of criterion, preferred limit (the main objective either to maximized or minimized the criterion) and selected generalized criterion. The same technique has been used in a well-known MCDM practice which is contractor selection (Marzouk 2008b). It has been also used in selecting concrete pumps (Tam et al. 2004). The case study is based on a 34-story building located in a 1,800 [m.sup.2] construction site in Hong Kong. It comprises ten alternatives in form of types of pumps (supplied to site by contractor) and eleven different criteria. A brief comparison--based on five characteristics--between five MCDM techniques (AHP, ELECTRE III, Fuzzy Logic, PROMETHEE and SIR) is presented. The advantages of using superiority and inferiority ranking technique in equipment selection are also presented. Selection of concrete pumps is also introduced using ELECTRE III (Ulubeyli, Kazaz 2009). They also made survey about the previous papers concerning the selection of construction equipment, the type of equipment to be selected and the selection method.
A generic tool has been developed for contractor selection that is capable to (Marzouk, Moselhi 2003): i) evaluation bid proposals (i.e, contractor selection); and/or ii) assisting the contractors themselves in estimating the markup in their bidding. In other words, unlike the models developed for similar purposes, the proposed model provides a decision support environment for the two functions; that is, estimating markup and evaluating bid. Dissimilar to the previous multi-criteria decision making methods used in the papers introduced in this section, the model in this paper utilizes the multi-attribute utility theory in addition to the analytic hierarchy process and makes use of their advantages. Bid markup estimation was developed using utility-theory by Dozzi et al. (1996). The research is conducting, considering the following procedure: 1) create a short-list that contains the most important factors on which the decision of the private investor in solving the problem defined earlier will be based; 2) develop a multi-criteria decision making approach that can rank the alternatives of the possible industrial projects; 3) apply sensitivity analysis to identify the most critical criterion and the most critical measure of performance.
2. Factors identification
An extensive search has taken place for the factors that might affect selection of the most appropriate type of industry. A preliminary list has been gathered from literature (Changshan 2007; Roussat et al. 2009; UNDP 2010) and interviews with the experts in the field. Six interviews have been conducted; in addition to, other several unstructured interviews but with no direct impact on the preliminary list of factors. The list contains 27 factors that belong to three clusters that are Economic, Socio-Economic and Environmental as listed in Table 1. After considering the 27-factors list, a process of acquiring the importance of factors has been performed. This has taken place by preparing a questionnaire survey. The main purpose of the questionnaire survey is to get the importance of the gathered factors. The factors were listed and given a scale from one to five. Degree one is the least important degree and degree five is the most important degree. The respondents evaluated each factor as if they are private investors. In other words, the questionnaire was evaluated from private investors' point of view, in order to make their decision on selecting the type of industry in which they can invest their money. Screening the gathered factors is an important phase. This is an important step in the track of reaching a reliable short-list/key list that contains the most important factors on which the private investor can rely upon in reaching the most appropriate industrial project to be constructed in Egypt's industrial zones. Low important factors have been eliminated. They are those factors those factors whose frequency cells that appear in Table 1 verifies the equation [(1 + 2 + (0.5*3)) [less than or equal to] ((0.5*3) + 4 + 5)]. The frequency cells reflect the numbers of votes for each level of importance (from 1 to 5) related to each factor. The numbers of votes have been gathered from the questionnaire feedback. Table 1 lists the result of the screening process (Importance frequency). It should be noted that four factors have been eliminated from the 27-factors list forming more reliable list of 23 factors. The eliminated factors are Males to Females Ratio, Females Employment, Illiteracy and Ecological Impact. The first three factors belong to the Socio-Economic cluster, while the fourth factor belongs to the Environmental cluster.
3. Analysis of relative importance
After having the importance of the gathered factors and eliminating the low important factors, the relative importance for the remaining factors is obtained. Relative importance couldn't have been acquired in an earlier stage since it would have been a complex action to get the importance and the relative importance in one exercise. Also, questionnaire feedback could have been possibly inaccurate. The relative importance is essential for assigning the weight of each factor. Weights allocation of factors is consequently essential since it will be integrated with a ranking technique. A procedure called Simos' procedure has been followed to acquire both the relative importance and the weights of factors (Figueira, Roy 2002).
A questionnaire has been prepared to get the relative importance of the factors. In the second questionnaire, aside assigning the relative importance of the factors, it was also required from the participants to assign the relative importance of the three main clusters/families for which all the factors belong. All responses have been compiled to reflect all assigned relative importance. This resultant has been developed by taking the average of each criterion in the questionnaire to calculate the total average relative importance. According to the average column, a sorting process has been performed based on the algorithm of Simos. The result of the sorting process has been added to an additional and final column. The process of getting a resultant to the received relative importance is shown in Table 2.
It is important to clarify why Weighted-Sum Model (WSM) is preferred to be used than other ranking techniques like Analytic Hierarchy Process (AHP). For example, using AHP necessitates formulating a number of pairwise matrixes (decision matrixes) for every single cluster/family of the available factors; in addition to, the main clusters themselves. That means that Table 2 is going to be breakdown into four different matrixes, one of which is going to be a 14x14 matrix. This case will be confusing and also incredibly time consuming for experts/participants who are going to fill up the questionnaire. Additionally, after performing the consistency ratio check on the questionnaire feedback, the probability of finding inconsistent answers is expected to be high. Accordingly, this most likely is going take the whole process in a loop which might not be useful to the research process. On the other hand, in this case WSM is used along with Simos' procedure making the questionnaire process (through Table 2) way easier to perform and--to great extent--assuring reliable feedback as well. Another reason of WSM preference is that potential audience of this research might be private investors and/or developers. Presenting a smooth procedure which performs the same job might be useful for better understanding to the study.
Before proceeding in further steps, an investigation of the factors has been performed. It has been found that factors which are constant among all alternatives of the decision making process (industrial projects) could have been eliminated since their effect will obviously be constant as well. Factors which are constant among all alternatives are those which are related to the location of projects' initiation. These factors include: 1) Growth Rate Ratio; 2) Age of Working Power; 3) Crime Location Data; 4) Population; 5) Gross Domestic Product (GDP); 6) Housing Price; 7) Human Development Index (HDI). At the same time, frequent trials concerning collection of records and data related to the gathered factors were taking place. Numerous visits were organized to visit several authorities including: Egyptian Industrial Development Authority, Egyptian Environmental Affairs Agency and Egyptian Social Fund for Development. The purpose of the visit is to identify significant factors. It has been found that some factors do not have either any records or having outdated measures. These factors are: 1) Income share per capita; 2) Global Warming; 3) Noise Impact; 4) Landscape and Visual Impact; 5) Hazardous Chemicals Control. By eliminating the stated above factors from the second questionnaire responses resultant, eleven sound and practical factors remained for further processes as listed in Table 3.
After getting the relative importance and performing the final screening, the list of factors now appear to be consistent/practical and measurable (i.e., ready for further processes). A short-list (key list) containing the most important factors on which the decision of the private investor in searching for the most appropriate industrial project to be constructed in Egypt will be based. In continuation to the paper objectives, the relative importance acquired is used in order to get the weights for the factors. Getting weights of factors is the second part in Simos' procedure as listed in Table 4. Since there is more than one family/cluster, the calculated weights still have to be converted from local weights within each cluster to global weights among all factors of all clusters. Except the local weights for the main cluster, they are already considered global too. Table 5 lists that the local normalized weights that are previously calculated which are multiplied by the weight of each relative cluster forming global weights.
4. Acquiring values of factors
Several visits have been carried out to industrial projects/factories of different types in order to acquire real values/measures to the list of factors. There were five factories and this activity is considered five different case studies, representing industrial projects. The details of factories are:
1. Factory 1 produces nylon bags of different sizes (project is related to petrochemical industry);
2. Factory 2 produces PVC pipes (project is also related to petrochemical industry);
3. Factory 3 is a huge mechanical workshop/ warehouse;
4. Factory 4 produces & galvanizes steel towers of mobile phone networks;
5. Factory 5 produces steel towers of mobile phone networks without galvanization.
Table 6 shows more information about the criteria and factors for five factories. Public Health Info, Local Public Acceptance, Pollution and Waste Management Impact criteria are based on grades from 1 to 10. By returning to the definitions of these criteria, it can be easily understood that these criteria are descriptive; consequently, they have been given grades to make the numerical evaluation possible.
5. Ranking of alternatives
The matrix depicted in Table 7 contains a column named Types of Industries. It is essential to identify which factory belongs to which type of industry and develop the Types of Industries column. The Public Health Info and Pollution criteria are recommended to be kept to the minimum. This means that as long as the given grade decreases to grade one, the alternative becomes more preferred. On the contrary, Local Public Acceptance and Waste Management Impact criteria are recommended to be increased. This means that as long as the given grade increases to grade ten, the alternative becomes more preferred. It can be noted that the entire column of criterion Local Public Acceptance does not show any change in its values. All alternatives have a value of 10 for this criterion. It is a coincidence in this scenario that all alternatives had the same value towards the Local Public Acceptance criterion; otherwise, it could have been eliminated in an earlier stage with other criteria which could have been potentially constant among all alternatives as in the criteria related to project location.
After reviewing some important issues in the decision matrix, ranking of alternatives determination process should begin. This is carried out using Weighted-Sum Model (WSM) method (Fishburn 1967). Developing the decision matrix with real measures of the selected criteria against the five different alternatives (case study projects) was the first step.
Secondly, all values were normalized to add up to one (Table 8). In other words, normalization can be either processed in relative to the largest value among specified set of values (column) or processed in relative to the summation of a specified set of values (column). What has been applied here is that the normalization is processed in accordance to the latter option. It can be also noticed that the raw which was carrying the units of criteria has been substituted by the weights of each criterion. This is because the normalized figures are now dimension-less; moreover, these weights will be used for the next step.
Thirdly, the normalized figures are multiplied by the weights of criteria forming weighted normalized matrix (see Table 8). By applying the Weighted-Sum Model (WSM) method on the values of Table 8, the final preferences and ranking of alternatives are obtained. It should be noted that some criteria are more preferred when their values increase (such as; Reward) while others are more preferred when their values decrease (such as; Time). What has been applied in this step in order to respect the nature of increasing and decreasing criteria is that, for each alternative, the summation of the increasing criteria preferences have been calculated separate from the summation of the decreasing criteria preferences. Then, the difference (net) between the two summations is considered the final preferences of alternatives as listed in Table 9.
By referring to Table 9, it can be noted that there are two alternatives [A.sub.3] and [A.sub.1] have the same final preference (-0.04). Alternative [A.sub.3] is preferred than alternative [A.sub.1] because originally alternative [A.sub.3] carries slightly larger final preference (lesser negative value); however, the final preferences presented here are only up to two decimal places to facilitate the visual comparison between the different alternatives. It is now clear that the most appropriate (preferred) alternative out of the five selected industrial projects is the fourth alternative [A.sub.4], a Medium type industry. It is the factory which produces and galvanizes steel towers of mobile phone networks.
6. Sensitivity analysis
Several efforts have been made to study the sensitivity of the criteria governing the decision making process (Mostafavi, Karamouz 2010; Zhang et al. 2008; Triantaphyllou, Sanchez 1997). The conducted sensitivity analysis reveals the most critical criterion and the most critical measure of performance that might affect the decision making process. The most critical criterion will be introduced first. It is previously mentioned that the Reward criterion is the most important one. The most critical criterion is not necessarily to be the most important criterion, in other words, not necessarily correspond to the highest weight. What is meant by the term "Critical" here is the smallest change that might occur to a certain criterion in order to affect the ranking of alternatives. Monitoring the behavior of alternatives is essential for the purpose of analysis. This can happen by observing the changes that occur in weights of criteria and its effect on the ranking of alternatives, considering two different points of views. The first one is for those who are concerned with the change within any two alternatives to reverse their existing ranking. However, it is also possible that others might be interested in only the best (top) alternative changes. As such, there are four definitions that can be considered; Absolute Any (AA), Absolute Top (AT), Percent Any (PA), and Percent Top (PT) (Mostafavi, Karamouz 2010; Zhang et al. 2008; Triantaphyllou, Sanchez 1997).
6.1. Processing most critical criterion--absolute terms
Table 10 shows all possible absolute changes in weights of criteria by applying Equations 1 or 2. Where [[delta].sub.k,i,j] denotes the minimum change in the current weight [W.sub.k] of Criterion [C.sub.k] such that the ranking of alternatives [A.sub.i] and [A.sub.j] will be reversed or become just equal:
[[delta].sub.k,I,j] < ([P.sub.j] - [P.sub.i])/([a.sub.jk] - [a.sub.ik]), if ([a.sub.jk] > [a.sub.ik]), or (1)
[[delta].sub.k,i,j] > ([P.sub.j] - [P.sub.i])/([a.sub.jk] - [a.sub.ik]), if ([a.sub.jk] > [a.sub.ik]). (2)
Such that "p" is the final preference of alternatives and "a" is a measure in the decision matrix of a specified criterion and corresponding to a specified alternative. For example [[delta].sub.1,1,2] can be calculated, using Tables 8 and 9, as follows:
[[delta].sub.1,1,2] = (-0.13-(-0.04))/(0.188-0.281) = 0.906 [approximately equal to] 0.91.
The cells marked with N/A in the table indicate infeasible values. By looking for the smallest absolute value of [[delta].sub.k,i,j] throughout the entire table, it can be found that it is equal to (-0.003). This means that Employment is the Absolute Any (AA) most critical criterion. It is important to recall that according to the weights of criteria, Reward was the most important criterion and not Employment; however, in this scenario, Reward wasn't the most critical criterion. By looking for the smallest absolute value of [[delta].sub.k,i,j] in all rows which are related to the best alternative only (Alternative A4), it can be found that (0.08) is that value. Reward is the corresponding criterion to the value this value. This means that Reward is the Absolute Top (AT) most critical criterion.
It can be noticed that the entire column of criterion Local Public Acceptance does not carry any values. This means that the criterion Local Public Acceptance is "equally sensitive" to all alternatives. In fact, it not necessarily that all alternatives have the same value in regard of a certain criterion. It is a coincidence in this scenario that all alternatives had the same value towards the Local Public Acceptance criterion.
6.2. Processing most critical criterion - relative terms
Processing the most critical criterion in relative terms is based on Table 10. By applying Eq. (3), Table 11 is derived. Where [[delta]'.sub.k,i,j] denotes the minimum relative change in the current weight [W.sub.k] of criterion [C.sub.k] such that the ranking of alternatives [A.sub.i] and [A.sub.j] will be reversed or become just equal:
[[delta]'.sub.k,i,j] = [[delta].sub.k,i,j] x 100/[W.sub.k]. (3)
For example [[delta]'.sub.k,i,j] can be calculated, using [W.sub.k] from Table 5, as follows:
[[delta].sub.k,i,j] = 0.91 x 100 / 0.125 = 728.
Similarly, the cells marked with N/A in the table indicate infeasible values. By looking for the smallest relative value of [[delta]'.sub.k,i,j] throughout the entire table, it can be found that ([absolute value of -4.4]) is that value. Reward is the corresponding criterion to the value ([absolute value of -4.4]). This means that Reward is the Percent Any (PA) most critical criterion.
By looking for the smallest relative value of [[delta]'.sub.k,i,j] in all rows which are related to the best alternative only (Alternative [A.sub.4]), it can be found that (30.8) is that value. Reward is the corresponding criterion to the value (30.8). This means that Reward is also the Percent Top (PT) most critical criterion.
6.3. Criticality degrees and sensitivity coefficients
As for the criticality degrees of criteria (see Table 12), they can be calculated by choosing the smallest value on each column of Table 11. By calculating the reciprocal of the absolute values of "Criticality Degrees", the sensitivity coefficients of the criteria can be achieved as per Table 12. The ranking of the criteria from the most sensitive to the least sensitive will be as follows: 1) Reward; 2) Land Parcel Inventory; 3) Employment; 4) Time; 5) Skilled Labors; 6) Electrical Power Consumption; 7) Cost; 8) Pollution; 9) Waste Management Impact; 10) Public Health Info.
6.4. Most critical measure of performance
The second stage of the sensitivity analysis is determining the most critical measure of performance. In other words, figuring out which specific value of the gathered criteria is the most critical. The methodology used here is Trial and Error. A solution has been developed using Microsoft Visual Basic 6.5[R] in order to get the final measures of performance needed so that the ranking of alternatives [A.sub.i] and [A.sub.k] will be reversed or become just equal. Table 13 shows all possible absolute measures of performance developed through Microsoft Visual Basic 6.5[R]. Table 14 shows all relative measures of performance (%) developed through the program. The relative measures are all relative to the first alternative ([A.sub.i]) to the left of the "Pair of Alternatives" column. The negative signs (-ve) in cells of Table 14 means that the original measure of performance of alternative [A.sub.i] needs to be decreased "to" the cell's current percent value (not to be decrease "by" the cell's percent value) in order to let the final preference of the two alternatives [A.sub.i] and [A.sub.j] be reversed or become almost equal.
The most critical measure of performance can be achieved by comparing the smallest positive value in Table 14 (the relative measures), with the highest negative value. Then, select the value which is closest to the number (100%). In other words, if the smallest positive value equals to 105% and the highest negative value equals to -90%. Then the 105% will be more critical since it means that the original corresponding measure needs to be increased by only 5% in order to change the ranking of alternatives; however, the original measure corresponding to the -90% needs to be decreased by 10% to do the same effect. Absolute values (listed in Table 14) are not applicable in this case since measures corresponding to each criterion have different units. There is no unite platform on which the absolute values can be compared together; however, relative figures are altogether connected to the percentage platform. Similar as previous analysis, there will be Percent Any and Percent Top values. The Percent Top value equals to (200%) and Percent Any value equals to (111.11%). Both values correspond to criterion [C.sub.3]. The table cells (in both Tables 13 and 14) marked with N/A, indicating that the program did not find any solutions throughout the given range.
7. Conclusions
This paper introduced an approach for selecting industrial projects using Multi-Criteria Decision Making (MCDM) techniques. In view of the fact that some mega projects are found not to be successful just before construction, during construction or even realize after the early stages of operation. MCDM can be applied during the feasibility study phase prior to design, procurement and construction stages to have the best use of its results and avoid the possible losses. The feasibility study needs to answer the question: "Does the idea make economic sense?" Further technically detailed considerations such as production lines of factories and machinery can be discussed from the Industrial Engineering perspective. This approach is developed in order to aid the private investors (foreign or local) who have investment intentions in Egypt. It aids them to select the most suitable/preferred industrial project to be constructed in Egypt's industrial zones in order to invest their capitals.
The formulation/development of this approach has passed through several stages. It starts with gathering the necessary factors from interviews and references, then getting the importance of each factor. Afterwards, necessary screening is performed to eliminate the low important factors. Giving relative importance and performing final refinement before proceeding are also important stages in the approach formulation. Weights of the remained factors have been indicated using Simos' procedure. Then after real values of factors have been collected from five case studies of industrial projects, a vital decision matrix have been prepared on which the ranking of the five case studies (alternatives) has took place. The ranking has taken place using Weighted-Sum Model method (WSM). Necessary sensitivity analysis has been performed to figure out the most critical criterion and the most critical measure of performance of this decision making approach. Also, it has been proven that the criterion which carries the highest weight is not necessarily be the criterion which can change the ranking of alternatives if subjected to the slightest change in its weight, i.e., it has been proven that the most important criterion does not necessarily be the most critical criterion.
The paper proposed a methodology for selecting industrial projects in Egypt. To achieve this main objective, the following sub-objectives are achieved: 1) A shortlist/key-list containing the most important factors that the decision maker (private investor) should consider is created; 2) A Methodology that can reach a solution to the most suitable industrial project to be constructed in Egypt; 3) Application of sensitivity analysis for better understanding.
doi: 10.3846/13923730.2012.734855
References
Amer, O. M. 2010. A multi-criteria decision making approach for selecting industrial projects. MSc Thesis. Construction Engineering and Management Division, Structural Engineering Department, Faculty of Engineering, Cairo University, Egypt.
Changshan, W. 2007. Remote sensing applications in urban socioeconomic analysis, in V. Mesev (Ed.). Integration of GIS and Remote Sensing. John Wiley & Sons, Inc., NY, US, 149-172.
Dozzi, S. P.; AbouRizk, S. M.; Schroeder, S. L. 1996. Utility-theory model for bid markup decisions, Journal of Construction Engineering and Management ASCE 122(2): 119-124. http://dx.doi.org/10.1061/(ASCE)07339364 (1996)122:2(119)
Figueira, J.; Roy, B. 2002. Determining the weights of criteria in the ELECTRE type methods with a revised Simos' procedure, European Journal of Operational Research 139(1-2): 317-326. http://dx.doi.org/10.1016/S03772217(01)00370-8
Fishburn, P. C. 1967. Additive utilities with incomplete product sets: application to priorities and assignments, Operations Research 15: 537-542. http://dx.doi.org/10.1287/opre.15.3.537
Marzouk, M.; Moselhi, O. 2003. A decision support tool for construction bidding, Construction Innovation: Information, Process, Management 3(2): 111-124.
Marzouk, M. 2008a. SIR-VE: A generic tool for value engineering, in Proc. of the 5th International Engineering and Construction Conference (IECC'5), 27-29 August, 2008, Irvine, California, USA, 663-672.
Marzouk, M. 2008b. A superiority and inferiority ranking model for contractor selection, Construction Innovation: Information, Process, Management 8(4): 250-268.
Mostafavi, A.; Karamouz, M. 2010. Selecting appropriate project delivery system: a fuzzy approach with risk analysis, Journal of Construction Engineering and Management ASCE 136(8): 923-930. http://dx.doi.org/10.1061/(ASCE)CO.1943-7862.0000190
Roussat, N.; Dujet, C.; Mehu, J. 2009. Choosing a sustainable demolition waste management strategy using multicriteria decision analysis, Waste Management 29(1): 12-20. http://dx.doi.org/10.1016/j.wasman.2008.04.010
Tam, C. M.; Tong, T. K. L.; Wong, Y. W. 2004. Selection of concrete pump using the superiority and inferiority ranking method, Journal of Construction Engineering and Management ASCE 130(6): 827-834. http://dx.doi.org/10.1061/(ASCE)0733-9364(2004)130: 6(827)
Triantaphyllou, E.; Sanchez, A. 1997. A sensitivity analysis approach for some deterministic multi-criteria decision making methods, Decision Sciences 28(1): 151-194. http://dx.doi.org/10.1111/j.1540-5915.1997.tb01306.x
Ulubeyli, S.; Kazaz, A. 2009. A multiple criteria decision making approach to the selection of concrete pumps, Journal of Civil Engineering and Management 15(4): 369-376. http://dx.doi.org/10.3846/1392-3730.2009.15.369-376
UNDP. 2010. Fighting climate change: human solidarity in a divided world. The 2007/2008 Human Development Report. United Nations Development Programme [cited 10 April 2010]. Available from Internet: http://hdr.undp.org/ en/media/HDR_20072008_EN_Complete.pdf
Zhang, C.; Zayed, T.; Hammad, A. 2008. Resource management of bridge deck rehabilitation: Jacques Cartier bridge case study, Journal of Construction Engineering and Management ASCE 134(5): 311-319. http://dx.doi.org/ 10.1061/(ASCE)0733-9364(2008)134:5(311)
Mohamed Marzouk (1), Omar Amer (2), Moheeb El-Said (3) Department of Structural Engineering, Faculty of Engineering, Cairo University, El Gamaa St., Giza, Egypt
E-mails: (1) mm_marzouk@yahoo.com (corresponding author); (2) omar.amer@mcg-consult.com; (3) elsaidl204@yahoo. com
Received 19 Mar. 2011; accepted 07 Jun. 2011
Mohamed MARZOUK. Associate Professor at Department of Structural Engineering, Faculty of Engineering, Cairo University. He received his BSc and MSc in Civil Engineering from Cairo University in 1995 and 1997, respectively. He received his PhD form Concordia University in 2002. He is Certified Project Management Professional (PMP[R]) and Certified Project Management Consultant (Egyptian Syndicate of Engineers). His research interests includes simulation and optimization of construction processes, O-O simulation, fuzzy logic and its applications in construction, risk analysis, and decision analysis.
Omar AMER. He is currently a Projects Engineer at MCG Misr Consult Group, Cairo, Egypt. In 2005, he joined a research team at University of Maryland, MD, USA, for a short-term period. He received his BSc in Construction and Building Engineering from the Arab Academy for Science & Technology and Maritime Transport in 2006. He received his MSc in Structural Engineering from Cairo University in 2010. His research interests includes risk assessment, geo- risk management, multi-criteria decision making, construction management and geotechnical engineering.
Moheeb EL-SAID. Professor of construction engineering and management at Department of Structural Engineering, Faculty of Engineering, Cairo University. His research interests includes productivity, schedule risk assessment, life cycle costs, and simulation. Table 1. Frequency of importance for gathered factors Cluster/Factor Frequency 1 2 3 4 5 Economic 1) Time 0 0 9 11 8 2) Cost 0 1 4 9 14 3) Reward 0 1 1 1 25 Socio-Economic 4) Employment 0 2 15 10 1 5) Income Share Per Capita 0 6 10 9 3 6) Growth Rate Ratio 0 4 7 11 6 7) Males to Females Ratio 7 10 6 4 1 8) Females Employment 7 11 5 5 0 9) Illiteracy 3 6 10 7 2 10) Skilled Labors 0 0 5 9 14 11) Age of Working Power 1 4 9 12 2 12) Land Parcel Inventory 1 2 6 13 6 13) Crime Location Data 1 4 4 10 9 14) Public Health Info 3 0 6 10 9 15) Population 3 3 12 8 2 16) Gross Domestic Product (GDP) 2 2 6 14 4 17) Electrical Power Consumption 0 2 4 11 11 18) Housing Price 0 5 5 12 6 19) Human Development Index (HDI) 1 4 13 7 3 20) Local Public Acceptance 1 3 9 8 7 Environmental 21) Pollution 1 0 5 14 8 22) Global Warming 5 12 6 3 23) Noise Impact 1 5 8 11 3 24) Ecological Impact 1 9 11 5 2 25) Landscape & Visual Impact 0 6 14 5 3 26) Waste Management Impact 2 2 4 16 4 27) Hazardous Chemicals Control 0 2 5 10 11 Table 2. Second questionnaire responses Cluster Factor Relative Weighting Average Q1 Q2 Q3 Q4 Q5 Economic 1) Time 1 1 1 2 2 1.4 2) Cost 1 2 2 1 1 1.4 3) Reward 2 3 3 3 3 2.8 Socio- 4) Employment 3 4 10 8 2 5.4 Economic 5) Income Share 2 4 3 2 1 2.4 Per Capita 6) Growth Rate 2 5 1 1 1 2 Ratio 7) Skilled 4 3 12 9 4 6.4 Labors 8) Age of 3 3 5 10 4 5 Working Power 9) Land Parcel 4 6 11 11 5 7.4 Inventory 10) Crime 1 2 2 3 2 2 Location Data 11) Public 3 3 7 4 3 4 Health Info 12) Population 3 2 3 3 3 2.8 13) Gross 2 2 6 5 1 3.2 Domestic Product (GDP) 14) Electrical 4 5 8 12 5 6.8 Power Consumption 15) Housing Price 4 3 9 13 3 6.4 16) Human 2 1 4 6 1 2.8 Development Index (HDI) 17) Local Public 4 5 13 7 6 7 Acceptance Environ- 18) Pollution 2 5 6 4 4 4.2 mental 19) Global 1 1 1 1 1 1 Warming 20) Noise 2 2 5 3 2 2.8 Impact 21) Landscape 3 3 4 2 3 3 & Visual Impact 22) Waste 2 4 2 5 6 3.8 Management Impact 23) Hazardous 2 5 3 6 5 4.2 Chemicals Control Main Economic 2 3 3 3 3 2.8 Clusters Socio-Economic 1 1 2 2 1 1.4 Environmental 1 2 1 1 2 1.4 Cluster Factor Simon' Rank Economic 1) Time 1 2) Cost 1 3) Reward 2 Socio- 4) Employment 7 Economic 5) Income Share 2 Per Capita 6) Growth Rate 1 Ratio 7) Skilled 8 Labors 8) Age of 6 Working Power 9) Land Parcel 11 Inventory 10) Crime 1 Location Data 11) Public 5 Health Info 12) Population 3 13) Gross 4 Domestic Product (GDP) 14) Electrical 9 Power Consumption 15) Housing Price 8 16) Human 3 Development Index (HDI) 17) Local Public 10 Acceptance Environ- 18) Pollution 5 mental 19) Global 1 Warming 20) Noise 2 Impact 21) Landscape 2 & Visual Impact 22) Waste 3 Management Impact 23) Hazardous 4 Chemicals Control Main Economic 2 Clusters Socio-Economic 1 Environmental 1 Table 3. Modified list of factors Cluster Factor Relative Weighting Average Simos' Q1 Q2 Q3 Q4 Q5 Rank Economic 1) Time 1 1 1 2 2 1.4 1 2) Cost 1 2 2 1 1 1.4 1 3) Reward 2 3 3 3 3 2.8 2 Socio- 4) Employment 3 4 10 8 2 5.4 2 Economic 5) Skilled 4 3 12 9 4 6.4 3 Labors 6) Land 4 6 11 11 5 7.4 6 Parcel Inventory 7) Public 3 3 7 4 3 4 1 Health Info 8) Electrical 4 5 8 12 5 6.8 4 Power Consumption 9) Local 4 5 13 7 6 7 5 Public Acceptance Environ- 10) Pollution 2 5 6 4 4 4.2 2 mental 11) Waste 2 4 2 5 6 3.8 1 Management Impact Main Economic 2 3 3 3 3 2.8 2 Clusters Socio-Economic 1 1 2 2 1 1.4 1 Environmental 1 2 1 1 2 1.4 1 Table 4. Determining relative weights of factors/criteria Factor No. Position Non- Normalized To- of Normalized weights tal Cards weights {Time, Cost} 2 1 1 25 50 {Reward} 1 2 2 50 50 Sum 3 4 100 {Public 1 1 1 5 5 Health Info} {Employment} 1 2 2 10 10 {Skilled Labors} 1 3 3 14 14 {Electrical 1 4 4 19 19 Power Consumption} {Local Public 1 5 5 24 24 Acceptance} {Land Parcel 1 6 6 29 29 Inventory} Sum 21 100 {Waste 1 1 1 33 33 Management Impact} {Pollution} 1 2 2 67 67 Sum 3 4 100 {Socio-Economic, 2 1 1 1 25 50 Environmental} {Economic} 1 2 2 50 50 Sum 3 4 100 Table 5. Global weights of factors Factors Relative Relative Global Weights Weights of Weights Clusters Time 0.250 0.5 0.125 Cost 0.250 0.5 0.125 Reward 0.500 0.5 0.250 Public Health Info 0.048 0.25 0.012 Employment 0.095 0.25 0.024 Skilled Labors 0.143 0.25 0.036 Electrical Power Consumption 0.190 0.25 0.048 Local Public Acceptance 0.238 0.25 0.060 Land Parcel Inventory 0.286 0.25 0.071 Waste Management Impact 0.333 0.25 0.083 Pollution 0.667 0.25 0.167 Table 6. Exposition of criteria Criterion Name Weight Objective Units [C.sub.1] Time 0.125 Minimize Months [C.sub.2] Cost 0.125 Minimize EGP [C.sub.3] Reward 0.25 Maximize EGP/Y ear [C.sub.4] Employment 0.02381 Minimize Number [C.sub.5] Skill Labor 0.03571 Minimize % [C.sub.6] Land Parcel 0.07143 Minimize [m.sup.2] Inventory [C.sub.7] Public Health 0.0119 Minimize 1-10 Info [C.sub.8] Electrical 0.04762 Minimize Mwatt/hr Power Consumption [C.sub.9] Local Public 0.05952 Maximize 1-10 Acceptance [C.sub.10] Pollution 0.16667 Minimize 1-10 [C.sub.11] Waste Management 0.08333 Maximize 1-10 Impact Table 7. Decision matrix (project criteria Vs different possible alternatives) [C.sub.1] [C.sub.2] [C.sub.3] Alternatives Types of Time Cost Reward Industries Months EGP EGP/Year [A.sub.1] H 18 7,000.000 22.500,000 [A.sub.2] H 12 130,000,000 36.000,000 [A.sub.3] L 10 3,000,000 2,000,000 [A.sub.4] M 12 20,000.000 40.000,000 [A.sub.5] L 12 5,000,000 7,500,000 Summation 64 165,000,000 108,000,000 [C.sub.4] [C.sub.5] [C.sub.6] [C.sub.7] Alternatives Employment Skilled Land Parcel Public Labors Inventory Health Info Number % [m.sup.2] 1-10 [A.sub.1] 700 15 20,000 1 [A.sub.2] 125 50 22,000 1.5 [A.sub.3] 45 90 800 1 [A.sub.4] 120 17.5 20,000 1.25 [A.sub.5] 35 17.5 2,000 1 Summation 1,025 190 64,800 6 [C.sub.8] [C.sub.9] [C.sub.10] [C.sub.11] Alternatives Electrical Local Population Waste Power Public Management Consumption Acceptance Impact MW/hr 1-10 1-10 1-10 [A.sub.1] 1.4 10 1 10 [A.sub.2] 5 10 1.5 10 [A.sub.3] 0.15 10 1 10 [A.sub.4] 0.25 10 1.5 8 [A.sub.5] 0.1 10 1 10 Summation 6.90 50 6 48 Table 8. Normalized and Weighted normalized decision matrix Alternative Type [C.sub.1] [C.sub.2] [C.sub.3] [C.sub.4] [A.sub.1] N 0.281 0.042 0.208 0.683 WN 0.0352 0.0053 0.0521 0.0163 [A.sub.2] N 0.188 0.788 0.333 0.122 WN 0.0234 0.0985 0.0833 0.0029 [A.sub.3] N 0.156 0.018 0.019 0.044 WN 0.0195 0.0023 0.0046 0.0010 [A.sub.4] N 0.188 0.121 0.370 0.117 WN 0.0234 0.0152 0.0926 0.0028 [A.sub.5] N 0.188 0.030 0.069 0.034 WN 0.0234 0.0038 0.0174 0.0008 Alternative Type [C.sub.5] [C.sub.6] [C.sub.7] [C.sub.8] [A.sub.1] N 0.079 0.309 0.174 0.203 WN 0.0028 0.0220 0.0021 0.0097 [A.sub.2] N 0.263 0.340 0.261 0.725 WN 0.0094 0.0243 0.0031 0.0345 [A.sub.3] N 0.474 0.012 0.174 0.022 WN 0.0169 0.0009 0.0021 0.0010 [A.sub.4] N 0.092 0.309 0.217 0.036 WN 0.0033 0.0220 0.0026 0.0017 [A.sub.5] N 0.092 0.031 0.174 0.014 WN 0.0033 0.0022 0.0021 0.0007 Alternative Type [C.sub.9] [C.sub.10] [C.sub.11] [A.sub.1] N 0.200 0.167 0.208 WN 0.0119 0.0278 0.0174 [A.sub.2] N 0.200 0.250 0.208 WN 0.0119 0.0417 0.0174 [A.sub.3] N 0.200 0.167 0.208 WN 0.0119 0.0278 0.0174 [A.sub.4] N 0.200 0.250 0.167 WN 0.0119 0.0417 0.0139 [A.sub.5] N 0.200 0.167 0.208 WN 0.0119 0.0278 0.0174 Note: N means normalized, WN means weighted normalized Table 9. Final preferences and ranking Alternatives Preference Preference Final Ranking of Increasing of Decreasing Preferences Criteria Criteria ([P.sub.j]) [A.sub.1] 0.0813 0.1211 -0.04 4 [A.sub.2] 0.1126 0.2378 -0.13 5 [A.sub.3] 0.0339 0.0715 -0.04 3 [A.sub.4] 0.1184 0.1127 0.01 1 [A.sub.5] 0.0466 0.0641 -0.02 2 Table 10. All possible [[delta].sub.k,i,j] values (absolute change in criteria weights) Pair of Alternatives [C.sub.1] [C.sub.2] [C.sub.3] [C.sub.4] [A.sub.1]-[A.sub.2] 0.911 -0.115 -0.683 0.152 [A.sub.1]-[A.sub.3] -0.017 -0.087 -0.011 0.003 [A.sub.1]-[A.sub.4] N/A 0.577 N/A N/A [A.sub.1]-[A.sub.5] N/A N/A -0.161 N/A [A.sub.2]-[A.sub.3] N/A -0.114 -0.278 N/A [A.sub.2]-[A.sub.4] N/A N/A N/A N/A [A.sub.2]-[A.sub.5] N/A N/A -0.408 N/A [A.sub.3]-[A.sub.4] 1.387 0.421 0.123 0.592 [A.sub.3]-[A.sub.5] 0.646 1.666 N/A N/A [A.sub.4]-[A.sub.5] N/A 0.255 0.077 0.279 Pair of Alternatives [C.sub.5] [C.sub.6] [C.sub.7] [C.sub.8] [A.sub.1]-[A.sub.2] N/A N/A N/A N/A [A.sub.1]-[A.sub.3] 0.005 -0.007 N/A -0.012 [A.sub.1]-[A.sub.4] 3.453 N/A 1.045 N/A [A.sub.1]-[A.sub.5] 1.695 N/A N/A N/A [A.sub.2]-[A.sub.3] 0.416 N/A N/A N/A [A.sub.2]-[A.sub.4] N/A N/A N/A N/A [A.sub.2]-[A.sub.5] N/A N/A N/A N/A [A.sub.3]-[A.sub.4] N/A 0.146 0.997 2.990 [A.sub.3]-[A.sub.5] N/A 1.090 N/A N/A [A.sub.4]-[A.sub.5] N/A 0.083 0.532 1.064 Pair of Alternatives [C.sub.9] [C.sub.10] [C.sub.11] [A.sub.1]-[A.sub.2] N/A -1.025 N/A [A.sub.1]-[A.sub.3] N/A N/A N/A [A.sub.1]-[A.sub.4] N/A 0.545 -1.091 [A.sub.1]-[A.sub.5] N/A N/A N/A [A.sub.2]-[A.sub.3] N/A N/A N/A [A.sub.2]-[A.sub.4] N/A N/A -3.140 [A.sub.2]-[A.sub.5] N/A N/A N/A [A.sub.3]-[A.sub.4] N/A 0.520 -1.040 [A.sub.3]-[A.sub.5] N/A N/A N/A [A.sub.4]-[A.sub.5] N/A 0.278 -0.555 Table 11. All possible [S'.sub.kij] values (relative change in criteria weights) Pair of Alternatives [C.sub.1] [C.sub.2] [C.sub.3] [C.sub.4] [A.sub.1]-[A.sub.2] 728.8 -91.7 -273.3 639.5 [A.sub.1]-[A.sub.3] -13.5 -69.6 -4.4 -13.9 [A.sub.1]-[A.sub.4] N/A 461.4 N/A N/A [A.sub.1]-[A.sub.5] N/A N/A -64.2 N/A [A.sub.2]-[A.sub.3] N/A -91.0 -111.2 N/A [A.sub.2]-[A.sub.4] N/A N/A N/A N/A [A.sub.2]-[A.sub.5] N/A N/A -163.3 N/A [A.sub.3]-[A.sub.4] 1109.3 336.5 49.3 2487.2 [A.sub.3]-[A.sub.5] 516.9 1332.7 N/A N/A [A.sub.4]-[A.sub.5] N/A 203.6 30.8 1171.9 Pair of Alternatives [C.sub.5] [C.sub.6] [C.sub.7] [C.sub.8] [A.sub.1]-[A.sub.2] N/A N/A N/A N/A [A.sub.1]-[A.sub.3] 15.0 -10.0 N/A -24.5 [A.sub.1]-[A.sub.4] 9669.7 N/A 8779.0 N/A [A.sub.1]-[A.sub.5] 4745.8 N/A N/A N/A [A.sub.2]-[A.sub.3] 1164.0 N/A N/A N/A [A.sub.2]-[A.sub.4] N/A N/A N/A N/A [A.sub.2]-[A.sub.5] N/A N/A N/A N/A [A.sub.3]-[A.sub.4] N/A 204.7 8371.5 6278.6 [A.sub.3]-[A.sub.5] N/A 1526.6 N/A N/A [A.sub.4]-[A.sub.5] N/A 116.6 4470.3 2235.2 Pair of Alternatives [C.sub.9] [C.sub.10] [C.sub.11] [A.sub.1]-[A.sub.2] N/A -614.9 N/A [A.sub.1]-[A.sub.3] N/A N/A N/A [A.sub.1]-[A.sub.4] N/A 327.2 -1308.7 [A.sub.1]-[A.sub.5] N/A N/A N/A [A.sub.2]-[A.sub.3] N/A N/A N/A [A.sub.2]-[A.sub.4] N/A N/A -3768.4 [A.sub.2]-[A.sub.5] N/A N/A N/A [A.sub.3]-[A.sub.4] N/A 312.0 -1247.9 [A.sub.3]-[A.sub.5] N/A N/A N/A [A.sub.4]-[A.sub.5] N/A 166.6 -666.4 Table 12. Criticality and sensitivity values Code Criticality Degree Sensitivity Value [C.sub.1] -13.5 0.074 [C.sub.2] -69.6 0.014 [C.sub.3] -4.4 0.227 [C.sub.4] -13.9 0.072 [C.sub.5] 15.0 0.067 [C.sub.6] -10.0 0.100 [C.sub.7] 4470.3 0.0002 [C.sub.8] -24.5 0.041 [C.sub.9] N/A N/A [C.sub.10] 166.6 0.006 [C.sub.11] -666.4 0.002 Table 13. All possible absolute critical measures of performance Pair of Alternatives [C.sub.1] [C.sub.2] [C.sub.3] [A.sub.i]-[A.sub.j] [A.sub.1]-[A.sub.2] N/A 120,000,000 N/A [A.sub.1]-[A.sub.3] N/A N/A 25,000,000 [A.sub.1]-[A.sub.4] N/A N/A 45,000,000 [A.sub.1]-[A.sub.5] N/A N/A N/A [A.sub.2]-[A.sub.3] N/A N/A 150,000,000 [A.sub.2]-[A.sub.4] N/A N/A 150,000,000 [A.sub.2]-[A.sub.5] N/A N/A 190,000,000 [A.sub.3]-[A.sub.4] N/A N/A 20,000,000 [A.sub.3]-[A.sub.5] N/A N/A 15,000,000 [A.sub.4]-[A.sub.5] 27.4 70,000,000 N/A Pair of Alternatives [C.sub.4] [C.sub.5] [C.sub.6] [C.sub.7] [A.sub.i]-[A.sub.j] [A.sub.1]-[A.sub.2] N/A N/A N/A N/A [A.sub.1]-[A.sub.3] N/A 2.0 N/A N/A [A.sub.1]-[A.sub.4] N/A N/A N/A N/A [A.sub.1]-[A.sub.5] N/A N/A N/A N/A [A.sub.2]-[A.sub.3] N/A N/A N/A N/A [A.sub.2]-[A.sub.4] N/A N/A N/A N/A [A.sub.2]-[A.sub.5] N/A N/A N/A N/A [A.sub.3]-[A.sub.4] N/A N/A N/A N/A [A.sub.3]-[A.sub.5] N/A N/A N/A N/A [A.sub.4]-[A.sub.5] N/A N/A N/A N/A Pair of Alternatives [C.sub.8] [C.sub.9] [C.sub.10] [C.sub.11] [A.sub.i]-[A.sub.j] [A.sub.1]-[A.sub.2] N/A N/A 6.4 N/A [A.sub.1]-[A.sub.3] 0.4 N/A N/A N/A [A.sub.1]-[A.sub.4] N/A N/A N/A N/A [A.sub.1]-[A.sub.5] N/A N/A N/A N/A [A.sub.2]-[A.sub.3] N/A N/A N/A N/A [A.sub.2]-[A.sub.4] N/A N/A N/A N/A [A.sub.2]-[A.sub.5] N/A N/A N/A N/A [A.sub.3]-[A.sub.4] N/A N/A N/A N/A [A.sub.3]-[A.sub.5] N/A N/A N/A N/A [A.sub.4]-[A.sub.5] 7.3 N/A 2.6 N/A Table 14. All possible relative critical measures of performance Pair of Alternatives [C.sub.1] [C.sub.2] [C.sub.3] [A.sub.i]--[A.sub.j] [A.sub.1]-[A.sub.2] N/A 1714.23 N/A [A.sub.1]-[A.sub.3] N/A N/A 111.11 [A.sub.1]-[A.sub.4] N/A N/A 200 [A.sub.1]-[A.sub.5] N/A N/A N/A [A.sub.2]-[A.sub.3] N/A N/A 416.67 [A.sub.2]-[A.sub.4] N/A N/A 416.67 [A.sub.2]-[A.sub.5] N/A N/A 527.78 [A.sub.3]-[A.sub.4] N/A N/A 1000 [A.sub.3]-[A.sub.5] N/A N/A 750 [A.sub.4]-[A.sub.5] 228.3 350 N/A Overall Criticality 228.3 350 111.11 Pair of Alternatives [C.sub.4] [C.sub.5] [C.sub.6] [A.sub.i]--[A.sub.j] [A.sub.1]-[A.sub.2] N/A N/A N/A [A.sub.1]-[A.sub.3] N/A -13.3 -8.95 [A.sub.1]-[A.sub.4] N/A N/A N/A [A.sub.1]-[A.sub.5] N/A N/A N/A [A.sub.2]-[A.sub.3] N/A N/A N/A [A.sub.2]-[A.sub.4] N/A N/A N/A [A.sub.2]-[A.sub.5] N/A N/A N/A [A.sub.3]-[A.sub.4] N/A N/A N/A [A.sub.3]-[A.sub.5] N/A N/A N/A [A.sub.4]-[A.sub.5] N/A N/A 365.35 Overall Criticality N/A -13.3 -8.95 Pair of Alternatives [C.sub.7] [C.sub.8] [C.sub.9] [A.sub.i]--[A.sub.j] [A.sub.1]-[A.sub.2] N/A N/A N/A [A.sub.1]-[A.sub.3] N/A -28.57 N/A [A.sub.1]-[A.sub.4] N/A N/A N/A [A.sub.1]-[A.sub.5] N/A N/A N/A [A.sub.2]-[A.sub.3] N/A N/A N/A [A.sub.2]-[A.sub.4] N/A N/A N/A [A.sub.2]-[A.sub.5] N/A N/A N/A [A.sub.3]-[A.sub.4] N/A N/A N/A [A.sub.3]-[A.sub.5] N/A N/A N/A [A.sub.4]-[A.sub.5] N/A 2920 N/A Overall Criticality N/A -28.57 N/A Pair of Alternatives [C.sub.10] [C.sub.11] [A.sub.i]--[A.sub.j] [A.sub.1]-[A.sub.2] 640 N/A [A.sub.1]-[A.sub.3] N/A N/A [A.sub.1]-[A.sub.4] N/A N/A [A.sub.1]-[A.sub.5] N/A N/A [A.sub.2]-[A.sub.3] N/A N/A [A.sub.2]-[A.sub.4] N/A N/A [A.sub.2]-[A.sub.5] N/A N/A [A.sub.3]-[A.sub.4] N/A N/A [A.sub.3]-[A.sub.5] N/A N/A [A.sub.4]-[A.sub.5] 173.3 N/A Overall Criticality 173.3 N/A