# Linear Programming and Its Application Techniques in Optimizing Portfolio Selection of a Firm

Authors: N. K. Oladejo; A. Abolarinwa; S. O. Salawu
Journal: Journal of Applied Mathematics
 (2020)

---

## Abstract

Optimization techniques have been used in this paper to obtain an optimal investment in a selected portfolio that gives maximum returns with minimal inputs based on the secondary data supplied by a particular firm that is examined. Sensitivity analysis is done to ascertain the robustness of the resulting model towards the changes in input parameters to determine a redundant constraint using linear programming. The challenge of determining the available funds and allocating each component of the portfolio to maximize returns and minimize inputs by portfolio holders and managers who are the major decision-makers in allocating their resources cannot be quantified. This optimization technique is used to obtain an optimal investment portfolio including financial risks of a firm with disposable of $15,000,000.00 invested in crude oil, mortgage securities, cash crop, certificate of deposit, fixed deposit, treasury bills, and construction loans. The model is a single-objective model that maximizes the return on the portfolio as the interests on the original data reduces by 5%; then, the return on investments also reduced by almost 15%, with the quantum of money on treasury bills and construction loans posing a significant reduction for the maximum return. The investment in the other options saw a slight decrease. Also, as the interest rates of the original data increase by 5%, the return on investments also grows by almost 17% while the quantum of money on the treasury bills and construction loans increases, and the quantum of money on the other options experienced a decrease except for mortgage securities which recorded a slight increase.


---

## Body

## 1. Introduction

A portfolio is an individual or corporate investment that can be managed by financial professionals or financial institutions, such a portfolio may include financial assets, stocks, bonds, and cash held and/or managed by an individual investor. It is designed according to the investor’s risk tolerance, time frame, and investment objectives. Papahristodoulou and Dotzauer [1] defined and discussed optimal as the best or most favorable among a set of alternatives and defined the optimal portfolio as the portfolio that considers the investor’s own “greed” and risk aversion. The challenge of portfolio optimization is an important aspect in investment and finance, and this may affect portfolio holders and managers who are the major decision-makers in allocating their resources across different categories. Protection against the risks related to everyday life is indispensable to every human being to enjoy some level of peace of mind. Therefore, this paper wishes to determine the availability of funds to be allocated to each component of the portfolio in order to maximize returns on the portfolio and to determine optimally the possible levels of investment in the selected portfolios of the firm under discussion. An emphasis on return maximization is considered and addresses the areas of investment, the investment constraints of the firm, and the levels of investments to maximize returns.


## 2. Literature Review

Meng and Yang [2] discussed various linear programming applications and techniques. The authors reported that aggregate production planning is the most important aspect of linear programming analysis. Young [3] emphasized that the optimization process adopted mathematical techniques to generate programs for training timetables and schedules for military application as was developed in the 1940s by George Dantzig. Markowitz [4] discussed the financial research and investment aspect of the portfolio optimization problem as one of the standard and most important aspects of portfolio management. An elegant way of managing risk in financial markets known as the portfolio theory was introduced in the study. Konno and Yamazaki [5] discussed Markowitz’s model and assessed it as a single-period model where the investor’s main objective was to maximize the portfolio’s expected return. William [6] introduced and discussed the Capital Asset Pricing Model (CAPM) based upon the empirical observation that gives the maximum expected return. The author compared and analyzed Markowitz’s model to develop a simplified variant that reduces data and computational requirements. Such an empirical fact was analyzed, discussed, and supported by William [7].Also, Ogryczak [8] discussed and analyzed the procedures and guidelines of setting investment policy. An asset allocation model was proposed and developed where the expected return for an asset class will be estimated using the simplex algorithm as an application of linear programming. Kostreva and Ogryczak [9] discussed and explained tracking through a benchmark by the portfolio manager to minimize the bound constraint sets from the volatility of the portfolio return. It was mentioned that if the benchmark is volatilized, then the volatility is bounded and most studies will focus on the price efficiency of equity markets. Marcus [10] presented and analyzed price efficiency as a market where all available information that is relevant to the valuation of securities at all times is fully reflected by the price. Olayinka et al. [11] examined and applied linear programming techniques in the entrepreneur decision-making process to maximize profits with the available resources through a fast-food firm with the challenges of product selection and profit maximization due to an increase in the price of raw materials. Oladejo et al. [12] considered the importance of optimization principles in maximized profits and minimized cost of production and applied linear programming techniques in solving a particular challenge in a bakery production firm using the AMPL software.Thus, in this paper, we examine the level of investment in a selected portfolio that gives maximum returns with minimal input based on the secondary data supplied by a particular firm, which were used as the parameters for the proposed linear programming model. This study has not been previously examined, and it has created gaps in portfolio management and optimization of a firm. The study is motivated by the earlier reports on the portfolio optimization and risk management of firms. A sensitivity analysis to ascertain the robustness of the resulting model towards the changes in input parameters to determine how redundant a constraint was for linear programming is carried out. The availability of funds and the allocation of each component of the portfolio to maximize returns and minimize inputs by portfolio holders and managers who are the major decision-makers in allocating their resources were also determined following Olayinka et al.’s [11] and Oladejo et al.’s [12] linear programming techniques.


