Powered By Blogger

Friday, February 3, 2012

Fuzzy Delphi Method to Design a Strategic Plan


Nowadays, Fuzzy Delphi Method (FDM) is broadly used by researchers in the various fields of Science, Technology and Management. This method was stated by Ishikawa et al. (1993) in which it is the integration between the traditional Delphi techniques and fuzzy set theory.
In this article, I am willing to employ FDM to design a strategic plan. At the first, I will explain a brief methodology of Fuzzy Delphi Method then I will depict step by step to make a strategic plan and I will highlight where we need to utilize FDM. Finally, I will bring an example for better perception of FDM.





Methodology  

Traditional Delphi method is an approach to gathering information from high qualified experts to develop the predictions about future events. A panel of experts is chosen. Then, they release their opinions for each feature where the responses of experts are collected and analyzed statistically. The processed data will communicate with the experts again to write another response. This procedure will be repeated rounds of questioning and written responses in which the outcome will cover the reasonable data to solve a problem or to forecast an event in the future.  This method was developed by the Rand Corporation at Santa Monica, California in the late 1960s. One of the most important problems is to solve the fuzziness of the expert consensus within the group decision making. Murray et al. (1985) first proposed the application of fuzzy theory to the Delphi method. Then Ishikawa et al. (1993) utilized the maximum-minimum method together with cumulative frequency distribution and fuzzy scoring to compile the expert opinions into fuzzy numbers. We can use triangular fuzzy number, trapezoidal fuzzy number and Gaussian fuzzy number as the selection of fuzzy membership functions. There are many Fuzzy Delphi methods such as basic FDM, Fuzzy Analytic Hierarchy Process (FAHP), and the concept of distance (dij) between two triangular numbers refer to Kaufmann and Gupta (1988). In this article, my example is applied the triangular membership functions referred to basic FDM accompanied by the type of alpha –cut method (Ranking) as threshold. But in the next article, I will bring an example of Distance method and I will compare these two methods. (Why?) I will tell you the reason behind of this comparison in the next article.
Now, let us see a literature review of basic FDM as follows:

Yu-Lung Hsu et al. (2010) stated the steps of basic FDM: [1]

1. Collect opinions of decision group: Find the evaluation score of each alternate factor’s significance given by each expert by using linguistic variables in questionnaires.

  2. Set up triangular fuzzy numbers: Calculate the evaluation value of triangular fuzzy number of each alternate factor given by experts, find out the significance triangular fuzzy number of the alternate factor.

  3. Defuzzification: Use simple centre of gravity method to defuzzify the fuzzy weight.

  4. Screen evaluation indexes: Finally proper factors can be screened out from numerous    factors by setting the threshold.”

I also used from above steps for my example in this article.

Designing Strategic Plan

Here, I follow the steps which should be taken to design a strategic plan simultaneously I highlight the items which need to utilize FDM.
In fact, by designing a strategic plan, we look at the image of the company or industry including current vision and mission then we will make new vision and vision as the outlooks of the company or industry. Let’s go the steps:

1) Overview of the company
2) History of the company
3) Current vision & mission
4) Strategic goals
5) Current strategies
6) External or Internal consideration (Is the company Industry base or Resource base?)
7) Financial performance
8) Financial and Strategic Objectives
4) Strategy - Making Hierarchy including corporate strategy, business strategy, functional area strategies within each business, operating strategies within each business.
5) PEST Analysis (The components of a company’s Microenvironment) including:
    5-1) The impact factors of political issues
    5-2) Dominant Economic Factors
     5 -3) Dominant Socio – Cultural Factors
    5-3) Dominant Technology Factors
We need to use from FDM to rank and to find priorities.
6) Porter’s forces
According to Porter’s forces, we have below forces:
-Power of Suppliers
-Power of Buyers
-Threat of New Entrants
-Threat of Substitutions
-Rivalry
To determine the ranking and priorities for each force, we need to use from FDM.
7) Strategic Map Application
By using of Strategic Group Maps, we will be able to assess the market positions of key competitors. We should identify the competitive characteristics and choose pairs of these differentiating characteristics then we should plot the firms on a two – variable map (pair characteristics).
Therefore, we need to utilize FDM to rank a pair characteristic for all firms.
7) Driving Forces
 We will use FDM to rank the most important driving forces that can affect an industry.
8) Industry structure
9) Key Success Factors (KSF)
These Key Success Factors can be referred to Driving forces. Which are the drivers of change unique?
10) The External Factor Evaluation (EFE) Matrix and the Competitive Profile Matrix (CPM)
By using of Driving Forces and KSF, we should find the most important Opportunities and Threats which are affecting on industry and company. Then we should rank all weights and ratings for each Opportunities and Threats.
Therefore, we need to approach FDM.
11) Traditional Porter’s Value Chain
12) Appraising the Resources and Capabilities
What are the Resources and Capabilities important to industry? What are the rank of them for the industry and the company?
We can use FDM to rank the Resources and Capabilities for the industry and the company.
13) To derive all key Strengths and key Weaknesses of the company referred to Appraising the Resources and Capabilities and Value Chain. For instance, we can use the value chain in cost analysis in which we should analyze three sections of Sequence of Analysis, Value Chain, and cost drivers.
14) Assessment of internal factors for strategic advantage
15) The Internal Factor Evaluation (IFE) Matrix
By using of above items (11, 12, 13, 14), we are expected to find the most important Strengths and weaknesses which are affecting on the company. Then we should rank all weights and ratings for each Strengths and weaknesses.
 Therefore, we need to approach FDM.
 16) Impact Analysis
This is a matrix where Strengths and weaknesses are on column and the drivers of change (Driving Forces) are on row. We should give the score numbers between minus (x) to plus (x) for each member of this matrix.
As you can see, to solve fuzziness among this matrix, we need to use FDM.
17) Competitor Analysis
This matrix is another type of Impact Analysis in which the company and major competitors are on column of matrix and the drivers of change are on row.
We can also utilize FDM to solve fuzziness among this matrix.
17) SWOT Matrix
18) The Space Matrix
In this matrix, we have two internal dimensions (financial position, and competitive position) and two external dimensions (stability position, and industry position) on vertical and horizontal axis of a four – quadrant framework.  We should give the score numbers between minus (x,y) to plus (x,y) for each dimension.
The best method to prevent the fuzziness is to use FDM.
19) The Boston Consulting Group (BCG) Matrix
20) The Internal – External (IE) matrix
When we need to use FDM for EFE and IFE, it means that we can apply FDM for this matrix.
21) The Grand Strategy Matrix
22) Ansoff Matrix
23) GE / Mc Kinsey Matrix
We should find the external factors which are affecting on industry or market attractiveness and so we should extract the internal factors which are affecting on competitive strength of a strategic business unit (Business unit strength). Then, we should give the weight and rating to each factors in which we will have a rank for market attractiveness and a rank for Business unit strength. On column of Mc Kinsey matrix, we have market attractiveness and on row, we have Business unit strength. Finally, we can evaluate the business unit in linguistic values of low, medium, high.
In the result, to prevent fuzziness, we can use FDM for this matrix.
24) Finally, we can find out the suggested vision and mission by using of above framework.
Example of Fuzzy Delphi Method
As you can see, the driving forces are the most important factors to design a strategic plan. Therefore, I have chosen the driving forces as my example of FDM depicted as follows:
According to book of “Crafting and Executing strategy: The Quest for Competitive Advantage: Concepts and Cases by Thompson, Peteraf, Gamble, Strickland, the most common driving forces have been introduced below cited:

The Most Common Driving Forces
1. Changes in the long-term industry growth rate.
2. Increasing globalization.
3. Emerging new Internet capabilities
4. Changes in who buys the product and how they use it
5. Production innovation
6. Technological change and manufacturing process innovation
7. Marketing innovation.
8. Entry or exit of major firms
9. Diffusion of technical know – how across more companies and more countries
10. Changes in cost & efficiency
11. Growing buyer preferences for differentiated products instead of standardized commodity product (or for a more standardized product instead of strongly differentiated products)
12. Reductions in uncertainty & business risks.
13. Regulatory influences government policies changes.
14. Changing societal concerns, attitudes, and life styles.
I write the codes for driving forces as follows:

Codes of Driving Forces
1
DF1
2
DF2
3
DF3
4
DF4
5
DF5
6
DF6
7
DF7
8
DF8
9
DF9
10
DF10
11
DF11
12
DF12
13
DF13
14
DF14

I assume that I have chosen 14 high qualified experts to conduct a Delphi technique and also I have found the weights for each expert in accordance with their work experiences, academic level and so on. (The weights are not need for this article. I will reserve them for my next article)

