Question

In: Operations Management

3. (20 pts) Hilton Financial Inc. has just obtained $240,000 for investment and would like to...

3. (20 pts) Hilton Financial Inc. has just obtained $240,000 for investment and would like to maximize investment return. The firm’s top financial analyst recommends that all new investments be made in the automobile industry (Ford, Honda), retail industry (Target, Wal-Mart), or in government bonds. Specifically, the analyst identified five investment opportunities and projected their annual rates of return:

                                              Investment                                            Projected Rate of Return

                                              Ford                                                                    12%

                                              Honda                                                                 11%       

                                              Target                                                                8%

                                              Wal-Mart                                                              6%

                                              Government Bonds                                             5%

Management of Hilton imposed the following guidelines:

                              1. Neither industry (automobile or retail) should receive more than $140,000.

                              2. Government bonds should be at least 25% of the retail industry investments.

                              3. The investment in Ford can not be more than 65% of the total automobile industry investment.

  1. The investment in Target may not exceed 70% of the investment in Wal-Mart.

        5. No more than 60% of the total funds invested in stock (automobile and retail) may be invested in the automobile industry, and no more than 55% of the funds invested in stock (automobile and retail) may be invested in the retail industry.

                        

Formulate a linear programming model of the problem to find out how much to invest in each security.

3. (20 pts) Hilton Financial Inc. has just obtained $240,000 for investment and would like to maximize investment return. The firm’s top financial analyst recommends that all new investments be made in the automobile industry (Ford, Honda), retail industry (Target, Wal-Mart), or in government bonds. Specifically, the analyst identified five investment opportunities and projected their annual rates of return:

                                              Investment                                            Projected Rate of Return

                                              Ford                                                                    12%

                                              Honda                                                                 11%       

                                              Target                                                                8%

                                              Wal-Mart                                                              6%

                                              Government Bonds                                             5%

Management of Hilton imposed the following guidelines:

                              1. Neither industry (automobile or retail) should receive more than $140,000.

                              2. Government bonds should be at least 25% of the retail industry investments.

                              3. The investment in Ford can not be more than 65% of the total automobile industry investment.

  1. The investment in Target may not exceed 70% of the investment in Wal-Mart.

        5. No more than 60% of the total funds invested in stock (automobile and retail) may be invested in the automobile industry, and no more than 55% of the funds invested in stock (automobile and retail) may be invested in the retail industry.

                        

Formulate a linear programming model of the problem to find out how much to invest in each security.

Solutions

Expert Solution

Answer: We will formulate LP model for the given problem as mentioned below;

Decision Variables:

Let Decision Variables:

x1 = $ Amount to be invested in the stock of Ford,

x2 = $ Amount to be invested in the stock of Honda,

x3 = $ Amount to be invested in the stock of Target,

x4 = $ Amount to be invested in the stock of Wall-Mart, and

x5= $ Amount to be invested in Government Bond

Where x1 + x2 = Total investment in automobile industry, and x3 + x4 = Total investment in retail industry

Objective Function:

Here, the main objective is to maximize the total return, hence the objective function =

0.12 x1 + 0.11 x2 + 0.08 x3 + 0.06 x4 + 0.05 x5

Subject to Constraints:
C1 = x1 + x2 + x3 + x4 + x6 ≤ 240000 (Total amount to be invested)

C2 = x1 + x2 ≤ 140000 (Max. amount to be invested in automobile industry)

C3 = x3 + x4 ≤ 140000 (Max. amount to be invested in retail industry)

C4 = x5 ≥ 0.25 ( x3 + x4) (Investment in Gov. Bonds should be at least 25% of total retail industry investiment)

C5 = x1 ≤ 0.65 ( x1 + x2) (Investment in Ford can not be more than 65% of the total automobile industry investment)

C6 = x3 ≤ 0.70 x4 (Investment in Target may not exceed 70% of the investment in Wal-Mart)

C7 = x1 + x2 ≤ 0.60 ( x1 + x2 + x3 + x4) [No more than 60% of the total funds invested in automobile and retail retail industry may be invested in the automobile industry]

C8 = c3 + c4 ≤ 0.55 ( x1 + x2 + x3 + x4) [No more than 55% of the funds invested in stock (automobile and retail) may be invested in the retail industry]

Non-Negativity Condition:

x1, x2, x3, x4, x5 ≥ 0

[Note: As no specific information is mentioned in the question we will just formulate an LP model. (No need to solve) ]


