| Microsoft Excel 9.0 Sensitivity Report | |||||||
| Worksheet: [Voting Problem.xls]Sheet1 | |||||||
| Report Created: 12/3/2001 3:56:55 PM | |||||||
| Adjustable Cells | |||||||
| Final | Reduced | Objective | Allowable | Allowable | |||
| Cell | Name | Value | Cost | Coefficient | Increase | Decrease | |
| $C$10 | Arkansas $ | 0 | 0 | 0 | 0 | 1E+30 | |
| $C$11 | Delaware $ | 0 | 0 | 0 | 0 | 1E+30 | |
| $C$12 | Florida $ | 0 | 0 | 0 | 0 | 1E+30 | |
| $C$13 | Illinois $ | 0 | 0 | 0 | 0 | 1E+30 | |
| $C$14 | Iowa $ | 0 | 0 | 0 | 0 | 1E+30 | |
| $C$15 | Maine $ | 0 | 0 | 0 | 0 | 1E+30 | |
| $C$16 | Missouri $ | 0 | 0 | 0 | 0 | 1E+30 | |
| $C$17 | Pennsylvania $ | 0 | 0 | 0 | 0 | 1E+30 | |
| $C$18 | Tennessee $ | 0 | 0 | 0 | 0 | 1E+30 | |
| $C$19 | Michigan $ | 0 | 0 | 0 | 0 | 1E+30 | |
| $C$20 | Nevada $ | 0 | 0 | 0 | 0 | 1E+30 | |
| $C$21 | New Mexico $ | 0 | 0 | 0 | 0 | 1E+30 | |
| $C$22 | Oregon $ | 0 | 0 | 0 | 0 | 1E+30 | |
| $C$23 | Washington $ | 0 | 0 | 0 | 0 | 1E+30 | |
| $C$24 | West Virginia $ | 0 | 0 | 0 | 0 | 1E+30 | |
| $C$25 | Wisconsin $ | 0 | 0 | 0 | 0 | 1E+30 | |
| Constraints | |||||||
| Final | Shadow | Constraint | Allowable | Allowable | |||
| Cell | Name | Value | Price | R.H. Side | Increase | Decrease | |
| $C$26 | $ | 0 | 0 | 5000000 | 1E+30 | 5000000 | |
| $F$50 | Arkansas Constraint | 0 | 0 | 1 | 1E+30 | 1 | |
| $F$51 | Delaware Constraint | 0 | 0 | 1 | 1E+30 | 1 | |
| $F$52 | Florida Constraint | 1 | 0 | 1 | 1E+30 | 0 | |
| $F$53 | Illinois Constraint | 1 | 0 | 1 | 1E+30 | 0 | |
| $F$54 | Iowa Constraint | 0 | 0 | 1 | 1E+30 | 1 | |
| $F$55 | Maine Constraint | 0 | 0 | 1 | 1E+30 | 1 | |
| $F$56 | Missouri Constraint | 1 | 0 | 1 | 1E+30 | 0 | |
| $F$57 | Pennsylvania Constraint | 0 | 0 | 1 | 1E+30 | 1 | |
| $F$58 | Tennessee Constraint | 0 | 0 | 1 | 1E+30 | 1 | |
| $F$59 | Michigan Constraint | 1 | 0 | 1 | 1E+30 | 0 | |
| $F$60 | Nevada Constraint | 0 | 0 | 1 | 1E+30 | 1 | |
| $F$61 | New Mexico Constraint | 0 | 0 | 1 | 1E+30 | 1 | |
| $F$62 | Oregon Constraint | 0 | 0 | 1 | 1E+30 | 1 | |
| $F$63 | Washington Constraint | 1 | 0 | 1 | 1E+30 | 0 | |
| $F$64 | West Virginia Constraint | 0 | 0 | 1 | 1E+30 | 1 | |
| $F$65 | Wisconsin Constraint | 0 | 0 | 1 | 1E+30 | 1 | |
| $K$30 | Arkansas sum | 1 | 0 | 1 | 1E+30 | 0 | |
| $K$31 | Delaware sum | 0 | 0 | 1 | 1E+30 | 1 | |
| $K$32 | Florida sum | 1 | 0 | 1 | 1E+30 | 0 | |
| $K$33 | Illinois sum | 1 | 0 | 1 | 1E+30 | 0 | |
| $K$34 | Iowa sum | 0 | 0 | 1 | 1E+30 | 1 | |
| $K$35 | Maine sum | 0 | 0 | 1 | 1E+30 | 1 | |
| $K$36 | Missouri sum | 1 | 0 | 1 | 1E+30 | 0 | |
| $K$37 | Pennsylvania sum | 0 | 0 | 1 | 1E+30 | 1 | |
| $K$38 | Tennessee sum | 1 | 0 | 1 | 1E+30 | 0 | |
| $K$39 | Michigan sum | 1 | 0 | 1 | 1E+30 | 0 | |
| $K$40 | Nevada sum | 0 | 0 | 1 | 1E+30 | 1 | |
| $K$41 | New Mexico sum | 0 | 0 | 1 | 1E+30 | 1 | |
| $K$42 | Oregon sum | 0 | 0 | 1 | 1E+30 | 1 | |
| $K$43 | Washington sum | 1 | 0 | 1 | 1E+30 | 0 | |
| $K$44 | West Virginia sum | 0 | 0 | 1 | 1E+30 | 1 | |
| $K$45 | Wisconsin sum | 0 | 0 | 1 | 1E+30 | 1 | |