A financial services company has a long list of potential projects to consider this year. Managers...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A financial services company has a long list of potential projects to consider this year. Managers at this company must decide which projects to pursue and how to define the scope of the projects selected for approval. The company has decided to use a weighted scoring model to help in project selection, using criteria that map to corporate objectives. All projects selected must develop a WBS using corporate guidelines. You are part of a team that will analyze proposals and recommend which projects to pursue. Your team has decided to create a weighted scoring model using the following criteria and weights: Criteria Weight 1. Enhances new product development 20% 2. Streamlines operations 15% 3. Increases cross-selling 30% 4. Has good NPV 35% To determine the score for the last criterion, your team has developed the following scoring system: • NPV is less than 0, the score is 0 • NPV is between 0 and $100,000, the score is 25 NPV is between $100,000 and $200,000, the score is 50 • NPV is between $200,000 and $400,000, the score is 75 NPV is above $400,000, the score is 100 The following is information for three potential projects: • Project 1: Scores for criteria 1, 2, and 3 are 10, 20, and 80, respectively. Estimated costs the first year are $500,000, and costs for years 2 and 3 are $100,000 each. Estimated benefits for years 1, 2, and 3 are $200,000, $400,000, and $600,000, respectively. Project 2: Scores for criteria 1, 2, and 3 are all 50. Estimated costs the first year are $700,000, and costs for the second year are $200,000. Estimated benefits for years 1 and 2 are $300,000 and $700,000, respectively. Project 3: Scores for criteria 1, 2, and 3 are 0, 50, and 80, respectively. Estimated costs the first year are $300,000, and costs for years 2, 3, and 4 are $100,000 each. Estimated benefits for years 1, 2, 3, and 4 are $0, $600,000, $500,000, and $400,000, respectively. Develop a spreadsheet to calculate the NPVS and weighted scores for the three projects. Use a 10 percent discount rate for the NPV calculations. A financial services company has a long list of potential projects to consider this year. Managers at this company must decide which projects to pursue and how to define the scope of the projects selected for approval. The company has decided to use a weighted scoring model to help in project selection, using criteria that map to corporate objectives. All projects selected must develop a WBS using corporate guidelines. You are part of a team that will analyze proposals and recommend which projects to pursue. Your team has decided to create a weighted scoring model using the following criteria and weights: Criteria Weight 1. Enhances new product development 20% 2. Streamlines operations 15% 3. Increases cross-selling 30% 4. Has good NPV 35% To determine the score for the last criterion, your team has developed the following scoring system: • NPV is less than 0, the score is 0 • NPV is between 0 and $100,000, the score is 25 NPV is between $100,000 and $200,000, the score is 50 • NPV is between $200,000 and $400,000, the score is 75 NPV is above $400,000, the score is 100 The following is information for three potential projects: • Project 1: Scores for criteria 1, 2, and 3 are 10, 20, and 80, respectively. Estimated costs the first year are $500,000, and costs for years 2 and 3 are $100,000 each. Estimated benefits for years 1, 2, and 3 are $200,000, $400,000, and $600,000, respectively. Project 2: Scores for criteria 1, 2, and 3 are all 50. Estimated costs the first year are $700,000, and costs for the second year are $200,000. Estimated benefits for years 1 and 2 are $300,000 and $700,000, respectively. Project 3: Scores for criteria 1, 2, and 3 are 0, 50, and 80, respectively. Estimated costs the first year are $300,000, and costs for years 2, 3, and 4 are $100,000 each. Estimated benefits for years 1, 2, 3, and 4 are $0, $600,000, $500,000, and $400,000, respectively. Develop a spreadsheet to calculate the NPVS and weighted scores for the three projects. Use a 10 percent discount rate for the NPV calculations.
Expert Answer:
Related Book For
Introduction to Statistical Quality Control
ISBN: 978-1118146811
7th edition
Authors: Douglas C Montgomery
Posted Date:
Students also viewed these mathematics questions
-
A financial services company monitors loan applications. Every day 50 applications are assessed for the accuracy of the information on the form. Results for 20 days are where Di is the number of...
-
A financial services company has 39 female top executives (presidents or vice presidents) among its 388 senior managers in its Banking Services division, while there are only 11 female top executives...
-
A financial services company conducted a survey of a random sample of its customers. One of the items on the survey was as follows:"The staff at my local branch can provide me with good advice on my...
-
In Problems 4352, graph each system of linear inequalities. State whether the graph is bounded or unbounded, and label the corner points. 0 x y 0 x + y = 1 x + y 7 2x + y 10
-
Nanimahoo Marketing Services has been operating for several years. It showed the following trial balance information (in alphabetical order) for the month just ended March 31, 2014: Required Using...
-
Leadership traits are considered to be important for leadership because they can lead to certain actions that are required for effective leadership. Review each of the traits in Exhibit 9.1 and...
-
Water flows from a two-dimensional open channel and is diverted by an inclined plate as illustrated in Fig. P5.78. When the velocity at section (1) is \(10 \mathrm{ft} / \mathrm{s}\), what horizontal...
-
Sam Baker owns a business called Sams Sporting Goods. His beginning inventory as of January 1, 20--, was $47,000, and his ending inventory as of December 31, 20--, was $53,000. Set up T accounts for...
-
Half a liter of gas in an air conditioner is initially at a temperature of 25 degrees Celsius and 2.0 atm of pressure. The volume of the gas is rapidly expanded to 2 L and the pressure of the gas...
-
The International Lodging Merger Role of AAA Hotels Executive Committee, discuss the major negotiation point between the two hotels and how to gain a result from the AAA Hotels point of view. How to...
-
Write a single command that will create a gzip compressed archive of all files in the /home directory. Call the archive abode, and give an an appropriate file extension.
-
Consider the following network of routers (A, B, C and D) in which the numbers above each link indicate the relative routing cost of that link. Assume a distance vector routing algorithm has been...
-
What must go inside of class B in this code? public interface A { public void doStuff(); public static int x = 2; } public class 8 implements A { // ? }
-
Three charged metal spheres, 91 = -5.54 nC, 92 2.90 nC, and 93 -2.56 nC, are arrayed in the xy plane so that they form an equilateral triangle with d = 12.0 cm, as shown in the figure. What is the...
-
Let f(z) = f(2) = f( 1) = (G) - 32 I H-3 Find the following. Write answers as fractions, not decimals.
-
Grand Slam Incorporated incurred the following costs during March: Selling expenses Direct labor Interest expense Manufacturing overhead, actual Raw materials used Administrative expenses $ 155,900...
-
To determine the issue price of a term bond, the present value of the principal and interest payments must be found using the stated interest rate.true or false
-
Write a while loop that uses an explicit iterator to accomplish the same thing as Exercise 7.3. Exercise 7.3. Write a for-each loop that calls the addInterest method on each BankAccount object in a...
-
Analyze the residuals from the multiple regression model on the patient satisfaction data from Exercise 4.51. Comment on the adequacy of the regression model.
-
Consider the chemical process yield data in Exercise 3.9. Calculate the sample average and standard deviation.
-
Consider the molecular weight data in Exercise 10.16. Construct a CUSUM control chart on the residuals from the model you fit to the data in part (c) of that exercise. Let ï0 = 0,...
-
The risk that can be diversified away is best described as: A. beta risk. B. systematic risk. C. unsystematic risk.
-
Which of the following statement is not true: A. A company's beta does not change over time. B. The fundamental beta allows for potential of beta to change over time. C. An historical beta is...
-
An efficient portfolio, according to Markowitz, is all but which of the following: A. lowest risk for a given level of expected return. B. greatest expected return for a given level of risk. C....
Study smarter with the SolutionInn App