Solver File.xlsx

Microsoft Excel 16.0 Answer Report Worksheet: [Book2]Sheet1 Report Created: 5/23/2017 8:20:18 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.25 Seconds. Iterations: 12 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative

Objective Cell (Max) Cell $I$3 Return

Name

Original Value Final Value 0 6618.181818

Variable Cells Cell Name $D$4 Investment ($) x1 $E$4 Investment ($) x2 $F$4 Investment ($) x3 $G$4 Investment ($) x4

Original Value Final Value Integer 0 0 Contin 0 0 Contin 0 38181.81818 Contin 0 31818.18182 Contin

Constraints Cell Name $I$10 Total investment LHS $I$11 X1 LHS $I$12 X2 LHS $I$13 X3 LHS $I$14 X4 LHS $I$6 MB constraint LHS $I$7 CD constraint LHS $I$8 CD+TD Constraint LHS $I$9 (CD+TD):(MB+GSF) Constraints LHS

Cell Value Formula Status Slack 70000 $I$10=$J$10 Binding 0 0 $I$11>=$J$11 Binding 0 0 $I$12>=$J$12 Binding 0 38181.818182 $I$13>=$J$13 Not Binding 38181.81818 31818.181818 $I$14>=$J$14 Not Binding 31818.18182 0 $I$6<=$J$6 Not Binding 14000 -70000 $I$7<=$J$7 Not Binding 70000 38181.818182 $I$8>=$J$8 Not Binding 17181.81818 7.275958E-12 $I$9>=$J$9 Binding 0

NonNegative

Microsoft Excel 16.0 Sensitivity Report Worksheet: [Book2]Sheet1 Report Created: 5/23/2017 8:20:18 PM

Variable Cells Cell $D$4 $E$4 $F$4 $G$4

Name Investment ($) x1 Investment ($) x2 Investment ($) x3 Investment ($) x4

Final Value 0 0 38181.81818 31818.18182

Reduced Cost 0 0 0 0

Objective Allowable Allowable Coefficient Increase Decrease 0.085 0.045 1E+030 0.05 0.015 1E+030 0.065 0.065 0.015 0.13 1E+030 0.045

Constraints Cell $I$10 $I$11 $I$12 $I$13 $I$14 $I$6 $I$7 $I$8 $I$9

Final Shadow Constraint Allowable Allowable Name Value Price R.H. Side Increase Decrease Total investment LHS 70000 0.0945454545 70000 1E+030 31500 X1 LHS 0 -0.045 0 14000 0 X2 LHS 0 -0.015 0 35000 0 X3 LHS 38181.81818 0 0 38181.81818 1E+030 X4 LHS 31818.18182 0 0 31818.18182 1E+030 MB constraint LHS 0 0 14000 1E+030 14000 CD constraint LHS -70000 0 0 1E+030 70000 CD+TD Constraint LHS 38181.81818 0 21000 17181.81818 1E+030 (CD+TD):(MB+GSF) Constraints LHS 7.275958E-12 -0.029545455 0 70000 37800

Product Return Investment ($)

x1 0.085 0

x2 x3 x4 0.05 0.065 0.13 0 38181.82 31818.18

6618.182 LHS

MB constraint CD constraint CD+TD Constraint (CD+TD):(MB+GSF) Constraints Total investment NNC X1 X2 X3 X4

1 -1 0 -1.2 1 1

0 1 1 1 1

0 -1 1 1 1

0 -1 0 -1.2 1

1 1 1

RHS 0 14000 -70000 0 38181.82 21000 7.28E-12 0 70000 70000 0 0 0 0 38181.82 0 31818.18 0