How create a spreadsheet model for lp model problem

Assignment Help Business Management

Reference no: EM1349026

A trust officer at the Blacksburg National Bank needs to determine how to invest $The officer wants to invest at least 50% of the money in short term issues and no more than 50% in high risk issues. At least 30% of the funds should go in tax free investments and at least 40% of the total annual return should be tax free.

a. formulate an LP model for this problem.

b. create a spreadsheet model for the problem and solve it using solver.

c. What is the optimal solution?

Data:

Bond Annual Return Maturity Risk Tax Free

A 9.50% Long High Yes

B 8.00% Short Low Yes

C 9.00% Long Low No

D 9.00% Long High Yes

E 9.00% Short High No

Reference no: EM1349026

Questions Cloud

Introduction to personality theories : Synthesize the following personality theories: A. Sigmund Freud B. Carl Jung C. Alfred Adler D. Karen Horney

Forecasts the purchases from suppliers : Dynamic Futon forecasts the following purchases from suppliers:

Show why understanding readiness for change is important : Show why understanding readiness for change is important? List and discuss 3 ways you can determine readiness for change within an organization.

Question on standard price per kilogram : Misemer Corporation is developing standards for its products. One product requires an input that is purchased for $57.00 per kilogram from the supplier.

How create a spreadsheet model for lp model problem : How create a spreadsheet model for the problem and solve it using solver and What is the optimal solution?

What does the slope of the graph represent : Two narrow slits 50 micrometers apart are illuminated with light of wavelength 500 nm . What is an angle of the m=2 bright fringe in radians? in degrees.

Explain how would each nation benefit from trade : If Englad can produce either 15 units of corn or 30 sweaters in one unit of labor and Portugal can produce 10 units of corn and 5 sweater in one unit of labor as well, explain how would each nation benefit (numerically) from trade.

Up-to-the-minute information effective for medical industry : Up-to-the-minute information to clinicians in visually rich format to improve quality of patient care" do you believe this is the effective for medical industry to view this kind of information? Why or why not?

Spearman and thurstones theories of intelligence : Describe the main differences between Spearman and Thurstone's theories of intelligence. How do the hierarchical theories attempt to "bridge the gap" between these two theories?

User Account

All Pages