Experts
Weights
E1
0.04
E2
0.08
E3
0.09
E4
0.1
E5
0.07
E6
0.05
E7
0.09
E8
0.07
E9
0.06
E10
0.06
E11
0.07
E12
0.09
E13
0.05
E14
0.08

The linguistic values have been purposed as follows:

Linguistic Values
Pessimistic = P
Most likely = M
Optimistic = O

I collected the significant opinions of the experts for each driving force. Here, I have brought a sample for DF1.  The others (thirteen samples) have been included in my spreadsheet of excel file.

DF1
Experts
Weight
P
M
O
2
6
8
E2
0.08
1
5
9
E3
0.09
3
7
10
E4
0.1
1
6
9
E5
0.07
2
7
9
E6
0.05
4
5
6
E7
0.09
3
6
9
E8
0.07
5
7
9
E9
0.06
1
6
10
E10
0.06
3
6
8
E11
0.07
2
5
9
E12
0.09
4
6
8
E13
0.05
1
4
7
E14
0.08
2
5
9

I calculated the evaluation value of triangular fuzzy number of each driving force given by the experts. In fact, we have three matrixes as follows:

W ij = (Pij, Mij, Oij)
Where:
i = 1, 2 ….14
j = 1, 2 ….14
No. j driving force given by No. i expert of 14 experts and 14 driving forces (j)

Then the fuzzy weighting Wj of No. j driving force is: Wj = (Pj, Mj, Oj) and j = 1, 2 ….14 where:
Pj = Min {Pij},   Mj = Sum {Mij} /14,    Oj = Max {Oij}
The below table shows us the final results:

DF
P
M
O
DF1
1
5.79
10
DF2
2
6.36
10
DF3
1
6.36
10
DF4
1
6.43
10
DF5
1
6.14
10
DF6
1
6.29
10
DF7
2
6.14
10
DF8
1
6.29
10
DF9
1
6.07
10
DF10
1
6.29
10
DF11
2
6.86
10
DF12
1
6.36
10
DF13
2
6.05
9
DF14
2
6.43
10

The next step is Defuzzification in which we should defuzzify the fuzzy weight of Wj.
The simple method is to use below formula:
Sj = (Pj + Mj+ Oj) / 3            j = 1, 2 ….14

The results have been included in below table:

DF
Sj
DF1
5.595238
DF2
6.119048
DF3
5.785714
DF4
5.809524
DF5
5.714286
DF6
5.761905
DF7
6.047619
DF8
5.761905
DF9
5.690476
DF10
5.761905
DF11
6.190476
DF12
5.785714
DF13
5.666667
DF14
6.142857


 Finally, we should define a threshold as alpha-cut to obtain proper driving forces which can be screened out from numerous driving forces by setting this threshold. The principle of screening is as follows:

If   Sj > alpha-cut, then No. j driving force is the evaluation index.
If   Sj < alpha-cut, then delete No. j driving force.

In this article, I consider alpha-cut = 6. Therefore, the appropriate driving forces are:

DF2:  Increasing globalization

DF7:  Marketing innovation

DF11:  Growing buyer preferences for differentiated products instead of standardized commodity product (or for a more standardized product instead of strongly differentiated products)

DF14:  Changing societal concerns, attitudes, and life styles

I have brought all above steps of Fuzzy Delphi Method on spreadsheet of excel file.




Note:  “All spreadsheets and calculation notes are available. The people, who are interested in having my spreadsheets of this method as a template for further practice, do not hesitate to ask me by sending an email to: soleimani_gh@hotmail.com or call me on my cellphone: +989109250225.   Please be informed these spreadsheets are not free of charge.”

I made all triangularFuzzy numbers by using of Monte Carlo technique because I had not any expert’s opinion.
This template can be also utilized for designing in the fields of engineering such as heat exchangers or Air –Pre Heater (APH) stated on below links:
As you know, there are so many business opportunities on the models of heat exchangers or APH to save energy. Everybody can test her/his creativity and chance to find out the new models.
Now, we can design the strategic plan for many topics by using of above template. Here are two examples of these topics:
-A strategic plan on Electricity Industry in USA
-A strategic Plan on Residential property industry in Middle East. 


 References

