Develop an integer programming model to maximize the NPV in this situation. Useexcel to solve this problem. Which of the three investments would be undertaken if[ Select ]Maximize 9000 X1 + 7000 X2 + 8000X3Minimize 32000 X2 + 29000X3NPV is maximized?V Minimize 25000 X1 + 32000 X2 + 29000X3Maximize 9000 X1 + 7000 X2The Objective functionThe Optimal solution:X1= [Select]X2= [ Select ]X3= [ Select ]Profit= $ [ Select ] A company is considering three alternative investments from which to choose. Itwill cost $25,000 to consider investment 1, and $32,000 to consider investment 2,and $29,000 to consider investment 3. The company can only choose 2 out of the 3investments and it has a budget of $62,000 to spend on these investments. Thecompany has a limitation of 36 resources for these investments, where investment 1requires 16 resources, investment 2 requires 14 resources and investment 3 requires19. The NVP on investment 1 is $9000, $7000 for investment 2, and $8000 forinvestment 3.

NPV stands for net present value. It is an important capital budgeting tool that we use to analyze…

Develop an integer programming model to maximize the NPV in this situation. Use excel to solve this problem. Which of the three investments would be undertaken if NPV is maximized? [ Select ] Maximize 9000 X1+ 7000 X2 + 8000X3 Minimize 32000 X2 + 29000X3 V Minimize 25000 X1 + 32000 X2 + 29000X3 The Objective functior Maximize 9000 X1 + 7000 X2

Develop an integer programming model to maximize the NPV in this situation. Use excel to solve this problem. Which of the three investments would be undertaken if NPV is maximized? [ Select ] Maximize 9000 X1+ 7000 X2 + 8000X3 Minimize 32000 X2 + 29000X3 V Minimize 25000 X1 + 32000 X2 + 29000X3 The Objective functior Maximize 9000 X1 + 7000 X2

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter19: Capital Investment

Section: Chapter Questions

Problem 25P

See similar textbooks

Similar questions

