Purchase Solution

Linear Programming Modification for Capital Budgeting

Not what you're looking for?

Ask Custom Question

Need LP tutorial help involving optimization and the use of Solver.

Solve the following modifications of the Tatham Capital Budgeting model (solve each part independently of the others)

(a) Suppose that at most two of the project 1 - 5 can be selected. write the appropriate algebraic constraint and solve. What is the new Z*?
(b) Suppose that if investment 1 is selected, then investment 3 must also be selected. Write the appropriate algebraic constraint and solve. What is the new Z*?
(c) Suppose that at least one of the investments 6 and 7 must be selected. Write the appropriate algebraic constraint and solve. What is the new Z*?
(d) Suppose that investment 2 can be selected only if both investments 1 and 3 are selected. Write the appropriate algebraic constraint and solve. What is the new Z*?

Attachments
Purchase this Solution
Solution Summary

Detailed solution to linear programming optimization is provided.

Solution Preview

Please see attached files. Thanks for using BrainMass!

Suppose the decision variables are Xi = 1 if investment i is selected, and 0 otherwise, i=1,2,...,7..
a) The additional constraint is
(see attached file for equations)
Please see Tab (a) in the spreadsheet. The new solution is investment 1, 5 and 7 are selected, ...

Purchase this Solution
Free BrainMass Quizzes
Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

View More Free Quizzes
Related BrainMass Solutions

  • Quantitative Methods: INTEGER PROGRAMMING

    What is the optimal solution to the integer linear programming problem? State the optimal values of decision variables and the value of the objective function. 17. Consider a capital budgeting example with 5 projects from which to select.

  • Integer programming problem

    What is the optimal solution to the integer linear programming problem? State the value of the objective function Z = x or x.x 2. Consider a capital budgeting example with 5 projects from which to select.

  • Quantitative Methods Linear/Integer Programming

    73504 Quantitative Methods Linear/Integer Programming Study Questions _______ 1. Linear programming models have decision variables for measuring the level of activity. _______ 2.

  • Application of Linear Programming to Financial Budgeting and the Costing of Funds

    26010 Application of Linear Programming to Financial Budgeting and the Costing of Funds Can anyone tell me "linear programming: direct and dual relations" are about in plain English, please?

  • Linear Programming Application

    Formulate an appropriate linear programming model that can be used to determine the optimal project selection structure for the budgeting period. b.

  • Quantitative Methods: True/False

    The linear programming model for a transportation problem has constraints for supply at each source and demand at each destination.

  • Quantitative Methods - Integer programming

    Assume that we are using 0-1 integer programming model to solve a capital budgeting problem and xj = 1 if project j is selected and xj = 0 otherwise.

  • Binary integer programming model (capital budgeting)

    4872 Binary integer programming model (capital budgeting) A. Define the decision variables for this formulation. b. Show the binary integer programming formulation including the objective function and all relevant constraints. c.

  • MCQs on LPP, IPP

    Find the Optimal Integer Solution 1 Consider the following integer linear programming problem (Problem in the attached word file) The solution to the Linear programming relaxation is: x1 = 5.714, x2 = 2.571.

  • Linear Programming with decision variables and constraints

    208386 Linear Programming with decision variables and constraints. Use Excel Problem # 3 A professor has been contacted by four not-for-profit agencies that are willing to work with student consulting teams.

View More Related Solutions