Related Solutions

you would like to retire 20 years from now and have an investment worth $3 million...
you would like to retire 20 years from now and have an investment worth $3 million at that time. Currently, you have $200,000 in your account and plan to add $10,000 to that account each year. What annual rate of return must you earn on average to achieve your goal? a) 10.42% b) 12.77% c) 12.86% d) 14.07% e) 12.25% An investment is expected to produce cash flows of $1,000 at the end of each of the next 6 years,...
DRK, Inc., has just sold 240,000 shares in an initial public offering. The underwriter’s explicit fees...
DRK, Inc., has just sold 240,000 shares in an initial public offering. The underwriter’s explicit fees were $144,000. The offering price for the shares was $32, but immediately upon issue, the share price jumped to $33.00. a. What is the total cost to DRK of the equity issue? Total Cost ________ b. Is the entire cost of the underwriting a source of profit to the underwriters? ___ Yes ___No
a.Joe Smith has asked your financial advice. He would like to have $2,000,000 in his investment...
a.Joe Smith has asked your financial advice. He would like to have $2,000,000 in his investment account 25 years from now. He expects a stable 6% return and has $250,000 now. How much does he need to add to his account annually to achieve his goal? b.Joe Smith has asked your financial advice. He would like to have $2,000,000 in his investment account 25 years from now. He expects a stable 6% return and has $250,000 now. What would he...
Parrish, Inc. is considering the purchase of a machine that would cost $240,000 and would last...
Parrish, Inc. is considering the purchase of a machine that would cost $240,000 and would last for 5 years, at the end of which, the machine would have a salvage value of $48,000. The machine would reduce labor and other costs by $62,000 per year. Additional working capital of $7,000 would be needed immediately, all of which would be recovered at the end of 5 years. The company’s discount rate is 17% Compute the net present value of the proposed...
3. April, Inc. issued 4000 shares of preferred stock for $240,000. The stock has a par...
3. April, Inc. issued 4000 shares of preferred stock for $240,000. The stock has a par value of $60 per share. The journal entry to record this transaction would ________. A) credit Cash $240,000, debit Preferred Stock—$60 Par Value $4000, and debit Paid-In Capital in Excess of Par—Preferred $236,000 B) debit Cash $240,000, credit Preferred Stock—$60 Par Value $4000, and credit Paid-In Capital in Excess of Par—Preferred $236,000 C) credit Cash $240,000 and debit Preferred Stock—$60 Par Value $240,000 D)...
Suppose you would like to be able to withdraw $240,000 per year for 30 years you...
Suppose you would like to be able to withdraw $240,000 per year for 30 years you are retired. How much do you need to save for the 45 years you are working reach this goal? Assume that you can earn 5% on your investments during your retirement and 7.5% in the years you are saving. Also, assume begin saving in year 1 and don’t make your first withdraw until year 46.
Erika would like to hire a financial advisor. The financial advisor that she has been considering...
Erika would like to hire a financial advisor. The financial advisor that she has been considering indicated that she would charge $2,500 to write a financial plan and 1% of any asset she manages. The financial advisor that Erika is considering is using what type of compensation model? A. Fee-offset. B. Fee-only. C. Commission. D. Fee-based.
A company has total fixed costs of $240,000 and a contribution margin ratio of 20%. The...
A company has total fixed costs of $240,000 and a contribution margin ratio of 20%. The total sales necessary to break even are ____________ (Round your answer to a whole number if needed. Just put the number in the blank. No $ sign.)
A company has just received a huge donation. It would like to make payments for its...
A company has just received a huge donation. It would like to make payments for its insurance for three years in advance. Previously, it has paid $100 in premiums every week. Assuming interest rate of 10%, what single sum of money should it pay?    (Note: the insurance payments are due at the beginning of the period of coverage, and compounding weekly). This is annuity due. a. 12,316.987 b. 10,051.421 c. 13,492.249 d. 15,118.687 e. 14,381.746
Hilton Company has the following information related to a new project: Initial investment: $1,510,000; Fixed costs:...
Hilton Company has the following information related to a new project: Initial investment: $1,510,000; Fixed costs: $502,000; Variable costs: $12.60 per unit; Selling price: $34.70 per unit; Discount rate: 12 percent; Project life: 5 years; Tax rate: 25 percent. Fixed assets are depreciated using straight-line depreciation over the project's life. What is the financial break-even point?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT