Microsoft Excel 12.0 Answer Report Worksheet: [Susan Wong Template Winter 2016.xlsx]Strategy 1 Report Created: 2/26/2016 2:24:31 PM Target Cell (Max) Cell Name $C$19 Return 3 month Investment Original Value Final Value 0 634.649999986 Adjustable Cells Cell Name $B$3 1 month Investment $C$3 3 month Investment $D$3 7 month Investment $B$4 1 month Investment $C$4 3 month Investment $D$4 7 month Investment $B$5 1 month Investment $C$5 3 month Investment $D$5 7 month Investment $B$6 1 month Investment $C$6 3 month Investment $D$6 7 month Investment $B$7 1 month Investment $C$7 3 month Investment $D$7 7 month Investment $B$8 1 month Investment $C$8 3 month Investment $D$8 7 month Investment $B$9 1 month Investment $C$9 3 month Investment $D$9 7 month Investment $B$10 1 month Investment $C$10 3 month Investment $D$10 7 month Investment $B$11 1 month Investment $C$11 3 month Investment $D$11 7 month Investment $B$12 1 month Investment $C$12 3 month Investment $D$12 7 month Investment $B$13 1 month Investment $C$13 3 month Investment $D$13 7 month Investment Original Value Final Value 0 399.999999991 0 2190 0 0 0 99.9999999978 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2519.99999995 0 0 0 714.999999984 0 529.999999988 0 849.999999981 0 0 0 0 0 249.999999995 0 0 0 0 0 0 0 1115 0 0 0 474.99999999 0 0 0 0 0 1255 0 0 0 0 0 0 0 0 0 4629.9999999 Constraints Cell $J$3 Net $J$4 Net $J$5 Net $J$6 Net $J$7 Net $J$8 Net $J$9 Net $J$10 Net $J$11 Net $J$12 Net $J$13 Net $J$14 Net Cell Value Formula 2860.00000006 $J$3>=$K$3 2749.99999999 $J$4>=$K$4 2550 $J$5>=$K$5 2120.00000001 $J$6>=$K$6 1205.00000003 $J$7>=$K$7 1600.00000002 $J$8>=$K$8 3049.99999999 $J$9>=$K$9 2300 $J$10>=$K$10 1975.00000001 $J$11>=$K$11 1670.00000002 $J$12>=$K$12 2709.99999999 $J$13>=$K$13 2979.99999999 $J$14>=$K$14 Name Status Slack Binding 0 Binding 0 Binding 0 Binding 0 Binding 0 Binding 0 Binding 0 Binding 0 Binding 0 Binding 0 Binding 0 Binding 0 Microsoft Excel 12.0 Sensitivity Report Worksheet: [Susan Wong Template Winter 2016.xlsx]Strategy 1 Report Created: 2/26/2016 2:24:32 PM Adjustable Cells Cell $B$3 $C$3 $D$3 $B$4 $C$4 $D$4 $B$5 $C$5 $D$5 $B$6 $C$6 $D$6 $B$7 $C$7 $D$7 $B$8 $C$8 $D$8 $B$9 $C$9 $D$9 $B$10 $C$10 $D$10 $B$11 $C$11 $D$11 $B$12 $C$12 $D$12 $B$13 $C$13 $D$13 Name 1 month Investment 3 month Investment 7 month Investment 1 month Investment 3 month Investment 7 month Investment 1 month Investment 3 month Investment 7 month Investment 1 month Investment 3 month Investment 7 month Investment 1 month Investment 3 month Investment 7 month Investment 1 month Investment 3 month Investment 7 month Investment 1 month Investment 3 month Investment 7 month Investment 1 month Investment 3 month Investment 7 month Investment 1 month Investment 3 month Investment 7 month Investment 1 month Investment 3 month Investment 7 month Investment 1 month Investment 3 month Investment 7 month Investment Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 400 0 0.005 0.005 1.000E+030 2190 0 0.02 1.000E+030 0 0 0 0.07 0 1.000E+030 100 0 0.005 0.005 1.000E+030 0 -0.025 0.02 0.025 1.000E+030 0 -0.005 0.07 0.005 1.000E+030 0 -0.005 0.005 0.005 1.000E+030 0 -0.03 0.02 0.03 1.000E+030 0 -0.005 0.07 0.005 1.000E+030 0 -0.025 0.005 0.025 1.000E+030 0 -0.025 0.02 0.025 1.000E+030 2520 0 0.07 1.000E+030 0 0 -0.005 0.005 0.005 1.000E+030 715 0 0.02 0.02 0.005 530 0 0.07 0.04 0.02 850 0 0.005 0.005 0 0 0 0.02 0 1.000E+030 0 -0.03 0.07 0.03 1.000E+030 250 0 0.005 0.005 0 0 0 0.02 0 1.000E+030 0 -0.025 0.07 0.025 1.000E+030 0 -0.005 0.005 0.005 1.000E+030 1115 0 0.02 0 0 0 -0.02 0.07 0.02 1.000E+030 475 0 0.005 0 0.01 0 -0.02 0.02 0.02 1.000E+030 0 -0.01 0.07 0.01 1.000E+030 1255 0 0.005 0 0.005 0 -0.055 0.02 0.055 1.000E+030 0 -0.005 0.07 0.005 1.000E+030 0 -0.025 0.005 0.025 1.000E+030 0 -0.05 0.02 0.05 1.000E+030 4630 0 0.07 1.000E+030 0.005 Constraints Cell $J$3 $J$4 $J$5 $J$6 $J$7 $J$8 $J$9 $J$10 $J$11 $J$12 $J$13 $J$14 Name Net Net Net Net Net Net Net Net Net Net Net Net Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 2860 -0.16 2860 2190 1.000E+030 2750 -0.155 2750 2190 400 2550 -0.15 2550 2190 100 2120 -0.14 2120 2520 1.000E+030 1205 -0.11 1205 715 1.000E+030 1600 -0.1 1600 250 1.000E+030 3050 -0.095 3050 250 1.000E+030 2300 -0.09 2300 1115 1.000E+030 1975 -0.08 1975 475 1.000E+030 1670 -0.075 1670 1255 1.000E+030 2710 -0.07 2710 4630 1.000E+030 2980 -0.04 2980 715 530 Month 1 month Investment 1 2 3 4 5 6 7 8 9 10 11 12 400 100 0 0 0 850 250 0 475 1255 0 Interests 16.65 Return 3 month Investment 2190 0 0 0 715 0 0 1115 0 0 0 7 month Investment 0 0 400 0 100 2520 0 530 0 00 0 850 0 250 00 0 475 4630 1255 0 80.399999998 537.59999999 634.64999999 Matured 1 month Investment Matured 3 Matured7 month month Investment Investment Extra Income 3000 2190 0 0 0 715 0 0 1115 0 0 0 0 2520 530 Salary Net 2450 2860.0000001 2450 2750 2450 2550 2450 2120 2450 1205 2450 1600 2450 3050 2450 2300 2450 1975 2450 1670 2450 2710 2450 2980 expense 2860 2750 2550 2120 1205 1600 3050 2300 1975 1670 2710 2980 Month 1 month Investment 3 month Investment 1 2 3 4 5 6 7 8 9 10 11 12 Matured 1 month Investment 7 month Investment Matured 3 Matured7 month month Investment Investment 3000 0 0 Interests 0 Return 0 Extra Income Salary 2450 5450 2450 2450 2450 2450 2450 2450 2450 2450 2450 2450 2450 Net expense 2860 2750 2550 2120 1205 1600 3050 2300 1975 1670 2710 2980