$($High school busing problem$)$ The Arden County, Maryland, superintendent of education is responsible for

assighing students to the three high schools in his county. He recognizes the need to bus a certain number of

students, for several sectors of the county are beyond walking distance to a school. The superintendent

partitions the county into three geographic sectors as he attempts to establish a plan that will minimize the total

number of student miles traveled by bus. He also recognizes that if a student happens to live in a certain sector

and is assigned to the high school in that sector, there is no need to bus that student because he or she can walk

to school. The three schools are located in sectors B$,$ C$,$ and D$.$

The following table reflects the number of high$-$school$-$age students living in each sector and the distance in

miles from each sector to each school:

Each high school has a capacity of $500$ students. Please define variables and set up the objective function and

constraints of this problem using Linear Programming $($LP$)$ so that the total number of student miles traveled by

bus is minimized. $(7$ points$)$

PLEASE PROVIDE EXCEL FORMULAR WITH THE ANSWER