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

MBA, #q.2 Q.2 Six Operators are to be assigned to five jobs with the cost o...

#q.2 Q.2 Six Operators are to be assigned to five jobs with the cost of assignment in Rs. given in the matrix below. Determine the optimal assignment. Which operator will have no a

Objectives of measuring dispersion - measure of dispersion, Objectives of M...

Objectives of Measuring Dispersion a. To judge the Reliability of Measures of Central Tendency: Measure of dispersion is the only means to test the representative charac

Some guidelines for bibliography entries , Some Guidelines for Bibliograp...

Some Guidelines for Bibliography Entries 1. Reference of a Back by One Authors : Mention authors name book title ( in italics hence to be underlined) city publication

Regression, Regression line drawn as Y=C+1075x, when x was 2, and y was 239...

Regression line drawn as Y=C+1075x, when x was 2, and y was 239, given that y intercept was 11. calculate the residual

One sample sign test - hypothesis testing , One Sample sign Test In...

One Sample sign Test In a one sample test the null hypothesis μ = μ 0 against an appropriate alternative on the basis of a random sample of size n we replace each sam

Trade literature - classification of documents, Trade Literature: Trad...

Trade Literature: Trade literature consists of documents that give information on the processes and materials involved in the manufacture of a product, various types of produc

Examine the future sustainability of business, In your role as a Consultant...

In your role as a Consultant to a renowned organisation or institution, you have been asked to design and submit a research proposal to examine the future sustainability of its bus

Purchasing, need of detailed information about the topic

need of detailed information about the topic

Maths, Maxz=3x1-2x2 St x1-x2 >_0, 3x1-x2 _0

Maxz=3x1-2x2 St x1-x2 >_0, 3x1-x2 _0

Two person zero sum game, definatins and example

definatins and example

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