Linear programming, Financial Problem, Operation Research

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

Maps, Maps, Atlases and Globes: Maps illustrate the distribution of ma...

Maps, Atlases and Globes: Maps illustrate the distribution of many things that occur on the surface of the earth. Information is presented by the use of a vast array of symbol

Inventory management, How do we determine EOQ?

How do we determine EOQ?

Z-test - hypothesis testing, Z-Test Prof. Fisher has given a method of...

Z-Test Prof. Fisher has given a method of testing the significance of the correlation coefficient in small samples. According to this method the coefficient of correlation

Sample survey methods:, Sample Survey Methods: If proposed investigati...

Sample Survey Methods: If proposed investigation is done only on a part taken out of universe then it will be known as sample survey. This part of the universe is kno

Duality, maximum 3x1+x2+x3-x4 subject to x1+5x2+3x3+4x4 x1+x2=-1 x3+x4

maximum 3x1+x2+x3-x4 subject to x1+5x2+3x3+4x4 x1+x2=-1 x3+x4

Banking operations, sir plz suggest me any book for this...or notes.....

sir plz suggest me any book for this...or notes.....

Deciles , DECILES The nine points on the scale of observations ( or...

DECILES The nine points on the scale of observations ( or values of the variable) which divide the total frequency into ten equal parts are called deciles for the data

Lpp, . A paper mill produces two grades of paper viz., X and Y. Because of...

. 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 pape

Deviation taken from assumed mean, Deviation Taken from Assumed Mean ...

Deviation Taken from Assumed Mean This methods is assorted when the arithmetic average is a fractional value. Taking deviation from fractional value would be a ver

Characteristics, correct answer

correct answer

Write Your Message!

Name

Email id

Message

Verfication Code

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!

Submit Assignment

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