Reference no: EM13541220
PROBLEM:
The board of directors of General Wheels Co. is considering seven large capital investments. Each investment can be made only once. The investments differ in the estimated long-run profit (net present value) that they will generate as well as in the amount of capital required, as shown by the following table:
The total amount of capital available for these investments is $100 million. Investment opportunities 1 and 2 are mutually exclusive, and so are 3 and 4.
Mutually exclusive alternatives: A group of alternatives where choosing any one alternative excludes choosing any of the others. For instance, when investment opportunities 1 and 2 are mutually exclusive, it means that if you select 1, you cannot select 2 or if you select 2, you cannot select 1.
Furthermore, neither 3 nor 4 can be undertaken unless one of the first two opportunities is under taken.
There are no such restrictions on investment opportunities 5, 6, and 7. The objective is to select the combination of capital investments that will maximize the total estimated long-run profit (net present value).
a) Formulate the above problem mathematically (in an algebraic form).
b) Formulate and solve the above problem on a spreadsheet using Excel.
c) Now, suppose that the following restrictions are given in addition to the above problem. Formulate each restriction as a constraint mathematically.
i. You cannot spend more than $60 million on first 3 of the opportunities.
ii. You can select at most 5 investment opportunities to invest.
iii. If you have selected both opportunities 5 and 6 to invest, you have to select either opportunity 1 or 2 to invest.
iv. You have to select at least two of the following opportunities: 1, 3, 5, 7.
|
Formulate the constraints and explain why they are needed
: formulate the constraints and explain why they are needed, and combine everything to have the final mathematical formulation.
|
|
What is the probability that the first pc you unpack and
: Assume that the probability of a PC being “dead on arrival” (DOA) due to an independent manufacturing defect is 1 in 100. If you order 300 PCs for (say) your business, what is the probability that the first PC you unpack and install is DOA?
|
|
Binary integer programming model
: Dispatcher next formulates and solves a binary integer programming model for selecting three routes that minimize their total time while including each delivery location on exactly one route.
|
|
Determine minimum cost plan that meets the electrical needs
: An electrical utility needs to generate 6,500 megawatts of electricity today. It has five generators. If any electricity is generated by a given generator, that generated must be started up and a fixed start-up cost is incurred.
|
|
Total amount of capital available for investments
: Formulate the problem mathematically and formulate and solve the above problem on a spreadsheet using Excel - total amount of capital available for these investments
|
|
Formulate a mixed-integer optimization model
: Formulate a mixed integer programming model for the given problem by defining your decision variables, and writing your objective functions and constraints - formulate a mixed integer linear programming model for the problem
|
|
Calculate the discharge if the downstream water height
: Water discharges from an irrigation pond (water surfaceelevation 230 ft) through a 4 ft diameter circular orifice. Theinvert elevation of the orifice is at 213 ft and the bottom of the pond has an elevation of 205 ft. Assuming a Cd = 0.60, calculatet..
|
|
What is the annual equivalent value of ageometrically
: Assume he has to reach a town 300km away, and that the 40 kg he carries includes both merchandiseand the food necessary for his sustenance during the trip at 2000Cal/day.
|
|
What amount of tension do you need to apply not to have any
: You are using that tape to measure the distance between two pointswhere the tapes are supported at the ends only. The temperature ofthe day is 68oF. What amount of tension do you need to apply not tohave any corrections in the tape measurement?
|