- Athe Level 3 Health and Social Care Assessment Questions
- M/618/4168 Unit 2 Principles, Values and Regulation in the Health and Social Care Sector – ATHE Level 3
- ILM Communication Skills Self-Assessment
- ILM Unit 8600-309: Understand How to Establish an Effective Team
- CMI Unit 525 Using Reflective Practice to Inform Personal and Professional Development
- Understand and Work with a Wide Range of Stakeholders and Organisational Structures – Assignment 1
- Assessment: Financial Performance Evaluation of Savory Snacks Company Ltd for Credit
- CMI L5 Assignment: Managing Stakeholder Relationships: Strategies, Challenges, and Best Practices
- Level 3 Unit 2 Assignment: Principles, Values and Regulation in the Health and Social Care Sector
- COM4006 Assignment: Introduction to Academic Skills and Professional Development
- Assessment: Managing Organisational Change: Evaluating Strategies, Challenges, and Impact
- UNIT CMI 706 Assignment: Finance for Strategic Leaders: The Role, Scope, and Impact of Finance
- ENGINEERING DESIGN TMA2 v1: CAD Design Report: Specification, Evaluation & Drawings
- Unit CMI 514 Assignment: Analysis of Organisational Change: Managing Change
- EMS402U TMA1: Engineering Design Solutions: Concept Development & Assessment
- LEVEL 3 UNIT 31: Effective Project Management (International BTEC )
- ILM Level 4 ASSIGNMENT: Managing equality and diversity in own area
- CMI 504 Assessment: The Rationale For Managing Performance Within Organisations
- Level 7 Unit 03 Assignment: Leading a Strategic Management and Leadership
- LO:01, LO:02 (MSCCO01) Managing Innovation and Change in Computing
BB5112: The Providential Insurance Company has developed a list of seven investment alternatives, with corresponding financial factors: Business Decision Modelling Assignment, KUL, UK
University | Kingston University London (KUL) |
Subject | BB5112: Business Decision Modelling |
The Providential Insurance Company has developed a list of seven investment alternatives, with corresponding financial factors, for a 10-year investment horizon. These investments and their corresponding financial factors are presented in the following table. With this table, the meaning of the various financial factors is as follows:
- The length of investment – the expected number of years required for the annual rate of return to be realized, taking into account the possibility of reinvestment;
- The annual rate of return – the expected rate of return over the 10-year investment horizon;
- The risk coefficient – a subjective, dimensionless estimate representing the portfolio manager’s appraisal of the relative safety of each alternative, based on an ordinal scale of 10;
- The growth potential– a subjective estimate representing the portfolio manager’s appraisal of the potential increase in the value of the investment alternative for the 10-year period.
The Providential Insurance Company seeks to maximize the return on its portfolio of investments, subject to the following restrictions on the selection of the portfolio:
- The average length of the investment for the portfolio should not exceed 7 years
- The average risk for the portfolio should not exceed 5
- The average growth potential for the portfolio should be at least 10%
- At least 10% of all available funds must be retained in the form of cash at all times in order to maintain working capital liquidity
- The proportions of funds invested in the various alternatives must sum to 1.0.
Are You Looking for Answer of This Assignment or Essay
Task
- Using clear notation, Identify the decision variables for this problem.
- Use these decision variables to formulate the firm’s objective function, clearly stating what the objective is.
- Use the information in Tables 1 and 2 above to identify the constraints for this problem.
- Using what you have identified in 1-3 above formulate and present the complete linear programming model for this problem.
- Enter the linear programming model you have derived in 4 above into Solver to obtain the optimal solution to the problem.
- Extract the optimal solution from Solver and state the value of the objective function, and the values of the decision variables then summarise the results, making clear the contribution to the Total Rate of Return made by each investment alternative.
- Using Solver extract a Sensitivity Report for the problem.
- From the Sensitivity Report extract the slack and surplus variables and interpret their meaning.
- Using the results of the Sensitivity Report indicates whether the optimal solution to the problem is unique or if there are alternative optimal solutions.
- Present a brief interpretation of the ranging information on the objective function coefficients presented in the Sensitivity Report for this problem.
- Identify the shadow prices from the Sensitivity Report and interpret their meaning.
- Using the shadow price on the average length of investment indicates the impact on the objective function of increasing the length by 1 year. What is the upper limit of the availability of component 1 for which this shadow price is valid?
- What would be the impact of increasing the liquidity requirement by 1 percent?
Do You Need Assignment of This Question
Excel in the field of business decision modelling with Diploma Assignment Help UK. Our expert team provides comprehensive assistance and support in understanding and applying business decision modelling techniques. Learn to analyze data, make informed decisions, and optimize business outcomes. Contact us now for high-quality solutions tailored to your BB5112 assignments.