Spreadsheet: 885511d1735173893-springfield-school-board-assigning-students-to-schools-work-corrected
Sheet: Answer Report 2

Microsoft Excel 16.0 Answer Report
Worksheet: [Work.xlsx]Option 2
Report Created: 25/12/2024 18:36:46
Result: Solver found a solution.  All Constraints and optimality conditions are satisfied.
Solver Engine
 | Engine: [NAME]
 | Solution Time: 26.297 Seconds.
 | Iterations: 6 Subproblems: 4574
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 | 617500
Variable Cells
 | Cell | Name | Original Value | Final Value | [NAME]
 | $C$9 | 6th | 16 | 16 | [NAME]
 | $D$9 | 7th | 19 | 19 | [NAME]
 | $E$9 | 8th | 15 | 15 | [NAME]
 | $F$9 | 6th | 112 | 112 | [NAME]
 | $G$9 | 7th | 133 | 133 | [NAME]
 | $[NAME] | 8th | 105 | 105 | [NAME]
 | $I$9 | 6th | 16 | 16 | [NAME]
 | $J$9 | 7th | 19 | 19 | [NAME]
 | $K$9 | 8th | 15 | 15 | [NAME]
 | $C$10 | 6th | 0 | 0 | [NAME]
 | $D$10 | 7th | 0 | 0 | [NAME]
 | $E$10 | 8th | 0 | 0 | [NAME]
 | $F$10 | 6th | 148 | 148 | [NAME]
 | $G$10 | 7th | 112 | 112 | [NAME]
 | $H$10 | 8th | 140 | 140 | [NAME]
 | $I$10 | 6th | 74 | 74 | [NAME]
 | $J$10 | 7th | 56 | 56 | [NAME]
 | $[NAME] | 8th | 70 | 70 | [NAME]
 | $C$11 | 6th | 15 | 15 | [NAME]
 | $[NAME] | 7th | 16 | 16 | [NAME]
 | $E$11 | 8th | 19 | 19 | [NAME]
 | $F$11 | 6th | 60 | 60 | [NAME]
 | $G$11 | 7th | 64 | 64 | [NAME]
 | $H$11 | 8th | 76 | 76 | [NAME]
 | $I$11 | 6th | 90 | 90 | [NAME]
 | $J$11 | 7th | 96 | 96 | [NAME]
 | $[NAME] | 8th | 114 | 114 | [NAME]
 | $C$12 | 6th | 91 | 91 | [NAME]
 | $D$12 | 7th | 130 | 130 | [NAME]
 | $E$12 | 8th | 104 | 104 | [NAME]
 | $F$12 | 6th | 7 | 7 | [NAME]
 | $G$12 | 7th | 10 | 10 | [NAME]
 | $H$12 | 8th | 8 | 8 | [NAME]
 | $I$12 | 6th | 0 | 0 | [NAME]
 | $J$12 | 7th | 0 | 0 | [NAME]
 | $K$12 | 8th | 0 | 0 | [NAME]
 | $C$13 | 6th | 156 | 156 | [NAME]
 | $D$13 | 7th | 136 | 136 | [NAME]
 | $E$13 | 8th | 108 | 108 | [NAME]
 | $F$13 | 6th | 0 | 0 | [NAME]
 | $G$13 | 7th | 0 | 0 | [NAME]
 | $H$13 | 8th | 0 | 0 | [NAME]
 | $I$13 | 6th | 39 | 39 | [NAME]
 | $J$13 | 7th | 34 | 34 | [NAME]
 | $[NAME] | 8th | 27 | 27 | [NAME]
 | $C$14 | 6th | 17 | 17 | [NAME]
 | $D$14 | 7th | 14 | 14 | [NAME]
 | $E$14 | 8th | 19 | 19 | [NAME]
 | $F$14 | 6th | 17 | 17 | [NAME]
 | $G$14 | 7th | 14 | 14 | [NAME]
 | $H$14 | 8th | 19 | 19 | [NAME]
 | $I$14 | 6th | 119 | 119 | [NAME]
 | $J$14 | 7th | 98 | 98 | [NAME]
 | $K$14 | 8th | 133 | 133 | [NAME]
