Spreadsheet: 885508d1735160956-springfield-school-board-assigning-students-to-schools-work
Sheet: Answer Report 1

Microsoft Excel 16.0 Answer Report
Worksheet: [Work.xlsx]Option 2 (2)
Report Created: 25/12/2024 18:35:55
Result: Solver found a solution.  All Constraints and optimality conditions are satisfied.
Solver Engine
 | Engine: [NAME]
 | Solution Time: 0.171 Seconds.
 | Iterations: 78 Subproblems: 0
Solver Options
 | [NAME],  Iterations Unlimited, Precision 0.000001, Use Automatic Scaling
 | Max Subproblems Unlimited, [NAME], [NAME] 1%, Assume NonNegative
Objective Cell (Min)
 | Cell | Name | Original Value | Final Value
 | $C$3 | OBJECTIVE | 617500 | 555555.555555559
Variable Cells
 | Cell | Name | Original Value | Final Value | [NAME]
 | $C$9 | 6th | 16 | 0 | [NAME]
 | $D$9 | 7th | 19 | 0 | [NAME]
 | $E$9 | 8th | 15 | 1.77635683940025e-15 | [NAME]
 | $F$9 | 6th | 112 | 144 | [NAME]
 | $G$9 | 7th | 133 | 171.0000000000005 | [NAME]
 | $[NAME] | 8th | 105 | 135.0000000000007 | [NAME]
 | $I$9 | 6th | 16 | -2.290231496512472e-14 | [NAME]
 | $J$9 | 7th | 19 | 2.099907549433868e-14 | [NAME]
 | $K$9 | 8th | 15 | 0 | [NAME]
 | $C$10 | 6th | 0 | 0 | [NAME]
 | $D$10 | 7th | 0 | 0 | [NAME]
 | $E$10 | 8th | 0 | 0 | [NAME]
 | $F$10 | 6th | 148 | 156.2222222222107 | [NAME]
 | $G$10 | 7th | 112 | 118.2222222222137 | [NAME]
 | $H$10 | 8th | 140 | 147.7777777777668 | [NAME]
 | $I$10 | 6th | 74 | 65.77777777778894 | [NAME]
 | $J$10 | 7th | 56 | 49.77777777778613 | [NAME]
 | $[NAME] | 8th | 70 | 62.22222222223395 | [NAME]
 | $C$11 | 6th | 15 | 2.486899575160351e-14 | [NAME]
 | $[NAME] | 7th | 16 | 4.263256414560601e-14 | [NAME]
 | $E$11 | 8th | 19 | 0 | [NAME]
 | $F$11 | 6th | 60 | 68.33333333334237 | [NAME]
 | $G$11 | 7th | 64 | 72.88888888889853 | [NAME]
 | $H$11 | 8th | 76 | 86.55555555556703 | [NAME]
 | $I$11 | 6th | 90 | 96.66666666665813 | [NAME]
 | $J$11 | 7th | 96 | 103.1111111111018 | [NAME]
 | $[NAME] | 8th | 114 | 122.444444444434 | [NAME]
 | $C$12 | 6th | 91 | 98.00000000000007 | [NAME]
 | $D$12 | 7th | 130 | 139.9999999999999 | [NAME]
 | $E$12 | 8th | 104 | 112.0000000000001 | [NAME]
 | $F$12 | 6th | 7 | 8.215650382226158e-15 | [NAME]
 | $G$12 | 7th | 10 | 8.43769498715119e-15 | [NAME]
 | $H$12 | 8th | 8 | 0 | [NAME]
 | $I$12 | 6th | 0 | 0 | [NAME]
 | $J$12 | 7th | 0 | 0 | [NAME]
 | $K$12 | 8th | 0 | 0 | [NAME]
 | $C$13 | 6th | 156 | 143.0000000000022 | [NAME]
 | $D$13 | 7th | 136 | 124.6666666666687 | [NAME]
 | $E$13 | 8th | 108 | 99.00000000000149 | [NAME]
 | $F$13 | 6th | 0 | 0 | [NAME]
 | $G$13 | 7th | 0 | 0 | [NAME]
 | $H$13 | 8th | 0 | 0 | [NAME]
 | $I$13 | 6th | 39 | 51.99999999999758 | [NAME]
 | $J$13 | 7th | 34 | 45.33333333333123 | [NAME]
 | $[NAME] | 8th | 27 | 35.99999999999831 | [NAME]
 | $C$14 | 6th | 17 | 28.33333333333281 | [NAME]
 | $D$14 | 7th | 14 | 23.3333333333329 | [NAME]
 | $E$14 | 8th | 19 | 31.66666666666608 | [NAME]
 | $F$14 | 6th | 17 | 0 | [NAME]
 | $G$14 | 7th | 14 | 4.618527782440651e-14 | [NAME]
 | $H$14 | 8th | 19 | 5.684341886080801e-14 | [NAME]
 | $I$14 | 6th | 119 | 124.6666666666672 | [NAME]
 | $J$14 | 7th | 98 | 102.6666666666671 | [NAME]
 | $K$14 | 8th | 133 | 139.3333333333339 | [NAME]
