{br} STUCK with your assignment? {br} When is it due? {br} Get FREE assistance. Page Title: {title}{br} Page URL: {url}
UK: +44 748 007-0908, USA: +1 917 810-5386 [email protected]

Linear Programming

Project description
The question:

You are an Independent Financial Advisor providing expert advice to individuals on request. A client has 150,000 which he wishes to invest in income-generating securities and government bonds so as to maximise his annual return. He has selected five possible investments, all of which he considers to have reasonably high yields and stability:

Oil company A stock, paying 9 % annual dividend.
Oil company B stock, paying 7.7% annual dividend.
Electric utility A stock, paying 5% annual dividend.
Electric utility B stock, paying 6.2% annual dividend.
Government bonds, paying 5.5 % annual interest.

Since he has no plans to sell his stock in the near future, he is not concerned with their selling price. Based on the various risk levels involved, he has made the following decisions:

The total investment in oil stocks may not exceed 32,000.
The total investment in electric utilities may not exceed 60,000.
The investment in oil company A may not exceed 28,000.
The total investment in electric utility A may not exceed 35,000.
The total investment in oil stocks may not exceed the total investment in electric utilities.
The investment in oil company A and electric utility A combined may not exceed the investment in Government bonds.

As the clients financial adviser you should advise him of the amount of money he should invest in the various investments in order to maximise his annual return.

1. Formulate the problem clearly defining the variables, the objective function and the constraints.
2.Solve the problem by linear programming using an Excel spreadsheet model, remembering that the Client’s objective is to maximise total annual income. State the optimal investments plan clearly, giving the values of all the problem variables. Include a copy of your spreadsheet, making sure that the layout of the spreadsheet is easy to follow and is carefully annotated. The layout should be your own design.
3. Produce an Excel Sensitivity Report

( I have done questions 1-3 which I shall attach as a word document and excel document, I would just need for the person to check to confirm that I am right and/or make any changes).
What I need help with is the last bit of the work:

4. Give an interpretation of the values in the Variables and Constraints tables of the report. Give three examples to test the sensitivity ranges given in Excel report by changing the original problem values. Each example should consider changing only one factor (i.e., variable or constraint). State why you have chosen the particular factors that you used and include copies of any appropriate Excel output and explain your answers and conclusions.

5.For the final part of your report, in your capacity as an Independent Financial Advisor, you should present a memorandum to your client. Describe your main conclusions to him in simple, non-technical English; i.e. do not use technical terms like variable, objective function or dual price. Dont worry about repeating some or all of the points that you have already made in answer to earlier questions. The aim is to communicate your conclusions clearly to someone who is knowledgeable about the practice of investment planning, but who knows nothing about the subject of linear programming. You may use tables and charts if you wish.

Microsoft Excel 14.4 Sensitivity Report
Worksheet: [Workbook3]Sheet1
Report Created: 19/12/2014 21:44:38

Variable Cells
Final    Reduced    Objective    Allowable    Allowable
Cell    Name    Value    Cost    Coefficient    Increase    Decrease
$B$14    CONSTRAINTS X1    28000    0    0.09    1E+30    0.013
$C$14    CONSTRAINTS X2    4000    0    0.077    0.013    0.022
$D$14    CONSTRAINTS Y1    0    -0.012    0.05    0.012    1E+30
$E$14    CONSTRAINTS Y2    60000    0    0.062    1E+30    0.007
$F$14    CONSTRAINTS Z1    58000    0    0.055    0.007    0.055

Constraints
Final    Shadow    Constraint    Allowable    Allowable
Cell    Name    Value    Price    R.H. Side    Increase    Decrease
$G$15    X1 + X2 + Y1 + Y2 + Z1 <= 150000 USED    150000    0.055    0    1E+30    30000 $G$16    X1 + X2 <= 32000 USED    32000    0.022    0    28000    4000 $G$17    Y1 + Y2 <= 60000 USED    60000    0.007    0    30000    28000 $G$18    X1 <= 28000 USED    28000    0.013    0    4000    28000 $G$19    Y1 <= 35000 USED    0    0    0    1E+30    35000 $G$20    X1 + X2 <= Y1 + Y2 USED    32000    0    0    1E+30    28000 $G$21    X1 + Y1 <= Z1  USED    28000    0    0    1E+30    30000 MA5051Project Management Group ZInterim Report Part 2 Linear Programming Formulation Problem Variables: Let X1 be the amount invested in the oil company A stock Let X2 be the amount invested in the oil company B stock Let Y1 be the amount invested in the electric utility A stock Let Y2 be the amount invested in the electric utility B stock Let Z1 be the amount invested in Government Bonds Constraints: X1 + X2 + Y1 + Y2 + Z1 = £150000 X1 + X2 = £32000           maximum invested in oil stock Y1 + Y2 = £60000           maximum invested in electric utilities X1 = £28000                   maximum invested in oil company stock A Y1 = £35000                   maximum invested in electric utility stock A X1 + X2 = Y1 + Y2    investment in oil stock may not exceed investment in electric utilities X1 + Y1 = Z1  investment in oil stock A and electric utility stock A combined may not exceed investment in government bonds X1, X2, Y1, Y2, Z1 = 0 Objective Function: Maximise total profit: P ? Max P = 0.09X1 + 0.077X2 + 0.05Y1 + 0.062Y2 + 0.055Z1 PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT :)