Constraints
 | Cell | Name | Cell Value | [NAME] | Status | Slack
 | $P$15 | Sub Total School 1 | 875 | $P$15<=$P$16 | Not Binding | 25
 | $Q$15 | Sub Total School 2 | 1025 | $Q$15<=$Q$16 | Not Binding | 75
 | $R$15 | Sub Total School 3 | 1000 | $R$15<=$R$16 | Binding | 0
 | $T$10 | "=" School 1 | 50 | $T$10>=1 | Not Binding | 49
 | $U$10 | "=" School 2 | 350 | $[NAME] | Not Binding | 349
 | $V$10 | "=" School 3 | 50 | $V$10>=1 | Not Binding | 49
 | $T$11 | "=" School 1 | 50 | $[NAME] | Not Binding | 49
 | $U$11 | "=" School 2 | 400 | $U$11>=1 | Not Binding | 399
 | $[NAME] | "=" School 3 | 200 | $V$11>=1 | Not Binding | 199
 | $T$12 | "=" School 1 | 325 | $[NAME] | Not Binding | 324
 | $U$12 | "=" School 2 | 200 | $U$12>=1 | Not Binding | 199
 | $V$12 | "=" School 3 | 300 | $[NAME] | Not Binding | 299
 | $T$13 | "=" School 1 | 400 | $T$13>=1 | Not Binding | 399
 | $U$13 | "=" School 2 | 25 | $U$13>=1 | Not Binding | 24
 | $[NAME] | "=" School 3 | 100 | $V$13>=1 | Not Binding | 99
 | $T$14 | "=" School 1 | 50 | $[NAME] | Not Binding | 49
 | $[NAME] | "=" School 2 | 50 | $U$14>=1 | Not Binding | 49
 | $V$14 | "=" School 3 | 350 | $V$14>=1 | Not Binding | 349
 | $C$15 | Sub Total 6th | 295 | $C$15>=$C$17 | Not Binding | 32.5
 | $D$15 | Sub Total 7th | 315 | $D$15>=$D$17 | Not Binding | 52.5
 | $E$15 | Sub Total 8th | 265 | $E$15>=$E$17 | Not Binding | 2.5
 | $F$15 | Sub Total 6th | 344 | $F$15>=$F$17 | Not Binding | 36.5
 | $[NAME] | Sub Total 7th | 333 | $G$15>=$G$17 | Not Binding | 25.5
 | $H$15 | Sub Total 8th | 348 | $H$15>=$H$17 | Not Binding | 40.5
 | $I$15 | Sub Total 6th | 338 | $I$15>=$I$17 | Not Binding | 38
 | $J$15 | Sub Total 7th | 303 | $J$15>=$J$17 | Not Binding | 3
 | $K$15 | Sub Total 8th | 359 | $K$15>=$K$17 | Not Binding | 59
 | $C$9 | 6th | 16 | $C$9=$C$21 | Binding | 0
 | $D$9 | 7th | 19 | $D$9=$D$21 | Binding | 0
 | $E$9 | 8th | 15 | $E$9=$E$21 | Binding | 0
 | $F$9 | 6th | 112 | $F$9=$F$21 | Binding | 0
 | $G$9 | 7th | 133 | $G$9=$G$21 | Binding | 0
 | $[NAME] | 8th | 105 | $H$9=$H$21 | Binding | 0
 | $I$9 | 6th | 16 | $I$9=$I$21 | Binding | 0
 | $J$9 | 7th | 19 | $J$9=$J$21 | Binding | 0
 | $K$9 | 8th | 15 | $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 | 148 | $[NAME] | Binding | 0
 | $G$10 | 7th | 112 | $G$10=$G$22 | Binding | 0
 | $H$10 | 8th | 140 | $H$10=$H$22 | Binding | 0
 | $I$10 | 6th | 74 | $I$10=$I$22 | Binding | 0
 | $J$10 | 7th | 56 | $J$10=$J$22 | Binding | 0
 | $[NAME] | 8th | 70 | $K$10=$K$22 | Binding | 0
 | $C$11 | 6th | 15 | $C$11=$C$23 | Binding | 0
 | $[NAME] | 7th | 16 | $D$11=$D$23 | Binding | 0
 | $E$11 | 8th | 19 | $E$11=$E$23 | Binding | 0
 | $F$11 | 6th | 60 | $F$11=$F$23 | Binding | 0
 | $G$11 | 7th | 64 | $G$11=$G$23 | Binding | 0
 | $H$11 | 8th | 76 | $H$11=$H$23 | Binding | 0
 | $I$11 | 6th | 90 | $I$11=$I$23 | Binding | 0
 | $J$11 | 7th | 96 | $J$11=$J$23 | Binding | 0
 | $[NAME] | 8th | 114 | $[NAME] | Binding | 0
 | $C$12 | 6th | 91 | $C$12=$C$24 | Binding | 0
 | $D$12 | 7th | 130 | $D$12=$D$24 | Binding | 0
 | $E$12 | 8th | 104 | $E$12=$E$24 | Binding | 0
 | $F$12 | 6th | 7 | $F$12=$F$24 | Binding | 0
 | $G$12 | 7th | 10 | $[NAME] | Binding | 0
 | $H$12 | 8th | 8 | $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 | 156 | $C$13=$C$25 | Binding | 0
 | $D$13 | 7th | 136 | $[NAME] | Binding | 0
 | $E$13 | 8th | 108 | $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 | 39 | $I$13=$I$25 | Binding | 0
 | $J$13 | 7th | 34 | $J$13=$J$25 | Binding | 0
 | $[NAME] | 8th | 27 | $K$13=$K$25 | Binding | 0
 | $C$14 | 6th | 17 | $C$14=$C$26 | Binding | 0
 | $D$14 | 7th | 14 | $D$14=$D$26 | Binding | 0
 | $E$14 | 8th | 19 | $E$14=$E$26 | Binding | 0
 | $F$14 | 6th | 17 | $F$14=$F$26 | Binding | 0
 | $G$14 | 7th | 14 | $G$14=$G$26 | Binding | 0
 | $H$14 | 8th | 19 | $H$14=$H$26 | Binding | 0
 | $I$14 | 6th | 119 | $I$14=$I$26 | Binding | 0
 | $J$14 | 7th | 98 | $J$14=$J$26 | Binding | 0
 | $K$14 | 8th | 133 | $[NAME] | Binding | 0
 | $C$15 | Sub Total 6th | 295 | $C$15<=$C$16 | Not Binding | 20
 | $D$15 | Sub Total 7th | 315 | $[NAME] | Binding | 0
 | $E$15 | Sub Total 8th | 265 | $E$15<=$E$16 | Not Binding | 50
 | $F$15 | Sub Total 6th | 344 | $F$15<=$F$16 | Not Binding | 25
 | $[NAME] | Sub Total 7th | 333 | $G$15<=$G$16 | Not Binding | 36
 | $H$15 | Sub Total 8th | 348 | $H$15<=$H$16 | Not Binding | 21
 | $I$15 | Sub Total 6th | 338 | $I$15<=$I$16 | Not Binding | 22
 | $J$15 | Sub Total 7th | 303 | $J$15<=$J$16 | Not Binding | 57
 | $K$15 | Sub Total 8th | 359 | $[NAME] | Not Binding | 1
 | $[NAME] | Total per area | 450 | $L$9=$N$9 | Binding | 0
 | $L$10 | Total per area | 600 | $[NAME] | Binding | 0
 | $L$11 | Total per area | 550 | $L$11=$N$11 | Binding | 0
 | $L$12 | Total per area | 350 | $L$12=$N$12 | Binding | 0
 | $L$13 | Total per area | 500 | $[NAME] | Binding | 0
 | $L$14 | Total per area | 450 | $[NAME] | Binding | 0
 | $C$9:$K$14=Integer