{"id":60,"date":"2022-01-04T21:07:58","date_gmt":"2022-01-04T21:07:58","guid":{"rendered":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/chapter\/2-4-project-selection-process\/"},"modified":"2025-01-03T02:18:39","modified_gmt":"2025-01-03T02:18:39","slug":"2-4-project-selection-process","status":"publish","type":"chapter","link":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/chapter\/2-4-project-selection-process\/","title":{"rendered":"2.4 Project Selection Process"},"content":{"raw":"Quantitative and qualitative analysis are useful in identifying projects with the greatest potential impact. Generally, more complex projects involve a greater amount of risk. They also require a longer implementation and business benefits realization period. Therefore, project selection decisions will weigh the benefits offered with the timeframe required to realize these benefits. Organizations will often consider the payback period, which refers to the amount of time it takes to recover the cost of an investment. Projects that offer significant benefits that can be realized relatively quickly are more likely to be approved. However, this is only one of the methods to evaluate if a project is favorable compared with other projects.[footnote]<a href=\"https:\/\/www.investopedia.com\/terms\/p\/paybackperiod.asp\">https:\/\/www.investopedia.com\/terms\/p\/paybackperiod.asp<\/a>[\/footnote]\r\n<h2>2.4.1 Payback Period<\/h2>\r\nIn Chapter 1, we evaluated the uniqueness and temporary nature of a project through which our grocery market chain, Grocery LLC, aimed at establishing self-checkout areas at all fifty markets across five states to solve the problem of more than usual traffic between 4 pm and 7 pm during the weekdays. Assume that we had two solution candidates for this problem. One is establishing the self-checkout area at all fifty stores (<a href=\"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/chapter\/1-2-project-characteristics\/\">see Chapter 1, the first example in Section 1.2<\/a>). Let\u2019s name the \u201cestablishment of self-checkout areas\u201d project \u201cProject B.\u201d We also wanted to evaluate another solution to increase the number of checkout stations where our cashiers work. This solution is named Project A.\r\n\r\nTable 2.4.1 provides cash inflows and outflows of two candidate projects, assuming that both project deliverables have a lifetime of five years. As seen in the table, the payback period for Project A would be three years, which means that our organization can recover the cost ($100,000) of this project\u2019s investment in three years.\r\n\r\n-100,000 (year 0) + 30,000 (<em>year<\/em> 1) + 40,000 (<em>year<\/em> 2) + 30,000 (<em>year<\/em> 3) = 0\r\n<table class=\"grid\" style=\"border-collapse: collapse;width: 100%;height: 145px\" border=\"0\"><caption>Table 2.4.1: Cash outflow and inflows of two projects ($)<\/caption>\r\n<tbody>\r\n<tr style=\"height: 19px\">\r\n<td style=\"width: 10%;height: 37px\" rowspan=\"2\"><\/td>\r\n<td style=\"width: 33.3333%;height: 19px;text-align: center\"><strong>Project A<\/strong><\/td>\r\n<td style=\"width: 33.3333%;height: 19px;text-align: center\"><strong>Project B<\/strong><\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 33.3333%;height: 18px;text-align: center\"><strong>(Traditional checkout stations)<\/strong><\/td>\r\n<td style=\"width: 33.3333%;height: 18px;text-align: center\"><strong>(Self-checkout areas)<\/strong><\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 10%;height: 18px\"><strong>Year 0<\/strong><\/td>\r\n<td style=\"width: 33.3333%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($100,000)<\/span><\/td>\r\n<td style=\"width: 33.3333%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($200,000)<\/span><\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 10%;height: 18px\"><strong>Year 1<\/strong><\/td>\r\n<td style=\"width: 33.3333%;height: 18px;text-align: center\">$30,000<\/td>\r\n<td style=\"width: 33.3333%;height: 18px;text-align: center\">$15,000<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 10%;height: 18px\"><strong>Year 2<\/strong><\/td>\r\n<td style=\"width: 33.3333%;height: 18px;text-align: center\">$40,000<\/td>\r\n<td style=\"width: 33.3333%;height: 18px;text-align: center\">$50,000<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 10%;height: 18px\"><strong>Year 3<\/strong><\/td>\r\n<td style=\"width: 33.3333%;height: 18px;text-align: center\">$30,000<\/td>\r\n<td style=\"width: 33.3333%;height: 18px;text-align: center\">$75,000<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 10%;height: 18px\"><strong>Year 4<\/strong><\/td>\r\n<td style=\"width: 33.3333%;height: 18px;text-align: center\">$10,000<\/td>\r\n<td style=\"width: 33.3333%;height: 18px;text-align: center\">$105,000<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 10%;height: 18px\"><strong>Year 5<\/strong><\/td>\r\n<td style=\"width: 33.3333%;height: 18px;text-align: center\">$10,000<\/td>\r\n<td style=\"width: 33.3333%;height: 18px;text-align: center\">$75,000<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nFor Project B, the payback period would be 3.57 years (3 years + 60,000\/105,000). As seen in Table 2.4.2, when we finished the third year, the net cash flow was still negative (-200,000 + (15,000 + 50,000 + 75,000) = - 60.000). Therefore, the breakeven point would be after the fourth year. Because Project A\u2019s payback period (3 years) is shorter than Project B\u2019s (3.57 years), we can prefer Project A over Project B, only considering the payback period.\r\n<table class=\"grid\" style=\"border-collapse: collapse;width: 100%;height: 144px\" border=\"0\"><caption>Table 2.4.2: Net cash inflows of two projects ($)<\/caption>\r\n<tbody>\r\n<tr style=\"height: 36px\">\r\n<td style=\"width: 20%;height: 36px\"><\/td>\r\n<td style=\"width: 20%;height: 36px;text-align: center\"><strong>Project A<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 36px;text-align: center\"><strong>Net Cash Flow<\/strong><\/td>\r\n<td style=\"width: 20%;height: 36px;text-align: center\"><strong>Project B<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 36px;text-align: center\"><strong>Net Cash Flow<\/strong><\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20%;height: 18px\"><strong>Year 0<\/strong><\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($100,000)<\/span><\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($100,000)<\/span><\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($200,000)<\/span><\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($200,000)<\/span><\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20%;height: 18px\"><strong>Year 1<\/strong><\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\">$30,000<\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($70,000)<\/span><\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\">$15,000<\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($185,000)<\/span><\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20%;height: 18px\"><strong>Year 2<\/strong><\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\">$40,000<\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($30,000)<\/span><\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\">$50,000<\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($135,000)<\/span><\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20%;height: 18px\"><strong>Year 3<\/strong><\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\">$30,000<\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">$0<\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\">$75,000<\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($60,000)<\/span><\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20%;height: 18px\"><strong>Year 4<\/strong><\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\">$10,000<\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">$10,000<\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\">$105,000<\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">$45,000<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20%;height: 18px\"><strong>Year 5<\/strong><\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\">$10,000<\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">$20,000<\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\">$75,000<\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">$120,000<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<h3>2.4.1.1 Discount Factor<\/h3>\r\nHowever, this financial method ignores a crucial factor that may affect the real value of our cash inflows, which is the time value of the money, that is affected by two main annual rates: (1) Inflation rate (p<sub>t<\/sub>) and (2) required rate of return (r). Therefore, the discount factor must be incorporated into the computation to have real values.\r\n\r\n<img src=\"https:\/\/pressbooks.ulib.csuohio.edu\/project-management-navigating-the-complexity\/wp-content\/uploads\/sites\/183\/2022\/01\/discount-factor.png\" alt=\"Discount factor equation\" width=\"277\" height=\"53\" class=\"alignleft wp-image-58\" \/>\r\n\r\n&nbsp;\r\n\r\n&nbsp;\r\n\r\nIn our example above, let\u2019s take p<sub>t<\/sub> 0.02 and r 0.08. Our organization expects to earn a minimum of 0.08 annually on average when we invest. This can also be considered as the opportunity cost.\r\n\r\n<img src=\"https:\/\/pressbooks.ulib.csuohio.edu\/project-management-navigating-the-complexity\/wp-content\/uploads\/sites\/183\/2024\/07\/equation-above-table-2_3.png\" alt=\"equation from year 1 to year 5\" width=\"476\" height=\"247\" class=\"alignleft wp-image-59\" \/>\r\n\r\n&nbsp;\r\n\r\n&nbsp;\r\n\r\n&nbsp;\r\n\r\n&nbsp;\r\n\r\n&nbsp;\r\n\r\n&nbsp;\r\n\r\nFor each year, we should multiply the discount factor by each cash inflow to find the real value.\r\n<table class=\"aligncenter\" style=\"border-collapse: collapse;width: 100%;height: 126px\" border=\"0\"><caption>Table 2.4.3: Net cash outflow and inflows of two projects with discount factors ($)<\/caption>\r\n<tbody>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 14.2857%;height: 18px\"><\/td>\r\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\"><strong>Project A<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\"><strong>Today's Value<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\"><strong>Net Cash Flow<\/strong><\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><strong>Project B<\/strong><\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><strong>Today's Value<\/strong><\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><strong>Net Cash Flow<\/strong><\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 14.2857%;height: 18px\"><strong>Year 0<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($100,000)<\/span><\/td>\r\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($100,000)<\/span><\/td>\r\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($100,000)<\/span><\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($200,000)<\/span><\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($200,000)<\/span><\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($200,000)<\/span><\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 14.2857%;height: 18px\"><strong>Year 1<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\">$30,000<\/td>\r\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\">$27,273<\/td>\r\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($72,727)<\/span><\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">$15,000<\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">$13,636<\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($186,364)<\/span><\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 14.2857%;height: 18px\"><strong>Year 2<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\">$40,000<\/td>\r\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\">$33,058<\/td>\r\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($39,669)<\/span><\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">$50,000<\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">$41,322<\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($145,041)<\/span><\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 14.2857%;height: 18px\"><strong>Year 3<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\">$30,000<\/td>\r\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\">$22,539<\/td>\r\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($17,130)<\/span><\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">$75,000<\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">$56,349<\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($88,693)<\/span><\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 14.2857%;height: 18px\"><strong>Year 4<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\">$10,000<\/td>\r\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\">$6,830<\/td>\r\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($10,300)<\/span><\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">$105,000<\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">$71,716<\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($16,976)<\/span><\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 14.2857%;height: 18px\"><strong>Year 5<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\">$10,000<\/td>\r\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\">$6,209<\/td>\r\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($4,091)<\/span><\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">$75,000<\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">$46,569<\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">$29,593<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nAs can be seen in Table 2.4.3, the payback period changed for both projects. The payback period for Project A cannot be attained in five years, which means that our organization cannot recover the cost ($100,000) of this project\u2019s investment even in five years. For Project B, it would be 4.36 years (4 years + 16,976\/46,569). Eventually, after taking into account the time value of the money, we can choose Project B over Project A, contrary to our first decision without the discount factor.\r\n<h2>2.4.2 Net Present Value (NPV)<\/h2>\r\nNPV (Net Present Value) is another way of showing the long-term profitability of a project. At the end of the expected lifetime of a project outcome, NPV indicates the profit (Earnings \u2013 Project investment costs). As seen in Table 2.4.4, NPV is negative for Project A and positive for Project B. Therefore, we can select B over A.\r\n<table class=\"grid\" style=\"border-collapse: collapse;width: 100%;height: 162px\" border=\"0\"><caption>Table 2.4.4: NPVs for Projects A and B ($)<\/caption>\r\n<tbody>\r\n<tr style=\"height: 36px\">\r\n<td style=\"width: 20%;height: 36px\"><\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 36px\"><strong>Project A<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 36px\"><strong>Today's Value<\/strong><\/td>\r\n<td style=\"width: 20%;height: 36px\"><strong>Project B<\/strong><\/td>\r\n<td style=\"width: 20%;height: 36px\"><strong>Today's Value<\/strong><\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20%;height: 18px\"><strong>Year 0<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($100,000)<\/span><\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($100,000)<\/span><\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($200,000)<\/span><\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($200,000)<\/span><\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20%;height: 18px\"><strong>Year 1<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">$30,000<\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">$27,273<\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\">$15,000<\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\">$13,636<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20%;height: 18px\"><strong>Year 2<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">\u00a0$40,000<\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">$33,058<\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\">$50,000<\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\">$41,322<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20%;height: 18px\"><strong>Year 3<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">\u00a0$30,000<\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">$22,539<\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\">$75,000<\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\">$56,349<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20%;height: 18px\"><strong>Year 4<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">\u00a0$10,000<\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">$6,830<\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\">$105,000<\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\">$71,716<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20%;height: 18px\"><strong>Year 5<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">\u00a0$10,000<\/td>\r\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">$6,209<\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\">$75,000<\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\">$46,569<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 20%;height: 18px\"><strong>NPV<\/strong><\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\"><\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($4,091)<\/span><\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\"><\/td>\r\n<td style=\"width: 20%;height: 18px;text-align: center\">$29,593<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nFinancial models such as payback period and NPV are solely the financial indicators. Since little about the specific solution may be known during project selection, financial evaluations are based only on high-level estimates. However, organizations must consider other qualitative factors such as competitive advantage, future market potential, risk, legal and regulatory issues, and safety. Therefore, many organizations utilize project selection models where they can include criteria prioritized for the organization in general, as well as the projects and their affiliated programs and portfolios. In this chapter, we will discuss only one of the models commonly used by organizations, which is the weighted scoring model.\r\n<h2>2.4.3 Weighted Scoring Model<\/h2>\r\nNon-financial reasons for selecting projects are often viewed as strategic considerations; they include everything from ending a dependency on an unreliable vendor to restoring the image of an organization. Once a project is selected, a more detailed financial analysis is often performed. Since decision-making models often consider numerous criteria when evaluating the change alternatives, tools such as the weighted scoring model are very helpful. Weighted scoring models introduce objectivity in what would otherwise be a very subjective decision-making process. A weighted scoring model allows decision-makers to structure the decision-making process by specifying and prioritizing needs by identifying decision-making criteria, evaluating, rating, and comparing different alternatives, and selecting the best matching solution.\r\n\r\nCreating a weighted scoring model starts with careful consideration of decision-making criteria. In the case of project selection, many organizations refer to their strategic plans to identify important factors. These criteria are often a mix of financial and non-financial criteria. Once the criteria have been selected, we give each criterion a weight value to illustrate its relative importance. The more important the criterion, the higher its weight. Each potential change initiative (e.g., business cases) is evaluated against the weighted criteria and given a score for each criterion. These models can help us introduce more objectivity into our decision-making.\r\n<h3>2.4.3.1 Grocery LLC's Projects<\/h3>\r\nLet us continue with our grocery market chain\u2019s project candidates. Thereafter, let us increase the number of projects to four. The project selection committee will evaluate these four potential projects based on six criteria. We have already discussed two projects\u2019 NPVs. The committee had scheduled a meeting today to discuss these four projects (Table 2.4.5). Project A targets increasing the traditional checkout stations in all the markets if their layouts allow for expansion inside the markets. Project B aims to designate areas for self-checkout stations. In this project, we must reduce the number of traditional checkout stations. Project C\u2019s goal is to create new ads for television and social media (e.g., YouTube, Facebook, Instagram). Finally, Project D aims to create a new mobile (smartphone and tablet) application and make the current website compliant with smartphones.\r\n\r\nThe organizational constraints (time, budget, resources, risks) allow for selecting a maximum of two projects. They are using a weighted scoring model. There are six criteria, as shown in Table 2.4.5. They are strategic opportunity, competitive advantage in IT, the potential for higher market share, profitability (NPV), sustainability, and risk aversion. As can be seen here, we are not focusing only on profitability but also on other factors that bring about a holistic approach to evaluating the feasibility and benefits of projects. The committee members will score each criterion as follows:\r\n<ul>\r\n \t<li>1: Unfavorable<\/li>\r\n \t<li>2: Satisfactory<\/li>\r\n \t<li>3: Favorable<\/li>\r\n<\/ul>\r\nAlthough weights are provided out of 100 percent, they are typed in Table 2.4.5 as two-digit numbers instead of decimals to make the computation easier to follow. Therefore, the total weight must not exceed 100. These weights may be decided after brainstorming meetings with subject matter experts and stakeholders. The subjectivity of these criteria\u2019s weights and points can be mitigated to some extent with the brainstorming activity. Most of the time, the organizations or the external client may impose the weights according to the organizational strategy and priorities.\r\n<table class=\"grid\" style=\"border-collapse: collapse;width: 100%;height: 146px\" border=\"0\"><caption>Table 2.4.5: Weighted Scoring Model<\/caption>\r\n<tbody>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 37.4588%;height: 18px\"><\/td>\r\n<td style=\"width: 9.90102%;height: 18px\"><\/td>\r\n<td style=\"width: 52.6404%;text-align: center;height: 18px\" colspan=\"4\"><strong>Projects<\/strong><\/td>\r\n<\/tr>\r\n<tr style=\"height: 20px\">\r\n<td style=\"width: 37.4588%;height: 20px\"><strong>Category<\/strong><\/td>\r\n<td style=\"width: 9.90102%;height: 20px;text-align: center\"><strong>Weight<\/strong><\/td>\r\n<td style=\"width: 12.8713%;height: 20px;text-align: center\"><strong>A<\/strong><\/td>\r\n<td style=\"width: 13.6964%;height: 20px;text-align: center\"><strong>B<\/strong><\/td>\r\n<td style=\"width: 12.7063%;height: 20px;text-align: center\"><strong>C<\/strong><\/td>\r\n<td style=\"width: 13.3664%;height: 20px;text-align: center\"><strong>D<\/strong><\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 37.4588%;height: 18px\">Strategic opportunity<\/td>\r\n<td style=\"width: 9.90102%;height: 18px;text-align: center\">25<\/td>\r\n<td style=\"width: 12.8713%;height: 18px;text-align: center\">1<\/td>\r\n<td style=\"width: 13.6964%;height: 18px;text-align: center\">3<\/td>\r\n<td style=\"width: 12.7063%;height: 18px;text-align: center\">2<\/td>\r\n<td style=\"width: 13.3664%;height: 18px;text-align: center\">3<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 37.4588%;height: 18px\">Competitive advantage in IT<\/td>\r\n<td style=\"width: 9.90102%;height: 18px;text-align: center\">15<\/td>\r\n<td style=\"width: 12.8713%;height: 18px;text-align: center\">1<\/td>\r\n<td style=\"width: 13.6964%;height: 18px;text-align: center\">3<\/td>\r\n<td style=\"width: 12.7063%;height: 18px;text-align: center\">1<\/td>\r\n<td style=\"width: 13.3664%;height: 18px;text-align: center\">3<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 37.4588%;height: 18px\">Potential for higher market share<\/td>\r\n<td style=\"width: 9.90102%;height: 18px;text-align: center\">20<\/td>\r\n<td style=\"width: 12.8713%;height: 18px;text-align: center\">2<\/td>\r\n<td style=\"width: 13.6964%;height: 18px;text-align: center\">2<\/td>\r\n<td style=\"width: 12.7063%;height: 18px;text-align: center\">3<\/td>\r\n<td style=\"width: 13.3664%;height: 18px;text-align: center\">3<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 37.4588%;height: 18px\">Profitability (NPV)<\/td>\r\n<td style=\"width: 9.90102%;height: 18px;text-align: center\">10<\/td>\r\n<td class=\"shaded\" style=\"width: 12.8713%;height: 18px;text-align: center\"><\/td>\r\n<td class=\"shaded\" style=\"width: 13.6964%;height: 18px;text-align: center\"><\/td>\r\n<td class=\"shaded\" style=\"width: 12.7063%;height: 18px;text-align: center\"><\/td>\r\n<td class=\"shaded\" style=\"width: 13.3664%;height: 18px;text-align: center\"><\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 37.4588%;height: 18px\">Sustainability<\/td>\r\n<td style=\"width: 9.90102%;height: 18px;text-align: center\">10<\/td>\r\n<td style=\"width: 12.8713%;height: 18px;text-align: center\">3<\/td>\r\n<td style=\"width: 13.6964%;height: 18px;text-align: center\">2<\/td>\r\n<td style=\"width: 12.7063%;height: 18px;text-align: center\">1<\/td>\r\n<td style=\"width: 13.3664%;height: 18px;text-align: center\">1<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 37.4588%;height: 18px\">Risk aversion<\/td>\r\n<td style=\"width: 9.90102%;height: 18px;text-align: center\">20<\/td>\r\n<td style=\"width: 12.8713%;height: 18px;text-align: center\">3<\/td>\r\n<td style=\"width: 13.6964%;height: 18px;text-align: center\">2<\/td>\r\n<td style=\"width: 12.7063%;height: 18px;text-align: center\">3<\/td>\r\n<td style=\"width: 13.3664%;height: 18px;text-align: center\">1<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nAs you can see in Table 2.4.5, NPV is just one of the criteria used by the selection committee. The required rate of return is 0.08, and the inflation rate is 0.02. We have already computed the discount factors above. The committee should incorporate the NPV scores based on the estimated cash flows in Table 2.4.6 and the decision table in Table 2.4.7.\r\n<table class=\"grid\" style=\"border-collapse: collapse;width: 100%;height: 90px\" border=\"0\"><caption>Table 2.4.6: Estimated cash flows ($)<\/caption>\r\n<tbody>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 14.2857%;text-align: center;height: 18px\"><strong>Project<\/strong><\/td>\r\n<td style=\"width: 16.1009%;text-align: center;height: 18px\"><strong>Investment<\/strong><\/td>\r\n<td style=\"width: 12.4705%;text-align: center;height: 18px\"><strong>Year 1<\/strong><\/td>\r\n<td style=\"width: 14.2857%;text-align: center;height: 18px\"><strong>Year 2<\/strong><\/td>\r\n<td style=\"width: 14.2857%;text-align: center;height: 18px\"><strong>Year 3<\/strong><\/td>\r\n<td style=\"width: 14.2857%;text-align: center;height: 18px\"><strong>Year 4<\/strong><\/td>\r\n<td style=\"width: 14.2857%;text-align: center;height: 18px\"><strong>Year 5<\/strong><\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><strong>A<\/strong><\/td>\r\n<td style=\"width: 16.1009%;height: 18px;text-align: center\">-100,000.00<\/td>\r\n<td style=\"width: 12.4705%;height: 18px;text-align: center\">30,000.00<\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">40,000.00<\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">30,000.00<\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">10,000.00<\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">10,000.00<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><strong>B<\/strong><\/td>\r\n<td style=\"width: 16.1009%;height: 18px;text-align: center\">-200,000.00<\/td>\r\n<td style=\"width: 12.4705%;height: 18px;text-align: center\">40,000.00<\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">60,000.00<\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">75,000.00<\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">105,000.00<\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">100,000.00<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><strong>C<\/strong><\/td>\r\n<td style=\"width: 16.1009%;height: 18px;text-align: center\">-30,000.00<\/td>\r\n<td style=\"width: 12.4705%;height: 18px;text-align: center\">20,000.00<\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">15,000.00<\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">10,000.00<\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">3,000.00<\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">1,000.00<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><strong>D<\/strong><\/td>\r\n<td style=\"width: 16.1009%;height: 18px;text-align: center\">-125,000.00<\/td>\r\n<td style=\"width: 12.4705%;height: 18px;text-align: center\">25,000.00<\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">40,000.00<\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">50,000.00<\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">55,000.00<\/td>\r\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">65,000.00<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nNPVs for four projects are, respectively, (4,090.63); 76,107.57; 10,761.62; and 46,276.49. Therefore, NPV scores are 1, 3, 2, and 2, respectively.\r\n<table class=\"grid aligncenter\" style=\"border-collapse: collapse;width: 61.226%\" border=\"0\"><caption><strong>Table 2.4.7: NPV score decision table<\/strong><\/caption>\r\n<tbody>\r\n<tr>\r\n<td style=\"width: 51.2255%\"><strong>NPV<\/strong><\/td>\r\n<td style=\"width: 71.2296%;text-align: center\"><strong>SCORES<\/strong><\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 51.2255%\">NPV &lt; 0<\/td>\r\n<td style=\"width: 71.2296%;text-align: center\">1<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 51.2255%\">0 \u2264 NPV &lt; 50,000<\/td>\r\n<td style=\"width: 71.2296%;text-align: center\">2<\/td>\r\n<\/tr>\r\n<tr>\r\n<td style=\"width: 51.2255%\">50,000 \u2264 NPV<\/td>\r\n<td style=\"width: 71.2296%;text-align: center\">3<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<h3>2.4.3.2 Calculating Weighted Scores<\/h3>\r\nWeighted scores are calculated by multiplying each criterion's weight by its score and summing all weighted scores of criteria for each project.\r\n\r\nFor example, \"Strategic opportunity\" has a weight of 0.25 (25%). Project A got an unfavorable score of 1. Its weighted score is 25 (25x1). When we multiply each weight by the score for Project A, we can find 25, 15, 40, 10, 30, and 60 for each criterion. When we sum them, we can find 180, which is the weighted score for Project A. We do it for all four projects and find 180, 250, 215, and 230 for projects A, B, C, and D, respectively.\r\n<table class=\"grid\" style=\"border-collapse: collapse;width: 100%;height: 290px\" border=\"0\"><caption>Table 2.4.8: Total Weighted Score (Computation of Total Scores)<\/caption>\r\n<tbody>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 30.3727%;height: 18px\"><\/td>\r\n<td style=\"width: 11.118%;height: 18px\"><\/td>\r\n<td style=\"width: 20.1242%;height: 18px;text-align: center\" colspan=\"4\"><strong>Projects<\/strong><\/td>\r\n<td style=\"width: 38.3851%;height: 18px;text-align: center\" colspan=\"4\"><strong>Weighted Scores\u00a0<\/strong><\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td class=\"shaded\" style=\"width: 30.3727%;height: 18px;text-align: center\"><strong>Category<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 11.118%;height: 18px;text-align: center\"><strong>Weight<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 5.03102%;height: 18px;text-align: center\"><strong>A<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 5.15526%;height: 18px;text-align: center\"><strong>B<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 4.65838%;height: 18px;text-align: center\"><strong>C<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 5.2795%;height: 18px;text-align: center\"><strong>D<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 9.13039%;height: 18px;text-align: center\"><strong>A<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 9.75156%;height: 18px;text-align: center\"><strong>B<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 9.50311%;height: 18px;text-align: center\"><strong>C<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 10%;height: 18px;text-align: center\"><strong>D<\/strong><\/td>\r\n<\/tr>\r\n<tr style=\"height: 36px\">\r\n<td style=\"width: 30.3727%;height: 36px;text-align: center\">Strategic opportunity<\/td>\r\n<td style=\"width: 11.118%;height: 36px;text-align: center\">25<\/td>\r\n<td style=\"width: 5.03102%;height: 36px;text-align: center\">1<\/td>\r\n<td style=\"width: 5.15526%;height: 36px;text-align: center\">3<\/td>\r\n<td style=\"width: 4.65838%;height: 36px;text-align: center\">2<\/td>\r\n<td style=\"width: 5.2795%;height: 36px;text-align: center\">3<\/td>\r\n<td style=\"width: 9.13039%;height: 36px;text-align: center\">25<\/td>\r\n<td style=\"width: 9.75156%;height: 36px;text-align: center\">75<\/td>\r\n<td style=\"width: 9.50311%;height: 36px;text-align: center\">50<\/td>\r\n<td style=\"width: 10%;height: 36px;text-align: center\">75<\/td>\r\n<\/tr>\r\n<tr style=\"height: 55px\">\r\n<td style=\"width: 30.3727%;height: 55px;text-align: center\">Competitive advantage in IT<\/td>\r\n<td style=\"width: 11.118%;height: 55px;text-align: center\">15<\/td>\r\n<td style=\"width: 5.03102%;height: 55px;text-align: center\">1<\/td>\r\n<td style=\"width: 5.15526%;height: 55px;text-align: center\">3<\/td>\r\n<td style=\"width: 4.65838%;height: 55px;text-align: center\">1<\/td>\r\n<td style=\"width: 5.2795%;height: 55px;text-align: center\">3<\/td>\r\n<td style=\"width: 9.13039%;height: 55px;text-align: center\">15<\/td>\r\n<td style=\"width: 9.75156%;height: 55px;text-align: center\">45<\/td>\r\n<td style=\"width: 9.50311%;height: 55px;text-align: center\">15<\/td>\r\n<td style=\"width: 10%;height: 55px;text-align: center\">45<\/td>\r\n<\/tr>\r\n<tr style=\"height: 55px\">\r\n<td style=\"width: 30.3727%;height: 55px;text-align: center\">Potential for higher market share<\/td>\r\n<td style=\"width: 11.118%;height: 55px;text-align: center\">20<\/td>\r\n<td style=\"width: 5.03102%;height: 55px;text-align: center\">2<\/td>\r\n<td style=\"width: 5.15526%;height: 55px;text-align: center\">2<\/td>\r\n<td style=\"width: 4.65838%;height: 55px;text-align: center\">3<\/td>\r\n<td style=\"width: 5.2795%;height: 55px;text-align: center\">3<\/td>\r\n<td style=\"width: 9.13039%;height: 55px;text-align: center\">40<\/td>\r\n<td style=\"width: 9.75156%;height: 55px;text-align: center\">40<\/td>\r\n<td style=\"width: 9.50311%;height: 55px;text-align: center\">60<\/td>\r\n<td style=\"width: 10%;height: 55px;text-align: center\">60<\/td>\r\n<\/tr>\r\n<tr style=\"height: 36px\">\r\n<td style=\"width: 30.3727%;height: 36px;text-align: center\">Profitability (NPV)<\/td>\r\n<td style=\"width: 11.118%;height: 36px;text-align: center\">10<\/td>\r\n<td style=\"width: 5.03102%;height: 36px;text-align: center\">1<\/td>\r\n<td style=\"width: 5.15526%;height: 36px;text-align: center\">3<\/td>\r\n<td style=\"width: 4.65838%;height: 36px;text-align: center\">2<\/td>\r\n<td style=\"width: 5.2795%;height: 36px;text-align: center\">2<\/td>\r\n<td style=\"width: 9.13039%;height: 36px;text-align: center\">10<\/td>\r\n<td style=\"width: 9.75156%;height: 36px;text-align: center\">30<\/td>\r\n<td style=\"width: 9.50311%;height: 36px;text-align: center\">20<\/td>\r\n<td style=\"width: 10%;height: 36px;text-align: center\">20<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 30.3727%;height: 18px;text-align: center\">Sustainability<\/td>\r\n<td style=\"width: 11.118%;height: 18px;text-align: center\">10<\/td>\r\n<td style=\"width: 5.03102%;height: 18px;text-align: center\">3<\/td>\r\n<td style=\"width: 5.15526%;height: 18px;text-align: center\">2<\/td>\r\n<td style=\"width: 4.65838%;height: 18px;text-align: center\">1<\/td>\r\n<td style=\"width: 5.2795%;height: 18px;text-align: center\">1<\/td>\r\n<td style=\"width: 9.13039%;height: 18px;text-align: center\">30<\/td>\r\n<td style=\"width: 9.75156%;height: 18px;text-align: center\">20<\/td>\r\n<td style=\"width: 9.50311%;height: 18px;text-align: center\">10<\/td>\r\n<td style=\"width: 10%;height: 18px;text-align: center\">10<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 30.3727%;height: 18px;text-align: center\">Risk aversion<\/td>\r\n<td style=\"width: 11.118%;height: 18px;text-align: center\">20<\/td>\r\n<td style=\"width: 5.03102%;height: 18px;text-align: center\">3<\/td>\r\n<td style=\"width: 5.15526%;height: 18px;text-align: center\">2<\/td>\r\n<td style=\"width: 4.65838%;height: 18px;text-align: center\">3<\/td>\r\n<td style=\"width: 5.2795%;height: 18px;text-align: center\">1<\/td>\r\n<td style=\"width: 9.13039%;height: 18px;text-align: center\">60<\/td>\r\n<td style=\"width: 9.75156%;height: 18px;text-align: center\">40<\/td>\r\n<td style=\"width: 9.50311%;height: 18px;text-align: center\">60<\/td>\r\n<td style=\"width: 10%;height: 18px;text-align: center\">20<\/td>\r\n<\/tr>\r\n<tr style=\"height: 36px\">\r\n<td class=\"shaded\" style=\"width: 30.3727%;height: 36px;text-align: center\"><strong>TOTAL SCORES<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 11.118%;height: 36px;text-align: center\"><strong>100<\/strong><\/td>\r\n<td style=\"width: 5.03102%;height: 36px;text-align: center\"><\/td>\r\n<td style=\"width: 5.15526%;height: 36px;text-align: center\"><\/td>\r\n<td style=\"width: 4.65838%;height: 36px;text-align: center\"><\/td>\r\n<td style=\"width: 5.2795%;height: 36px;text-align: center\"><\/td>\r\n<td class=\"shaded\" style=\"width: 9.13039%;height: 36px;text-align: center\"><strong>180<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 9.75156%;height: 36px;text-align: center\"><strong>250<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 9.50311%;height: 36px;text-align: center\"><strong>215<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 10%;height: 36px;text-align: center\"><strong>230<\/strong><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nInstead of multiplying each weight by each criterion's score for the project, we can use Excel's Sumproduct formula as a shortcut (Table 2.4.9).\r\n<div class=\"textbox shaded\">=SUMPRODUCT($B$3:$B$8,C3:C8)<\/div>\r\nUsing dollar signs for the weights is very important. They create absolute references for the range starting at B3 (25) through B8 (20). When we copy the cell to the relevant cells for Projects B, C, and D, \"B\"s do not change to C, D, or E. Therefore, the values are fixed, although used in other cells.\r\n\r\nC3:C8 is a relative reference, meaning that Excel adjusts the range in column C accordingly when we copy the formula to another column. Project B is in column D. Therefore, the formula becomes \"=SUMPRODUCT($B$3:$B$8,D3:D8).\"\r\n<table class=\"grid\" style=\"border-collapse: collapse;width: 50%;height: 290px;margin: 0 auto\" border=\"0\"><caption>Table 2.4.9: Total Weighted Score (Excel's Sumproduct Formula)<\/caption>\r\n<tbody>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 15.2815%;height: 18px\"><\/td>\r\n<td style=\"width: 2.98507%;height: 18px\"><\/td>\r\n<td style=\"width: 33.4666%;height: 18px;text-align: center\" colspan=\"4\"><strong>Projects<\/strong><\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td class=\"shaded\" style=\"width: 15.2815%;height: 18px;text-align: center\"><strong>Category<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 2.98507%;height: 18px;text-align: center\"><strong>Weight<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 30.554%;height: 18px;text-align: center\"><strong>A<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 1.03413%;height: 18px;text-align: center\"><strong>B<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 0.913242%;height: 18px;text-align: center\"><strong>C<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 0.965251%;height: 18px;text-align: center\"><strong>D<\/strong><\/td>\r\n<\/tr>\r\n<tr style=\"height: 36px\">\r\n<td style=\"width: 15.2815%;height: 36px;text-align: center\">Strategic opportunity<\/td>\r\n<td style=\"width: 2.98507%;height: 36px;text-align: center\">25<\/td>\r\n<td style=\"width: 30.554%;height: 36px;text-align: center\">1<\/td>\r\n<td style=\"width: 1.03413%;height: 36px;text-align: center\">3<\/td>\r\n<td style=\"width: 0.913242%;height: 36px;text-align: center\">2<\/td>\r\n<td style=\"width: 0.965251%;height: 36px;text-align: center\">3<\/td>\r\n<\/tr>\r\n<tr style=\"height: 55px\">\r\n<td style=\"width: 15.2815%;height: 55px;text-align: center\">Competitive advantage in IT<\/td>\r\n<td style=\"width: 2.98507%;height: 55px;text-align: center\">15<\/td>\r\n<td style=\"width: 30.554%;height: 55px;text-align: center\">1<\/td>\r\n<td style=\"width: 1.03413%;height: 55px;text-align: center\">3<\/td>\r\n<td style=\"width: 0.913242%;height: 55px;text-align: center\">1<\/td>\r\n<td style=\"width: 0.965251%;height: 55px;text-align: center\">3<\/td>\r\n<\/tr>\r\n<tr style=\"height: 55px\">\r\n<td style=\"width: 15.2815%;height: 55px;text-align: center\">Potential for higher market share<\/td>\r\n<td style=\"width: 2.98507%;height: 55px;text-align: center\">20<\/td>\r\n<td style=\"width: 30.554%;height: 55px;text-align: center\">2<\/td>\r\n<td style=\"width: 1.03413%;height: 55px;text-align: center\">2<\/td>\r\n<td style=\"width: 0.913242%;height: 55px;text-align: center\">3<\/td>\r\n<td style=\"width: 0.965251%;height: 55px;text-align: center\">3<\/td>\r\n<\/tr>\r\n<tr style=\"height: 36px\">\r\n<td style=\"width: 15.2815%;height: 36px;text-align: center\">Profitability (NPV)<\/td>\r\n<td style=\"width: 2.98507%;height: 36px;text-align: center\">10<\/td>\r\n<td style=\"width: 30.554%;height: 36px;text-align: center\">1<\/td>\r\n<td style=\"width: 1.03413%;height: 36px;text-align: center\">3<\/td>\r\n<td style=\"width: 0.913242%;height: 36px;text-align: center\">2<\/td>\r\n<td style=\"width: 0.965251%;height: 36px;text-align: center\">2<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 15.2815%;height: 18px;text-align: center\">Sustainability<\/td>\r\n<td style=\"width: 2.98507%;height: 18px;text-align: center\">10<\/td>\r\n<td style=\"width: 30.554%;height: 18px;text-align: center\">3<\/td>\r\n<td style=\"width: 1.03413%;height: 18px;text-align: center\">2<\/td>\r\n<td style=\"width: 0.913242%;height: 18px;text-align: center\">1<\/td>\r\n<td style=\"width: 0.965251%;height: 18px;text-align: center\">1<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 15.2815%;height: 18px;text-align: center\">Risk aversion<\/td>\r\n<td style=\"width: 2.98507%;height: 18px;text-align: center\">20<\/td>\r\n<td style=\"width: 30.554%;height: 18px;text-align: center\">3<\/td>\r\n<td style=\"width: 1.03413%;height: 18px;text-align: center\">2<\/td>\r\n<td style=\"width: 0.913242%;height: 18px;text-align: center\">3<\/td>\r\n<td style=\"width: 0.965251%;height: 18px;text-align: center\">1<\/td>\r\n<\/tr>\r\n<tr style=\"height: 36px\">\r\n<td class=\"shaded\" style=\"width: 15.2815%;height: 36px;text-align: center\"><strong>TOTAL SCORES<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 2.98507%;height: 36px;text-align: center\"><strong>100<\/strong><\/td>\r\n<td style=\"width: 30.554%;height: 36px;text-align: center;font-size: 12px\">=SUMPRODUCT($B$3:$B$8,C3:C8)\r\n\r\n=180<\/td>\r\n<td style=\"width: 1.03413%;height: 36px;text-align: center;font-size: 12px\">=SUMPRODUCT($B$3:$B$8,D3:D8)\r\n\r\n=250<\/td>\r\n<td style=\"width: 0.913242%;height: 36px;text-align: center;font-size: 12px\">=SUMPRODUCT($B$3:$B$8,E3:E8)\r\n\r\n=215<\/td>\r\n<td style=\"width: 0.965251%;height: 36px;text-align: center;font-size: 12px\">=SUMPRODUCT($B$3:$B$8,F3:F8)\r\n\r\n=230<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nThe selection committee should choose Project B (Self-checkout areas) based on the results since it has the highest score. Project D (M-commerce) has the second-highest total points (230 points). Since we can select and initiate two projects, we can move forward with projects B and D. The project initiation will be discussed in Chapter 3. In that chapter and the following chapters, we will focus on Project D.\r\n<h3>2.4.3.3 Pros and Cons of the Weighted Model<\/h3>\r\nHowever, modifying the weights to favor another project is always possible. Therefore, this reminds us of the fact that these models are not free from subjectivity. For example, if we change the \u201cstrategic opportunity\u201d weight from 15 to 10, the \u201ccompetitive advantage in IT\u201d weight from 25 to 10, the \u201cprofitability (NPV)\u201d weight from 10 to 5, the \u201csustainability\u201d weight from 10 to 25, and the \u201crisk aversion\u201d weight from 20 to 30, we can make Project A (Increasing the number of traditional checkout stations) the highest score. Hence, we can select Project A (Table 2.4.10). As seen in this example, this method is subject to substantial subjectivity.\r\n<table class=\"grid\" style=\"border-collapse: collapse;width: 100%;height: 290px\" border=\"0\"><caption>Table 2.4.10: Total Weighted Score (Changed weights)<\/caption>\r\n<tbody>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 31.2423%;height: 18px\"><\/td>\r\n<td style=\"width: 4.68943%;height: 18px\"><\/td>\r\n<td style=\"width: 7.1532%;height: 18px\"><\/td>\r\n<td style=\"width: 18.8198%;height: 18px;text-align: center\" colspan=\"4\"><strong>Projects<\/strong><\/td>\r\n<td style=\"width: 38.0952%;height: 18px;text-align: center\" colspan=\"4\"><strong>Weighted Scores\u00a0<\/strong><\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td class=\"shaded\" style=\"width: 31.2423%;height: 18px;text-align: center\"><strong>Category<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 4.68943%;text-align: center;height: 18px\"><strong>Old Weight<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 7.1532%;height: 18px;text-align: center\"><strong>New Weight<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 4.59624%;height: 18px;text-align: center\"><strong>A<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 5.01033%;height: 18px;text-align: center\"><strong>B<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 4.51346%;height: 18px;text-align: center\"><strong>C<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 4.69979%;height: 18px;text-align: center\"><strong>D<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 9.7101%;height: 18px;text-align: center\"><strong>A<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 9.02692%;height: 18px;text-align: center\"><strong>B<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 9.35818%;height: 18px;text-align: center\"><strong>C<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 10%;height: 18px;text-align: center\"><strong>D<\/strong><\/td>\r\n<\/tr>\r\n<tr style=\"height: 36px\">\r\n<td style=\"width: 31.2423%;height: 36px;text-align: left\">Strategic opportunity<\/td>\r\n<td style=\"width: 4.68943%;text-align: center;height: 36px\">15<\/td>\r\n<td style=\"width: 7.1532%;height: 36px;text-align: center\">10<\/td>\r\n<td style=\"width: 4.59624%;height: 36px;text-align: center\">1<\/td>\r\n<td style=\"width: 5.01033%;height: 36px;text-align: center\">3<\/td>\r\n<td style=\"width: 4.51346%;height: 36px;text-align: center\">2<\/td>\r\n<td style=\"width: 4.69979%;height: 36px;text-align: center\">3<\/td>\r\n<td style=\"width: 9.7101%;height: 36px;text-align: center\">10<\/td>\r\n<td style=\"width: 9.02692%;height: 36px;text-align: center\">30<\/td>\r\n<td style=\"width: 9.35818%;height: 36px;text-align: center\">20<\/td>\r\n<td style=\"width: 10%;height: 36px;text-align: center\">30<\/td>\r\n<\/tr>\r\n<tr style=\"height: 55px\">\r\n<td style=\"width: 31.2423%;height: 55px;text-align: left\">Competitive advantage in IT<\/td>\r\n<td style=\"width: 4.68943%;text-align: center;height: 55px\">25<\/td>\r\n<td style=\"width: 7.1532%;height: 55px;text-align: center\">10<\/td>\r\n<td style=\"width: 4.59624%;height: 55px;text-align: center\">1<\/td>\r\n<td style=\"width: 5.01033%;height: 55px;text-align: center\">3<\/td>\r\n<td style=\"width: 4.51346%;height: 55px;text-align: center\">1<\/td>\r\n<td style=\"width: 4.69979%;height: 55px;text-align: center\">3<\/td>\r\n<td style=\"width: 9.7101%;height: 55px;text-align: center\">10<\/td>\r\n<td style=\"width: 9.02692%;height: 55px;text-align: center\">30<\/td>\r\n<td style=\"width: 9.35818%;height: 55px;text-align: center\">10<\/td>\r\n<td style=\"width: 10%;height: 55px;text-align: center\">30<\/td>\r\n<\/tr>\r\n<tr style=\"height: 55px\">\r\n<td style=\"width: 31.2423%;height: 55px;text-align: left\">Potential for higher market share<\/td>\r\n<td style=\"width: 4.68943%;text-align: center;height: 55px\">20<\/td>\r\n<td style=\"width: 7.1532%;height: 55px;text-align: center\">20<\/td>\r\n<td style=\"width: 4.59624%;height: 55px;text-align: center\">2<\/td>\r\n<td style=\"width: 5.01033%;height: 55px;text-align: center\">2<\/td>\r\n<td style=\"width: 4.51346%;height: 55px;text-align: center\">3<\/td>\r\n<td style=\"width: 4.69979%;height: 55px;text-align: center\">3<\/td>\r\n<td style=\"width: 9.7101%;height: 55px;text-align: center\">40<\/td>\r\n<td style=\"width: 9.02692%;height: 55px;text-align: center\">40<\/td>\r\n<td style=\"width: 9.35818%;height: 55px;text-align: center\">60<\/td>\r\n<td style=\"width: 10%;height: 55px;text-align: center\">60<\/td>\r\n<\/tr>\r\n<tr style=\"height: 36px\">\r\n<td style=\"width: 31.2423%;height: 36px;text-align: left\">Profitability (NPV)<\/td>\r\n<td style=\"width: 4.68943%;text-align: center;height: 36px\">10<\/td>\r\n<td style=\"width: 7.1532%;height: 36px;text-align: center\">5<\/td>\r\n<td style=\"width: 4.59624%;height: 36px;text-align: center\">1<\/td>\r\n<td style=\"width: 5.01033%;height: 36px;text-align: center\">3<\/td>\r\n<td style=\"width: 4.51346%;height: 36px;text-align: center\">2<\/td>\r\n<td style=\"width: 4.69979%;height: 36px;text-align: center\">2<\/td>\r\n<td style=\"width: 9.7101%;height: 36px;text-align: center\">5<\/td>\r\n<td style=\"width: 9.02692%;height: 36px;text-align: center\">15<\/td>\r\n<td style=\"width: 9.35818%;height: 36px;text-align: center\">10<\/td>\r\n<td style=\"width: 10%;height: 36px;text-align: center\">10<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 31.2423%;height: 18px;text-align: left\">Sustainability<\/td>\r\n<td style=\"width: 4.68943%;text-align: center;height: 18px\">10<\/td>\r\n<td style=\"width: 7.1532%;height: 18px;text-align: center\">25<\/td>\r\n<td style=\"width: 4.59624%;height: 18px;text-align: center\">3<\/td>\r\n<td style=\"width: 5.01033%;height: 18px;text-align: center\">2<\/td>\r\n<td style=\"width: 4.51346%;height: 18px;text-align: center\">1<\/td>\r\n<td style=\"width: 4.69979%;height: 18px;text-align: center\">1<\/td>\r\n<td style=\"width: 9.7101%;height: 18px;text-align: center\">75<\/td>\r\n<td style=\"width: 9.02692%;height: 18px;text-align: center\">50<\/td>\r\n<td style=\"width: 9.35818%;height: 18px;text-align: center\">25<\/td>\r\n<td style=\"width: 10%;height: 18px;text-align: center\">25<\/td>\r\n<\/tr>\r\n<tr style=\"height: 18px\">\r\n<td style=\"width: 31.2423%;height: 18px;text-align: left\">Risk aversion<\/td>\r\n<td style=\"width: 4.68943%;text-align: center;height: 18px\">20<\/td>\r\n<td style=\"width: 7.1532%;height: 18px;text-align: center\">30<\/td>\r\n<td style=\"width: 4.59624%;height: 18px;text-align: center\">3<\/td>\r\n<td style=\"width: 5.01033%;height: 18px;text-align: center\">2<\/td>\r\n<td style=\"width: 4.51346%;height: 18px;text-align: center\">3<\/td>\r\n<td style=\"width: 4.69979%;height: 18px;text-align: center\">1<\/td>\r\n<td style=\"width: 9.7101%;height: 18px;text-align: center\">90<\/td>\r\n<td style=\"width: 9.02692%;height: 18px;text-align: center\">60<\/td>\r\n<td style=\"width: 9.35818%;height: 18px;text-align: center\">90<\/td>\r\n<td style=\"width: 10%;height: 18px;text-align: center\">30<\/td>\r\n<\/tr>\r\n<tr style=\"height: 36px\">\r\n<td class=\"shaded\" style=\"width: 31.2423%;height: 36px;text-align: center\"><strong>TOTAL SCORES<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 4.68943%;height: 36px;text-align: center\"><strong>\u00a0<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 7.1532%;height: 36px;text-align: center\"><strong>100<\/strong><\/td>\r\n<td style=\"width: 4.59624%;height: 36px;text-align: center\"><\/td>\r\n<td style=\"width: 5.01033%;height: 36px;text-align: center\"><\/td>\r\n<td style=\"width: 4.51346%;height: 36px;text-align: center\"><\/td>\r\n<td style=\"width: 4.69979%;height: 36px;text-align: center\"><\/td>\r\n<td class=\"shaded\" style=\"width: 9.7101%;height: 36px;text-align: center\"><strong>230<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 9.02692%;height: 36px;text-align: center\"><strong>225<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 9.35818%;height: 36px;text-align: center\"><strong>215<\/strong><\/td>\r\n<td class=\"shaded\" style=\"width: 10%;height: 36px;text-align: center\"><strong>185<\/strong><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nWeighted scoring models are easier to use as they offer structurally simple models. These models allow organizations to prioritize criteria according to their strategic objectives and client expectations. Management can directly ask the committees to consider the weights they provide so that it can be a direct reflection of managerial policy. Additionally, the weights can be modified to accommodate any changes in management and program levels. One of the apparent drawbacks of these models is that they don\u2019t allow a linear comparison among the projects. If a project gets 100 points and another gets 200 points, it doesn\u2019t necessarily mean the second project is two times more important than the first. Another drawback could emerge when the number of criteria increases to a level where weights become relatively small. Thus, this model becomes like a non-weighted model in which criteria weights don\u2019t impact the total scores.\r\n\r\nThis model is meant to add objectivity to our decision-making process; it is not meant to replace our own judgment. When the weighted scores are close, this indicates that a slight change in the weight of a criterion and\/or a change in the subjective scores could significantly change the decision. For this reason, a weighted scoring model is often viewed as a tool meant to be revised as we learn more about what truly matters to us and\/or the organization.","rendered":"<p>Quantitative and qualitative analysis are useful in identifying projects with the greatest potential impact. Generally, more complex projects involve a greater amount of risk. They also require a longer implementation and business benefits realization period. Therefore, project selection decisions will weigh the benefits offered with the timeframe required to realize these benefits. Organizations will often consider the payback period, which refers to the amount of time it takes to recover the cost of an investment. Projects that offer significant benefits that can be realized relatively quickly are more likely to be approved. However, this is only one of the methods to evaluate if a project is favorable compared with other projects.<a class=\"footnote\" title=\"https:\/\/www.investopedia.com\/terms\/p\/paybackperiod.asp\" id=\"return-footnote-60-1\" href=\"#footnote-60-1\" aria-label=\"Footnote 1\"><sup class=\"footnote\">[1]<\/sup><\/a><\/p>\n<h2>2.4.1 Payback Period<\/h2>\n<p>In Chapter 1, we evaluated the uniqueness and temporary nature of a project through which our grocery market chain, Grocery LLC, aimed at establishing self-checkout areas at all fifty markets across five states to solve the problem of more than usual traffic between 4 pm and 7 pm during the weekdays. Assume that we had two solution candidates for this problem. One is establishing the self-checkout area at all fifty stores (<a href=\"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/chapter\/1-2-project-characteristics\/\">see Chapter 1, the first example in Section 1.2<\/a>). Let\u2019s name the \u201cestablishment of self-checkout areas\u201d project \u201cProject B.\u201d We also wanted to evaluate another solution to increase the number of checkout stations where our cashiers work. This solution is named Project A.<\/p>\n<p>Table 2.4.1 provides cash inflows and outflows of two candidate projects, assuming that both project deliverables have a lifetime of five years. As seen in the table, the payback period for Project A would be three years, which means that our organization can recover the cost ($100,000) of this project\u2019s investment in three years.<\/p>\n<p>-100,000 (year 0) + 30,000 (<em>year<\/em> 1) + 40,000 (<em>year<\/em> 2) + 30,000 (<em>year<\/em> 3) = 0<\/p>\n<table class=\"grid\" style=\"border-collapse: collapse;width: 100%;height: 145px\">\n<caption>Table 2.4.1: Cash outflow and inflows of two projects ($)<\/caption>\n<tbody>\n<tr style=\"height: 19px\">\n<td style=\"width: 10%;height: 37px\" rowspan=\"2\"><\/td>\n<td style=\"width: 33.3333%;height: 19px;text-align: center\"><strong>Project A<\/strong><\/td>\n<td style=\"width: 33.3333%;height: 19px;text-align: center\"><strong>Project B<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 33.3333%;height: 18px;text-align: center\"><strong>(Traditional checkout stations)<\/strong><\/td>\n<td style=\"width: 33.3333%;height: 18px;text-align: center\"><strong>(Self-checkout areas)<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 10%;height: 18px\"><strong>Year 0<\/strong><\/td>\n<td style=\"width: 33.3333%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($100,000)<\/span><\/td>\n<td style=\"width: 33.3333%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($200,000)<\/span><\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 10%;height: 18px\"><strong>Year 1<\/strong><\/td>\n<td style=\"width: 33.3333%;height: 18px;text-align: center\">$30,000<\/td>\n<td style=\"width: 33.3333%;height: 18px;text-align: center\">$15,000<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 10%;height: 18px\"><strong>Year 2<\/strong><\/td>\n<td style=\"width: 33.3333%;height: 18px;text-align: center\">$40,000<\/td>\n<td style=\"width: 33.3333%;height: 18px;text-align: center\">$50,000<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 10%;height: 18px\"><strong>Year 3<\/strong><\/td>\n<td style=\"width: 33.3333%;height: 18px;text-align: center\">$30,000<\/td>\n<td style=\"width: 33.3333%;height: 18px;text-align: center\">$75,000<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 10%;height: 18px\"><strong>Year 4<\/strong><\/td>\n<td style=\"width: 33.3333%;height: 18px;text-align: center\">$10,000<\/td>\n<td style=\"width: 33.3333%;height: 18px;text-align: center\">$105,000<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 10%;height: 18px\"><strong>Year 5<\/strong><\/td>\n<td style=\"width: 33.3333%;height: 18px;text-align: center\">$10,000<\/td>\n<td style=\"width: 33.3333%;height: 18px;text-align: center\">$75,000<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>For Project B, the payback period would be 3.57 years (3 years + 60,000\/105,000). As seen in Table 2.4.2, when we finished the third year, the net cash flow was still negative (-200,000 + (15,000 + 50,000 + 75,000) = &#8211; 60.000). Therefore, the breakeven point would be after the fourth year. Because Project A\u2019s payback period (3 years) is shorter than Project B\u2019s (3.57 years), we can prefer Project A over Project B, only considering the payback period.<\/p>\n<table class=\"grid\" style=\"border-collapse: collapse;width: 100%;height: 144px\">\n<caption>Table 2.4.2: Net cash inflows of two projects ($)<\/caption>\n<tbody>\n<tr style=\"height: 36px\">\n<td style=\"width: 20%;height: 36px\"><\/td>\n<td style=\"width: 20%;height: 36px;text-align: center\"><strong>Project A<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 36px;text-align: center\"><strong>Net Cash Flow<\/strong><\/td>\n<td style=\"width: 20%;height: 36px;text-align: center\"><strong>Project B<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 36px;text-align: center\"><strong>Net Cash Flow<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20%;height: 18px\"><strong>Year 0<\/strong><\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($100,000)<\/span><\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($100,000)<\/span><\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($200,000)<\/span><\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($200,000)<\/span><\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20%;height: 18px\"><strong>Year 1<\/strong><\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\">$30,000<\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($70,000)<\/span><\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\">$15,000<\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($185,000)<\/span><\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20%;height: 18px\"><strong>Year 2<\/strong><\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\">$40,000<\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($30,000)<\/span><\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\">$50,000<\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($135,000)<\/span><\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20%;height: 18px\"><strong>Year 3<\/strong><\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\">$30,000<\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">$0<\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\">$75,000<\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($60,000)<\/span><\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20%;height: 18px\"><strong>Year 4<\/strong><\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\">$10,000<\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">$10,000<\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\">$105,000<\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">$45,000<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20%;height: 18px\"><strong>Year 5<\/strong><\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\">$10,000<\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">$20,000<\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\">$75,000<\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">$120,000<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>2.4.1.1 Discount Factor<\/h3>\n<p>However, this financial method ignores a crucial factor that may affect the real value of our cash inflows, which is the time value of the money, that is affected by two main annual rates: (1) Inflation rate (p<sub>t<\/sub>) and (2) required rate of return (r). Therefore, the discount factor must be incorporated into the computation to have real values.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/pressbooks.ulib.csuohio.edu\/project-management-navigating-the-complexity\/wp-content\/uploads\/sites\/183\/2022\/01\/discount-factor.png\" alt=\"Discount factor equation\" width=\"277\" height=\"53\" class=\"alignleft wp-image-58\" srcset=\"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2022\/01\/discount-factor.png 538w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2022\/01\/discount-factor-300x58.png 300w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2022\/01\/discount-factor-65x13.png 65w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2022\/01\/discount-factor-225x43.png 225w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2022\/01\/discount-factor-350x68.png 350w\" sizes=\"auto, (max-width: 277px) 100vw, 277px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>In our example above, let\u2019s take p<sub>t<\/sub> 0.02 and r 0.08. Our organization expects to earn a minimum of 0.08 annually on average when we invest. This can also be considered as the opportunity cost.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/pressbooks.ulib.csuohio.edu\/project-management-navigating-the-complexity\/wp-content\/uploads\/sites\/183\/2024\/07\/equation-above-table-2_3.png\" alt=\"equation from year 1 to year 5\" width=\"476\" height=\"247\" class=\"alignleft wp-image-59\" srcset=\"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/equation-above-table-2_3.png 915w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/equation-above-table-2_3-300x156.png 300w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/equation-above-table-2_3-768x399.png 768w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/equation-above-table-2_3-65x34.png 65w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/equation-above-table-2_3-225x117.png 225w, https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-content\/uploads\/sites\/183\/2024\/07\/equation-above-table-2_3-350x182.png 350w\" sizes=\"auto, (max-width: 476px) 100vw, 476px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>For each year, we should multiply the discount factor by each cash inflow to find the real value.<\/p>\n<table class=\"aligncenter\" style=\"border-collapse: collapse;width: 100%;height: 126px\">\n<caption>Table 2.4.3: Net cash outflow and inflows of two projects with discount factors ($)<\/caption>\n<tbody>\n<tr style=\"height: 18px\">\n<td style=\"width: 14.2857%;height: 18px\"><\/td>\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\"><strong>Project A<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\"><strong>Today&#8217;s Value<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\"><strong>Net Cash Flow<\/strong><\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><strong>Project B<\/strong><\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><strong>Today&#8217;s Value<\/strong><\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><strong>Net Cash Flow<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 14.2857%;height: 18px\"><strong>Year 0<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($100,000)<\/span><\/td>\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($100,000)<\/span><\/td>\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($100,000)<\/span><\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($200,000)<\/span><\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($200,000)<\/span><\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($200,000)<\/span><\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 14.2857%;height: 18px\"><strong>Year 1<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\">$30,000<\/td>\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\">$27,273<\/td>\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($72,727)<\/span><\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">$15,000<\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">$13,636<\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($186,364)<\/span><\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 14.2857%;height: 18px\"><strong>Year 2<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\">$40,000<\/td>\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\">$33,058<\/td>\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($39,669)<\/span><\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">$50,000<\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">$41,322<\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($145,041)<\/span><\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 14.2857%;height: 18px\"><strong>Year 3<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\">$30,000<\/td>\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\">$22,539<\/td>\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($17,130)<\/span><\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">$75,000<\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">$56,349<\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($88,693)<\/span><\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 14.2857%;height: 18px\"><strong>Year 4<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\">$10,000<\/td>\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\">$6,830<\/td>\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($10,300)<\/span><\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">$105,000<\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">$71,716<\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($16,976)<\/span><\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 14.2857%;height: 18px\"><strong>Year 5<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\">$10,000<\/td>\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\">$6,209<\/td>\n<td class=\"shaded\" style=\"width: 14.2857%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($4,091)<\/span><\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">$75,000<\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">$46,569<\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">$29,593<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>As can be seen in Table 2.4.3, the payback period changed for both projects. The payback period for Project A cannot be attained in five years, which means that our organization cannot recover the cost ($100,000) of this project\u2019s investment even in five years. For Project B, it would be 4.36 years (4 years + 16,976\/46,569). Eventually, after taking into account the time value of the money, we can choose Project B over Project A, contrary to our first decision without the discount factor.<\/p>\n<h2>2.4.2 Net Present Value (NPV)<\/h2>\n<p>NPV (Net Present Value) is another way of showing the long-term profitability of a project. At the end of the expected lifetime of a project outcome, NPV indicates the profit (Earnings \u2013 Project investment costs). As seen in Table 2.4.4, NPV is negative for Project A and positive for Project B. Therefore, we can select B over A.<\/p>\n<table class=\"grid\" style=\"border-collapse: collapse;width: 100%;height: 162px\">\n<caption>Table 2.4.4: NPVs for Projects A and B ($)<\/caption>\n<tbody>\n<tr style=\"height: 36px\">\n<td style=\"width: 20%;height: 36px\"><\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 36px\"><strong>Project A<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 36px\"><strong>Today&#8217;s Value<\/strong><\/td>\n<td style=\"width: 20%;height: 36px\"><strong>Project B<\/strong><\/td>\n<td style=\"width: 20%;height: 36px\"><strong>Today&#8217;s Value<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20%;height: 18px\"><strong>Year 0<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($100,000)<\/span><\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($100,000)<\/span><\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($200,000)<\/span><\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($200,000)<\/span><\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20%;height: 18px\"><strong>Year 1<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">$30,000<\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">$27,273<\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\">$15,000<\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\">$13,636<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20%;height: 18px\"><strong>Year 2<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">\u00a0$40,000<\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">$33,058<\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\">$50,000<\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\">$41,322<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20%;height: 18px\"><strong>Year 3<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">\u00a0$30,000<\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">$22,539<\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\">$75,000<\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\">$56,349<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20%;height: 18px\"><strong>Year 4<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">\u00a0$10,000<\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">$6,830<\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\">$105,000<\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\">$71,716<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20%;height: 18px\"><strong>Year 5<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">\u00a0$10,000<\/td>\n<td class=\"shaded\" style=\"width: 20%;height: 18px;text-align: center\">$6,209<\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\">$75,000<\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\">$46,569<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 20%;height: 18px\"><strong>NPV<\/strong><\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\"><\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\"><span style=\"color: #ff0000\">($4,091)<\/span><\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\"><\/td>\n<td style=\"width: 20%;height: 18px;text-align: center\">$29,593<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Financial models such as payback period and NPV are solely the financial indicators. Since little about the specific solution may be known during project selection, financial evaluations are based only on high-level estimates. However, organizations must consider other qualitative factors such as competitive advantage, future market potential, risk, legal and regulatory issues, and safety. Therefore, many organizations utilize project selection models where they can include criteria prioritized for the organization in general, as well as the projects and their affiliated programs and portfolios. In this chapter, we will discuss only one of the models commonly used by organizations, which is the weighted scoring model.<\/p>\n<h2>2.4.3 Weighted Scoring Model<\/h2>\n<p>Non-financial reasons for selecting projects are often viewed as strategic considerations; they include everything from ending a dependency on an unreliable vendor to restoring the image of an organization. Once a project is selected, a more detailed financial analysis is often performed. Since decision-making models often consider numerous criteria when evaluating the change alternatives, tools such as the weighted scoring model are very helpful. Weighted scoring models introduce objectivity in what would otherwise be a very subjective decision-making process. A weighted scoring model allows decision-makers to structure the decision-making process by specifying and prioritizing needs by identifying decision-making criteria, evaluating, rating, and comparing different alternatives, and selecting the best matching solution.<\/p>\n<p>Creating a weighted scoring model starts with careful consideration of decision-making criteria. In the case of project selection, many organizations refer to their strategic plans to identify important factors. These criteria are often a mix of financial and non-financial criteria. Once the criteria have been selected, we give each criterion a weight value to illustrate its relative importance. The more important the criterion, the higher its weight. Each potential change initiative (e.g., business cases) is evaluated against the weighted criteria and given a score for each criterion. These models can help us introduce more objectivity into our decision-making.<\/p>\n<h3>2.4.3.1 Grocery LLC&#8217;s Projects<\/h3>\n<p>Let us continue with our grocery market chain\u2019s project candidates. Thereafter, let us increase the number of projects to four. The project selection committee will evaluate these four potential projects based on six criteria. We have already discussed two projects\u2019 NPVs. The committee had scheduled a meeting today to discuss these four projects (Table 2.4.5). Project A targets increasing the traditional checkout stations in all the markets if their layouts allow for expansion inside the markets. Project B aims to designate areas for self-checkout stations. In this project, we must reduce the number of traditional checkout stations. Project C\u2019s goal is to create new ads for television and social media (e.g., YouTube, Facebook, Instagram). Finally, Project D aims to create a new mobile (smartphone and tablet) application and make the current website compliant with smartphones.<\/p>\n<p>The organizational constraints (time, budget, resources, risks) allow for selecting a maximum of two projects. They are using a weighted scoring model. There are six criteria, as shown in Table 2.4.5. They are strategic opportunity, competitive advantage in IT, the potential for higher market share, profitability (NPV), sustainability, and risk aversion. As can be seen here, we are not focusing only on profitability but also on other factors that bring about a holistic approach to evaluating the feasibility and benefits of projects. The committee members will score each criterion as follows:<\/p>\n<ul>\n<li>1: Unfavorable<\/li>\n<li>2: Satisfactory<\/li>\n<li>3: Favorable<\/li>\n<\/ul>\n<p>Although weights are provided out of 100 percent, they are typed in Table 2.4.5 as two-digit numbers instead of decimals to make the computation easier to follow. Therefore, the total weight must not exceed 100. These weights may be decided after brainstorming meetings with subject matter experts and stakeholders. The subjectivity of these criteria\u2019s weights and points can be mitigated to some extent with the brainstorming activity. Most of the time, the organizations or the external client may impose the weights according to the organizational strategy and priorities.<\/p>\n<table class=\"grid\" style=\"border-collapse: collapse;width: 100%;height: 146px\">\n<caption>Table 2.4.5: Weighted Scoring Model<\/caption>\n<tbody>\n<tr style=\"height: 18px\">\n<td style=\"width: 37.4588%;height: 18px\"><\/td>\n<td style=\"width: 9.90102%;height: 18px\"><\/td>\n<td style=\"width: 52.6404%;text-align: center;height: 18px\" colspan=\"4\"><strong>Projects<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 20px\">\n<td style=\"width: 37.4588%;height: 20px\"><strong>Category<\/strong><\/td>\n<td style=\"width: 9.90102%;height: 20px;text-align: center\"><strong>Weight<\/strong><\/td>\n<td style=\"width: 12.8713%;height: 20px;text-align: center\"><strong>A<\/strong><\/td>\n<td style=\"width: 13.6964%;height: 20px;text-align: center\"><strong>B<\/strong><\/td>\n<td style=\"width: 12.7063%;height: 20px;text-align: center\"><strong>C<\/strong><\/td>\n<td style=\"width: 13.3664%;height: 20px;text-align: center\"><strong>D<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 37.4588%;height: 18px\">Strategic opportunity<\/td>\n<td style=\"width: 9.90102%;height: 18px;text-align: center\">25<\/td>\n<td style=\"width: 12.8713%;height: 18px;text-align: center\">1<\/td>\n<td style=\"width: 13.6964%;height: 18px;text-align: center\">3<\/td>\n<td style=\"width: 12.7063%;height: 18px;text-align: center\">2<\/td>\n<td style=\"width: 13.3664%;height: 18px;text-align: center\">3<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 37.4588%;height: 18px\">Competitive advantage in IT<\/td>\n<td style=\"width: 9.90102%;height: 18px;text-align: center\">15<\/td>\n<td style=\"width: 12.8713%;height: 18px;text-align: center\">1<\/td>\n<td style=\"width: 13.6964%;height: 18px;text-align: center\">3<\/td>\n<td style=\"width: 12.7063%;height: 18px;text-align: center\">1<\/td>\n<td style=\"width: 13.3664%;height: 18px;text-align: center\">3<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 37.4588%;height: 18px\">Potential for higher market share<\/td>\n<td style=\"width: 9.90102%;height: 18px;text-align: center\">20<\/td>\n<td style=\"width: 12.8713%;height: 18px;text-align: center\">2<\/td>\n<td style=\"width: 13.6964%;height: 18px;text-align: center\">2<\/td>\n<td style=\"width: 12.7063%;height: 18px;text-align: center\">3<\/td>\n<td style=\"width: 13.3664%;height: 18px;text-align: center\">3<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 37.4588%;height: 18px\">Profitability (NPV)<\/td>\n<td style=\"width: 9.90102%;height: 18px;text-align: center\">10<\/td>\n<td class=\"shaded\" style=\"width: 12.8713%;height: 18px;text-align: center\"><\/td>\n<td class=\"shaded\" style=\"width: 13.6964%;height: 18px;text-align: center\"><\/td>\n<td class=\"shaded\" style=\"width: 12.7063%;height: 18px;text-align: center\"><\/td>\n<td class=\"shaded\" style=\"width: 13.3664%;height: 18px;text-align: center\"><\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 37.4588%;height: 18px\">Sustainability<\/td>\n<td style=\"width: 9.90102%;height: 18px;text-align: center\">10<\/td>\n<td style=\"width: 12.8713%;height: 18px;text-align: center\">3<\/td>\n<td style=\"width: 13.6964%;height: 18px;text-align: center\">2<\/td>\n<td style=\"width: 12.7063%;height: 18px;text-align: center\">1<\/td>\n<td style=\"width: 13.3664%;height: 18px;text-align: center\">1<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 37.4588%;height: 18px\">Risk aversion<\/td>\n<td style=\"width: 9.90102%;height: 18px;text-align: center\">20<\/td>\n<td style=\"width: 12.8713%;height: 18px;text-align: center\">3<\/td>\n<td style=\"width: 13.6964%;height: 18px;text-align: center\">2<\/td>\n<td style=\"width: 12.7063%;height: 18px;text-align: center\">3<\/td>\n<td style=\"width: 13.3664%;height: 18px;text-align: center\">1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>As you can see in Table 2.4.5, NPV is just one of the criteria used by the selection committee. The required rate of return is 0.08, and the inflation rate is 0.02. We have already computed the discount factors above. The committee should incorporate the NPV scores based on the estimated cash flows in Table 2.4.6 and the decision table in Table 2.4.7.<\/p>\n<table class=\"grid\" style=\"border-collapse: collapse;width: 100%;height: 90px\">\n<caption>Table 2.4.6: Estimated cash flows ($)<\/caption>\n<tbody>\n<tr style=\"height: 18px\">\n<td style=\"width: 14.2857%;text-align: center;height: 18px\"><strong>Project<\/strong><\/td>\n<td style=\"width: 16.1009%;text-align: center;height: 18px\"><strong>Investment<\/strong><\/td>\n<td style=\"width: 12.4705%;text-align: center;height: 18px\"><strong>Year 1<\/strong><\/td>\n<td style=\"width: 14.2857%;text-align: center;height: 18px\"><strong>Year 2<\/strong><\/td>\n<td style=\"width: 14.2857%;text-align: center;height: 18px\"><strong>Year 3<\/strong><\/td>\n<td style=\"width: 14.2857%;text-align: center;height: 18px\"><strong>Year 4<\/strong><\/td>\n<td style=\"width: 14.2857%;text-align: center;height: 18px\"><strong>Year 5<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><strong>A<\/strong><\/td>\n<td style=\"width: 16.1009%;height: 18px;text-align: center\">-100,000.00<\/td>\n<td style=\"width: 12.4705%;height: 18px;text-align: center\">30,000.00<\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">40,000.00<\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">30,000.00<\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">10,000.00<\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">10,000.00<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><strong>B<\/strong><\/td>\n<td style=\"width: 16.1009%;height: 18px;text-align: center\">-200,000.00<\/td>\n<td style=\"width: 12.4705%;height: 18px;text-align: center\">40,000.00<\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">60,000.00<\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">75,000.00<\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">105,000.00<\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">100,000.00<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><strong>C<\/strong><\/td>\n<td style=\"width: 16.1009%;height: 18px;text-align: center\">-30,000.00<\/td>\n<td style=\"width: 12.4705%;height: 18px;text-align: center\">20,000.00<\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">15,000.00<\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">10,000.00<\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">3,000.00<\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">1,000.00<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 14.2857%;height: 18px;text-align: center\"><strong>D<\/strong><\/td>\n<td style=\"width: 16.1009%;height: 18px;text-align: center\">-125,000.00<\/td>\n<td style=\"width: 12.4705%;height: 18px;text-align: center\">25,000.00<\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">40,000.00<\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">50,000.00<\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">55,000.00<\/td>\n<td style=\"width: 14.2857%;height: 18px;text-align: center\">65,000.00<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>NPVs for four projects are, respectively, (4,090.63); 76,107.57; 10,761.62; and 46,276.49. Therefore, NPV scores are 1, 3, 2, and 2, respectively.<\/p>\n<table class=\"grid aligncenter\" style=\"border-collapse: collapse;width: 61.226%\">\n<caption><strong>Table 2.4.7: NPV score decision table<\/strong><\/caption>\n<tbody>\n<tr>\n<td style=\"width: 51.2255%\"><strong>NPV<\/strong><\/td>\n<td style=\"width: 71.2296%;text-align: center\"><strong>SCORES<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 51.2255%\">NPV &lt; 0<\/td>\n<td style=\"width: 71.2296%;text-align: center\">1<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 51.2255%\">0 \u2264 NPV &lt; 50,000<\/td>\n<td style=\"width: 71.2296%;text-align: center\">2<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 51.2255%\">50,000 \u2264 NPV<\/td>\n<td style=\"width: 71.2296%;text-align: center\">3<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>2.4.3.2 Calculating Weighted Scores<\/h3>\n<p>Weighted scores are calculated by multiplying each criterion&#8217;s weight by its score and summing all weighted scores of criteria for each project.<\/p>\n<p>For example, &#8220;Strategic opportunity&#8221; has a weight of 0.25 (25%). Project A got an unfavorable score of 1. Its weighted score is 25 (25&#215;1). When we multiply each weight by the score for Project A, we can find 25, 15, 40, 10, 30, and 60 for each criterion. When we sum them, we can find 180, which is the weighted score for Project A. We do it for all four projects and find 180, 250, 215, and 230 for projects A, B, C, and D, respectively.<\/p>\n<table class=\"grid\" style=\"border-collapse: collapse;width: 100%;height: 290px\">\n<caption>Table 2.4.8: Total Weighted Score (Computation of Total Scores)<\/caption>\n<tbody>\n<tr style=\"height: 18px\">\n<td style=\"width: 30.3727%;height: 18px\"><\/td>\n<td style=\"width: 11.118%;height: 18px\"><\/td>\n<td style=\"width: 20.1242%;height: 18px;text-align: center\" colspan=\"4\"><strong>Projects<\/strong><\/td>\n<td style=\"width: 38.3851%;height: 18px;text-align: center\" colspan=\"4\"><strong>Weighted Scores\u00a0<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td class=\"shaded\" style=\"width: 30.3727%;height: 18px;text-align: center\"><strong>Category<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 11.118%;height: 18px;text-align: center\"><strong>Weight<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 5.03102%;height: 18px;text-align: center\"><strong>A<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 5.15526%;height: 18px;text-align: center\"><strong>B<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 4.65838%;height: 18px;text-align: center\"><strong>C<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 5.2795%;height: 18px;text-align: center\"><strong>D<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 9.13039%;height: 18px;text-align: center\"><strong>A<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 9.75156%;height: 18px;text-align: center\"><strong>B<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 9.50311%;height: 18px;text-align: center\"><strong>C<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 10%;height: 18px;text-align: center\"><strong>D<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 36px\">\n<td style=\"width: 30.3727%;height: 36px;text-align: center\">Strategic opportunity<\/td>\n<td style=\"width: 11.118%;height: 36px;text-align: center\">25<\/td>\n<td style=\"width: 5.03102%;height: 36px;text-align: center\">1<\/td>\n<td style=\"width: 5.15526%;height: 36px;text-align: center\">3<\/td>\n<td style=\"width: 4.65838%;height: 36px;text-align: center\">2<\/td>\n<td style=\"width: 5.2795%;height: 36px;text-align: center\">3<\/td>\n<td style=\"width: 9.13039%;height: 36px;text-align: center\">25<\/td>\n<td style=\"width: 9.75156%;height: 36px;text-align: center\">75<\/td>\n<td style=\"width: 9.50311%;height: 36px;text-align: center\">50<\/td>\n<td style=\"width: 10%;height: 36px;text-align: center\">75<\/td>\n<\/tr>\n<tr style=\"height: 55px\">\n<td style=\"width: 30.3727%;height: 55px;text-align: center\">Competitive advantage in IT<\/td>\n<td style=\"width: 11.118%;height: 55px;text-align: center\">15<\/td>\n<td style=\"width: 5.03102%;height: 55px;text-align: center\">1<\/td>\n<td style=\"width: 5.15526%;height: 55px;text-align: center\">3<\/td>\n<td style=\"width: 4.65838%;height: 55px;text-align: center\">1<\/td>\n<td style=\"width: 5.2795%;height: 55px;text-align: center\">3<\/td>\n<td style=\"width: 9.13039%;height: 55px;text-align: center\">15<\/td>\n<td style=\"width: 9.75156%;height: 55px;text-align: center\">45<\/td>\n<td style=\"width: 9.50311%;height: 55px;text-align: center\">15<\/td>\n<td style=\"width: 10%;height: 55px;text-align: center\">45<\/td>\n<\/tr>\n<tr style=\"height: 55px\">\n<td style=\"width: 30.3727%;height: 55px;text-align: center\">Potential for higher market share<\/td>\n<td style=\"width: 11.118%;height: 55px;text-align: center\">20<\/td>\n<td style=\"width: 5.03102%;height: 55px;text-align: center\">2<\/td>\n<td style=\"width: 5.15526%;height: 55px;text-align: center\">2<\/td>\n<td style=\"width: 4.65838%;height: 55px;text-align: center\">3<\/td>\n<td style=\"width: 5.2795%;height: 55px;text-align: center\">3<\/td>\n<td style=\"width: 9.13039%;height: 55px;text-align: center\">40<\/td>\n<td style=\"width: 9.75156%;height: 55px;text-align: center\">40<\/td>\n<td style=\"width: 9.50311%;height: 55px;text-align: center\">60<\/td>\n<td style=\"width: 10%;height: 55px;text-align: center\">60<\/td>\n<\/tr>\n<tr style=\"height: 36px\">\n<td style=\"width: 30.3727%;height: 36px;text-align: center\">Profitability (NPV)<\/td>\n<td style=\"width: 11.118%;height: 36px;text-align: center\">10<\/td>\n<td style=\"width: 5.03102%;height: 36px;text-align: center\">1<\/td>\n<td style=\"width: 5.15526%;height: 36px;text-align: center\">3<\/td>\n<td style=\"width: 4.65838%;height: 36px;text-align: center\">2<\/td>\n<td style=\"width: 5.2795%;height: 36px;text-align: center\">2<\/td>\n<td style=\"width: 9.13039%;height: 36px;text-align: center\">10<\/td>\n<td style=\"width: 9.75156%;height: 36px;text-align: center\">30<\/td>\n<td style=\"width: 9.50311%;height: 36px;text-align: center\">20<\/td>\n<td style=\"width: 10%;height: 36px;text-align: center\">20<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 30.3727%;height: 18px;text-align: center\">Sustainability<\/td>\n<td style=\"width: 11.118%;height: 18px;text-align: center\">10<\/td>\n<td style=\"width: 5.03102%;height: 18px;text-align: center\">3<\/td>\n<td style=\"width: 5.15526%;height: 18px;text-align: center\">2<\/td>\n<td style=\"width: 4.65838%;height: 18px;text-align: center\">1<\/td>\n<td style=\"width: 5.2795%;height: 18px;text-align: center\">1<\/td>\n<td style=\"width: 9.13039%;height: 18px;text-align: center\">30<\/td>\n<td style=\"width: 9.75156%;height: 18px;text-align: center\">20<\/td>\n<td style=\"width: 9.50311%;height: 18px;text-align: center\">10<\/td>\n<td style=\"width: 10%;height: 18px;text-align: center\">10<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 30.3727%;height: 18px;text-align: center\">Risk aversion<\/td>\n<td style=\"width: 11.118%;height: 18px;text-align: center\">20<\/td>\n<td style=\"width: 5.03102%;height: 18px;text-align: center\">3<\/td>\n<td style=\"width: 5.15526%;height: 18px;text-align: center\">2<\/td>\n<td style=\"width: 4.65838%;height: 18px;text-align: center\">3<\/td>\n<td style=\"width: 5.2795%;height: 18px;text-align: center\">1<\/td>\n<td style=\"width: 9.13039%;height: 18px;text-align: center\">60<\/td>\n<td style=\"width: 9.75156%;height: 18px;text-align: center\">40<\/td>\n<td style=\"width: 9.50311%;height: 18px;text-align: center\">60<\/td>\n<td style=\"width: 10%;height: 18px;text-align: center\">20<\/td>\n<\/tr>\n<tr style=\"height: 36px\">\n<td class=\"shaded\" style=\"width: 30.3727%;height: 36px;text-align: center\"><strong>TOTAL SCORES<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 11.118%;height: 36px;text-align: center\"><strong>100<\/strong><\/td>\n<td style=\"width: 5.03102%;height: 36px;text-align: center\"><\/td>\n<td style=\"width: 5.15526%;height: 36px;text-align: center\"><\/td>\n<td style=\"width: 4.65838%;height: 36px;text-align: center\"><\/td>\n<td style=\"width: 5.2795%;height: 36px;text-align: center\"><\/td>\n<td class=\"shaded\" style=\"width: 9.13039%;height: 36px;text-align: center\"><strong>180<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 9.75156%;height: 36px;text-align: center\"><strong>250<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 9.50311%;height: 36px;text-align: center\"><strong>215<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 10%;height: 36px;text-align: center\"><strong>230<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Instead of multiplying each weight by each criterion&#8217;s score for the project, we can use Excel&#8217;s Sumproduct formula as a shortcut (Table 2.4.9).<\/p>\n<div class=\"textbox shaded\">=SUMPRODUCT($B$3:$B$8,C3:C8)<\/div>\n<p>Using dollar signs for the weights is very important. They create absolute references for the range starting at B3 (25) through B8 (20). When we copy the cell to the relevant cells for Projects B, C, and D, &#8220;B&#8221;s do not change to C, D, or E. Therefore, the values are fixed, although used in other cells.<\/p>\n<p>C3:C8 is a relative reference, meaning that Excel adjusts the range in column C accordingly when we copy the formula to another column. Project B is in column D. Therefore, the formula becomes &#8220;=SUMPRODUCT($B$3:$B$8,D3:D8).&#8221;<\/p>\n<table class=\"grid\" style=\"border-collapse: collapse;width: 50%;height: 290px;margin: 0 auto\">\n<caption>Table 2.4.9: Total Weighted Score (Excel&#8217;s Sumproduct Formula)<\/caption>\n<tbody>\n<tr style=\"height: 18px\">\n<td style=\"width: 15.2815%;height: 18px\"><\/td>\n<td style=\"width: 2.98507%;height: 18px\"><\/td>\n<td style=\"width: 33.4666%;height: 18px;text-align: center\" colspan=\"4\"><strong>Projects<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td class=\"shaded\" style=\"width: 15.2815%;height: 18px;text-align: center\"><strong>Category<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 2.98507%;height: 18px;text-align: center\"><strong>Weight<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 30.554%;height: 18px;text-align: center\"><strong>A<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 1.03413%;height: 18px;text-align: center\"><strong>B<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 0.913242%;height: 18px;text-align: center\"><strong>C<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 0.965251%;height: 18px;text-align: center\"><strong>D<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 36px\">\n<td style=\"width: 15.2815%;height: 36px;text-align: center\">Strategic opportunity<\/td>\n<td style=\"width: 2.98507%;height: 36px;text-align: center\">25<\/td>\n<td style=\"width: 30.554%;height: 36px;text-align: center\">1<\/td>\n<td style=\"width: 1.03413%;height: 36px;text-align: center\">3<\/td>\n<td style=\"width: 0.913242%;height: 36px;text-align: center\">2<\/td>\n<td style=\"width: 0.965251%;height: 36px;text-align: center\">3<\/td>\n<\/tr>\n<tr style=\"height: 55px\">\n<td style=\"width: 15.2815%;height: 55px;text-align: center\">Competitive advantage in IT<\/td>\n<td style=\"width: 2.98507%;height: 55px;text-align: center\">15<\/td>\n<td style=\"width: 30.554%;height: 55px;text-align: center\">1<\/td>\n<td style=\"width: 1.03413%;height: 55px;text-align: center\">3<\/td>\n<td style=\"width: 0.913242%;height: 55px;text-align: center\">1<\/td>\n<td style=\"width: 0.965251%;height: 55px;text-align: center\">3<\/td>\n<\/tr>\n<tr style=\"height: 55px\">\n<td style=\"width: 15.2815%;height: 55px;text-align: center\">Potential for higher market share<\/td>\n<td style=\"width: 2.98507%;height: 55px;text-align: center\">20<\/td>\n<td style=\"width: 30.554%;height: 55px;text-align: center\">2<\/td>\n<td style=\"width: 1.03413%;height: 55px;text-align: center\">2<\/td>\n<td style=\"width: 0.913242%;height: 55px;text-align: center\">3<\/td>\n<td style=\"width: 0.965251%;height: 55px;text-align: center\">3<\/td>\n<\/tr>\n<tr style=\"height: 36px\">\n<td style=\"width: 15.2815%;height: 36px;text-align: center\">Profitability (NPV)<\/td>\n<td style=\"width: 2.98507%;height: 36px;text-align: center\">10<\/td>\n<td style=\"width: 30.554%;height: 36px;text-align: center\">1<\/td>\n<td style=\"width: 1.03413%;height: 36px;text-align: center\">3<\/td>\n<td style=\"width: 0.913242%;height: 36px;text-align: center\">2<\/td>\n<td style=\"width: 0.965251%;height: 36px;text-align: center\">2<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 15.2815%;height: 18px;text-align: center\">Sustainability<\/td>\n<td style=\"width: 2.98507%;height: 18px;text-align: center\">10<\/td>\n<td style=\"width: 30.554%;height: 18px;text-align: center\">3<\/td>\n<td style=\"width: 1.03413%;height: 18px;text-align: center\">2<\/td>\n<td style=\"width: 0.913242%;height: 18px;text-align: center\">1<\/td>\n<td style=\"width: 0.965251%;height: 18px;text-align: center\">1<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 15.2815%;height: 18px;text-align: center\">Risk aversion<\/td>\n<td style=\"width: 2.98507%;height: 18px;text-align: center\">20<\/td>\n<td style=\"width: 30.554%;height: 18px;text-align: center\">3<\/td>\n<td style=\"width: 1.03413%;height: 18px;text-align: center\">2<\/td>\n<td style=\"width: 0.913242%;height: 18px;text-align: center\">3<\/td>\n<td style=\"width: 0.965251%;height: 18px;text-align: center\">1<\/td>\n<\/tr>\n<tr style=\"height: 36px\">\n<td class=\"shaded\" style=\"width: 15.2815%;height: 36px;text-align: center\"><strong>TOTAL SCORES<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 2.98507%;height: 36px;text-align: center\"><strong>100<\/strong><\/td>\n<td style=\"width: 30.554%;height: 36px;text-align: center;font-size: 12px\">=SUMPRODUCT($B$3:$B$8,C3:C8)<\/p>\n<p>=180<\/td>\n<td style=\"width: 1.03413%;height: 36px;text-align: center;font-size: 12px\">=SUMPRODUCT($B$3:$B$8,D3:D8)<\/p>\n<p>=250<\/td>\n<td style=\"width: 0.913242%;height: 36px;text-align: center;font-size: 12px\">=SUMPRODUCT($B$3:$B$8,E3:E8)<\/p>\n<p>=215<\/td>\n<td style=\"width: 0.965251%;height: 36px;text-align: center;font-size: 12px\">=SUMPRODUCT($B$3:$B$8,F3:F8)<\/p>\n<p>=230<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>The selection committee should choose Project B (Self-checkout areas) based on the results since it has the highest score. Project D (M-commerce) has the second-highest total points (230 points). Since we can select and initiate two projects, we can move forward with projects B and D. The project initiation will be discussed in Chapter 3. In that chapter and the following chapters, we will focus on Project D.<\/p>\n<h3>2.4.3.3 Pros and Cons of the Weighted Model<\/h3>\n<p>However, modifying the weights to favor another project is always possible. Therefore, this reminds us of the fact that these models are not free from subjectivity. For example, if we change the \u201cstrategic opportunity\u201d weight from 15 to 10, the \u201ccompetitive advantage in IT\u201d weight from 25 to 10, the \u201cprofitability (NPV)\u201d weight from 10 to 5, the \u201csustainability\u201d weight from 10 to 25, and the \u201crisk aversion\u201d weight from 20 to 30, we can make Project A (Increasing the number of traditional checkout stations) the highest score. Hence, we can select Project A (Table 2.4.10). As seen in this example, this method is subject to substantial subjectivity.<\/p>\n<table class=\"grid\" style=\"border-collapse: collapse;width: 100%;height: 290px\">\n<caption>Table 2.4.10: Total Weighted Score (Changed weights)<\/caption>\n<tbody>\n<tr style=\"height: 18px\">\n<td style=\"width: 31.2423%;height: 18px\"><\/td>\n<td style=\"width: 4.68943%;height: 18px\"><\/td>\n<td style=\"width: 7.1532%;height: 18px\"><\/td>\n<td style=\"width: 18.8198%;height: 18px;text-align: center\" colspan=\"4\"><strong>Projects<\/strong><\/td>\n<td style=\"width: 38.0952%;height: 18px;text-align: center\" colspan=\"4\"><strong>Weighted Scores\u00a0<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td class=\"shaded\" style=\"width: 31.2423%;height: 18px;text-align: center\"><strong>Category<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 4.68943%;text-align: center;height: 18px\"><strong>Old Weight<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 7.1532%;height: 18px;text-align: center\"><strong>New Weight<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 4.59624%;height: 18px;text-align: center\"><strong>A<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 5.01033%;height: 18px;text-align: center\"><strong>B<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 4.51346%;height: 18px;text-align: center\"><strong>C<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 4.69979%;height: 18px;text-align: center\"><strong>D<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 9.7101%;height: 18px;text-align: center\"><strong>A<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 9.02692%;height: 18px;text-align: center\"><strong>B<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 9.35818%;height: 18px;text-align: center\"><strong>C<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 10%;height: 18px;text-align: center\"><strong>D<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 36px\">\n<td style=\"width: 31.2423%;height: 36px;text-align: left\">Strategic opportunity<\/td>\n<td style=\"width: 4.68943%;text-align: center;height: 36px\">15<\/td>\n<td style=\"width: 7.1532%;height: 36px;text-align: center\">10<\/td>\n<td style=\"width: 4.59624%;height: 36px;text-align: center\">1<\/td>\n<td style=\"width: 5.01033%;height: 36px;text-align: center\">3<\/td>\n<td style=\"width: 4.51346%;height: 36px;text-align: center\">2<\/td>\n<td style=\"width: 4.69979%;height: 36px;text-align: center\">3<\/td>\n<td style=\"width: 9.7101%;height: 36px;text-align: center\">10<\/td>\n<td style=\"width: 9.02692%;height: 36px;text-align: center\">30<\/td>\n<td style=\"width: 9.35818%;height: 36px;text-align: center\">20<\/td>\n<td style=\"width: 10%;height: 36px;text-align: center\">30<\/td>\n<\/tr>\n<tr style=\"height: 55px\">\n<td style=\"width: 31.2423%;height: 55px;text-align: left\">Competitive advantage in IT<\/td>\n<td style=\"width: 4.68943%;text-align: center;height: 55px\">25<\/td>\n<td style=\"width: 7.1532%;height: 55px;text-align: center\">10<\/td>\n<td style=\"width: 4.59624%;height: 55px;text-align: center\">1<\/td>\n<td style=\"width: 5.01033%;height: 55px;text-align: center\">3<\/td>\n<td style=\"width: 4.51346%;height: 55px;text-align: center\">1<\/td>\n<td style=\"width: 4.69979%;height: 55px;text-align: center\">3<\/td>\n<td style=\"width: 9.7101%;height: 55px;text-align: center\">10<\/td>\n<td style=\"width: 9.02692%;height: 55px;text-align: center\">30<\/td>\n<td style=\"width: 9.35818%;height: 55px;text-align: center\">10<\/td>\n<td style=\"width: 10%;height: 55px;text-align: center\">30<\/td>\n<\/tr>\n<tr style=\"height: 55px\">\n<td style=\"width: 31.2423%;height: 55px;text-align: left\">Potential for higher market share<\/td>\n<td style=\"width: 4.68943%;text-align: center;height: 55px\">20<\/td>\n<td style=\"width: 7.1532%;height: 55px;text-align: center\">20<\/td>\n<td style=\"width: 4.59624%;height: 55px;text-align: center\">2<\/td>\n<td style=\"width: 5.01033%;height: 55px;text-align: center\">2<\/td>\n<td style=\"width: 4.51346%;height: 55px;text-align: center\">3<\/td>\n<td style=\"width: 4.69979%;height: 55px;text-align: center\">3<\/td>\n<td style=\"width: 9.7101%;height: 55px;text-align: center\">40<\/td>\n<td style=\"width: 9.02692%;height: 55px;text-align: center\">40<\/td>\n<td style=\"width: 9.35818%;height: 55px;text-align: center\">60<\/td>\n<td style=\"width: 10%;height: 55px;text-align: center\">60<\/td>\n<\/tr>\n<tr style=\"height: 36px\">\n<td style=\"width: 31.2423%;height: 36px;text-align: left\">Profitability (NPV)<\/td>\n<td style=\"width: 4.68943%;text-align: center;height: 36px\">10<\/td>\n<td style=\"width: 7.1532%;height: 36px;text-align: center\">5<\/td>\n<td style=\"width: 4.59624%;height: 36px;text-align: center\">1<\/td>\n<td style=\"width: 5.01033%;height: 36px;text-align: center\">3<\/td>\n<td style=\"width: 4.51346%;height: 36px;text-align: center\">2<\/td>\n<td style=\"width: 4.69979%;height: 36px;text-align: center\">2<\/td>\n<td style=\"width: 9.7101%;height: 36px;text-align: center\">5<\/td>\n<td style=\"width: 9.02692%;height: 36px;text-align: center\">15<\/td>\n<td style=\"width: 9.35818%;height: 36px;text-align: center\">10<\/td>\n<td style=\"width: 10%;height: 36px;text-align: center\">10<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 31.2423%;height: 18px;text-align: left\">Sustainability<\/td>\n<td style=\"width: 4.68943%;text-align: center;height: 18px\">10<\/td>\n<td style=\"width: 7.1532%;height: 18px;text-align: center\">25<\/td>\n<td style=\"width: 4.59624%;height: 18px;text-align: center\">3<\/td>\n<td style=\"width: 5.01033%;height: 18px;text-align: center\">2<\/td>\n<td style=\"width: 4.51346%;height: 18px;text-align: center\">1<\/td>\n<td style=\"width: 4.69979%;height: 18px;text-align: center\">1<\/td>\n<td style=\"width: 9.7101%;height: 18px;text-align: center\">75<\/td>\n<td style=\"width: 9.02692%;height: 18px;text-align: center\">50<\/td>\n<td style=\"width: 9.35818%;height: 18px;text-align: center\">25<\/td>\n<td style=\"width: 10%;height: 18px;text-align: center\">25<\/td>\n<\/tr>\n<tr style=\"height: 18px\">\n<td style=\"width: 31.2423%;height: 18px;text-align: left\">Risk aversion<\/td>\n<td style=\"width: 4.68943%;text-align: center;height: 18px\">20<\/td>\n<td style=\"width: 7.1532%;height: 18px;text-align: center\">30<\/td>\n<td style=\"width: 4.59624%;height: 18px;text-align: center\">3<\/td>\n<td style=\"width: 5.01033%;height: 18px;text-align: center\">2<\/td>\n<td style=\"width: 4.51346%;height: 18px;text-align: center\">3<\/td>\n<td style=\"width: 4.69979%;height: 18px;text-align: center\">1<\/td>\n<td style=\"width: 9.7101%;height: 18px;text-align: center\">90<\/td>\n<td style=\"width: 9.02692%;height: 18px;text-align: center\">60<\/td>\n<td style=\"width: 9.35818%;height: 18px;text-align: center\">90<\/td>\n<td style=\"width: 10%;height: 18px;text-align: center\">30<\/td>\n<\/tr>\n<tr style=\"height: 36px\">\n<td class=\"shaded\" style=\"width: 31.2423%;height: 36px;text-align: center\"><strong>TOTAL SCORES<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 4.68943%;height: 36px;text-align: center\"><strong>\u00a0<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 7.1532%;height: 36px;text-align: center\"><strong>100<\/strong><\/td>\n<td style=\"width: 4.59624%;height: 36px;text-align: center\"><\/td>\n<td style=\"width: 5.01033%;height: 36px;text-align: center\"><\/td>\n<td style=\"width: 4.51346%;height: 36px;text-align: center\"><\/td>\n<td style=\"width: 4.69979%;height: 36px;text-align: center\"><\/td>\n<td class=\"shaded\" style=\"width: 9.7101%;height: 36px;text-align: center\"><strong>230<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 9.02692%;height: 36px;text-align: center\"><strong>225<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 9.35818%;height: 36px;text-align: center\"><strong>215<\/strong><\/td>\n<td class=\"shaded\" style=\"width: 10%;height: 36px;text-align: center\"><strong>185<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Weighted scoring models are easier to use as they offer structurally simple models. These models allow organizations to prioritize criteria according to their strategic objectives and client expectations. Management can directly ask the committees to consider the weights they provide so that it can be a direct reflection of managerial policy. Additionally, the weights can be modified to accommodate any changes in management and program levels. One of the apparent drawbacks of these models is that they don\u2019t allow a linear comparison among the projects. If a project gets 100 points and another gets 200 points, it doesn\u2019t necessarily mean the second project is two times more important than the first. Another drawback could emerge when the number of criteria increases to a level where weights become relatively small. Thus, this model becomes like a non-weighted model in which criteria weights don\u2019t impact the total scores.<\/p>\n<p>This model is meant to add objectivity to our decision-making process; it is not meant to replace our own judgment. When the weighted scores are close, this indicates that a slight change in the weight of a criterion and\/or a change in the subjective scores could significantly change the decision. For this reason, a weighted scoring model is often viewed as a tool meant to be revised as we learn more about what truly matters to us and\/or the organization.<\/p>\n<hr class=\"before-footnotes clear\" \/><div class=\"footnotes\"><ol><li id=\"footnote-60-1\"><a href=\"https:\/\/www.investopedia.com\/terms\/p\/paybackperiod.asp\">https:\/\/www.investopedia.com\/terms\/p\/paybackperiod.asp<\/a> <a href=\"#return-footnote-60-1\" class=\"return-footnote\" aria-label=\"Return to footnote 1\">&crarr;<\/a><\/li><\/ol><\/div>","protected":false},"author":3,"menu_order":5,"template":"","meta":{"pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-60","chapter","type-chapter","status-publish","hentry"],"part":47,"_links":{"self":[{"href":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-json\/pressbooks\/v2\/chapters\/60","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-json\/wp\/v2\/users\/3"}],"version-history":[{"count":11,"href":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-json\/pressbooks\/v2\/chapters\/60\/revisions"}],"predecessor-version":[{"id":1049,"href":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-json\/pressbooks\/v2\/chapters\/60\/revisions\/1049"}],"part":[{"href":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-json\/pressbooks\/v2\/parts\/47"}],"metadata":[{"href":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-json\/pressbooks\/v2\/chapters\/60\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-json\/wp\/v2\/media?parent=60"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-json\/pressbooks\/v2\/chapter-type?post=60"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-json\/wp\/v2\/contributor?post=60"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/pressbooks.ulib.csuohio.edu\/projectmanagement2ndedition\/wp-json\/wp\/v2\/license?post=60"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}