Case Study 2: Portfolio selection Select a portfolio package from a set of alternative investments > Maximization of the expected annual return based on available capital and company's policy Problem data Expected annual return of investments Investment Share A-manufacturing sector Share B-manufacturing sector Share C-food and beverage sector Share D-food and beverage sector Mutual fund E Mutual fund Z Requirements Expected annual return rate (%) 15.4 19.2 18.7 13.5 17.8 16.3 Total amount = $ 90000 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 shares QUESTION 2 Based on the following case studies, students need to List down the optimization problem; Define the decision variables ; Develop the objective function and constraints: Develop a mathematical model that can be used to solve the optimization problem for each case study. Students need to solve the mathematical model by using Microsoft Excel's 'Solver', find the optimal solution and interpret the result. Students also need to conduct sensitivity analysis and interpret the solution. > Appendix: Students need to attach the excel output and sensitivity analysis for each case study. Case Study 1: Human Resources Managemnet > Allocation of available human resources to different departments, work centers, shifts etc. > Recruitment of seasonal staff Allocation of staff to shifts > Minimizing the number of employees who should work in various time periods during the day Problem data Time Period 7 a.m. -9 a.m. 9 a.m. 11 a.m. 11 a.m.-13 p.m. 13 p.m. -15 p.m. 15 p.m. - 17 p.m. 17 p.m. - 19 p.m. 19 p.m.-21 p.m. 21 p.m. -23 p.m. 23 p.m. -7 a.m. Gross Employee Cost per day (in S) 1 1 1 1 230 2 1 220 Shift 3 225 4 7 / 7 7 240 (50 marks) 5 260 Minimum Number of Required Employees 35 68 60 57 65 63 72 33 12 Case Study 2: Portfolio selection Select a portfolio package from a set of alternative investments > Maximization of the expected annual return based on available capital and company's policy Problem data Expected annual return of investments Investment Share A-manufacturing sector Share B-manufacturing sector Share C-food and beverage sector Share D-food and beverage sector Mutual fund E Mutual fund Z Requirements Expected annual return rate (%) 15.4 19.2 18.7 13.5 17.8 16.3 Total amount = $ 90000 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 shares QUESTION 2 Based on the following case studies, students need to List down the optimization problem; Define the decision variables ; Develop the objective function and constraints: Develop a mathematical model that can be used to solve the optimization problem for each case study. Students need to solve the mathematical model by using Microsoft Excel's 'Solver', find the optimal solution and interpret the result. Students also need to conduct sensitivity analysis and interpret the solution. > Appendix: Students need to attach the excel output and sensitivity analysis for each case study. Case Study 1: Human Resources Managemnet > Allocation of available human resources to different departments, work centers, shifts etc. > Recruitment of seasonal staff Allocation of staff to shifts > Minimizing the number of employees who should work in various time periods during the day Problem data Time Period 7 a.m. -9 a.m. 9 a.m. 11 a.m. 11 a.m.-13 p.m. 13 p.m. -15 p.m. 15 p.m. - 17 p.m. 17 p.m. - 19 p.m. 19 p.m.-21 p.m. 21 p.m. -23 p.m. 23 p.m. -7 a.m. Gross Employee Cost per day (in S) 1 1 1 1 230 2 1 220 Shift 3 225 4 7 / 7 7 240 (50 marks) 5 260 Minimum Number of Required Employees 35 68 60 57 65 63 72 33 12