Book
1) Bojadziev, George., & Bojadziev, Maria (2007). FUZZY LOGIC FOR BUSINESS, FINANCE, AND MANAGEMENT (2nd ed.). London:  World Scientific Publishing Co. Pte. Ltd.
2) Thompson, Arthur., Peteraf, Margaret., Gamble, John., Strickland, A. J. (2011). Crafting and Executing strategy: The Quest for Competitive Advantage: Concepts and Cases (18th ed.). Churchville: Irwin/McGraw-Hill.
Papers   
1) Hsu,Yu-Lung., Lee, Cheng-Haw., & Kreng, V.B. (2010). The application of Fuzzy Delphi Method and Fuzzy AHP in lubricant regenerative technology selection. Expert Systems with Applications, 37, 419–425.

2) Dutta, Palash., Boruah, Hrishikesh., & Ali,Tazid. (2011). Fuzzy Arithmetic with and without using α-cut method: A Comparative Study. International Journal of Latest Trends in Computing 2 (1).

3) Glumac, Brano., Han, Qi., Smeets, Jos., & Schaefer, Wim. (2011). Brownfield redevelopment features: applying Fuzzy Delphi. Journal of European Real Estate
Research, 4(2), 145-159.

 

Thursday, January 19, 2012

Discounted Cash Flow Analysis plus Monte Carlo Method to Analyze Share Price of a Company


One of the basic methods to examine the share price of a company is to utilize the Discounted Cash Flow Analysis (DCF). The Purpose of this article is, applying Monte Carlo method for a DCF to reach at least standard deviation (STDEV). I again chose  financial case of  Nike, Inc: Cost of Capital because this case has a ready Discounted Cash Flow analysis that we can use it as a good template just like to below spreadsheet:



Note: By using above template, you will be able to make your own DCF analysis for any company, if you have at least two years the Balance sheet and Income statement of the company. These data have been included in annual report of each company. 

In the reference with my previous post of http://www.emfps.org/2011/06/case-analysis-of-nike-inc-cost-of.html
I stated: “…But I am willing to tell you that it can be a complex case in which we can doubt about sensitivity analysis done by Kimi Ford (portfolio manager) too. Because her assumptions such as Revenue Growth Rate, COGS / Sales,
S &A / Sales, Current Assets / Sales, and Current Liability / Sales have been adopted from previous income statements and balance sheets from 1995 to 2001. Perhaps, we can take new assumptions.”
As we know, the most crucial thing to bear in mind for a true financial analysis is to reach to the accurate and reasonable assumptions. We usually use from five years of annual reports to gather data from income statements and balance sheets as the sources of our assumptions. This is only an internal analysis and maybe it will be enough for small size companies. But to analyze the big size companies, we should not only have an internal analysis but also external analysis such as PEST and Porter’s Five Forces to find out competitive advantages. In this case, I have only examined the influence of the economic indicators included in Macroeconomic as driving forces but we as well as know to take a good external analysis, we should analyze the impacts of Political issues, Society-Culture, Technology and prepare a SWOT analysis compatible with value chain (value- added) and Porter’s five forces. This is only a sample of external – internal analysis for Case of Nike, Inc. in which I would like to expand a Monte Carlo Analysis on this case. How can we do our analysis?

In this article, I am willing to tell you the method of Monte Carlo Analysis done on the case of Nike, Inc.: Cost of Capital step by step as follows:

Ø  At the first, we should make a spreadsheet just like EXHIBIT 2 (Discounted Cash Flow Analysis) made by Kimi Ford. This spreadsheet will be our basic platform of the simulation model (Monte Carlo).
Ø  We should have so many scenarios on assumptions such as Revenue Growth rate (%), COGS / Sales (%), S & A / Sales (%), Tax rate (%), Current assets / Sales (%), Current liabilities/ Sales (%), Terminal value growth rate (%) and merge all scenarios to find out what the share price is most sensitive to assumptions. In fact, we would like to know which assumptions have most impact on enterprise value or share price.
Ø  To make the scenario analysis on your spreadsheet (Excel 2007), please go to Data – What-If Analysis – Scenario Manager – Add and write the name of scenario – Changing Cell – write the range of your assumption – Protection –Hide – OK.
Ø  I already made so many scenarios and I merged them together where I found that the assumptions of COGS / Sales (%), S & A / Sales (%) have most impact on share price and enterprise value.
Ø  Kimi Ford considered a range of COGS / Sales between 0.58 and 0.6, and a range of S & A / Sales between 0.25 and 0.28. These ranges could be compatible with five years income statement which is an internal analysis.
Ø  But to take an external analysis, we should find the economic indicators which are driving forces on COGS / Sales and S & A / Sales. Then we should consider the probability distribution for each range of COGS / Sales and S & A / Sales in accordance with data collected from economic indicators.
Ø  Firstly, the timing of our external analysis is very important. We should bear in mind that we are on July 5, 2001(the date of the Case). Therefore. We should collect and select economic indicators data before 2001 year to expand our projection of probability distribution for next 10 years until 2011year.
Ø  The economic indicators, which are affecting on COGS / Sales and S & A / Sales, are Unemployment rate, Inflation rate, PPI (Product Price Index), CPI (Consumer Price Index), and Economic growth rate.
Ø   I collected and selected the economic indicator data from below links:


              http://www.bls.gov/ppi/

              http://www.bls.gov/bls/newsrels.htm#OEUS




              http://www.bea.gov/




