Question: A school district must determine which students from each of the four attendance zones will attend which of the three high schools. The north attendance

A school district must determine which students from each of the four attendance zones will attend which of the three high schools. The north attendance zone is 8 miles from Central High School, 4 miles from Northwestern High School, and 16 miles from Southeastern High School. All of the distances (in miles) are shown in the following table.

Each school can have as many as 1,200 students enrolled. The school district would like to make the allocation of students to schools that will minimize the number of miles necessary to transport the students.

ATTENDANCE ZONE NORTH SOUTH EAST WEST Central High School 8 4 17 15 Northwestern High School Southeastern High School 16 18 Number of Students 903 741 923793

Step by Step Solution

★★★★★

3.27 Rating (179 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style16 msonumberformat 000 000 00220022 msostylenameComma msostyleid3 style0 msonumberformatGeneral textaligngeneral vertical... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

718-M-S-L-P (1056).xlsx

300 KBs Excel File

Students Have Also Explored These Related Statistics Questions!

The school district in Problem 3-46 wishes to impose an additional constraint on the problem: It wants to enroll the same number of students in each of the three schools. Solve for the revised...

Refer to Exercise 14.9. Another study was conducted in the following way. Students from each of the high schools who were admitted to the business program were matched according to their high school...

After deciding to close one of its middle schools, the Springfield school board needs to reassign all of next years middle school students to the three remaining middle schools. Many of the students...

46 A school district must determine which students from each of the four attendance zones will attend which of the three high schools. The north attendance zone is 8 miles from Central High School, 4...

3.46 A school district must determine which students from each of the four attendance zones will attend which of the three high schools. The north attendance zone is 8 miles from Central High School,...

LINEAR PROGRAMMING MODELING APPLICATIONS WITH COMPUTER ANALYSES IN EXC Table for Problem 45 CUSTOMERS ($ PER UNIT SHIPPED) PLANT SAVANNAH MOBILE ROANOKE AVAILABLE posn tou Sh#14 $42 $38 450 Columbia...

I need to be able to put this into an excel chart and figure out the constraints for with the inequalities then using solver, similar to the chart example provided below. CS 250 CM 0 42.00 CR 0 38.00...

A school district must determine which students from each of the four attendance zones will attend which of the three high schools. The north atten- dance zone is 8 miles from Central High School, 4...

2. City X has three high schools, each with a capacity of 1,200 students. There are five districts in the city with different high school student populations-north, south, east, west, and central....

Accounts receivable are usually valued on the balance sheet at current value-namely, the amount owing from customers less an allowance for uncollectible accounts. Does this violate the historical...

What is fractional reserve banking, and why is it the key to bank profits? (Hint: What opportunities to make profits would banks lose if reserve requirements were 100 percent?) Why does fractional...

2.48 The following is a set of data from a sample of n = 11 countries selected for analyzing the relationship between fertility rate and median age. Median age: 17.8 18.4 17.9 14.4 17.0 16.3 15.9...

Exercise G Stuart Company purchased goods for USD 84,000 on June 14, under the following terms: 3/10, n/ 30; FOB shipping point, freight collect. The bill for the freight was paid on June 15, USD...

12 Rockwell Electronics Corporation retains a service crew to repair machine breakdowns that occur on an average of l = 3 per day (approximately Poisson in nature). The crew can service an average of...

11 From historical data, Harrys Car Wash estimates that dirty cars arrive at a rate of 10 per hour all day Saturday. With a crew working the wash line, Harry figures that cars can be cleaned at a...

4 Why must the service rate be greater than the arrival rate in a single-server queuing system?

Here is a recursive method for counting all zeroes in an array starting with a given position: public static int zeroes ( int [ ] a , int pos ) { if ( pos = = a . length ) { return 0 ; } int result =...

3. Profitability ratios Profitability ratios help in the analysis of the combined impact of liquidity ratios, asset management ratios, and debt management ratios on the operating performance of a...

please show all calucations clearly, thank you!! financial calculator inputs if possible as well 12. You are considering two independent projects with the following cash flows. The required return...