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
-
Use the data set from problem 21 of Chapter 3 on poor quality in the production of electric motors. a. Find the standard deviation and range to summarize the typical batch-to-batch variability in...
-
After eight matches a basketball player has a mean of 27 points. After ten matches his mean was 31 points. How many points in total did he score in his last two matches?
-
Describe why you should itemize deductions as opposed to taking the standard deduction.
-
Zurich Company reports pretax financial income of $70,000 for 2008. The following items cause taxable income to be different than pretax financial income. 1. Depreciation on the tax return is greater...
-
Milo Company manufactures beach umbrellas. The company ispreparing detailed budgets for the third quarter and has assembledthe following information to assist in the budget preparation:The Marketin 2...
-
Identify the following users as either External users or Internal users. a. Customers b. Suppliers c. External auditors d. Business press e. Managers f. District attorney g. Shareholders h. Lenders...
-
'In the United States, how can we improve the funding resources of the state and local governments without increasing our national debt?
-
Humpty Doo Production Systems Pty Ltd make designer kitchen furniture for the Top End home market. There are two types of product, the Family Suite, and the upmarket Designer Suite. In September 2023...
-
Small sphere attached to a light rigid rod rotates about an axis perpendicular to and fixed to the other end of the rod. Relative to the positive direction of the axis of rotation, the angular...
-
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter. The company's balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June...
-
Set the launch speed to 25 [m/s] and the launch angle to 30. Without clearing the run, set the launch angle to 60and run a second trial, so that both curves are simultaneously visible. What do you...
-
Reflective Report on Managing and Controlling Ethics Programs Learning What have I learnt (i.e., what was new/different for me)? 2. Critique How relevant is the topic of study? This should include a...
-
Statement of financial position at the start of the week: ASSETS $ Property 360,000 Office Equipment 130,000 Inventories 75,000 Trade Receivables 60,000 Total assets 625,000 EQUITY AND LIABILITIES $...
-
For all of the following words, if you move the first letter to the end of the word, and then spell the result backwards, you will get the original word: banana dresser grammar potato revive uneven...
-
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,...
-
2. Fluor, an engineering and construction company, was awarded a $1 billion project to build a coal gasification plant in South Africa. Fluor signed an agreement with a South African client that...
-
3. Do you love ice cream? Here is an opportunity for you! For only $800, you can buy a cow from Berkshire Ice Cream. The company gets milk from the cow and you get to share in the profits from the...
-
4. ETHICS ETS Payphones, Inc., sold pay phones to the public. The company then leased back the pay phones from the purchaser, promising a fixed 14 percent annual return on their investment. Although...
Study smarter with the SolutionInn App