## 3. Formulation of the Linear Programming (LP) Model

The following general LP model was considered:(1)Optimize:fx,Subjectto:gix≤bi,1≤i≤pgix=bi,p+1≤i≤kg1x≥bi,k+1≤i≤n,where fx is the objective function of a vector variable. x=x1,x2,⋯,xnT represents the measure of effectiveness of a decision. gix1≤i≤m is the constraint function of x. The variable xjj=1,2,⋯,n is the activity level associated with the decision-making problem. The term bi1≤i≤m represents the upper or lower limit of the ith constraint functions. Constraint x≥0 restricts the decision variables xjj=1,2,⋯,n to nonnegative real numbers.Since the objective and constraint functions are linear, they are precisely defined in the form(2)fx=c1x1+c2x2+⋯+cnxn=∑j=1ncjxj,(3)gix=ai1x1+⋯+ainxn=∑j=1naijxj.From (2) and (3), we then write the linear programming as
(4)Optimize:Z=∑j=1ncjxj,(5)Subjectto:∑j=1naijxj,1≤i≤p∑j=1maijxj,p+1≤i≤k∑j=1naijxj,k+1≤i≤mxj≥0,1≤j≤n.,where aij and cj are called technological and cost coefficients, respectively. bi is the main parameters of the models.Equations (4) and (5) can be expressed in the forms of the matrix:
(6)Optimize:Z=CTx,Subjectto:Ax≤bx≥0C=c1,c2,⋯,cnT,where K is a feasible set standard LP while K=x∈Rn:Ax=b,x≥0. If x∈K or if x satisfies Ax=b and x≥0, then x is a feasible solution. Let CTx be the objective function of a LP to be optimized. x∈K is an optimal solution if for all y∈K, CTx>CTy. Let x be a basic solution of Ax=b. If x≥0, then it is called a basic feasible solution (BFS). An artificial variable Ai≥0 is a dummy variable added for the specific purpose of generating an initial basic feasible solution. It has no economic meaning.Thus,(7)A=a11a12a13⋯⋯a1na21a22a23⋯⋯a2n⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯⋯an1an2an3⋯⋯amn,b=b1,b2,b3,⋯,bmT.


## 4. Materials and Methods

In this study, a firm with more than one investment opportunity or how much of its capital should be channeled into each investment opportunity to maximize profits is considered. The firm is also facing constraints on the availability of the inputs to be used in its investment activities and management policies.The firm under consideration has, at its disposal, fifteen million dollars ($15,000,000.00) for the period considered to invest among seven (7) investment options with the aim of maximizing returns. After identifying the preferred areas of investment, the distribution of available funds among each investment area to derive the maximum return under an acceptable level of risk becomes a major challenge. The decision for the distribution of funds to the various investments should not be done arbitrarily, since there is no guarantee of achieving the goal of maximum return. A scientific approach to the problem therefore is the best way forward. The firm, according to its own records, does not adopt any scientific procedure for its investment decision-making and thus is not able to tell whether it has been making the desired return on its investments or not over the past years. The decision to go scientific for the period under consideration was informed by the changing trends in the world of business.Table1 shows the summary of the investment options identified by the firm to invest the available funds to achieve its aim. These are fixed deposit, treasury bills, crude oil, mortgage, construction, cashew nuts, and Forex trading.Table 1
Investment areas, interest rates, and risk scores.
InvestmentInterest rate (%)Risk score (%)Fixed deposit10.01.7Treasury bills20.52.5Crude oil20.01.5Mortgage8.01.9Construction28.52.9Cashew nuts18.51.5Forex trading9.52.2


### 4.1. Evaluation of Investment Risk

The level of risk (i.e., risk score) associated with each investment is obtained by taking the average return (in percentage) over at least the past five (5) years. The mean (average) of the returns on the investment for the period considered is calculated, the sum of the squares of the deviations is divided by the number of years considered minus one, and the square root of the result is taken.


### 4.2. Constraints of the Linear Programming Problem

The following six (6) constraints associated with the linear programming problem are considered:(1)
Invest up to $15M in the entire investment options. The firm is constrained not to go beyond investing $15M in the entire seven investment areas identified. However, investing less than $15M is allowed. Thus, at the end of distributing the available funds among the seven investments, the total distribution should not exceed $15M(2)
Not more than 20% of the total investment in any one investment area. Investment in any one of the seven investment areas should not exceed 20% of the total investment. Thus, the quantum of money that is supposed to go into any one of the seven investments can be less than 20% of the total money for entire investments (i.e., ≤20% of $15,000,000.00)(3)
At least 25% of the total investment in deposits. The firm is not allowed to commit less than 25% of the total amount of money into deposits (i.e., fixed deposit and crude oil). Hence, the firm is to commit not less than 25% of $15M into fixed deposit and Forex trading(4)
At least 30% of the total investment in cash crops. The firm is not allowed to commit less than 30% of the total amount of money into cash crops (cashew nuts). Hence, the firm is to commit not less than 30% of $15M for cashew nuts(5)
At least 45% of the total investment in treasury bills and construction loans. The firm is not allowed to commit less than 45% of the total amount of money into treasury bills and construction loans. Hence, the firm is to commit not less than 45% of $15M into treasury bills and construction loans(6)
The overall risk should not be more than 2.0% of the portfolio risk, calculated using the weighted average, which should be equal to or less than 2.0%. Short-term treasury bills (six months) are risk-free, while long-term treasury bills (more than six months) are risky when the prime rates are reviewed upwards


### 4.3. Modeling the Problem as LP

Here, the formulation of the model by defining the decision variables, the objective and constraint functions are presented. Let the following be the decision parameters:(i)
xA be the amount to invest in fixed deposit(ii)
xB be the amount to invest in treasury bills(iii)
xC be the amount to invest in crude oil(iv)
xD be the amount to invest in mortgage(v)
xE be the amount to invest in construction(vi)
xF be the amount to invest in cash crop(vii)
xG be the amount to invest in Forex tradingThe objective function in terms of the decision variables is as follows:(8)Maximize:Z=0.1xA+0.205xB+0.2xC+1xD+0.3xE+0.2xF+0.095xG,Individual constraints identified are expressed quantitatively as follows:LetY=xA+xB+xC+xD+xE+xF+xG:
(a)
For an investment of $15M, thenY≤15M(b)
Not more than 20% of the total investment in a particular investmentThus,xA≤0.2Y, xB≤0.2Y, xC≤0.2Y, xD≤0.2Y, xE≤0.2Y, xF≤0.2Y, and xG≤0.2Y.This implies(9)xA=xB=xC=xD=xE=xF=xG≤0.2Y,which can be equivalently expressed as follows:
(10)0.24xA–xB–xC–xD–xE–xF–xG≤0,0.2xA–4xB+xC+xD+xE+xF+xG≥0,0.2xA+xB–4xC+xD+xE+xF+xG≥0,0.2xA+xB+xC–4xD+xE+xF+xG≥0,0.2xA+xB+xC+xD–4xE+xF+xG≥0,0.2xA+xB+xC+xD+xE–4xF+xG≥0,0.2xA+xB+xC+xD+xE+xF–4xG≥0.(c)
At least 25% of the total investment into deposits,xA+xG/xA+xB+xC+xD+xE+xF+xG≥0.25(11)xA+xG≥0.3xA+xB+xC+xD+xE+xF+xG~0.8xA–0.3xB–0.3xC–0.3xD–0.3xE−0.3xF+0.8xG≥0.(d)
At least 30% of the total investment to cash crops,xC+xF/xA+xB+xC+xD+xE+xF+xG≥0.3(12)xC+xF≥0.3xA+xB+xC+xD+xE+xF+xG~0.3xA+0.3xB+0.7xC+0.3xD+0.3xE+0.7xF+0.3xG≤0.(e)
At least 45% of the total investment in treasury bills and construction loans,xB+xE/xA+xB+xC+xD+xE+xF+xG≥0.5(13)xB+xE≥0.5xA+xB+xC+xD+xE+xF+xG~0.5xA+0.5xB+0.5xC+0.5xD–0.5xE+0.5xF+0.5xG≤0.(f)
Overall risk limited to not more than 2.0 (using a weighted average to calculate portfolio risk),1.7xA+2.5xB+1.5xC+1.9xD+2.9xE+1.5F+2.2xG/xA+xB+xC+xD+xE+xF+xG≤2.0(14)1.7xA+2.5xB+1.5xC+1.9xD+2.9xE+1.5xF+2.2xG≤2xA+xB+xC+xD+xE+xF+xG~0.3xA–0.5xB+0.5xC+0.1xD–0.9xE+0.5xF–0.2xG≥0.(g)
Nonnegativity of decision variablesxA,xB,xC,xD,xE,xF,xG≥0These are then transformed into the linear program model as follows:Maximize:(15)Z=0.1xA+0.2xB+0.2xC+0.1xD+0.3xE+0.2xF+0.1xG,Subject to:(16)xA+xB+xC+xD+xE+xF+xG≤15M,0.24xA–xB–xC–xD–xE–xF–xG≤0,0.2xA–4xB+xC+xD+xE+xF+xG≥0,0.2xA+xB–4xC+xD+xE+xF+xG≥0,0.2xA+xB+xC–4xD+xE+xF+xG≥0,0.2xA+xB+xC+xD–4xE+xF+xG≥0,0.2xA+xB+xC+xD+xE–4xF+xG≥0,0.2xA+xB+xC+xD+xE+xF–4xG≥0,0.8xA–0.3xB–0.3xC–0.3xD−0.3xE−0.3xF+0.8xG≥0,0.3xA+0.3xB–0.7xC+0.3xD+0.3xE–0.7xF+0.3xG≤0,0.5xA–0.6xB+0.5xC+0.5xD–0.5xE+0.5xF+0.5xG≤0,0.3xA–0.5xB+0.5xC+0.1xD–0.9xE+0.5xF–0.2xG≥0,xA,xB,xC,xD,xE,xF,xG≥0.


## 4.1. Evaluation of Investment Risk

The level of risk (i.e., risk score) associated with each investment is obtained by taking the average return (in percentage) over at least the past five (5) years. The mean (average) of the returns on the investment for the period considered is calculated, the sum of the squares of the deviations is divided by the number of years considered minus one, and the square root of the result is taken.


## 4.2. Constraints of the Linear Programming Problem

The following six (6) constraints associated with the linear programming problem are considered:(1)
Invest up to $15M in the entire investment options. The firm is constrained not to go beyond investing $15M in the entire seven investment areas identified. However, investing less than $15M is allowed. Thus, at the end of distributing the available funds among the seven investments, the total distribution should not exceed $15M(2)
Not more than 20% of the total investment in any one investment area. Investment in any one of the seven investment areas should not exceed 20% of the total investment. Thus, the quantum of money that is supposed to go into any one of the seven investments can be less than 20% of the total money for entire investments (i.e., ≤20% of $15,000,000.00)(3)
At least 25% of the total investment in deposits. The firm is not allowed to commit less than 25% of the total amount of money into deposits (i.e., fixed deposit and crude oil). Hence, the firm is to commit not less than 25% of $15M into fixed deposit and Forex trading(4)
At least 30% of the total investment in cash crops. The firm is not allowed to commit less than 30% of the total amount of money into cash crops (cashew nuts). Hence, the firm is to commit not less than 30% of $15M for cashew nuts(5)
At least 45% of the total investment in treasury bills and construction loans. The firm is not allowed to commit less than 45% of the total amount of money into treasury bills and construction loans. Hence, the firm is to commit not less than 45% of $15M into treasury bills and construction loans(6)
The overall risk should not be more than 2.0% of the portfolio risk, calculated using the weighted average, which should be equal to or less than 2.0%. Short-term treasury bills (six months) are risk-free, while long-term treasury bills (more than six months) are risky when the prime rates are reviewed upwards


## 4.3. Modeling the Problem as LP

Here, the formulation of the model by defining the decision variables, the objective and constraint functions are presented. Let the following be the decision parameters:(i)
xA be the amount to invest in fixed deposit(ii)
xB be the amount to invest in treasury bills(iii)
xC be the amount to invest in crude oil(iv)
xD be the amount to invest in mortgage(v)
xE be the amount to invest in construction(vi)
xF be the amount to invest in cash crop(vii)
xG be the amount to invest in Forex tradingThe objective function in terms of the decision variables is as follows:(8)Maximize:Z=0.1xA+0.205xB+0.2xC+1xD+0.3xE+0.2xF+0.095xG,Individual constraints identified are expressed quantitatively as follows:LetY=xA+xB+xC+xD+xE+xF+xG:
(a)
For an investment of $15M, thenY≤15M(b)
Not more than 20% of the total investment in a particular investmentThus,xA≤0.2Y, xB≤0.2Y, xC≤0.2Y, xD≤0.2Y, xE≤0.2Y, xF≤0.2Y, and xG≤0.2Y.This implies(9)xA=xB=xC=xD=xE=xF=xG≤0.2Y,which can be equivalently expressed as follows:
(10)0.24xA–xB–xC–xD–xE–xF–xG≤0,0.2xA–4xB+xC+xD+xE+xF+xG≥0,0.2xA+xB–4xC+xD+xE+xF+xG≥0,0.2xA+xB+xC–4xD+xE+xF+xG≥0,0.2xA+xB+xC+xD–4xE+xF+xG≥0,0.2xA+xB+xC+xD+xE–4xF+xG≥0,0.2xA+xB+xC+xD+xE+xF–4xG≥0.(c)
At least 25% of the total investment into deposits,xA+xG/xA+xB+xC+xD+xE+xF+xG≥0.25(11)xA+xG≥0.3xA+xB+xC+xD+xE+xF+xG~0.8xA–0.3xB–0.3xC–0.3xD–0.3xE−0.3xF+0.8xG≥0.(d)
At least 30% of the total investment to cash crops,xC+xF/xA+xB+xC+xD+xE+xF+xG≥0.3(12)xC+xF≥0.3xA+xB+xC+xD+xE+xF+xG~0.3xA+0.3xB+0.7xC+0.3xD+0.3xE+0.7xF+0.3xG≤0.(e)
At least 45% of the total investment in treasury bills and construction loans,xB+xE/xA+xB+xC+xD+xE+xF+xG≥0.5(13)xB+xE≥0.5xA+xB+xC+xD+xE+xF+xG~0.5xA+0.5xB+0.5xC+0.5xD–0.5xE+0.5xF+0.5xG≤0.(f)
Overall risk limited to not more than 2.0 (using a weighted average to calculate portfolio risk),1.7xA+2.5xB+1.5xC+1.9xD+2.9xE+1.5F+2.2xG/xA+xB+xC+xD+xE+xF+xG≤2.0(14)1.7xA+2.5xB+1.5xC+1.9xD+2.9xE+1.5xF+2.2xG≤2xA+xB+xC+xD+xE+xF+xG~0.3xA–0.5xB+0.5xC+0.1xD–0.9xE+0.5xF–0.2xG≥0.(g)
Nonnegativity of decision variablesxA,xB,xC,xD,xE,xF,xG≥0These are then transformed into the linear program model as follows:Maximize:(15)Z=0.1xA+0.2xB+0.2xC+0.1xD+0.3xE+0.2xF+0.1xG,Subject to:(16)xA+xB+xC+xD+xE+xF+xG≤15M,0.24xA–xB–xC–xD–xE–xF–xG≤0,0.2xA–4xB+xC+xD+xE+xF+xG≥0,0.2xA+xB–4xC+xD+xE+xF+xG≥0,0.2xA+xB+xC–4xD+xE+xF+xG≥0,0.2xA+xB+xC+xD–4xE+xF+xG≥0,0.2xA+xB+xC+xD+xE–4xF+xG≥0,0.2xA+xB+xC+xD+xE+xF–4xG≥0,0.8xA–0.3xB–0.3xC–0.3xD−0.3xE−0.3xF+0.8xG≥0,0.3xA+0.3xB–0.7xC+0.3xD+0.3xE–0.7xF+0.3xG≤0,0.5xA–0.6xB+0.5xC+0.5xD–0.5xE+0.5xF+0.5xG≤0,0.3xA–0.5xB+0.5xC+0.1xD–0.9xE+0.5xF–0.2xG≥0,xA,xB,xC,xD,xE,xF,xG≥0.


## 5. Results

### 5.1. Solving the LP Problem Using MATLAB

Table2 shows the linear program results taken from Table 1 and the model formulated. The solutions are obtained using the simplex method with the help of MATLAB Solver.Table 2
The simplex method and MATLAB solution in finding the optimal investment in a portfolio mix for the firm.
BasisxAxBxCxDxExFxGbChk.MATLAB solution ($)0.120.170.170.130.210.100.1001.00Fixed deposit111111115222,674,300Treasury bill0.8-0.2-0.2-0.2-0.20.20.200.42,554,800Crude oil0.2-0.80.20.20.20.20.200.41,974,800Mortgage0.20.2-0.80.20.20.20.200.4813,480Construction0.20.20.2-0.80.20.20.200.42,407,320Cash crops0.20.20.20.2-0.80.20.200.42,674,800Cert. deposit0.20.20.20.20.2-0.80.200.41,900,500Tot. investment0.20.20.20.20.20.2-0.800.415% investment0.80.20.20.2-0.2-0.20.901.820% deposit0.80.2-0.80.20.2-0.80.200.025% cash crop0.80.3-0.80.30.30.8-0.800.840% treasury and construction0.60.4-0.60.4-0.60.60.401.2Max. return2,553,096


### 5.2. Sensitivity Analysis

Here, we test the stability and robustness of the model by slightly changing the coefficients to determine the redundancy of the constraints. This would help to reduce errors in decision-making. The interest rate on each investment is reduced by 5% and later increased by 5%, the resulting LP problem is solved, and the solution to the real LP problem as compared to the original LP problem is shown in Table3.Table 3
The sensitivity analysis results of the portfolios in linear programming.
Types of investmentNormal interest rate (%)5% reduction5% incrementInvestment without treasury billRisk score (%)%Output%Output%OutputFixed deposit12.011.42,399,80012.51,808,03212.03,000,0001.0Treasury bills17.016.151,874,30018.03,674,30017.03,000,0002.0Crude oil17.016.712,129,80018.01,974,30013.02,700,0001.0Mortgage13.012.952,207,32013.65813,76821.03,000,0001.0Construction21.019.951,013,48022.053,155,80010.03,300,0002.0Cashew nuts10.09.52,674,80010.51,674,800——1.0Forex trading10.09.52,700,50010.51,900,000——2.0Maximum return2,170,1322,983,0961,895,092The problem is then formulated as an LP problem as follows:Maximize:(17)Z=0.11xA+0.16xB+0.17xC+0.13xD+0.19xE+0.10xF+0.10xG5%reduction,T=0.13xA+0.18xB+0.18xC+0.14xD+0.22xE+0.11xF+0.11xG5%increment,Y=0.12xA+0.17xB+0.13xC+0.21xD+0.10xEnotreasurybill.Subject to:(18)xA+xB+xC+xD+xE+xF+xG≤15M,0.24xA–xB–xC–xD–xE–xF–xG≤0,0.2xA–4xB+xC+xD+xE+xF+xG≥0,0.2xA+xB–4xC+xD+xE+xF+xG≥0,0.2xA+xB+xC–4xD+xE+xF+xG≥0,0.2xA+xB+xC+xD–4xE+xF+xG≥0,0.2xA+xB+xC+xD+xE–4xF+xG≥0,0.2xA+xB+xC+xD+xE+xF–4xG≥0,0.24xA–xB–xC–xD−xE−xF+4xG≥0,0.24xA+xB–4xC+xD+xE–4xF+xG≤0,0.8xA–0.3xB+0.8xC+0.3xD–0.3xE+0.8xF+0.8xG≤0,0.6xA–0.4xB+0.6xC+0.4xD–0.6xE+0.6xF–0.4xG≥0,xA,xB,xC,xD,xE,xF,xG≥0.In Table4, the comparison of results is performed to establish the correctness and validate the present study. A good agreement in both results is seen and presented in the table.Table 4
Comparison of results of previous studies with the present study.
Chicken pieMeat pieDoughnutResourcesOlayinka et al. (2015)Present resultsFlour10050100100044.2333Margarine502040600200200.0045Eggs203040160010001000.01345Contribution405070Profit10001000.02124


## 5.1. Solving the LP Problem Using MATLAB

Table2 shows the linear program results taken from Table 1 and the model formulated. The solutions are obtained using the simplex method with the help of MATLAB Solver.Table 2
The simplex method and MATLAB solution in finding the optimal investment in a portfolio mix for the firm.
BasisxAxBxCxDxExFxGbChk.MATLAB solution ($)0.120.170.170.130.210.100.1001.00Fixed deposit111111115222,674,300Treasury bill0.8-0.2-0.2-0.2-0.20.20.200.42,554,800Crude oil0.2-0.80.20.20.20.20.200.41,974,800Mortgage0.20.2-0.80.20.20.20.200.4813,480Construction0.20.20.2-0.80.20.20.200.42,407,320Cash crops0.20.20.20.2-0.80.20.200.42,674,800Cert. deposit0.20.20.20.20.2-0.80.200.41,900,500Tot. investment0.20.20.20.20.20.2-0.800.415% investment0.80.20.20.2-0.2-0.20.901.820% deposit0.80.2-0.80.20.2-0.80.200.025% cash crop0.80.3-0.80.30.30.8-0.800.840% treasury and construction0.60.4-0.60.4-0.60.60.401.2Max. return2,553,096


## 5.2. Sensitivity Analysis

Here, we test the stability and robustness of the model by slightly changing the coefficients to determine the redundancy of the constraints. This would help to reduce errors in decision-making. The interest rate on each investment is reduced by 5% and later increased by 5%, the resulting LP problem is solved, and the solution to the real LP problem as compared to the original LP problem is shown in Table3.Table 3
The sensitivity analysis results of the portfolios in linear programming.
Types of investmentNormal interest rate (%)5% reduction5% incrementInvestment without treasury billRisk score (%)%Output%Output%OutputFixed deposit12.011.42,399,80012.51,808,03212.03,000,0001.0Treasury bills17.016.151,874,30018.03,674,30017.03,000,0002.0Crude oil17.016.712,129,80018.01,974,30013.02,700,0001.0Mortgage13.012.952,207,32013.65813,76821.03,000,0001.0Construction21.019.951,013,48022.053,155,80010.03,300,0002.0Cashew nuts10.09.52,674,80010.51,674,800——1.0Forex trading10.09.52,700,50010.51,900,000——2.0Maximum return2,170,1322,983,0961,895,092The problem is then formulated as an LP problem as follows:Maximize:(17)Z=0.11xA+0.16xB+0.17xC+0.13xD+0.19xE+0.10xF+0.10xG5%reduction,T=0.13xA+0.18xB+0.18xC+0.14xD+0.22xE+0.11xF+0.11xG5%increment,Y=0.12xA+0.17xB+0.13xC+0.21xD+0.10xEnotreasurybill.Subject to:(18)xA+xB+xC+xD+xE+xF+xG≤15M,0.24xA–xB–xC–xD–xE–xF–xG≤0,0.2xA–4xB+xC+xD+xE+xF+xG≥0,0.2xA+xB–4xC+xD+xE+xF+xG≥0,0.2xA+xB+xC–4xD+xE+xF+xG≥0,0.2xA+xB+xC+xD–4xE+xF+xG≥0,0.2xA+xB+xC+xD+xE–4xF+xG≥0,0.2xA+xB+xC+xD+xE+xF–4xG≥0,0.24xA–xB–xC–xD−xE−xF+4xG≥0,0.24xA+xB–4xC+xD+xE–4xF+xG≤0,0.8xA–0.3xB+0.8xC+0.3xD–0.3xE+0.8xF+0.8xG≤0,0.6xA–0.4xB+0.6xC+0.4xD–0.6xE+0.6xF–0.4xG≥0,xA,xB,xC,xD,xE,xF,xG≥0.In Table4, the comparison of results is performed to establish the correctness and validate the present study. A good agreement in both results is seen and presented in the table.Table 4
Comparison of results of previous studies with the present study.
Chicken pieMeat pieDoughnutResourcesOlayinka et al. (2015)Present resultsFlour10050100100044.2333Margarine502040600200200.0045Eggs203040160010001000.01345Contribution405070Profit10001000.02124


