Please solve in detail on excel. thank you!

OAKDALE County SCIOoL Busing T he Ouldale County School Baard was mecting in special sexioe. A federal jodge had ondered the boand to present an acceptable tuxing plan for racially balancing the four Migh schools in Oakdale Coanty within a weck. The jadge had previotedy givea the school hoard sevenal opportunities to infornally procet a plan, bot the mem: bers had been unakle to agree amning themselves. Every time they mer and isarted to develop a plan to bor dracters from aee high school disurict to ancher, an argunent would arise before they fot past the find busing move, and they would adjours the mecting. This time, however, they linew the jodge had lest patiesce and they had to apres on wamething. Or the four schools, enfy Weut High School was racially halanced, with 500 white stukents and $00 black audents. Niarih High School hat 1,000 while sladents and oely 300 black dadents; Eact High Schood wan almod as bad, will 1,050 whic stodests and 400 black sudents, South High School was prodominantly black, with 100 black atadears Oabdale Coanh, 60% ware while and 40h Mack: Look; - wid John Ccanor, a school bound manker from the West dintrict, rather than sarting edr by inging to be exablidh what we want so acoomplish-you linow, what oar goals anc? Sevenal of the other member endiled in agroences, and Frod Harvey, the boord chairman, said, "Good idea, Jhe" said. Sisfy percetit of our sudents are whike, and wors are black, so thar's what we noed our schools to the, tork and 40F tecause your district has those propeetices already 0 you won't have any bening. But ewy ditund in the North is a kong way from that ratio, and we wooll have ss bes a Jat of cor students to achicve a tor:/40R ratia" "Twe not aying it, Betry," aid John. That is hanically "Johin's righ, Berly, and we're not buting sfudenis yct. we're junt putting donin our objectives," aid Fred. T think. that has io be our highed-priority chjoctive. How about the eal of you? They all nodked their agreement, even Berty Philips. refuctanify. "Since we tinow we're goileg to have to bus sodents to achieve this ratio at each school, I think we eught to ty ta minimize the amouint of traveling the sudents will have to de," wepreated Micicy Cibboncy, a member from the South district. Fred Harvey nuted that page 30 of their handout had a chart showieg the avorape mikeage a stadent in one distrit would have io travel on a bun to the high schoot in exch of the obcr distakts. The chart koded like this: Why dan'i we try to wet same reasomahle ebjoctives for total touing miles, for the shasknts' sale and for trod. teut abou 30.000 miles per day, hased ob the miles we has sudents now. If we get mach higher than that, we're not gaing to have the rocesy to pay for it, and it means we'll be The obor memher nodided and apreet. foal" Betey Fatips spole up again. -IH icll you ancether thing ing at Nonth lfigh School. We have 100 students noee than capacity nowk" "You think you have problems mob Wifkne Beflained. Th East we lave 1,450 stodicnts and capacily for 1,000. Think no evercronding is a great idea? Tagrec," sid Michey Gibbency." "We'te 250 oner aur capaciry it South High Schocit" Thatha tice idea," John Conihar roponded sand Ireal. We that we have 200 sualents less than ear capaciry 3 Wica High School. However, let"s face it, in the couery we have capacily for 4,400 , nos 5,6m, students, wo there's poeng wo the some evercrouding. I think our obycative should be duat all foer schoxis share is the ostroronding proporticeally"- That soends reasonatle so me," said Frad Harvey? How akout the reut of you? Oby to syy our number-ibre goal is to be as clone to capacity at each school as poscile bet ahare proparticanally in the everrowding? They all woiked their aproval "Well," Nho Consor conctuded, 7 think we kave ides. s.fied the thises we want to accomplish in car plan. Now If we could jeat aie noene magic trisk to fiod a plan for busing sudeets heraeen die divincts that would acticve all these goals:- Nin ochers anded and fruwned. A. Fonnulate a gaul progrannung mod -il io help the board with its dilenana. B. Solve the gual propratninity model by unint the compeler OAKDALE County SCIOoL Busing T he Ouldale County School Baard was mecting in special sexioe. A federal jodge had ondered the boand to present an acceptable tuxing plan for racially balancing the four Migh schools in Oakdale Coanty within a weck. The jadge had previotedy givea the school hoard sevenal opportunities to infornally procet a plan, bot the mem: bers had been unakle to agree amning themselves. Every time they mer and isarted to develop a plan to bor dracters from aee high school disurict to ancher, an argunent would arise before they fot past the find busing move, and they would adjours the mecting. This time, however, they linew the jodge had lest patiesce and they had to apres on wamething. Or the four schools, enfy Weut High School was racially halanced, with 500 white stukents and $00 black audents. Niarih High School hat 1,000 while sladents and oely 300 black dadents; Eact High Schood wan almod as bad, will 1,050 whic stodests and 400 black sudents, South High School was prodominantly black, with 100 black atadears Oabdale Coanh, 60% ware while and 40h Mack: Look; - wid John Ccanor, a school bound manker from the West dintrict, rather than sarting edr by inging to be exablidh what we want so acoomplish-you linow, what oar goals anc? Sevenal of the other member endiled in agroences, and Frod Harvey, the boord chairman, said, "Good idea, Jhe" said. Sisfy percetit of our sudents are whike, and wors are black, so thar's what we noed our schools to the, tork and 40F tecause your district has those propeetices already 0 you won't have any bening. But ewy ditund in the North is a kong way from that ratio, and we wooll have ss bes a Jat of cor students to achicve a tor:/40R ratia" "Twe not aying it, Betry," aid John. That is hanically "Johin's righ, Berly, and we're not buting sfudenis yct. we're junt putting donin our objectives," aid Fred. T think. that has io be our highed-priority chjoctive. How about the eal of you? They all nodked their agreement, even Berty Philips. refuctanify. "Since we tinow we're goileg to have to bus sodents to achieve this ratio at each school, I think we eught to ty ta minimize the amouint of traveling the sudents will have to de," wepreated Micicy Cibboncy, a member from the South district. Fred Harvey nuted that page 30 of their handout had a chart showieg the avorape mikeage a stadent in one distrit would have io travel on a bun to the high schoot in exch of the obcr distakts. The chart koded like this: Why dan'i we try to wet same reasomahle ebjoctives for total touing miles, for the shasknts' sale and for trod. teut abou 30.000 miles per day, hased ob the miles we has sudents now. If we get mach higher than that, we're not gaing to have the rocesy to pay for it, and it means we'll be The obor memher nodided and apreet. foal" Betey Fatips spole up again. -IH icll you ancether thing ing at Nonth lfigh School. We have 100 students noee than capacity nowk" "You think you have problems mob Wifkne Beflained. Th East we lave 1,450 stodicnts and capacily for 1,000. Think no evercronding is a great idea? Tagrec," sid Michey Gibbency." "We'te 250 oner aur capaciry it South High Schocit" Thatha tice idea," John Conihar roponded sand Ireal. We that we have 200 sualents less than ear capaciry 3 Wica High School. However, let"s face it, in the couery we have capacily for 4,400 , nos 5,6m, students, wo there's poeng wo the some evercrouding. I think our obycative should be duat all foer schoxis share is the ostroronding proporticeally"- That soends reasonatle so me," said Frad Harvey? How akout the reut of you? Oby to syy our number-ibre goal is to be as clone to capacity at each school as poscile bet ahare proparticanally in the everrowding? They all woiked their aproval "Well," Nho Consor conctuded, 7 think we kave ides. s.fied the thises we want to accomplish in car plan. Now If we could jeat aie noene magic trisk to fiod a plan for busing sudeets heraeen die divincts that would acticve all these goals:- Nin ochers anded and fruwned. A. Fonnulate a gaul progrannung mod -il io help the board with its dilenana. B. Solve the gual propratninity model by unint the compeler