Practical Management Science
Practical Management Science
5th Edition
ISBN: 9781305734845
Author: WINSTON
Publisher: Cengage
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 2, Problem 44P

The IRR is the discount rate r that makes a project have an NPV of $0. You can find IRR in Excel with the built-in IRR function, using the syntax =IRR(range of cash flows). However, it can be tricky. In fact, if the IRR is not near 10%, this function might not find an answer, and you would get an error message. Then you must try the syntax =IRR(range of cash flows, guess), where “guess" is your best guess for the IRR. It is best to try a range of guesses (say, −90% to 100%). Find the IRR of the project described in Problem 34.

34. Consider a project with the following cash flows: year 1, −$400; year 2, $200; year 3, $600; year 4, −$900; year 5, $1000; year 6, $250; year 7, $230. Assume a discount rate of 15% per year.

  1. a. Find the project’s NPV if cash flows occur at the ends of the respective years.
  2. b. Find the project’s NPV if cash flows occur at the beginnings of the respective years.
  3. c. Find the project’s NPV if cash flows occur at the middles of the respective years.
Blurred answer
Students have asked these similar questions
IM.54 A growing online retailer sells thousands of items yet has has one specialty product category with just 30 items. They want to classify these thirty items according to the annual dollar volume (revenue) generated by each item. The table below lists each item number, Annual Sales (in units), and Price per unit: Item #   Annual Sales     Price   1 221 $25.85 2 446 $14.15 3 8,940 $168.19 4 2,965 $15.99 5 1,322 $29.37 6 2,575 $12.77 7 767 $28.43 8 5,803 $163.01 9 2,673 $20.51 10 642 $14.71 11 4,168 $54.53 12 1,881 $22.55 13 2,417 $29.63 14 5,207 $36.41 15 1,381 $20.55 16 9,635 $173.69 17 17,406 $27.07 18 1,573 $25.99 19 6,471 $64.99 20 6,047 $29.83 21 433 $20.89 22 2,279 $53.59 23 15,532 $106.91 24 1,585 $4.09 25 5,376 $65.23 26 2,965 $37.93 27 2,048 $28.51 28 1,174 $22.99 29 381 $5.57 30 2,930 $3.43   Which item in the table above has the highest annual dollar volume?  In the answer field below, write the ITEM # that…
IM.84 An outdoor equipment manufacturer sells a rugged water bottle to complement its product line. They sell this item to a variety of sporting goods stores and other retailers. The manufacturer offers quantity discounts per the following discount schedule: Option Plan Quantity    Price A 1 - 2,199 $5.00 B 2,200 - 3,699 $4.55 C 3,700+ $3.90 A large big-box retailer expects to sell 9,200 units this year. This retailer estimates that it incurs an internal administrative cost of $235 each time it places an order with the manufacturer. Holding cost for the retailer is $60 per case per year. (There are 52 units or water bottles per case.)Based on this information, and not taking into account any quantity discount offers, what is the calculated EOQ (in units)? (Display your answer to the nearest whole number.)     Based on this information, sort each quantity discount plan from left to right by dragging the MOST preferred option plan to the left, and the LEAST preferred option…
Please provide detailed solutions to the following problems/exercises (4 problems/exercises x 9 points each):   1) View the video ON Unveils ‘Lightspray’ Technology (4.55 mins, Ctrl+Click in the link), and The Secret of Lightspray (8.27 mins, Ctrl+Click in the link), answer the following questions: https://www.youtube.com/watch?v=wjmeaC-wlZs a) What is new about the design of ON’s shoes? b) How will ON’s new manufacturing technique affect location planning for footwear firms? c) How does ON focus on it sustainability strategy?   Note: As a rough guideline, please try to keep the written submission to one or two paragraphs for each of the questions.   2) Unimed Hospital currently processes patient admissions through three admitting clerks who are set up to work in series, with respective reliabilities of 0.96, 0.95, and 0.90 (see figure below).           a) Find the reliability of the current admission process. Due to rising patient complaints, the hospital administrator, Chimeg…
Knowledge Booster
Background pattern image
Operations Management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Single Exponential Smoothing & Weighted Moving Average Time Series Forecasting; Author: Matt Macarty;https://www.youtube.com/watch?v=IjETktmL4Kg;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License