Linear programming, Financial Problem, Operation Research

Assignment Help:
How do I set this problem up for Excel:
A National Credit Union has $250,000 available to invest in a 12 month commitment. The money can be placed in Treasury notes yielding an 8% return or in mubnicipal bonds at an average rate of return of 9%. Credit uniion regulations require diversification to the extent that at least 50% of the investiment be placed in Treasury notes. Because of defaults in other municipalities, it is decided that NO MORE than 40% of the investiment be placed in bonds. How much should the credit union invest in each security so as to maximize its return on investment?

Related Discussions:- Linear programming, Financial Problem

Linear Programming Problem, A paper mill produces two grades of paper viz. ...

A paper mill produces two grades of paper viz. , X and Y. Because of raw material restrictions, it cannot produce more than 400 tons of grade X paper and 300 tons of grade Y paper

Chi square test - hypothesis testing, Chi Square Test ( X 2 ) Chi Squ...

Chi Square Test ( X 2 ) Chi Square Test Defined  the chi square test is one  simplest  and most  commonly  used non parametric tests in statistical work. The Greek letter X 2

Operation research, Discuss the methodology of operation research

Discuss the methodology of operation research

Characteristics - probability distribution , Characteristics a. Discr...

Characteristics a. Discrete Distribution: Like  binomial  distribution it is  also a  discrete probability  i e,  occurrences can be  described  by a random  variable. b.

Dual of the lpp, the dual form of the following lpp min z=3x1+2.5x2 constra...

the dual form of the following lpp min z=3x1+2.5x2 constraints:2x1+4x2>=40, 3x1+2x2>=50 and x1,x2>=0

Introduction to probability distribution , Introduction to Probability Dist...

Introduction to Probability Distribution By  theoretical distribution we mean  a frequency distribution  which  is obtained  in relation to a random  variable by some  mathem

Lp model, A company produce three sizes of windows fans small,medium and la...

A company produce three sizes of windows fans small,medium and large. The manager has formulated an LP model for production.

Question, i need many good and important question of operation research obo...

i need many good and important question of operation research obout dinamic programing and non-liner programing and integer orograming ....for study! thank you

Techniques, explain the different techniques as operation research

explain the different techniques as operation research

Linear Programming, A paper mill produces two grades of paper viz., X and Y...

A paper mill produces two grades of paper viz., X and Y. Because of raw material restrictions, it cannot produce more than 400 tons of grade X paper and 300 tons of grade Y paper i

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd