Mathematical Programming Techniques Assignment and Simulation Modelling Assignment

Mathematical Programming Techniques Assignment (Part A)
.
Institution Name:
Student Name:
Arrivals into the workshop

a. i. Maximize the return from your portfolio of investments
Defining Variables:
Let; X1= the amount of return from fund A
X2= the amount of return from fund B
X3= the amount of return from fund C
X4= the amount of return from fund P
X5= the total amount of return from R
X6= the amount of return from fund S
X7= the amount of return from fund T
X8= the amount of return from fund X
X9= the amount of return from fund Z
a.ii. Maximum return r= 20x1+ 30x2 + 20 x3 + 60 x4+ 40x5 + 35 x6 + 40 x7
+ 5x8 + 8x9 . This is the objective function for obtaining the total returns from
each fund.
Where; 20x1 = Total Returns from fund A
30X2= the amount of return from fund B
20X3= the amount of return from fund C
60X4= the amount of return from fund P
40x5=the amount of return from fund Q
35X6= the amount of return from fund R
40X7= the amount of return from fund X
5X8= the amount of return from fund Y
8X9= the amount of return from fund Z
The Constraints are;
X1, x2, x3, x4, x5, x6, x7, x8 and x9 ≥0. This means that the individual returns from each
fund must be greater than or equal to 0.
X1 + X2 +X3+ X4+ X4 + X5 + X6 + X7 + X8 + X9≤ 10000. This means that the sum
returns from each of the individual funds must not be less than or equal to 10000 (i.e. the
amount must not be more than 10000).
i. Maximize the total rating for your portfolio of investments
Defining Variables:
Let; X1= the rating of fund A
X2= the rating of fund B
X3= the rating of fund C
X4= the rating of fund P
X5= the rating of fund R
X6= the rating of fund S
X7= the rating of fund T

X8= the rating of fund X
X9= the rating of fund Z
` Maximum rating R= 5x1+ 3x2 + 3x3 + 4x4+ 5x5 + 1x6 + 2x7 + 3x8 + 3x9
. This is the objective function for obtaining the total rating of each fund.
Where; 5X11 = the rating of fund A
3X2= the rating of fund B
3X3= the rating of fund C
5X4= the rating of fund P
4X5=the rating of fund Q
5X6= the rating of fund R
1X7= the rating of fund X
2X8= the rating of fund Y
3X9= the rating of fund Z
The Constraints are;
X1, x2, x3, x4, x5, x6, x7, x8 and x9 ≥0. This means that the individual of each
fund must be greater than or equal to 0.
X1 + X2 +X3+ X4+ X4 + X5 + X6 + X7 + X8 + X9≤ 45 This mean that the sum
ratings of each of the individual funds must not be less than or equal to 5(i.e. the
amount must not be more than 5).
a.iii. Maximize the return given that the portfolio should have an average rating of
at least 3.7.
Defining Variables:
Let; X1= the rating of fund A
X2= the rating of fund B
X3= the rating of fund C
X4= the rating of fund P
X5= the rating of fund R
X6= the rating of fund S
X7= the rating of fund T
X8= the rating of fund X
X9= the rating of fund Z
Maximum rating R= 5x1+ 3x2 + 3x3 + 4x4+ 5x5 + 1x6 + 2x7 + 3x8 + 3x9 . This
is the objective function for obtaining the total rating of each fund.
Where; 5X11 = the rating of fund A
3X2= the rating of fund B
3X3= the rating of fund C
5X4= the rating of fund P
4X5=the rating of fund Q
5X6= the rating of fund R

1X7= the rating of fund X
2X8= the rating of fund Y
3X9= the rating of fund Z
The Constraints are;
X1, x2, x3, x4, x5, x6, x7, x8 and x9 ≥0. This means that the individual of each
fund must be greater than or equal to 0.
X1 + X2 +X3+ X4+ X4 + X5 + X6 + X7 + X8 + X9≤ 5This mean that the sum
ratings of each of the individual funds must not be less than or equal to 3.7 (i.e.
the amount must not be more than 3.7).
b. Investigate how each of these portfolios would change if
The funds invested with C&R must be greater than those invested with the other
fund providers.
The change of portfolio is determined using the excel solver and the set conditions
outlined above. The table below shows how the conditions will change. The funds will
have a composition of similar to the one in the column used. It is clearly demonstrated
that P, Q, and R will have larger shares .The calculations are available in the excel
appendices.
B.ii. The portfolio must include investments in funds B and Z.
For the portfolio to include B and Z, the table below shows the optimal conditions. B
must be 60 while Z must be 16. This will give a maximum return and rating.The
calculations are available in the excel appendices.
c. Extend your investigation to include the restriction that the total investment
with funds
Carrying a “5 rating” must be greater than the total investment in the funds
carrying a
Rating 1 or 2 or 3.
The table below shows the changes in the variables.
Maximizing Returns Number to make
1. Objective Function 2 5
2. Input Variables
3. Decision Variables
4. Constraints
Required used 1 3 3
A 20 0 40 <= 0
B 30 0 60 <= 0
C 20 0 40 <= 0