Question: You are trying to help the MCSCC (Monroe County School Corporation) determine the appropriate high school district for each housing development in Bloomington. For each

You are trying to help the MCSCC (Monroe County School Corporation) determine the appropriate high school district for each housing development in Bloomington. For each development, you are given the number of students, the mean family income, the percentage of minorities, and the distance to each high school (South and North). These data are listed in the file P05_44.xlsx. In assigning the students, MCSCC wants to minimize total distance traveled subject to the following constraints:

■ Each school must have at least 1500 students.

■ The mean family income must be at least $85,000 for students of each school.

■ Each school must have at least 10% minorities.

Determine an optimal assignment of students to schools. Then provide a one-paragraph summary of how the optimal solution changes as the required minority percentage varies from 5% to 11%.

Step by Step Solution

★★★★★

3.31 Rating (169 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Assigning students to schools Area Mean income minorities Distance to South Distance to N... 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 (3 attachments)

1497_60b741243cf8e_696495.pdf

180 KBs PDF File

1497_6075d7aee1801_696495.xlsx

300 KBs Excel File

1497_60b741243cf8e_696495.docx

120 KBs Word File

Students Have Also Explored These Related Practical Management Science Questions!

The Internet provides many resources to help small-business owners successfully manage their businesses. Resources include information about common techniques used for planning and managing...

It is New Year's Day and you are trying to help your sister's new boyfriend with a finance problem. Fred is an international arms dealer. When he gets an order, he purchases the weapons on terms of...

You are trying to determine which of two retail clothing stores would be a more beneficial investment to you. You have a minimum required rate of return of 7 percent and have collected the following...

We are trying to help the MCSCC (Monroe County School Corporation) determine the appropriate high school district for each housing development in Bloomington. For each development, we are given the...

Please help solve You are trying to help the MCSCC (Monroe County School Corporation) determine the appropriate high school district for each housing development in Bloomington. For each development,...

Howard county Meryland Comprehensive Annual Financial Report for the Fiscal Year Ended June 30, 2012 1-Does the government have revenue bonds outstanding that are related to business-type activities?...

please help me with this assignment I need to identify the issue, specify the IDEA principle it pertains to, state the rule, and provide a brief conclusion. STATE OF MAINE SPECIAL EDUCATION DUE...

How are the changes that Taco Bell implemented, such as K-minus, SOS, etc., similar to, or different from, the various concepts/techniques that were presented in weeks 1-8 in this module. Provide a...

Literature Review Examples Find a peer-reviewed literature review article that you will use as a source in your literature review. In three hundred words provide a critical analysis of the article...

I need help on the Boulder Public School Case Study . There are three questions asked at the end of the case study. HBSP Product Number TCG239. Rev. Oct. 2015 THE CRIMSON PRESS CURRICULUM CENTER THE...

(c) Let f: X R be an infinitely differentiable function on set X CR containing 0. The n-th Maclaurin polynomial of f is the polynomial Mf,n(x) = f(h)(0) prk. = k! k=1 n The Maclaurin series of is...

On 1 July 2019, ABC Ltd acquired a portion of XYZ Ltd and they use the partial method to account for the 10% share of the NCI. ABC Ltd acquired their portion of the equity at a cost of $500,000 when...

Stephen paid $ 2 0 , 0 0 0 for his car 3 years ago. He still has we monthly payments of $ 4 0 0 left to pay, and the current balance on his auto loan is $ 9 , 0 0 0 . He estimates the market value of...

8.32 Show that if n, n 1 is a sequence of random variables and F is a continuous cdf, then sup

The balance in Mesa Companys raw materials inventory account was $45,000 at the beginning of April and $38,000 at the end of April. Raw materials purchased during the month totaled $55,000. Mesa used...

The following financial information is for Leeward Company. (Note that the most current financial information is presented in the first column.) Of the total raw materials placed in production for...

The following financial information is for Caravelli Company. Of the total raw materials placed in production for the year, $36,000 was for indirect materials. The company had $3,795,000 in sales for...

Pertormed counseling services tor $ 3 0 , 0 0 0 cash. On February 1 , Year 1 , paid $ 2 1 , 0 0 0 cash to rent office space for the coming year. Adjusted the accounts to reflect the amount of rent...

Tom is considering purchasing a $ 20 000 car. After five years, he will be able to sell the vehicle for $ 10 000. Petrol costs will be $ 2 000 per year, insurance $600 per year, and parking S 600 per...

You are analyzing the purchase of new equipment. Since you are not an expert on this type of equipment, you hire a consulting firm to make recommendations. The consultant charged you $1,500 and...