Please attach excel/spreedsheet or screenshot it to show excel solver.

A&B have already done.

The Springfield School Board has made the decision to close one of its middle schools (sixth, seventh, and eighth grades) at the end of this school year and reassign all of next years middle school student to the three remaining middle schools. The school district provides busing for all middle school students who must travel more than approximately a mile, so the school board wants a plan for reassigning the students that will minimize the total busing cost. The annual cost per student for busing from each of the six residential areas of the city to each of the schools is shown in the following table (along with other basic data for next year), where 0 indicates that busing is not needed and a dash indicates an infeasible assignment.

					Busing Cost per Student
Area	# of students	% in 6th grade	% in 7th grade	% in 8th grade	School 1	School 2	School 3
1	450	32	38	30	$300	$0	$700
2	600	37	28	35	-	400	500
3	550	30	32	38	600	300	200
4	350	28	40	32	200	500	-
5	500	39	34	27	0	-	400
6	450	34	28	38	500	300	0
School Capacity:					900	1,100	1,000

The school board also has imposed the restriction that each grade must constitute between 30 and 36% of each schools population. The above table shows the % of each areas middle school population for next year that falls into each of the three grades. The school attendance zone boundaries can be drawn so as to split any given area among more than one school but assume that the % shown in the table will continue to hold for any partial assignment of an area to a school.

You have been hired as a management science consultant to assist the school board in determining how many students in each area should assigned to each school.

a. Formulate and solve a linear programming model for this problem.

b. What is your resulting recommendation to the school board?

After seeing your recommendation, the school board expressed concern about all the splitting of residential areas among multiple schools. They indicate that they would like to keep each neighborhood together.

c. Adjust your recommendation as well as you can to enable each area to be assigned to just one school. (Adding this restriction may force you to fudge on some other constraints.)