100 likes | 243 Views
Operations Management Linear Programming Module B - Harder Formulations. Harder Formulation Example.
E N D
Operations ManagementLinear ProgrammingModule B - Harder Formulations
Harder Formulation Example You are creating an investment portfolio from 4 investment options: stocks, real estate, T-bills (Treasury-bills), and cash. Stocks have an annual rate of return of 12% and a risk measure of 5. Real estate has an annual rate of return of 10% and a risk measure of 8. T-bills have an annual rate of return of 5% and a risk measure of 1. Cash has an annual rate of return of 0% and a risk measure of 0. The average risk of the portfolio can not exceed 5. At least 15% of the portfolio must be in cash. Formulate an LP to maximize the annual rate of return of the portfolio.
Constraints:: Average risk 5 At least 15% in cash Investment Formulation Return Risk Investment 0.12 Stocks 5 0.10 8 Real estate 1 T-bills 0.05 0 Cash 0 5 Portfolio
Variables:: xi = % of portfolio in investment type i. i = 1 is Stocks; i = 2 is Real estate; i = 3 is T-bills; i=4 is is Cash Investment Formulation Return Risk Investment 0.12 Stocks 5 0.10 8 Real estate 1 T-bills 0.05 0 Cash 0 5 Portfolio
x4 0.15 (Cash) 5x1 + 8x2 + x3 5 (Risk) x1 + x2 + x3 + x4 = 1.0(total = 100%) x1, x2, x3 , x40 : Maximize: 0.12x1 + 0.10x2 + 0.05x3 Investment Formulation xi = % of portfolio in investment type i. i = 1 is Stocks; i = 2 is Real estate; i = 3 is T-bills; i=4 is is Cash Optimal Solution is x1 = 0.85, x2 = 0, x3 = 0 and x4 = 0.15
Investment Formulation xi = % of portfolio in investment type i. Maximize: 0.12x1 + 0.10x2 + 0.05x3 x4 0.15 (Cash) 5x1 + 8x2 + x3 5 (Risk) x1, x2, x3 , x40 Without the total = 100% constraint, the optimal solution is: x1 = 0, x2 = 0, x3 = 5 and x4 = 0.15 This means invest 500% in T-bills and get a 25% return!!
Midnight - 4 am 4 am - 8 am 3 6 Another Formulation Example A business operates 24 hours a day and employees work 8 hour shifts. Shifts may begin at midnight, 4 am, 8 am, noon, 4 pm or 8 pm. The number of employees needed in each 4 hour period of the day to serve demand is in the table below. Formulate an LP to minimize the number of employees to satisfy the demand. 8 am - noon Noon - 4 pm 4 pm - 8 pm 8 pm - midnight 12 9 13 15
12-4 am 4-8 am 8-noon 12-4 pm 4-8 pm 8 pm-12 3 6 13 15 12 9 x1 x2 x3 x4 x5 x6 x6 Another Formulation Example xi = number of employees who start an 8 hour shift at time i i = 1 is midnight, i = 2 is 4 am, i = 3 is 8 am; i=4 is noon, i = 5 is 4 pm, i = 6 is 8 pm
Another Formulation Example xi = Number of employees who start an 8 hour shift at time i. i = 1 is midnight, i = 2 is 4 am, i = 3 is 8 am; i=4 is noon, i = 5 is 4 pm, i = 6 is 8 pm Minimize: x1 + x2 + x3 + x4 + x5 + x6 x1 + x6 3 x1 + x2 6 x2 + x3 13 x3 + x4 15 x4 + x5 12 x5 + x6 9 x1, x2, x3 , x4 , x5 , x6 0
Another Formulation Example xi = Number of employees who start an 8 hour shift at time i. Minimize: x1 + x2 + x3 + x4 + x5 + x6 x1 + x6 3 x1 + x2 6 x2 + x3 13 x3 + x4 15 x4 + x5 12 x5 + x6 9 x1, x2, x3 , x4 , x5 , x6 0 Optimal solution is 30 employees: x1 = 3, x2 = 3, x3 = 10, x4 = 5, x5 = 9, x6 = 0