Ø  The relationship between inflation rate and unemployment rate is vice versa. It means that in the period of high inflation rate, the rate of unemployment will decrease. But a high inflation rate will increase the price of goods sold including the cost of hiring the workers. The employers have to pay the demand of workers for higher wages during the period of low unemployment rate. If we have a high unemployment rate but during the period of high inflation, the Consumer Price Index will be increase in which the price of goods in stores will go up. Whereas the employers are able to hire the cheaper workers in the period of high unemployment rate, but if the workers cannot receive the enough wages or any loan to purchase the goods, the stores will have to decrease the price of their goods where it will lead to a lower inflation. It is the same first relationship mentioned between inflation rate and unemployment rate which is Vice Versa.
Ø  According to the data selected by me from above links, the unemployment rate fell down from 1995 to 2000 year while we had an increase on PPI and inflation rate. Therefore, my assumption for probability distribution on COGS / Sales and S & A / Sales referred to the outcomes are as follows:

Outcomes
Probability
        S&A / sales
                        COGS/sales
 Stagnant
      0.1
0.25
0.58
 Slow growth
      0.3
0.26
0.59
Average growth
      0.35
0.27
0.6
 Rapid growth
      0.25
0.28
0.61


Ø  Now, I can start the Monte Carlo Analysis as follows:
Ø  I considered the formula = Rand() for COGS / Sales and S & A / Sales to generate the random numbers.
Ø  I obtained the cut-offs table for COGS / Sales and S & A / Sales separately as follows:

Cutoffs
S&A / sales
0
0.25
0.1
0.26
0.4
0.27
0.75
0.28
cutoffs
COGS/sales
0
0.58
0.1
0.59
0.4
0.6
0.75
0.61


Ø  Then, I replaced the formula = Vlookup instead of numbers 0.6 and 0.28 for 2002 year in spreadsheet and copy & paste them for all years.
Ø  Finally, I made a Two –Way Data Table where the column was included the numbers of 1 to 1000 and row was included as variable of discount rate and the impact of column and row variables were on share price. When I run this sensitivity analysis, the calculation was repeated for 1000 times from random numbers of COGS / Sales and S & A / Sales. You can see this model on following GIF s.








Ø  The result of mean and standard deviation for share prices in related to the Cost of Capital have been sorted in below table:

Mean
STDEV
WACC
Share price
Share  price
12%
30.15
2.14
11.50%
32.48
2.39
11.17%
34.03
2.62
11%
35.02
2.64
10.50%
37.43
2.96
10%
40.63
2.93
9.50%
44.34
3.48
9%
48.79
3.97
8.50%
54.20
4.68
8%
60.16
5.33



As we can see, above table shows us that if the cost of capital of Nike increase more than 9.8%, its share price will be overvalue and it will not be valuable. But, if we refer to my previous analysis mentioned on link: http://www.emfps.org/2011/09/case-analysis-of-nike-inc-cost-of.html, we can find that WACC = 7.92% consequently to purchase the share price is valuable.

Now, let me return back today and see Close share price of Nike extracted from Yahoo. Finance from 2001 to 2011 sorted on below table:

Average for each year
Year
Share price
2001
51.08
2002
50.97
2003
56.21
2004
76.93
2005
83.59
2006
86.10
2007
70.50
2008
61.01
2009
55.40
2010
74.79
2011
87.93

What do you think about my economic analysis? Is it true or wrong?
Nowadays, Nike, Inc.’s cost of capital should be approximately 7%.



All researchers and individual people, who are interested in having this model, don’t hesitate to send their request to below addresses: