What are the optimum allocations between the three schools

Assignment Help Financial Management

Reference no: EM131366748

The Arden County, Maryland, superintendent of education is responsible for assigning 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 five 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 E. Each high school has a capacity of 900 students. The following table reflects the number of high-school-age students living in each sector and the busing distance in miles from each sector to each school: a) 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. Then solve the problem using SOLVER and Excel. b) What is the minimum total number of student miles traveled? c) What are the optimum allocations between the three schools and the five geographic sectors?

Reference no: EM131366748

Questions Cloud

Should the organization put a policy in place regardin : Should the organization put a policy in place regarding how employees can interact outside of the workplace? If so, how would this policy be enforced? Is this ethical?

Personal perceptions and experiences tie into your judgments : What criteria do you use to judge whether or not something is ethical or not in your professional world? How much or how little do your personal perceptions and experiences tie into your judgments? What are your thoughts?

Its licenses to practice as certified public accountants : In 2002, the accounting firm of Arthur Andersen voluntarily surrendered its licenses to practice as certified public accountants (CPA's) in the United States after being found guilty of criminal charges relating to the firm's handling of the auditing..

Create convergence between interests of stockholders : Suggest the substantive manner in which the company could create a convergence between the interests of stockholders and managers. Indicate the most likely impact to profitability of such a convergence. Provide two (2) examples of instances that supp..

What are the optimum allocations between the three schools : The Arden County, Maryland, superintendent of education is responsible for assigning 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 di..

Agree on the number of lessons or the dollar amount : Jack and Scotty begin negotiations where Scotty will give Jack hockey lessons for a certain amount of money per week. While they are still negotiating the dollar amount and the number of lessons, they begin to meet weekly to have lessons. After ten l..

Making or outsourcing pump housings : The Muenster Pump Company has manufactured high-quality agricultural pumps for over 40 years. The firm’s only plant is located in the small midwestern city of Muenster. The company is Muenster’s largest employer. Bob Dorf, president of the firm, is t..

Sues for specific performance : Nicole has a contract to buy 14 cases of hammers from Tyler. Tyler breaches the contract. Even though she can get similar hammers somewhere else, Nicole wants to sell his hammers because she secretly likes his logo and thinks it will draw customers i..

Negotiations where scotty will give jack hockey lessons : Jack and Scotty begin negotiations where Scotty will give Jack hockey lessons for a certain amount of money per week. While they are still negotiating the dollar amount and the number of lessons, they begin to meet weekly to have lessons. After ten l..

User Account

All Pages