## 6. Discussion of Results

From Table5, as the interest rate on the original data reduces by 5%, the return on investment also decreases by almost 15% (i.e., from $2,553,096.55 to $2,170,132.068). The quantum of money on treasury bills and construction loans had a significant reduction from $2,554,800.00 to $1,874,300.00 and from $2,407,320.00 to $1,013,480.00, respectively, for maximum return. However, investment in crude oil, mortgage, securities, cash crop, and certificate of deposit appreciated from $1,974,800.00 to $2,129,800.00, from $813,480.00 to $2,207,320.00, from $2,674,800.00 to $2,674,800.00, and from $1,900,500.00 to $2,7005,00.00, respectively. However, fixed deposit had a slight decrease from $2,674,300.00 to $2,399,800.00. Furthermore, as the interest rate of the original data increases by 5%, the return on investment also grows by almost 17% (i.e., from $2,553,096.55 to $2,983,096.55) with the quantum of money on treasury bills and construction loans being the most affected in terms of increment, that is, increasing from $2,554,800.00 to $3,674,300.00 and from $2,407,320.00 to $3,155,800.00, respectively. However, the quantum of money on fixed deposit, crude oil, cash crop, and certificate of deposit experienced a decrease from $2,674,300.00 to $1,808,032.00, from $1,974,800.00 to $1,974,300.00, from $2,674, 800.00 to $1,674,800.00, and from $1,900,500.00 to $1,900,000.00, respectively, while mortgage securities recorded a slight increase from $813,480.00 to $813,768.00, while treasury bills and construction loans are exempted from the portfolio, and the quantum of money on each investment increases rapidly while the return on investments reduces to $1,895,092.65.Table 5
The result and summary of the solutions.
InvestmentsRate on investment (%)Rate on investment down by 5%Rate on investment increased by 5%Rate on investment (without treasury bills and construction loans) (%)Rate of investment (%)Money investedRate of investment (%)Money investedRate of investment (%)Money investedRate of investment (%)Money investedFixed deposit12.02,674,30011.42,399,80012.51,808,03212.03,000,000Treasury bills17.02,554,80016.151,874,30018.03,674,300——Crude oil17.01,974,80016.712,129,80018.01,974,30017.03,000,000Mortgage13.0813,48012.952,207,32013.65813,76813.02,700,000Construction21.02,407,32019.951,013,48022.053,155,800—Cashew nuts10.02,674,8009.52,674,80010.51,674,80021.03,000,000Forex trading10.01,900,5009.52,700,50010.51,900,00010.03,300,000Return on investment ($)2,553,0962,170,1322,983,0961,895,092


## 7. Conclusion

This paper investigates the level of investment in a selected portfolio that gives maximum returns with minimal inputs based on the secondary data supplied by a particular firm to determine the available funds to allocate each component of the portfolio to maximize returns and minimize inputs using linear programming. Sensitive analysis to ascertain the robustness of the resulting model towards the changes in input parameters to determine a redundant constraint was conducted. The model given is a single-objective model that maximizes the return on the portfolio as interests on the original data reduce by 5%, the return on investments also goes down by almost 15%, and the quantum of money on treasury bills and construction loans saw a significant reduction for maximum return while the investment in others options saw a slight decrease. Moreover, as the interest rate of the original data increases by 5%, the return on investment also grows by almost 17% while the quantum of money on treasury bills and construction loans increases, and the quantum of money on other options experienced a decrease except for mortgage securities which recorded a slight increase.The results of this investigation are much applicable to businesses and portfolio management. The present study can be extended to small-scale and large-scale businesses and investments in maximizing the profit of some selected portfolios and rightful decision-making.



---

*Source: 8817909-2020-12-11.xml*