Microsoft Excel 15.0 Answer Report Worksheet: [Susan Wong Template Fall 2015-McGuire-Powers.xlsx]Q1 Report Created: 11/19/2015 9:44:00 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.016 Seconds. Iterations: 13 Subproblems: 0 Solver Options Max Time 100 sec, Iterations 100, Precision 0.000001 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 5%, Assume NonNegative Objective Cell (Max) Cell Name $C$19 Return 3 month Investment Original Value 0 Final Value 634.65 Variable 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Final Value Integer 400 Contin 2190 Contin 0 Contin 100 Contin 0 Contin 0 Contin 0 Contin 0 Contin 0 Contin 0 Contin 0 Contin 2520 Contin 0 Contin 715 Contin 530 Contin 600 Contin 250 Contin 0 Contin 0 Contin 0 Contin 0 Contin 0 Contin 865 Contin 0 Contin 725 Contin 0 Contin 0 Contin 1505 Contin 0 Contin 0 Contin 0 Contin 0 Contin 4630 Contin 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 Name Cell Value Formula 2860 $J$3>=$K$3 2750 $J$4>=$K$4 2550 $J$5>=$K$5 2120 $J$6>=$K$6 1205 $J$7>=$K$7 1600 $J$8>=$K$8 3050 $J$9>=$K$9 2300 $J$10>=$K$10 1975 $J$11>=$K$11 1670 $J$12>=$K$12 2710 $J$13>=$K$13 2980 $J$14>=$K$14 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 15.0 Sensitivity Report Worksheet: [Susan Wong Template Fall 2015-McGuire-Powers.xlsx]Q1 Report Created: 11/19/2015 9:44:00 PM Variable 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 Value Cost Coefficient 400 0 0.005 2190 0 0.02 0 0 0.07 100 0 0.005 0 -0.025 0.02 0 -0.005 0.07 0 -0.005 0.005 0 -0.03 0.02 0 -0.005 0.07 0 -0.025 0.005 0 -0.025 0.02 2520 0 0.07 0 -0.005 0.005 715 0 0.02 530 0 0.07 600 0 0.005 250 0 0.02 0 -0.03 0.07 0 -1.11022E-016 0.005 0 -1.11022E-016 0.02 0 -0.025 0.07 0 -0.005 0.005 865 0 0.02 0 -0.02 0.07 725 0 0.005 0 -0.02 0.02 0 -0.01 0.07 1505 0 0.005 0 -0.055 0.02 0 -0.005 0.07 0 -0.025 0.005 0 -0.05 0.02 4630 0 0.07 Allowable Increase 0.005 1.00000E+030 0 0.005 0.025 0.005 0.005 0.03 0.005 0.025 0.025 1.00000E+030 0.005 0.02 0.04 1.11022E-016 0.005 0.03 1.11022E-016 1.11022E-016 0.025 0.005 0 0.02 0.005 0.02 0.01 0.005 0.055 0.005 0.025 0.05 1.00000E+030 Allowable Decrease 1.00000E+030 0 1.00000E+030 1.00000E+030 1.00000E+030 1.00000E+030 1.00000E+030 1.00000E+030 1.00000E+030 1.00000E+030 1.00000E+030 0 1.00000E+030 0.005 0.02 0.025 1.11022E-016 1.00000E+030 1.00000E+030 1.00000E+030 1.00000E+030 1.00000E+030 0.005 1.00000E+030 1.11022E-016 1.00000E+030 1.00000E+030 1.11022E-016 1.00000E+030 1.00000E+030 1.00000E+030 1.00000E+030 0.005 Allowable Increase 2190 2190 2190 2520 715 250 250 865 725 1505 4630 715 Allowable Decrease 1.00000E+030 400 100 1.00000E+030 1.00000E+030 1.00000E+030 600 1.00000E+030 1.00000E+030 1.00000E+030 1.00000E+030 530 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 Value 2860 2750 2550 2120 1205 1600 3050 2300 1975 1670 2710 2980 Shadow Constraint Price R.H. Side -0.16 2860 -0.155 2750 -0.15 2550 -0.14 2120 -0.11 1205 -0.1 1600 -0.095 3050 -0.09 2300 -0.08 1975 -0.075 1670 -0.07 2710 -0.04 2980 Month 1 month Investment 1 2 3 4 5 6 7 8 9 10 11 12 3 month Investment 400 100 0 0 0 600 0 0 725 1505 0 Interests 16.65 Return 7 month Investment 2190 0 0 0 715 250 0 865 0 0 0 80.4 634.65 Matured 1 month Investment 0 0 400 0 100 2520 0 530 0 00 0 600 00 00 0 725 4630 1505 0 537.6 Matured 3 Matured7 month month Investment Investment Extra Income 3000 2190 0 0 0 715 250 0 865 0 0 0 0 2520 530 Salary 2450 2860 2450 2750 2450 2550 2450 2120 2450 1205 2450 1600 2450 3050 2450 2300 2450 1975 2450 1670 2450 2710 2450 2980 Net expense 2860 2750 2550 2120 1205 1600 3050 2300 1975 1670 2710 2980 Microsoft Excel 15.0 Answer Report Worksheet: [Susan Wong Template Fall 2015-McGuire-Powers.xlsx]Q2 Report Created: 11/19/2015 10:05:17 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.031 Seconds. Iterations: 17 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 Name $C$19 Return 3 month Investment Original Value Final Value 0 659.257658132 Variable 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 Integer 0 397.514912997 Contin 0 2192.485087 Contin 0 0 Contin 0 99.5024875622 Contin 0 0 Contin 0 0 Contin 0 0 Contin 0 0 Contin 0 0 Contin 0 0 Contin 0 0 Contin 0 2566.33478874 Contin 0 0 Contin 0 749.672897196 Contin 0 495.327102804 Contin 0 597.014925373 Contin 0 252.985074627 Contin 0 0 Contin 0 0 Contin 0 0 Contin 0 0 Contin 0 0 Contin 0 914.66635514 Contin 0 0 Contin 0 733.044776119 Contin 0 0 Contin 0 0 Contin 0 1516.71 Contin 0 0 Contin 0 0 Contin 0 0 Contin 0 0 Contin 0 4943.2314562 Contin 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 Name Cell Value Formula 2860 $J$3>=$K$3 2750 $J$4>=$K$4 2550 $J$5>=$K$5 2120 $J$6>=$K$6 1205 $J$7>=$K$7 1600 $J$8>=$K$8 3050 $J$9>=$K$9 2300 $J$10>=$K$10 1975 $J$11>=$K$11 1670 $J$12>=$K$12 2710 $J$13>=$K$13 2980 $J$14>=$K$14 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 15.0 Sensitivity Report Worksheet: [Susan Wong Template Fall 2015-McGuire-Powers.xlsx]Q2 Report Created: 11/19/2015 10:05:17 PM Variable 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 Value 397.514913 2192.485087 0 99.502487562 0 0 0 0 0 0 0 2566.3347887 0 749.6728972 495.3271028 597.01492537 252.98507463 0 0 0 0 0 914.66635514 0 733.04477612 0 0 1516.71 0 0 0 0 4943.2314562 Reduced Cost 0 0 0 0 -0.0264954997 -0.0056104372 -0.0055825246 -0.0318189139 -0.0055825246 -0.02610586 -0.02610586 0 -0.0053750086 0 0 0 0 -0.032341285 0 0 -0.026857 -0.0052696163 0 -0.0214 0 -0.01951875 -0.01072675 0 -0.05535 -0.00535 -0.024398 -0.05 0 Objective Allowable Allowable Coefficient Increase Decrease 0.005 0.0056384894 1.00000E+030 0.02 1.00000E+030 0 0.07 0 1.00000E+030 0.005 0.0056104372 1.00000E+030 0.02 0.0264954997 1.00000E+030 0.07 0.0056104372 1.00000E+030 0.005 0.0055825246 1.00000E+030 0.02 0.0318189139 1.00000E+030 0.07 0.0055825246 1.00000E+030 0.005 0.02610586 1.00000E+030 0.02 0.02610586 1.00000E+030 0.07 1.00000E+030 0 0.005 0.0053750086 1.00000E+030 0.02 0.0204755515 0.0053750086 0.07 0.043228 0.0204755515 0.005 0 0.0257219503 0.02 0.0053482672 0 0.07 0.032341285 1.00000E+030 0.005 0 1.00000E+030 0.02 0 1.00000E+030 0.07 0.026857 1.00000E+030 0.005 0.0052696163 1.00000E+030 0.02 0 0.0052696163 0.07 0.0214 1.00000E+030 0.005 0.0052433993 0 0.02 0.01951875 1.00000E+030 0.07 0.01072675 1.00000E+030 0.005 0 0 0.02 0.05535 1.00000E+030 0.07 0.00535 1.00000E+030 0.005 0.024398 1.00000E+030 0.02 0.05 1.00000E+030 0.07 0 0.0053233831 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.167798 2860 2192.485087 1.00000E+030 2750 -0.1619880597 2750 2203.4475124 399.50248756 2550 -0.1562070246 2550 2214.46475 100 2120 -0.1449 2120 2566.3347887 1.00000E+030 1205 -0.113228 1205 749.6728972 1.00000E+030 1600 -0.102341285 1600 252.98507463 1.00000E+030 3050 -0.096857 3050 254.25 600 2300 -0.0914 2300 914.66635514 1.00000E+030 1975 -0.08072675 1975 733.04477612 1.00000E+030 1670 -0.07535 1670 1516.71 1.00000E+030 2710 -0.07 2710 4943.2314562 1.00000E+030 2980 -0.0404 2980 802.15 530 Month 1 month Investment 1 397.514913 2 99.502487562 3 0 4 0 5 0 6 597.01492537 7 0 8 0 9 733.04477612 10 1516.71 11 0 12 3 month Investment 7 month Investment 2192.485087 0 0 0 399.50248756 0 0 100 0 2566.3347887 0 749.6728972 495.3271028 0 252.98507463 00 0 0 600 914.66635514 00 0 00 0 0 736.71 0 4943.2314562 1524.29355 0 Interests 16.71893551 82.196188279 560.34253434 Return Matured 1 month Investment 659.25765813 Matured 3 Matured7 month month Investment Investment Extra Income 3000 2236.334789 0 0 0 764.6663551 0 258.0447761 0 0 0 932.9596822 2745.978224 0 530 Salary 2450 2860 2450 2750 2450 2550 2450 2120 2450 1205 2450 1600 2450 3050 2450 2300 2450 1975 2450 1670 2450 2710 2450 2980 Net expense 2860 2750 2550 2120 1205 1600 3050 2300 1975 1670 2710 2980 Microsoft Excel 15.0 Answer Report Worksheet: [Susan Wong Template Fall 2015-McGuire-Powers.xlsx]Q1 Report Created: 11/19/2015 9:44:00 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.016 Seconds. Iterations: 13 Subproblems: 0 Solver Options Max Time 100 sec, Iterations 100, Precision 0.000001 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 5%, Assume NonNegative Objective Cell (Max) Cell Name $C$19 Return 3 month Investment Original Value 0 Final Value 634.65 Variable 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Final Value Integer 400 Contin 2190 Contin 0 Contin 100 Contin 0 Contin 0 Contin 0 Contin 0 Contin 0 Contin 0 Contin 0 Contin 2520 Contin 0 Contin 715 Contin 530 Contin 600 Contin 250 Contin 0 Contin 0 Contin 0 Contin 0 Contin 0 Contin 865 Contin 0 Contin 725 Contin 0 Contin 0 Contin 1505 Contin 0 Contin 0 Contin 0 Contin 0 Contin 4630 Contin 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 Name Cell Value Formula 2860 $J$3>=$K$3 2750 $J$4>=$K$4 2550 $J$5>=$K$5 2120 $J$6>=$K$6 1205 $J$7>=$K$7 1600 $J$8>=$K$8 3050 $J$9>=$K$9 2300 $J$10>=$K$10 1975 $J$11>=$K$11 1670 $J$12>=$K$12 2710 $J$13>=$K$13 2980 $J$14>=$K$14 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 15.0 Sensitivity Report Worksheet: [Susan Wong Template Fall 2015-McGuire-Powers.xlsx]Q1 Report Created: 11/19/2015 9:44:00 PM Variable 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 Value Cost Coefficient 400 0 0.005 2190 0 0.02 0 0 0.07 100 0 0.005 0 -0.025 0.02 0 -0.005 0.07 0 -0.005 0.005 0 -0.03 0.02 0 -0.005 0.07 0 -0.025 0.005 0 -0.025 0.02 2520 0 0.07 0 -0.005 0.005 715 0 0.02 530 0 0.07 600 0 0.005 250 0 0.02 0 -0.03 0.07 0 -1.11022E-016 0.005 0 -1.11022E-016 0.02 0 -0.025 0.07 0 -0.005 0.005 865 0 0.02 0 -0.02 0.07 725 0 0.005 0 -0.02 0.02 0 -0.01 0.07 1505 0 0.005 0 -0.055 0.02 0 -0.005 0.07 0 -0.025 0.005 0 -0.05 0.02 4630 0 0.07 Allowable Increase 0.005 1.00000E+030 0 0.005 0.025 0.005 0.005 0.03 0.005 0.025 0.025 1.00000E+030 0.005 0.02 0.04 1.11022E-016 0.005 0.03 1.11022E-016 1.11022E-016 0.025 0.005 0 0.02 0.005 0.02 0.01 0.005 0.055 0.005 0.025 0.05 1.00000E+030 Allowable Decrease 1.00000E+030 0 1.00000E+030 1.00000E+030 1.00000E+030 1.00000E+030 1.00000E+030 1.00000E+030 1.00000E+030 1.00000E+030 1.00000E+030 0 1.00000E+030 0.005 0.02 0.025 1.11022E-016 1.00000E+030 1.00000E+030 1.00000E+030 1.00000E+030 1.00000E+030 0.005 1.00000E+030 1.11022E-016 1.00000E+030 1.00000E+030 1.11022E-016 1.00000E+030 1.00000E+030 1.00000E+030 1.00000E+030 0.005 Allowable Increase 2190 2190 2190 2520 715 250 250 865 725 1505 4630 715 Allowable Decrease 1.00000E+030 400 100 1.00000E+030 1.00000E+030 1.00000E+030 600 1.00000E+030 1.00000E+030 1.00000E+030 1.00000E+030 530 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 Value 2860 2750 2550 2120 1205 1600 3050 2300 1975 1670 2710 2980 Shadow Constraint Price R.H. Side -0.16 2860 -0.155 2750 -0.15 2550 -0.14 2120 -0.11 1205 -0.1 1600 -0.095 3050 -0.09 2300 -0.08 1975 -0.075 1670 -0.07 2710 -0.04 2980 Month 1 month Investment 1 2 3 4 5 6 7 8 9 10 11 12 3 month Investment 400 100 0 0 0 600 0 0 725 1505 0 Interests 16.65 Return 7 month Investment 2190 0 0 0 715 250 0 865 0 0 0 80.4 634.65 Matured 1 month Investment 0 0 400 0 100 2520 0 530 0 00 0 600 00 00 0 725 4630 1505 0 537.6 Matured 3 Matured7 month month Investment Investment Extra Income 3000 2190 0 0 0 715 250 0 865 0 0 0 0 2520 530 Salary 2450 2860 2450 2750 2450 2550 2450 2120 2450 1205 2450 1600 2450 3050 2450 2300 2450 1975 2450 1670 2450 2710 2450 2980 Net expense 2860 2750 2550 2120 1205 1600 3050 2300 1975 1670 2710 2980 Microsoft Excel 15.0 Answer Report Worksheet: [Susan Wong Template Fall 2015-McGuire-Powers.xlsx]Q2 Report Created: 11/19/2015 10:05:17 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.031 Seconds. Iterations: 17 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 Name $C$19 Return 3 month Investment Original Value Final Value 0 659.257658132 Variable 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 Integer 0 397.514912997 Contin 0 2192.485087 Contin 0 0 Contin 0 99.5024875622 Contin 0 0 Contin 0 0 Contin 0 0 Contin 0 0 Contin 0 0 Contin 0 0 Contin 0 0 Contin 0 2566.33478874 Contin 0 0 Contin 0 749.672897196 Contin 0 495.327102804 Contin 0 597.014925373 Contin 0 252.985074627 Contin 0 0 Contin 0 0 Contin 0 0 Contin 0 0 Contin 0 0 Contin 0 914.66635514 Contin 0 0 Contin 0 733.044776119 Contin 0 0 Contin 0 0 Contin 0 1516.71 Contin 0 0 Contin 0 0 Contin 0 0 Contin 0 0 Contin 0 4943.2314562 Contin 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 Name Cell Value Formula 2860 $J$3>=$K$3 2750 $J$4>=$K$4 2550 $J$5>=$K$5 2120 $J$6>=$K$6 1205 $J$7>=$K$7 1600 $J$8>=$K$8 3050 $J$9>=$K$9 2300 $J$10>=$K$10 1975 $J$11>=$K$11 1670 $J$12>=$K$12 2710 $J$13>=$K$13 2980 $J$14>=$K$14 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 15.0 Sensitivity Report Worksheet: [Susan Wong Template Fall 2015-McGuire-Powers.xlsx]Q2 Report Created: 11/19/2015 10:05:17 PM Variable 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 Value 397.514913 2192.485087 0 99.502487562 0 0 0 0 0 0 0 2566.3347887 0 749.6728972 495.3271028 597.01492537 252.98507463 0 0 0 0 0 914.66635514 0 733.04477612 0 0 1516.71 0 0 0 0 4943.2314562 Reduced Cost 0 0 0 0 -0.0264954997 -0.0056104372 -0.0055825246 -0.0318189139 -0.0055825246 -0.02610586 -0.02610586 0 -0.0053750086 0 0 0 0 -0.032341285 0 0 -0.026857 -0.0052696163 0 -0.0214 0 -0.01951875 -0.01072675 0 -0.05535 -0.00535 -0.024398 -0.05 0 Objective Allowable Allowable Coefficient Increase Decrease 0.005 0.0056384894 1.00000E+030 0.02 1.00000E+030 0 0.07 0 1.00000E+030 0.005 0.0056104372 1.00000E+030 0.02 0.0264954997 1.00000E+030 0.07 0.0056104372 1.00000E+030 0.005 0.0055825246 1.00000E+030 0.02 0.0318189139 1.00000E+030 0.07 0.0055825246 1.00000E+030 0.005 0.02610586 1.00000E+030 0.02 0.02610586 1.00000E+030 0.07 1.00000E+030 0 0.005 0.0053750086 1.00000E+030 0.02 0.0204755515 0.0053750086 0.07 0.043228 0.0204755515 0.005 0 0.0257219503 0.02 0.0053482672 0 0.07 0.032341285 1.00000E+030 0.005 0 1.00000E+030 0.02 0 1.00000E+030 0.07 0.026857 1.00000E+030 0.005 0.0052696163 1.00000E+030 0.02 0 0.0052696163 0.07 0.0214 1.00000E+030 0.005 0.0052433993 0 0.02 0.01951875 1.00000E+030 0.07 0.01072675 1.00000E+030 0.005 0 0 0.02 0.05535 1.00000E+030 0.07 0.00535 1.00000E+030 0.005 0.024398 1.00000E+030 0.02 0.05 1.00000E+030 0.07 0 0.0053233831 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.167798 2860 2192.485087 1.00000E+030 2750 -0.1619880597 2750 2203.4475124 399.50248756 2550 -0.1562070246 2550 2214.46475 100 2120 -0.1449 2120 2566.3347887 1.00000E+030 1205 -0.113228 1205 749.6728972 1.00000E+030 1600 -0.102341285 1600 252.98507463 1.00000E+030 3050 -0.096857 3050 254.25 600 2300 -0.0914 2300 914.66635514 1.00000E+030 1975 -0.08072675 1975 733.04477612 1.00000E+030 1670 -0.07535 1670 1516.71 1.00000E+030 2710 -0.07 2710 4943.2314562 1.00000E+030 2980 -0.0404 2980 802.15 530 Month 1 month Investment 1 397.514913 2 99.502487562 3 0 4 0 5 0 6 597.01492537 7 0 8 0 9 733.04477612 10 1516.71 11 0 12 3 month Investment 7 month Investment 2192.485087 0 0 0 399.50248756 0 0 100 0 2566.3347887 0 749.6728972 495.3271028 0 252.98507463 00 0 0 600 914.66635514 00 0 00 0 0 736.71 0 4943.2314562 1524.29355 0 Interests 16.71893551 82.196188279 560.34253434 Return Matured 1 month Investment 659.25765813 Matured 3 Matured7 month month Investment Investment Extra Income 3000 2236.334789 0 0 0 764.6663551 0 258.0447761 0 0 0 932.9596822 2745.978224 0 530 Salary 2450 2860 2450 2750 2450 2550 2450 2120 2450 1205 2450 1600 2450 3050 2450 2300 2450 1975 2450 1670 2450 2710 2450 2980 Net expense 2860 2750 2550 2120 1205 1600 3050 2300 1975 1670 2710 2980