Question: NEED THIS ASAP! A company is considering three alternative investments from which to choose. It will cost $21,000 to consider investment 1 , and $30,000

which to choose. It will cost $21,000 to consider investment 1 ,

NEED THIS ASAP!

and $30,000 to consider investment 2 , and $28,000 to consider investment

3 . The company can only choose 2 out of the 3

A company is considering three alternative investments from which to choose. It will cost $21,000 to consider investment 1 , and $30,000 to consider investment 2 , and $28,000 to consider investment 3 . The company can only choose 2 out of the 3 investments and it has a budget of $62,000 to spend on these investments. The company has a limitation of 36 resources for these investments, where investment 1 requires 15 resources, investment 2 requires 13 resources and investment 3 requires 18. The NVP on investment 1 is $9000,$12000 for investment 2 , and $8000 for investment 3 . Develop a 0 - 1 integer programming model to maximize the NPV in this situation. Use excel to solve this problem. The Objective function: The Constraint: Budget: Resources: Resources: Investments: The Optimal solution: X1= 2= 3= Profit =$ Which of the three investments would be undertaken if NPV is maximized

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Levine Company is a manufacturer of very inexpensive DVD players and television sets. The company uses recycled parts and a highly structured manufacturing process to keep costs low so that it can...

A company is considering three alternative investments from which to choose. It will cost $25,000 to consider investment 1, and $32,000 to consider investment 2, and $29,000 to consider investment 3....

A company is considering four alternative investments from which to choose. It will cost $ 2 4 , 0 0 0 to consider investment 1 , and $ 3 1 , 0 0 0 to consider investment 2 , and $ 2 8 , 0 0 0 to...

.. LTE ED Widget $120,000 $70,000 -$30,000 Hummer 60,000 40,000 20,000 Nimnot 35,000 30,000 30,000 a) Compute the expected value for each decision and select the best one. b) Determine how much the...

Please help me with questions 1-18 , has to be in Excel 6.1. Future value with multiple cash flows: Konerko, Inc., expects to earn cash flows of $1 years. If the company uses an 8 percent discount...

Complete tabs 6.1, 6.4, 6.7, 6.9, 6.12, 6.16, 6.23, and 6.33 in the attached Chapter 6 Excel spreadsheet. An EXAMPLE tab is provided in the spreadsheet for your guidance. You must use formulas in the...

MULTIPLE CHOICE: 1. Using the balanced scorecard approach, an organization evaluates managerial performance based on: a. A single ultimate measure of operating results, such as residual income. b....

please can you explain the Palamon Case, Palamon Caputal Partners/Teamsystem S.P.A PALAMON CAPITAL PARTNERS/TEAMSYSTEM S.P.A. We want to make money by investing in change. -Louis Elson, Managing...

Need help with these discussion postings (in a document) and assignments (all in separate files), all directions are included as well. FINANCE DIRECTIONS Need to provide 1 original post substantial...

You just need to add with latest information from wall street journal news as per question. You need to add the information in the assignments. I have attached four assignments. Also I am attaching...

data dile is in photo attached. that is all i have . 2. A company is considering three vendors for purchasing a CRM system: Delphi Inc., CRM International, and Murray Analytics. The costs of the...

For a normal distribution, a. Find the z -score for which a total probability of 0.02 falls more than z standard deviations (in either direction) from the mean, that is, below - z or above + z. b....

Write a computer program to fit a straight line y = ax + b to tabulated (x, y) data, assuming that no more than 100 data points will be taken in any one run. Your program should read in and store the...

code class = "asciimath" > For a continuous random variable, X , with a probability density function, f , defined by f ( x ) = { ( ( 1 ) / ( 2 ) x + 2 , - 4

Assume that you are auditing Pacific Tours Ltd for the year ended 31 December 2019. The financial report will be approved and signed by the directors on January 2020, with the auditors report signed...

(a) What are the auditor\'s responsibilities for \'going concern assumptions\'? (2 marks) (250 - 300 words) (b) Maxim Stewart is the partner in charge of the audit for a new client, Southern...

You have reviewed the work performed by your assistant, Raymond Snow, on the audit of Tin Ltd for the year ended 30 June 20X8 and you have noted the following two independent matters: (i) In testing...

The figure shows the solubility of a compound A in three different solvents (I-III) as a function of temperature. Which solvent would you choose to recrystallize A? Why? Temperature Problem 2 The...

Create a 200 word summary on the Juvenile Justice System than and today. Describe The Juvenile system and provide a generalizable definition. Highlight the issues in the Juvenile system and why this...

Consider the scholarship fund in the preceding question. Suppose that the first scholarship award occurs one year from now and the donor wants the scholarship to grow by 2 percent per year. How much...

A single-payment note promises $67,280 at maturity. The issuer of the note exchanges it for land with a fair market value of $50,000. The exchange occurs two years before the maturity date on the...

Finding implicit interest rates; constructing amortization schedules. Berman Company purchased a plot of land for possible future development. The land had fair market value of $86,000. Berman...