Purchase Solution

Linear Programming for General Wheels Co.

Not what you're looking for?

Ask Custom Question

See attached file.

The board of directors of General Wheels Co. is considering seven large capital investments. Each investment can be made only once. These 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: (See attachment for actual table)

Investment Opportunity Estimated Profit (millions) Capital Required (millions)
1 17 43
2 10 28
3 15 34
4 19 48
5 7 17
6 13 32
7 9 23

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. Furthermore, neither 3 nor 4 can be undertaken unless one of the first two opportunities is undertaken. 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.

a) Formulate and solve a BIP model on a spreadsheet for this problem.

b) Which investments should be undertaken?

c) What will be the maximum profit?

Attachments
Purchase this Solution

Solution Summary

The solution discusses linear programming for the General Wheels Co. including investments and maximum profit.

Solution provided by:
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution


Free BrainMass Quizzes
Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)