Any business students out there? Help a brotha out.

A portfolio manager for a mutual fund company is strategizing for the next calendar year. After careful analysis, she has identified the following stocks as candidates for inclusion in her portfolio this year.
Risk Estimated
Investment Category: Stock Price/Share Classification Dividend/Share Annual Growth
Banks/Financial 1 $50 1 $2.50 5%
2 $60 1 $2.75 6%
3 $80 2 $4.00 7.5%
4 $30 3 none 4%
Energy 5 $75 2 $3.00 10%
6 $125 1 $4.50 8%
7 $250 3 none 20%
Consumer Staples 8 $25 1 $.80 5%
9 $40 1 $1.25 6%
10 $90 2 $.50 15%
Health Care 11 $55 1 $1.40 7%
12 $120 1 $3.00 8%
13 $200 1 $4.75 10%
Telecommunications 14 $70 2 $2.00 5.5%
15 $100 3 $0.50 15%
Info Technology 16 $130 1 $1.40 12.5%
17 $150 1 $1.00 10%
18 $50 1 $0.70 15%
Utilities 19 $40 1 $2.40 5%
20 $54 1 $3.00 4%

The risk classifications are (1) = low risk, (2) = moderate risk, and (3) high risk.

The portfolio manager wants to determine the number of shares of each stock to purchase. The

what class is this? Financial management?

The class is called: Introduction to Business Analysis and Applications, but i think this is covering financial management, yeah. This is linear programming using excel and solver bro, i just don't know where to start.

The first thing to do would be to input all that data into excel. Leave an empty column for share number (this is your only variable it looks like). Then just adjust the number of shares until you get the highest return you think possible.

The other think to consider is the risk factor. for example, Banks/Finance 4 looks like shit. High risk with 4% estimated growth and no dividend return, compared to BFSI 2, moderate risk with 6% estimated growth and $2.50 per share dividend return. Don't know why you would put money into BFSI 4. Whereas Energy 3 has high risk and no dividend return, but 20% estimated growth.

damn dude, clean that shit up with excel first. what a clusterfuck to read

The answer is























tl;dr

annual growth times price. forget about stocks that are rated a 3. basically, just run numbers and try to maximize the value of the portfolio for the year.

thanks guys i figured the constraints out and shit. sorry for not cleaning it up, i tried to but when i submitted it it came out looking like shit for some reason. thanks to everyone for the input, this is what i came up with:

Maximize z = $52.5x1+$63.6x2+$86x3+$31.2x4+$82.5x5+$135x6+$300x7+$26.25x8+$42.4x9+$103.5x10+$58.85x11+$129.6x12+$220x13+$73.85x14+$115x15+$146.25x16+$165x17+$57.5x18+$42x19+$56.16x20

s.t.
A. $52.5x1+$63.6x2+$86x3+$31.2x4+$82.5x5+$135x6+$300x7+$26.25x8+$42.4x9+$103.5x10+$58.85x11+$129.6x12+$220x13+$73.85x14+$115x15+$146.25x16+$165x17+$57.5x18+$42x19+$56.16x20 <= $10,000,000

C. 50x1+60x2+80x3+30x4 => $1,500,000

D. 55x11+120x12+200x13 => $2,000,000

E. 25x8+40x9+90x10 <= $750,000

F-1. 130x16 => $400,000

F-2. 150x17 => $400,000

F-3. 50x18 => $400,000

G. 80x3+75x5+90x10+70x14 <= $750,000

H. 30x4+250x7+100x15 - .05(50x1+60x2+80x3+30x4+75x5+125x6+250x7+25x8+40x9+90x10+55x11+120x12+200x13+70x14+100x15+130x16+150x17+50x18+40x19+54x20) <= 0

I. 22.5x1+2.75x2+4x3+3x5+4.5x6+.8x8+1.25x9+.5x10+1.4x11+3x12+4.75x13+2x14+.5x15+1.4x16+1x17+.7x18+2.4x19+3x20 => 400,000

J. 130x16+150x17+50x18 - 2(25x8+40x9+90x10+40x19+54x20) => 0

K. x14+x15 <= 7,500 shares

now im just having problems with excel's solver add-in due to my lack of excel skills, but i still have a few more days before i hand this shit in.

www.youtube.com/watch?v=GlKL_EpnSp8

algebra 1