Formulate as an ILP & Solve using Excel A company is considering three major research projects...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Formulate as an ILP & Solve using Excel A company is considering three major research projects labeled A, B, and C. Each of the projects can be selected for any of the next 3 years or may be omitted from the portfolio entirely. The total return for each project based on the year it is selected is given in the table. This return captures all relevant cash flows, including investments. It also includes the effects of the time value of money. The investment required for each project occurs entirely within the year for which it is selected. The goal is to maximize the total return. This problem has the following constraints. No more than two projects can be selected in any year. Total investment in any year cannot exceed 9. Project B must be selected after project A. Project A and B cannot be selected in the same year. A project can be selected at most once. Formulate and solve the problem as an IP. Define all notation. Year 1 2 3 Investment A 7585 Total return for project B 6 4 47 3 4455 Formulate as an ILP & Solve using Excel A company is considering three major research projects labeled A, B, and C. Each of the projects can be selected for any of the next 3 years or may be omitted from the portfolio entirely. The total return for each project based on the year it is selected is given in the table. This return captures all relevant cash flows, including investments. It also includes the effects of the time value of money. The investment required for each project occurs entirely within the year for which it is selected. The goal is to maximize the total return. This problem has the following constraints. No more than two projects can be selected in any year. Total investment in any year cannot exceed 9. Project B must be selected after project A. Project A and B cannot be selected in the same year. A project can be selected at most once. Formulate and solve the problem as an IP. Define all notation. Year 1 2 3 Investment A 7585 Total return for project B 6 4 47 3 4455
Expert Answer:
Answer rating: 100% (QA)
Certainly Lets denote the decision variables and formulate the Integer Linear Programming ILP proble... View the full answer
Related Book For
Posted Date:
Students also viewed these general management questions
-
BACKGROUND You are an information analyst working for NEE. The company president has asked you to prepare a Quantitative analysis of financial, sales, and operations data to help determine which...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
In 2020/21 Ella had taxable income (after deducting the personal allowance) of 52,000, all of which represented savings income. She paid 1,600 as a Gift Aid donation to the NSPCC (a registered...
-
1. Understand human resource management and explain how managers develop and implement a human resource plan. 2. Understand why teams may be effective or ineffective and identify the skills needed by...
-
RDI Products Co. manufactures a variety of products made of plastic and aluminum components. During the winter months, substantially all of the production capacity is devoted to the production of...
-
Consider the regression models described in Example 8.4. Example 8.4 a. Graph the response function associated with Eq. (8.10). Equation (8.10) b. Graph the response function associated with Eq....
-
Lopez and Tiznado, dentists, budgeted for the following revenue and expenses for March: Depreciationequipment. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 1,500 Fringe...
-
Coronado Industries has 26000 units in beginning finished goods. If sales are expected to be 140000 units for the year and Coronado desires an ending finished goods of 35000 units, how many units...
-
K Ltd. paid an employee a tax-free travel allowance of $5,200 based on 9,000 kilometres of out-of-town driving. What amount can K deduct for tax purposes?
-
A Gaussian blur is a common image processing operation. This is computed by taking a weighted average of the pixel itself with its nearest neighbors. Given the following 3x3 filter like the...
-
True or False: Benefit-cost analysis is primarily used by regulated utilities.
-
True or False: The B-C evaluation is directly applicable to evaluation of one or many alternatives.
-
True or False: If the optimum replacement interval for an over-the-road tractor is 4 years and the salvage value for used tractors is suddenly cut in half, then the optimum replacement interval for...
-
A pipeline contractor can purchase a needed truck for \($40,000.\) Its estimated life is 6 years, and it has no salvage value. Maintenance is estimated to be \($2,400\) per year. Operating expense is...
-
Snow Valley Ski Resort has been contracting snow removal from its parking lots at a cost of \($400/day.\) A snow removal machine can be purchased for \($25,000.\) The machine is estimated to have a...
-
Why is knowing and being able to measure the performance criteria necessary for training and evaluating training? How might performance criterion deficiency make it difficult to know if training was...
-
AB CORPORATION ISSUED THE FOLLOWING 850 COMMON STOCKS PAR VALUE P100 750 PARTICIPATING PREFERRED STOCKS PAR VALUE P100 AT 3% AB CORPORATION DECLARED P100,000.00 DIVIDEND IN 2022.
-
Why is it necessary to eliminate services charged by one company in a group to another company in the same group?
-
In the fall of 2012, eight wealthy businesspeople from the same ethnic background formed a committee (CKER committee) to obtain a radio license from the Canadian Radio-television and...
-
Why is it important to identify transactions as current or previous period transactions?
-
An amorphous material is: (a) Mica (b) Lead (c) Rubber (d) Glass
-
Discuss the application vernier caliper and its method of measurement.
-
In center lathe, cutting tool is fed in ____ directions with reference to the lathe axis.
Study smarter with the SolutionInn App