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

Other determinants of sample size- sampling decisions, Other  Determinants ...

Other  Determinants  of Sample Size 1. The variability  of elements  within the population  has become  a  very  important  factor  to decide the  sample  size.    The more  v

Scope, Scope of operation research?

Scope of operation research?

Linear programming, B A paper mill produces two grades of paper viz., X and...

B 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

Simplex method, Maximize Z =3x+4x subject to x1+x2 =3 2x1+3x2 =4 x1,x2 =0

Maximize Z =3x+4x subject to x1+x2 =3 2x1+3x2 =4 x1,x2 =0

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

LPP., A constraints in an LPP restricts? (Value of objective function,Value...

A constraints in an LPP restricts? (Value of objective function,Value of decision variable,Use of available resources, uncertainty of optimum value) please help me to find out righ

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

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

Mode of presentation - report writing presentation, Mode  of Presentation...

Mode  of Presentation A strategy  needs to be  chalked out for  a satisfactory  rendering of the  topic. The  man oeuvres are going  t vary  with a  change in the  manner  of

Graphs of time series, Graphs of Time Series A time  series  is a sequ...

Graphs of Time Series A time  series  is a sequence of values  corresponding  to successive points  of time. Time  series  are  graphed  with time  on the x axis  and the  oth

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