Wisconsin Dairy Inc. is deciding on its capital budget for the upcoming year. Among the projects being considered are two machines, W and WW. W costs $500,000 and will produce expected after-tax cash flows of $300,000 during the next 2 years. WW also costs $500,000, but it will produce after-tax cash flows of $165,000 during the next 4 years. Both projects have a 10% WACC. If the projects are independent and not repeatable, which project(s) should the company accept? If the projects are mutually exclusive but are not repeatable, which project should the company accept? Assume that the projects are mutually exclusive and can be repeated indefinitely. Use the replacement chain method to determine the NPV of the project selected. Use the equivalent annual annuity method to determine the annuity of the project selected.
The Chief Financial Officer of Eaton Medical Devices has determined that the firm’s capital investment budget will be $5,000,000 for the upcoming year. Unfortunately, this amount is not sufficient to cover all of the positive NPV projects available to the firm. Project Cost NPV A $1,061,191 $122,737 B 561,758 58,102 C 1,647,849 280,660 D 1,026,020 89,365 E 191,870 17,568 F 1,333,625 76,960 G 3,102,642 123,240 H 275,568 79,367 I 2,044,070 60,506 J 1,017,567 56,690 Using the Solver, determine which of the above projects should be included in the budget if the firm’s goal is to maximize shareholder wealth (Note: Set the Solver to use the Simplex LP method, and turn off the Ignore Integer Constraints setting.)
An engineering firm has identified five ways to cut costs in its main office. Only one of the options can be implemented, however, since each involves significant training time for staff engineers. Data are provided in the table. Each option has a lifetime of seven years, and the firm sets a MARR at 15%. Option A B C D E Capital cost ($ million) 2.713 0.375 1.650 0.088 0.950 Annual cost ($ million/yr 0.093 0.275 0.132 0.147 0.228 Annual benefit ($ million/yr) 0.890 0.288 0.841 0.312 0.505 a) Solve by present worth analysis. b) Solve by annual cash flow analysis. c) Solve by incremental benefit-cost ratio analysis. d) Solve by an incremental rate of return analysis using the full detailed procedure
ClockWatchers is about to introduce a new employee monitoring tool and has determined that it will charge $100 per unit. The company must decide whether or not to purchase a high-capacity manufacturing machine. If the high-capacity machine is selected, then the cash fixed costs will be $5,000 per year, with variable costs of $50 per unit and depreciation and amortisation expenses of $2,000. Otherwise the fixed costs will be $2,000, with variable costs of $75 per unit and depreciation and amortisation expenses of $500. If EBIT Break-even is how the company evaluates its projects, then above what level of expected sales should ClockWatchers choose the high fixed cost alternative? 60 units 90 units120 units 180 units
Camber Corporation has to decide if they can finance purchasing 10 new machines for all their manufacturing sites. The machines cost $1.73 million each, and the supplier agreed to the following payment terms, 40% upfront, and the remainder to be paid over 4 years at an annual rate of 12%.a) Executives at Camber Corporation review their budgets and discover that they can pay the supplier 40% now, but their budget will only allow them to pay $4,000,000 per year for the next four years. Will that be enough to make the purchase? [Note: you are supposed to show every step of your calculation and interpret the result
As part of its overall plant modernization and cost reduction program, the management of Tanner-Woods Textile Mills has decided to install a new automated weaving loom. In the capital budgeting analysis of this equipment, the IRR of the project was 20% versus a project required return of 12%. The loom has an invoice price of $250,000, including delivery and installation charges. The funds needed could be borrowed from the bank through a 4-year amortized loan at a 10% interest rate, with payments to be made at year-end. In the event the loom is purchased, the manufacturer will contract to maintain and service it for a fee of $20,000 per year paid at year-end. The loom falls in the MACRS 5-year class, and Tanner-Woods's marginal federal-plus-state tax rate is 40%. The applicable MACRS rates are 20%, 32%, 19%, 12%, 11%, and 6%. United Automation Inc., maker of the loom, has offered to lease the loom to Tanner-Woods for $70,000 upon delivery and installation (at t = 0) plus 4…
Camber Corporation has to decide if they can finance purchasing 10 new machines for all their manufacturing sites. The machines cost $1.73 million each, and the supplier agreed to the following payment terms, 40% upfront, and the remainder to be paid over 4 years at an annual rate of 12%. Executives at Camber Corporation review their budgets and discover that they can pay the supplier 40% now, but their budget will only allow them to pay $4,000,000 per year for the next four years. Will that be enough to make the purchase? Critically discuss the effect of increasing the amount paid upfront when corporations make capital purchases, focusing on the benefits and drawbacks
In conducting an EVA analysis for year two for a newly introduced product line, Bethune, Inc., which manufactures pre-assembled blower packages and other water treatment components, determined the EVA to be $28,000. Bethune’s CEO knew that the gross income was $700,000, but he asked you to find out how much expense was associated with the new product line for year 2. The company uses an after-tax interest rate of 14% and a Te of 35%. The initial investment capital required for the new product was $550,000 and all equipment is 3-year MACRS depreciated.
The management of a private hospital is considering automating some back office functions. This would replace five personnel that currently cover three shifts per day, 365 days per year. Each person earns $35,000 per year. Company-paid benefits and overhead are 45% of wages. Money costs 8% after income taxes. Combined federal and state income taxes are 28%. Annual property taxes and maintenance are and 4% of investment, respectively. Depreciation is 15-year straight line. Disregarding inflation, how large an investment in the automation project can be economically justified?
A firm has only $10,000 to invest and must choose between two projects. Project A returns $12,400 after a year while project B pays $15,609 after three years. If management wants to select the investment with the higher return, which alternative should be chosen?
Two proposals have been offered for streamlining the business operations of a customer call center. Proposal A has an investment cost of $30,000, an expected life of 5 years, property taxes of $450 per year, and no market value. Annual expenses are estimated to be $6,000. Proposal B has an investment cost of $38,000, an expected life of 4 years, property taxes of $600 per year, and no market value. Its annual operating expenses are expected to be $4,000. Using a MARR = 10% per year, which proposal should be recommended? Use the AW method and state your assumption(s).
As an staff at company, you are considering two projects which project A has an initial investment of $100,000 and yearly revenue of $17, 600 for 10 years, and Project B has an initial investment of $51,000 and yearly revenue of $10, 100 for 10 years. What is the point of indifference? Which project would you accept at a WACC of 16.0%? a) Point of indifference does not exist, accept project B b)Point of indifference at 8.60%, accept both Project A and Project B c) Point of indifference at 8.60%, don't accept Project A and don't accept ProjectB d) Point of indifference at 14.84%, accept Project B. e) Point of indifference at 11.86%, accept Project B f)Point of indifference at 11.86%, accept Project A