How do you solve this using exel Exercise Score 40 of 40 phs

How do you solve this using exel??

Exercise Score: 40 of 40 phs Assignment Score: 100% (60 of 60 pts) 3 of 3 complete The Hills County, Michigan superintendent of edueation is responsable for assigning stuadents to the three high schools in his courty. He recognizes the need to bus a certain nmumber of students, for several five h sectors A-E, of the county are beyond walking distance to a school. The superintendent partisions the superintendent partitions the county into f ege graphic sectors as he attempts to establish a plant at ilmm ze totr ber of dent miles t ard d by bus He also recopte tairastatet haren to hein,catass to as assigned to the high school in that sector, there is no need to bus him because he can walk to school. The three schools are located in sectors B, C, and E. t will The accompanying table reflects the mumber of high-school age students living in each sector and the distance in miles from each sector to each schoo SectorSchool in Sector B Distance to School School in Sector C School in Sector Number of Students 700 500 100 800 400 A. 12 12 Total Each high school has a capacity of 900 students You have been asked to develop a linear programming model so as to mirimize the total mumber of student miles traveled by bus Decision variable X, Number of students Bving in sector i traveling to school located in sector The number of decision variables for the model 15 Questian is compiete. A parts showring Similar Exercise

Solution