Reference no: EM132202607
Supply Chain Finance is a new and important field. Lets say you just got hired as a SCM analyst tasked with a finance initiative. You have to select a portfolio pakage from a set of alternative investments. Your goals are to:
Maximization of the expected return or minimzation of the risk
Not exceeding the avilable capital
Managing the compan's (risk) policy
Consider the duration of investments' economic life, potential growth rate, danger, liquidity
You have been given the following expected return information:
Investment Expected annual return rate (%)
Share A - manufacturing sector 15.4
Share B - manufacturing sector 19.2
Share C - food and beverage sector 18.7
Share D - food and beverage sector 13.5
Mutual fund E 17.8
Mutual fund Z 16.3
You also have the following requirements:
Total amount of capital = $90,000
Amount in shares of a sector no larger than 50% of total available
Amount in shares with the larger return of a sector less or equal to 80% of sector's total amount
Amount in manufacturing company B less or equal to 10% of the whole share amount
Amount in mutual funds less or equal to 25% of the amount in manufacturing share
Therefore, you must:
a. Formulate the problem, complete with the objective function and appropriate constraints and be sure to clearly label you devision variables.
b. Solve this problem in excel with solver
c. Write a few sentences describing wat the results say, in plain language.