Solve the revised model with lingo or excel solver

Assignment Help Operation Management

Reference no: EM13918891

In the Markowitz portfolio optimization model defined in equations (8.10) through (8.19), the decision variables represent the percentage of the portfolio invested in each of the mu- tual funds. For example, FS = 0.25 in the solution means that 25% of the money in the portfolio is invested in the foreign stock mutual fund. It is possible to define the decision variables to represent the actual dollar amount invested in each mutual fund or stock. Redefine the decision variables so that now each variable represents the dollar amount invested in the mutual fund. Assume an investor has $50,000 to invest and wants to minimize the variance of his or her portfolio subject to a constraint that the portfolio returns a minimum of 10%. Reformulate the model given by (8.10) through (8.19) based on the new definition of the decision variables. Solve the revised model with LINGO or Excel Solver.

Text Book: An Introduction to Management Science: Quantitative Approaches to Decision. By David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey Camm, James Cochran.

Reference no: EM13918891

Questions Cloud

What are the eight drivers of an innovation economy : What are the eight drivers of an innovation economy? Which of the eight drivers of an innovation economy influences your organization the most? Explain your answer. What is the influence of these eight drivers on your organization, and why?

Investment in the marketing of a brand over time : Question 1: ________ represent(s) the cumulative added value of a company's investment in the marketing of a brand over time.

Mathematical sequences in calculator program : Each mathematical operation in the menu should be represented by a separate function. In addition to all operations your calculator had to support in lab 3, please add additional functionality to your calculator. Include the ability to compute the..

Which reading strategies will use to enhance a unit of study : Which reading and writing strategies (tools) will you use to enhance a unit of study? Why did you select those in differentiating instruction for specific students? Will the differentiation result in improved learning? How will you gather evidence..

Solve the revised model with lingo or excel solver : Reformulate the model given by (8.10) through (8.19) based on the new definition of the decision variables. Solve the revised model with LINGO or Excel Solver.

Explain in terms of energy conservation : Explain in terms of energy conservation how, by knowing the vertical drop height, the energy at impact of a pendulum impactor can be calculated.

What is procter and gamble business strategy : How is P&G using collaboration systems to execute its business model and business strategy? List and describe the collaboration systems and technologies it is using and the benefits of each.

Check data before preparing financial reports : A form used to organize and check data before preparing financial reports is known as a(n):

What are the keys to success in the industry : Provide an overview of the computing segment of the computer technology industry and its structure. What are the opportunities and threats facing industry players?

User Account

All Pages