Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This project must be completed in groups of at maximum of 4 students. Please list all group members' names in the files you submit. The
This project must be completed in groups of at maximum of 4 students. Please list all group members' names in the files you submit. The assignment can be done in groups of less than four. If there are 3 members in your group, do the first three questions. If 2 in your group, do the first two questions. If you are doing the assignment individually ask your instructor which question you are to submit. Late submissions will not be graded. Projects should be submitted in Blackboard ( Linear Programming Group Assignment link). You will submit two files per group: 1. One Word Document with a report outlining your recommendations for the issues listed in the case. The document should also include an appendix for each of the issues showing your algebraic equations and decisions, and a readable screen clip of your Excel output, including the Solver dialogue box (see parts a & b below). This is especially important to show how you used solver. 2. One Excel Spreadsheet with clearly labelled worksheets (one worksheet for each of the issues in the assignment). The work in the worksheets needs to be well organized and clearly labelled, with formulas used appropriately. Examples of potential formats can be found in chapter 16 in the text. The general approach for solving each of the issues should be: a. Formulate the linear programming model for the issue algebraically. Group this in three sections: 1) Definition of Decision Variables, 2) Objective Function Equation, 3) Constraints Equations. This should go in the appendix to your memo. (6 marks each issue) b. Set up and solve this problem using Excel. Include screenshots of this in the appendix to the memo or report. (6 marks each issue) c. Provide your answers and recommendations to the Manager of the company (include your recommendations for all issues in single report). (2 marks each issue). See basic structure of the report and memo on pages 5 & 6. d. General organization and formatting - 4 marks. Decision 2: Financial - Assets Investment Richelieu Specialty Paints has been quite successful and has $1,500,000 cash to be invested. Amanda and her management team have developed four potential investments in addition to leaving the cash in a low interest deposit. The four new opportunities are: 1. Purchase some shares of a major supplier (25% risk of total loss, 13% potential return) 2. Invest in the research and development of a new product (50% risk of total loss, 60% potential return) 3. Buy a selection of corporate bonds (10% risk of total loss, 6% potential return) 4. Buy a selection of government bonds (1% risk of total loss, 3% potential return) Leaving the money in a low interest deposit is virtually riskless and has a 0.5% potential return. Richelieu's father had provided Amanda with some guidelines for investment, aimed at diversification and risk management. These are: 1. Invest a maximum of 40% of the total cash in any one of the four new opportunities to ensure some risk control. 2. Invest at least $100,000 in each of the four new opportunities to ensure some diversity. 3. Limit the total potential loss, on average, to $250,000, based on the risk factors indicated. 4. Ensure the highest return possible. Recommend the appropriate mix of the four investments and note how much money, if any, should be left in the low interest deposit. Also, how would this mix change, and what would happen to potential return, if Amanda decided to take a more conservative approach and limit the total potential loss to $175,000. This project must be completed in groups of at maximum of 4 students. Please list all group members' names in the files you submit. The assignment can be done in groups of less than four. If there are 3 members in your group, do the first three questions. If 2 in your group, do the first two questions. If you are doing the assignment individually ask your instructor which question you are to submit. Late submissions will not be graded. Projects should be submitted in Blackboard ( Linear Programming Group Assignment link). You will submit two files per group: 1. One Word Document with a report outlining your recommendations for the issues listed in the case. The document should also include an appendix for each of the issues showing your algebraic equations and decisions, and a readable screen clip of your Excel output, including the Solver dialogue box (see parts a & b below). This is especially important to show how you used solver. 2. One Excel Spreadsheet with clearly labelled worksheets (one worksheet for each of the issues in the assignment). The work in the worksheets needs to be well organized and clearly labelled, with formulas used appropriately. Examples of potential formats can be found in chapter 16 in the text. The general approach for solving each of the issues should be: a. Formulate the linear programming model for the issue algebraically. Group this in three sections: 1) Definition of Decision Variables, 2) Objective Function Equation, 3) Constraints Equations. This should go in the appendix to your memo. (6 marks each issue) b. Set up and solve this problem using Excel. Include screenshots of this in the appendix to the memo or report. (6 marks each issue) c. Provide your answers and recommendations to the Manager of the company (include your recommendations for all issues in single report). (2 marks each issue). See basic structure of the report and memo on pages 5 & 6. d. General organization and formatting - 4 marks. Decision 2: Financial - Assets Investment Richelieu Specialty Paints has been quite successful and has $1,500,000 cash to be invested. Amanda and her management team have developed four potential investments in addition to leaving the cash in a low interest deposit. The four new opportunities are: 1. Purchase some shares of a major supplier (25% risk of total loss, 13% potential return) 2. Invest in the research and development of a new product (50% risk of total loss, 60% potential return) 3. Buy a selection of corporate bonds (10% risk of total loss, 6% potential return) 4. Buy a selection of government bonds (1% risk of total loss, 3% potential return) Leaving the money in a low interest deposit is virtually riskless and has a 0.5% potential return. Richelieu's father had provided Amanda with some guidelines for investment, aimed at diversification and risk management. These are: 1. Invest a maximum of 40% of the total cash in any one of the four new opportunities to ensure some risk control. 2. Invest at least $100,000 in each of the four new opportunities to ensure some diversity. 3. Limit the total potential loss, on average, to $250,000, based on the risk factors indicated. 4. Ensure the highest return possible. Recommend the appropriate mix of the four investments and note how much money, if any, should be left in the low interest deposit. Also, how would this mix change, and what would happen to potential return, if Amanda decided to take a more conservative approach and limit the total potential loss to $175,000
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started