Question

Linear Programming (Multiple choice) 2. Base your answer on the following linear progr profit 20 labor materials 600 s 300 s 841 19 15 36 budget 24 a) The optimal product mix is 17 laptops and 12 desktops. b) The maximum profit is $2030. c) The minimum cost is $900. d) The best product mix is 20 laptops and 30 desktops 1. Linear Programming (Fill-ins) Following is the linear programming model where S dollars invested in stock fund and M - dollars invested in money market fund. You are given a template in the Excel file. Use Excel's Solver tool to identify the optimal solution. Minimize Risk = 10 S + 4 M subject to S M 200,000 0.10 S+ 0.05 M 14,000 M >= 40,000 S, M0 rite the optimal solution and the optimal objective values here: , Total Risk = -- ,

Answer 1

1. Let, Dollars invested in stock fund = S

Dollars invested in money market fund = M

Objective function :- Minimize Risk = 10S + 4M

Constraints :-

S + M = 200000

0.1S + 0.05M >= 14000

M >= 40000

S, M >= 0

On solving these inequalities , we get

S = Dollars invested in stock fund = $80000

M = Dollars invested in money market fund = $120000

Total risk = ( 10 × 80000 ) + (4 × 120000 ) = $1280000