# bussing excel

## Project Description:

use this data for the final assgnment

data: percentage percentage percentage
number in 6th in 7th in 8th
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)
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

30% of total in school
<= <= <=
<= <= <=
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)
1
2
3
4

ni

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

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

of total in school
<= <= <=
<= <= <=
of total in school
Skills Required:
Project Stats:

Price Type: Fixed

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

### Proposals

Proposals Reputation Price offered
• 5.0
259 Jobs 159 Reviews
\$60 in 2 Days
• 4.8
60 Jobs 32 Reviews
\$120 in 2 Days
• 4.9
367 Jobs 233 Reviews
\$60 in 1 Day