Constraints
 | Cell | Name | Cell Value | [NAME] | Status | Slack
 | $P$15 | Sub Total School 1 | 800.0000000000044 | $P$15<=$P$16 | Not Binding | 99.99999999999557
 | $Q$15 | Sub Total School 2 | 1100 | $Q$15<=$Q$16 | Binding | 0
 | $R$15 | Sub Total School 3 | 999.9999999999982 | $R$15<=$R$16 | Binding | 0
 | $C$15 | Sub Total 6th | 269.3333333333351 | $C$15>=$C$17 | Not Binding | 29.33333333333377
 | $D$15 | Sub Total 7th | 288.0000000000016 | $D$15>=$D$17 | Not Binding | 48.00000000000028
 | $E$15 | Sub Total 8th | 242.6666666666677 | $E$15>=$E$17 | Not Binding | 2.666666666666373
 | $F$15 | Sub Total 6th | 368.5555555555531 | $F$15>=$F$17 | Not Binding | 38.55555555555298
 | $[NAME] | Sub Total 7th | 362.1111111111127 | $G$15>=$G$17 | Not Binding | 32.11111111111262
 | $H$15 | Sub Total 8th | 369.3333333333347 | $H$15>=$H$17 | Not Binding | 39.33333333333456
 | $I$15 | Sub Total 6th | 339.1111111111118 | $I$15>=$I$17 | Not Binding | 39.11111111111234
 | $J$15 | Sub Total 7th | 300.8888888888862 | $J$15>=$J$17 | Not Binding | 0.888888888886811
 | $K$15 | Sub Total 8th | 360.0000000000001 | $K$15>=$K$17 | Not Binding | 60.00000000000068
 | $C$9 | 6th | 0 | $C$9=$C$21 | Binding | 0
 | $D$9 | 7th | 0 | $D$9=$D$21 | Binding | 0
 | $E$9 | 8th | 1.77635683940025e-15 | $E$9=$E$21 | Binding | 0
 | $F$9 | 6th | 144 | $F$9=$F$21 | Binding | 0
 | $G$9 | 7th | 171.0000000000005 | $G$9=$G$21 | Binding | 0
 | $[NAME] | 8th | 135.0000000000007 | $H$9=$H$21 | Binding | 0
 | $I$9 | 6th | -2.290231496512472e-14 | $I$9=$I$21 | Binding | 0
 | $J$9 | 7th | 2.099907549433868e-14 | $J$9=$J$21 | Binding | 0
 | $K$9 | 8th | 0 | $K$9=$K$21 | Binding | 0
 | $C$10 | 6th | 0 | $C$10=$C$22 | Binding | 0
 | $D$10 | 7th | 0 | $D$10=$D$22 | Binding | 0
 | $E$10 | 8th | 0 | $E$10=$E$22 | Binding | 0
 | $F$10 | 6th | 156.2222222222107 | $[NAME] | Binding | 0
 | $G$10 | 7th | 118.2222222222137 | $G$10=$G$22 | Binding | 0
 | $H$10 | 8th | 147.7777777777668 | $H$10=$H$22 | Binding | 0
 | $I$10 | 6th | 65.77777777778894 | $I$10=$I$22 | Binding | 0
 | $J$10 | 7th | 49.77777777778613 | $J$10=$J$22 | Binding | 0
 | $[NAME] | 8th | 62.22222222223395 | $K$10=$K$22 | Binding | 0
 | $C$11 | 6th | 2.486899575160351e-14 | $C$11=$C$23 | Binding | 0
 | $[NAME] | 7th | 4.263256414560601e-14 | $D$11=$D$23 | Binding | 0
 | $E$11 | 8th | 0 | $E$11=$E$23 | Binding | 0
 | $F$11 | 6th | 68.33333333334237 | $F$11=$F$23 | Binding | 0
 | $G$11 | 7th | 72.88888888889853 | $G$11=$G$23 | Binding | 0
 | $H$11 | 8th | 86.55555555556703 | $H$11=$H$23 | Binding | 0
 | $I$11 | 6th | 96.66666666665813 | $I$11=$I$23 | Binding | 0
 | $J$11 | 7th | 103.1111111111018 | $J$11=$J$23 | Binding | 0
 | $[NAME] | 8th | 122.444444444434 | $[NAME] | Binding | 0
 | $C$12 | 6th | 98.00000000000007 | $C$12=$C$24 | Binding | 0
 | $D$12 | 7th | 139.9999999999999 | $D$12=$D$24 | Binding | 0
 | $E$12 | 8th | 112.0000000000001 | $E$12=$E$24 | Binding | 0
 | $F$12 | 6th | 8.215650382226158e-15 | $F$12=$F$24 | Binding | 0
 | $G$12 | 7th | 8.43769498715119e-15 | $[NAME] | Binding | 0
 | $H$12 | 8th | 0 | $H$12=$H$24 | Binding | 0
 | $I$12 | 6th | 0 | $I$12=$I$24 | Binding | 0
 | $J$12 | 7th | 0 | $[NAME] | Binding | 0
 | $K$12 | 8th | 0 | $[NAME] | Binding | 0
 | $C$13 | 6th | 143.0000000000022 | $C$13=$C$25 | Binding | 0
 | $D$13 | 7th | 124.6666666666687 | $[NAME] | Binding | 0
 | $E$13 | 8th | 99.00000000000149 | $E$13=$E$25 | Binding | 0
 | $F$13 | 6th | 0 | $F$13=$F$25 | Binding | 0
 | $G$13 | 7th | 0 | $G$13=$G$25 | Binding | 0
 | $H$13 | 8th | 0 | $H$13=$H$25 | Binding | 0
 | $I$13 | 6th | 51.99999999999758 | $I$13=$I$25 | Binding | 0
 | $J$13 | 7th | 45.33333333333123 | $J$13=$J$25 | Binding | 0
 | $[NAME] | 8th | 35.99999999999831 | $K$13=$K$25 | Binding | 0
 | $C$14 | 6th | 28.33333333333281 | $C$14=$C$26 | Binding | 0
 | $D$14 | 7th | 23.3333333333329 | $D$14=$D$26 | Binding | 0
 | $E$14 | 8th | 31.66666666666608 | $E$14=$E$26 | Binding | 0
 | $F$14 | 6th | 0 | $F$14=$F$26 | Binding | 0
 | $G$14 | 7th | 4.618527782440651e-14 | $G$14=$G$26 | Binding | 0
 | $H$14 | 8th | 5.684341886080801e-14 | $H$14=$H$26 | Binding | 0
 | $I$14 | 6th | 124.6666666666672 | $I$14=$I$26 | Binding | 0
 | $J$14 | 7th | 102.6666666666671 | $J$14=$J$26 | Binding | 0
 | $K$14 | 8th | 139.3333333333339 | $[NAME] | Binding | 0
 | $C$15 | Sub Total 6th | 269.3333333333351 | $C$15<=$C$16 | Not Binding | 18.66666666666652
 | $D$15 | Sub Total 7th | 288.0000000000016 | $[NAME] | Binding | 0
 | $E$15 | Sub Total 8th | 242.6666666666677 | $E$15<=$E$16 | Not Binding | 45.33333333333391
 | $F$15 | Sub Total 6th | 368.5555555555531 | $F$15<=$F$16 | Not Binding | 27.44444444444707
 | $[NAME] | Sub Total 7th | 362.1111111111127 | $G$15<=$G$16 | Not Binding | 33.88888888888744
 | $H$15 | Sub Total 8th | 369.3333333333347 | $H$15<=$H$16 | Not Binding | 26.66666666666549
 | $I$15 | Sub Total 6th | 339.1111111111118 | $I$15<=$I$16 | Not Binding | 20.88888888888755
 | $J$15 | Sub Total 7th | 300.8888888888862 | $J$15<=$J$16 | Not Binding | 59.11111111111308
 | $K$15 | Sub Total 8th | 360.0000000000001 | $[NAME] | Binding | 0
 | $[NAME] | Total per area | 450.0000000000013 | $L$9=$N$9 | Binding | 0
 | $L$10 | Total per area | 600.0000000000002 | $[NAME] | Binding | 0
 | $L$11 | Total per area | 550.0000000000018 | $L$11=$N$11 | Binding | 0
 | $L$12 | Total per area | 350.0000000000001 | $L$12=$N$12 | Binding | 0
 | $L$13 | Total per area | 499.9999999999995 | $[NAME] | Binding | 0
 | $L$14 | Total per area | 450.0000000000001 | $[NAME] | Binding | 0