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
-
Find all the Chebyshev rational approximations of degree 2 for f (x) = ex. Which give the best approximations to f (x) = ex at x = 0.25, 0.5, and 1?
-
Klose Outfitters Inc. believes that its optimal capital structure consists of 60% common equity and 40% debt, and its tax rate is 40%. Klose must raise additional capital to fund its upcoming...
-
Refer to Exercise 4.80 and obtain the (a) mean; (b) variance; (c) standard deviation for the number of requests for conference rooms. Data From Exercise 4.80 4.80 Upon reviewing recent use of...
-
G.S. Adams Jr., vice president of the Washington Bank & Trust Co., met with Bruce Bickham. An agreement was reached whereby Bickham agreed to do his personal and corporate banking business with the...
-
14. (3 points) Write a program that ask the user for 1. their first name and 2. their last name, Enter first name: Matt Enter last name: Priem Hello Matt Priem! and then outputs a greeting similar to...
-
Jorg is building an office building for Wilmington Company for $20,000,000. The contract has the following characteristics: The office building is built to the customers specifications and the...
-
Kincaid Company owns a equipment with a cost of $366,100 and accumulated depreciation of $53,600 that can be sold for $277,900, less a 3% sales commission. Alternatively, Kincaid Company can lease...
-
At the end of November 202 Upper X, the total amount of Social Security, $ 490, and Medicare, $ 275, was withheld as tax deductions from the employees of Rapid Waters, Inc. Federal income tax of $ 2...
-
For the current year, Boardwalk Games has the following inventory transactions related to its traditional board games. Date Transactions Units Unit Cost Total Cost January 1 Beginning inventory 102 $...
-
Sandy and John Ferguson got married eight years ago and have a seven-year-old daughter, Samantha. In 2022, Sandy worked as a computer technician at a local university earning a salary of $152,600,...
-
An incomplete cost of goods manufactured schedule is presented here. Complete the cost of goods manufactured schedule for Splish Brothers Company. ( Assume that all raw materials used were direct...
-
Use the link below to answer the followings questions. https://www.justice.gov/opa/pr/new-jersey-construction-company-operator-pleads-guilty-tax-crimes-and-bankruptcy-fraud 1. Company and Industry:...
-
describe about a conceptual Entity Relationship model?
-
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,...
-
On June 3, 2019, Catherine Shanahan received an unsolicited phone call on her cell phone. When she answered, she heard a prerecorded voice message advertising extended automobile warranties (Service...
-
In July 2006, the International Brotherhood of Teamsters, Local Union 25, filed two petitions and held an election for a collective bargaining representative at two FedEx locations. However, FedEx...
-
Miller filed for Chapter 7 bankruptcy protection on April 26, 2013. Based upon the filing date, the period for determining Millers current monthly income was October 1, 2012, through March 31, 2013....
Study smarter with the SolutionInn App