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

Classification of documents by information characteristics , Classification...

Classification of documents by information Characteristics: The schemes of classification advocated by Hanson and Grogan are mainly based on the information characteristics of

Explain what do you understand by dynamic programming, Question: (a) (i...

Question: (a) (i) Explain what do you understand by ‘Dynamic Programming'. (ii) Describe the dynamic programming approach to solve the shortest route problem. (iii) Outli

What are the functions of a store manager, Question 1 Explain Pre-Store op...

Question 1 Explain Pre-Store opening activities and State at least 10 pre-store opening activities that should be ideally carried out in a retail store? Question 2 What ar

Development of lp problems, A company manufactures 2 kinds of hats. Each ha...

A company manufactures 2 kinds of hats. Each hat of the I type needs twice as much as labour time as the II type. The company can manufacture a sum of 500 hats a day. The market re

Business Simulation Model, How much does cost for developing a simple model...

How much does cost for developing a simple model using Simuli 8 software and 2 pages write up (Explaining model). This is for my university assignment. For example last year assig

Modeling process, What are the basic 5 elements of modeling process

What are the basic 5 elements of modeling process

Question, Solve the following Linear Programming Problem using Simple metho...

Solve the following Linear Programming Problem using Simple method. Maximize Z= 3x1 + 2X2 Subject to the constraints: X1+ X2 = 4 X1 - X2 = 2 X1, X2 = 0

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

''qualitative generic research'', Use the following article on qualitative ...

Use the following article on qualitative approaches written by Kahlke (2014), http://ejournals.library.ualberta.ca/index.php/IJQM/article/viewFile/19590/16141/ to answer the fol

Decision Analysis, make a research project for modern day companies on how...

make a research project for modern day companies on how they can make decisions using decision analysis

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