1. Write the MAD model for the portfolio problem in the attacted protfolio.xls file. 2. Solve the MAD model by Excel Solver. 3. Suppose that you would like to invest 50,000 R.O on the given assets. (1) Identify how much money you should invest in each asset., (ii) what is the risk of the investment (iii) what is the expected return of the investment? 4. Solve the given assignment problem in the attacted assignment.xls file by using both Excel- solver and Hungrian method. What is the cost for the optimal assigment? Cand.nl D16 x & fox A B D E F G H Year 4 Year 6 Year 1 0.00 0.01 -0.03 0.04 Year 2 -0.03 0.03 -0.01 -0.05 Year 3 0.05 0.02 0.05 -0.02 0.01 0.05 0.03 -0.02 Year 5 -0.01 0.04 0.01 0.00 0.03 0.00 -0.03 0.03 1 Investment 2 A 3 B 4 C 5 D 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 24 25 26 27 28 29 Ready @ 1 1 A B D E F G H J WORKSERS 1 2 3 1 2 32 LO 3 39 JOBS 5 36 4 5 6 20 7 24 8 16 45 on A N 4 B 8 42 31 36 50 16 47 C 17 39 17 6 22 43 28 25 5 6 24 47 18 15 D 25 28 14 15 37 IN 190 7 43 15 E F 14 18 10 26 46 11 32 9 31 22 9 34 28 38 36 30 5 44 S 38 20 36 G H 29 9 42 12 39 13 21 21 36 8 9 10 11 12 13 14 15 16 17 18 19 0 DO 1. Write the MAD model for the portfolio problem in the attacted protfolio.xls file. 2. Solve the MAD model by Excel Solver. 3. Suppose that you would like to invest 50,000 R.O on the given assets. (1) Identify how much money you should invest in each asset., (ii) what is the risk of the investment (iii) what is the expected return of the investment? 4. Solve the given assignment problem in the attacted assignment.xls file by using both Excel- solver and Hungrian method. What is the cost for the optimal assigment? Cand.nl D16 x & fox A B D E F G H Year 4 Year 6 Year 1 0.00 0.01 -0.03 0.04 Year 2 -0.03 0.03 -0.01 -0.05 Year 3 0.05 0.02 0.05 -0.02 0.01 0.05 0.03 -0.02 Year 5 -0.01 0.04 0.01 0.00 0.03 0.00 -0.03 0.03 1 Investment 2 A 3 B 4 C 5 D 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 24 25 26 27 28 29 Ready @ 1 1 A B D E F G H J WORKSERS 1 2 3 1 2 32 LO 3 39 JOBS 5 36 4 5 6 20 7 24 8 16 45 on A N 4 B 8 42 31 36 50 16 47 C 17 39 17 6 22 43 28 25 5 6 24 47 18 15 D 25 28 14 15 37 IN 190 7 43 15 E F 14 18 10 26 46 11 32 9 31 22 9 34 28 38 36 30 5 44 S 38 20 36 G H 29 9 42 12 39 13 21 21 36 8 9 10 11 12 13 14 15 16 17 18 19 0 DO