Revised Middletown

.xlsx
Middletown School District Zoning Problem (Revised) Distance Number of Cost (Miles) School 1 School 2 School 3 Students (Miles) Tract 1 2.2 1.9 2.5 500 Tract 1 Tract 2 1.4 1.3 1.7 400 Tract 2 Tract 3 0.5 1.8 1.1 450 Tract 3 Tract 4 1.2 0.3 2 400 Tract 4 Tract 5 0.9 0.7 1 500 Tract 5 Tract 6 1.1 1.6 0.6 450 Tract 6 Tract 7 2.7 0.7 1.5 450 Tract 7 Tract 8 1.8 1.2 0.8 400 Tract 8 Tract 9 1.5 1.7 0.7 500 Tract 9 Total Assignment School 1 School 2 School 3 Assignments Supply Tract 1 0 1 0 1 = 1 Tract 2 1 0 0 1 = 1 Tract 3 1 0 0 1 = 1 Tract 4 0 1 0 1 = 1 Tract 5 1 0 0 1 = 1 Tract 6 0 0 1 1 = 1 Tract 7 0 1 0 1 = 1 Tract 8 0 0 1 1 = 1 Tract 9 0 0 1 1 = 1 Total Assigned 3 3 3 = = = Total Distance Demand 3 3 3 (Miles) 3560 A B C D E F G H 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
School 1 School 2 School 3 1100 950 1250 Range Name Cells 560 520 680 Assignment C18:E26 225 810 495 Cost I5:K13 480 120 800 Demand C29:E29 450 350 500 Distance C5:E13 495 720 270 NumberOfStudents F5:F13 1215 315 675 Supply H18:H26 720 480 320 TotalAssigned C27:E27 750 850 350 TotalAssignments F18:F26 TotalDistance H30 I J K L M N 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
Uploaded by trantony2293 on coursehero.com