Sample Answer

Compelling correspondence is essential to the achievement all things considered but since of the changing idea of the present working environments, successful correspondence turns out to be more troublesome, and because of the numerous impediments that will permit beneficiaries to acknowledge the plan of the sender It is restricted. Misguided judgments.In spite of the fact that correspondence inside the association is rarely completely open, numerous straightforward arrangements can be executed to advance the effect of these hindrances.

Concerning specific contextual analysis, two significant correspondence standards, correspondence channel determination and commotion are self-evident. This course presents the standards of correspondence, the act of general correspondence, and different speculations to all the more likely comprehend the correspondence exchanges experienced in regular daily existence. The standards and practices that you learn in this course give the premise to additionally learning and correspondence.

This course starts with an outline of the correspondence cycle, the method of reasoning and hypothesis. In resulting modules of the course, we will look at explicit use of relational connections in close to home and expert life. These incorporate relational correspondence, bunch correspondence and dynamic, authoritative correspondence in the work environment or relational correspondence. Rule of Business Communication In request to make correspondence viable, it is important to follow a few rules and standards. Seven of them are fundamental and applicable, and these are clear, finished, brief, obliging, right, thought to be, concrete. These standards are frequently called 7C for business correspondence. The subtleties of these correspondence standards are examined underneath: Politeness Principle: When conveying, we should build up a cordial relationship with every individual who sends data to us.

To be inviting and polite is indistinguishable, and politeness requires an insightful and amicable activity against others. Axioms are notable that gracious “pay of graciousness is the main thing to win everything”. Correspondence staff ought to consistently remember this. The accompanying standards may assist with improving courtesy:Preliminary considering correspondence with family All glad families have the mystery of progress. This achievement originates from a strong establishment of closeness and closeness. Indeed, through private correspondence these cozy family connections become all the more intently. Correspondence is the foundation of different affiliations, building solid partners of obedient devotion, improving family way of life, and assisting with accomplishing satisfaction (Gosche, p. 1). In any case, so as to keep up an amicable relationship, a few families experienced tumultuous encounters. Correspondence in the family is an intricate and alluring marvel. Correspondence between families isn’t restricted to single messages between families or verbal correspondence.

It is a unique cycle that oversees force, closeness and limits, cohesiveness and flexibility of route frameworks, and makes pictures, topics, stories, ceremonies, rules, jobs, making implications, making a feeling of family life An intelligent cycle that makes a model. This model has passed ages. Notwithstanding the view as a family and family automatic framework, one of the greatest exploration establishments in between family correspondence centers around a family correspondence model. Family correspondence model (FCP) hypothesis clarifies why families impart in their own specific manner dependent on one another ‘s psychological direction. Early FCP research established in media research is keen on how families handle broad communications data. Family correspondence was perceived as an exceptional scholastic exploration field by the National Communications Association in 1989. Family correspondence researchers were at first impacted by family research, social brain science, and relational hypothesis, before long built up the hypothesis and began research in a family framework zeroed in on a significant job. Until 2001, the primary issue of the Family Communication Research Journal, Family Communication Magazine, was given. Family correspondence is more than the field of correspondence analysts in the family. Examination on family correspondence is normally done by individuals in brain science, humanism, and family research, to give some examples models. However, as the popular family correspondence researcher Leslie Baxter stated, it is the focal point of this intelligent semantic creation measure making the grant of family correspondence special. In the field of in-home correspondence, correspondence is normally not founded on autonomous messages from one sender to one beneficiary, yet dependent on the dynamic interdependency of data shared among families It is conceptualized. The focal point of this methodology is on the shared trait of semantic development inside family frameworks. As such, producing doesn’t happen in vacuum, however it happens in a wide scope of ages and social exchange.

Standards are rules end up being followed when performing work to agree to a given objective. Hierarchical achievement relies significantly upon compelling correspondence. So as to successfully impart, it is important to follow a few standards and rules. Coming up next are rules to guarantee powerful correspondence: clearness: lucidity of data is a significant guideline of correspondence. For beneficiaries to know the message plainly, the messages ought to be sorted out in a basic language. To guarantee that beneficiaries can without much of a stretch comprehend the importance of the message, the sender needs to impart unmistakably and unhesitatingly so the beneficiary can plainly and unquestionably comprehend the data.>

Our customer support team is here to answer your questions. Ask us anything!