bussing excel

Project Description:

use this data for the final assgnment


data: percentage percentage percentage
number in 6th in 7th in 8th
area of students grade grade grade
1 400 32% 38% 30%
2 500 37% 28% 35%
3 700 30% 32% 38%
4 500 28% 40% 32%
5 600 39% 34% 27%
6 500 34% 28% 38%
7 500 37% 28% 35%
8 100 28% 32% 40%



bussing cost ($/student)
school 1 school 2 school 3 school 4
$300 $0 $700 $560
$0 $400 $500 $490
$600 $300 $200 $0 dark blue color ($0 bussing cost) indicates a no service point
$200 $500 $0 $444
$0 $0 $400 $560
$500 $300 $0 $630
$490 $0 $350 $280
$280 $440 $470 $0

capacity 1,100 800 800 1,400
maximum number of students per school

grade constraints: minimum 27% of total in school each school must have at least 27% of each grade level
maximum 40% of total in school each school must have at most 40% of each grade level

3-5 conceptual solution structure for the final assgnment
use data from first "data" worksheet only

data: percentage percentage percentage
in 6th in 7th in 8th bussing cost ($/student)
area grade grade grade school 1 school n
1
2
3
4

ni


solution: number of students assigned total number of
school 1 school n from area students
area 1 = 450
area 2 = 600
area 3 = 550
area 4 = 350
= 500
area ni = 450
total in school
<= <= <= total
capacity bussing
cost

grade constraints:
30% of total in school
<= <= <=
6th graders
7th graders
8th graders
<= <= <=
36% of total in school


7-3 ;conceptual solution structure for the final assgnment
use data from first "data" worksheet only

data: percentage percentage percentage
number in 6th in 7th in 8th bussing cost ($/student)
area of students grade grade grade school 1 school n
1
2
3
4

ni


area tasks total
school 1 school 2 school 3 tasks supply
area 1 = 1
area 2 = 1
area 3 = 1
area 4 = 1
= 1
ni = 1


student tasks
school 1 …. school n
area 1
area 2
area 3 total
area 4 bussing
cost
ni
total in school
<= <= <=
capacity


grade constraints:
of total in school
<= <= <=
6th graders 5100 0 3000
7th graders 3.08 0 1.85
8th graders 3.44 0 1.4
<= <= <=
of total in school
Skills Required:
Project Stats:

Price Type: Fixed

Project Budget: $50 to $100
Completed
Total Proposals: 3
1 Current viewersl
30 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 5.0
    214 Jobs 139 Reviews
    $60 in 2 Days
  • 4.8
    60 Jobs 32 Reviews
    $120 in 2 Days
  • 4.9
    303 Jobs 181 Reviews
    $60 in 1 Day